Name: School Facilities Database 2019-20 Geocoded

Display Field: District_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -125.343070183216
YMin: 42.0105308500001
XMax: -116.83467999
YMax: 46.191940012
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,128,111,255],"toColor":[252,128,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[126,176,214,255],"toColor":[126,176,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[178,224,96,255],"toColor":[178,224,96,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,126,191,255],"toColor":[190,126,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,180,89,255],"toColor":[255,180,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,237,102,255],"toColor":[255,237,102,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,184,219,255],"toColor":[189,184,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,229,255],"toColor":[252,204,229,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[140,212,200,255],"toColor":[140,212,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,237,197,255],"toColor":[204,237,197,255]}]}},"type":"uniqueValue","field1":"Use_Code","defaultSymbol":{"color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"defaultLabel":"Secondary Buildings","uniqueValueInfos":[{"value":"ES","symbol":{"color":[255,170,0,255],"size":6.2475000000000005,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"label":"ES"},{"value":"MS","symbol":{"color":[168,0,132,255],"size":6.2475000000000005,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"label":"MS"},{"value":"HS","symbol":{"color":[76,115,0,255],"size":6.2475000000000005,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"label":"HS"},{"value":"K8","symbol":{"color":[0,132,168,255],"size":6.2475000000000005,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"label":"K8"},{"value":"K12","symbol":{"color":[0,77,168,255],"size":6.2475000000000005,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[26,26,26,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}},"label":"K12"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: Use_Code

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• District_ID (type: esriFieldTypeDouble, alias: District ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• District_Name (type: esriFieldTypeString, alias: District Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• School_ID (type: esriFieldTypeDouble, alias: School ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• School_Name (type: esriFieldTypeString, alias: School Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_ID (type: esriFieldTypeDouble, alias: Building ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Building_Name (type: esriFieldTypeString, alias: Building Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Replaced_Building (type: esriFieldTypeString, alias: Replaced Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Replaced_Building_ID (type: esriFieldTypeString, alias: Replaced Building ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Street_Address (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Zip_Code (type: esriFieldTypeDouble, alias: Zip Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_of_Completion (type: esriFieldTypeDouble, alias: Year of Completion, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Building_Age (type: esriFieldTypeDouble, alias: Building Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_No_Longer_Used (type: esriFieldTypeString, alias: Year No Longer Used, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Reason_No_Longer_Used (type: esriFieldTypeString, alias: Reason No Longer Used, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Use_Code (type: esriFieldTypeString, alias: Use Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Gross_Square_Footage (type: esriFieldTypeDouble, alias: Gross Square Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Stories (type: esriFieldTypeDouble, alias: Stories, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Primary_Structure_Type (type: esriFieldTypeString, alias: Primary Structure Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Secondart_Structure_Type (type: esriFieldTypeString, alias: Secondart Structure Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Student_Capacity (type: esriFieldTypeDouble, alias: Student Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Metered (type: esriFieldTypeString, alias: Metered, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Electricity (type: esriFieldTypeString, alias: Electricity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Natural_Gas (type: esriFieldTypeString, alias: Natural Gas, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Heating_Oil (type: esriFieldTypeDouble, alias: Heating Oil, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Other_Energey (type: esriFieldTypeString, alias: Other Energey, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Seismic_Zone_Code (type: esriFieldTypeString, alias: Seismic Zone Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Internet (type: esriFieldTypeString, alias: Internet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Internet_Type (type: esriFieldTypeString, alias: Internet Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Internet_Upload_Speed (type: esriFieldTypeString, alias: Internet Upload Speed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Internet_Download_Speed (type: esriFieldTypeString, alias: Internet Download Speed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Code_1 (type: esriFieldTypeString, alias: Renovation Code 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Year_1 (type: esriFieldTypeString, alias: Renovation Year 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Code_2 (type: esriFieldTypeString, alias: Renovation Code 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Year_2 (type: esriFieldTypeString, alias: Renovation Year 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Code_3 (type: esriFieldTypeString, alias: Renovation Code 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Year_3 (type: esriFieldTypeString, alias: Renovation Year 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Code_4 (type: esriFieldTypeString, alias: Renovation Code 4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Year_4 (type: esriFieldTypeString, alias: Renovation Year 4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Code_5 (type: esriFieldTypeString, alias: Renovation Code 5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renovation_Year_5 (type: esriFieldTypeString, alias: Renovation Year 5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Seismic_Modification_Code (type: esriFieldTypeString, alias: Seismic Modification Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Asbestos_Present (type: esriFieldTypeString, alias: Asbestos Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lead_in_Paint_Present (type: esriFieldTypeString, alias: Lead in Paint Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Total_Yearly_Maintenance_Cost (type: esriFieldTypeDouble, alias: Total Yearly Maintenance Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FREQUENCY (type: esriFieldTypeInteger, alias: FREQUENCY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUM_Gross_Square_Footage (type: esriFieldTypeDouble, alias: SUM_Gross_Square_Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUM_Student_Capacity (type: esriFieldTypeDouble, alias: SUM_Student_Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUM_Total_Yearly_Maintenance_Co (type: esriFieldTypeDouble, alias: SUM_Total_Yearly_Maintenance_Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MIN_Building_Age (type: esriFieldTypeDouble, alias: MIN_Building_Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAX_Building_Age (type: esriFieldTypeDouble, alias: MAX_Building_Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRST_Use_Code (type: esriFieldTypeString, alias: FIRST_Use_Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

ID: ES
Name: ES
Domains:

Templates:

Name: ES
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Use_Code: ES

---

ID: MS
Name: MS
Domains:

Templates:

Name: MS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Use_Code: MS

---

ID: HS
Name: HS
Domains:

Templates:

Name: HS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Use_Code: HS

---

ID: K8
Name: K8
Domains:

Templates:

Name: K8
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Use_Code: K8

---

ID: K12
Name: K12
Domains:

Templates:

Name: K12
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• Use_Code: K12

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/27/2021 7:43:08 PM

Schema Last Edit Date: 4/27/2021 7:43:08 PM

Data Last Edit Date: 4/27/2021 7:43:08 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat