Layers:

Layer: DBO.OntarioCollege_GeocodeAddresses (0)


Name: DBO.OntarioCollege_GeocodeAddresses

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

This dataset contains location data for 25 colleges in the province of Ontario. The name of each college, it's address, as well as a URL to each college's OCAS webpage is provided.



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: -89.267202015
YMin: 42.2479979980001
XMax: -75.627867419
YMax: 48.487278013
Spatial Reference: 4326 (4326)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[147,63,102,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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:

Type ID Field:

Fields:
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddressNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddressRange, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CntryName (type: esriFieldTypeString, alias: CountryName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: Province, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: Postal Extension, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country Code, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_College (type: esriFieldTypeString, alias: College, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• USER_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• USER_More_Info (type: esriFieldTypeString, alias: More Info, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)

Templates:

Name: DBO.OntarioCollege_GeocodeAddresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_Address:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_College:
• USER_More_Info:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/10/2023 2:49:14 PM

Schema Last Edit Date: 4/10/2023 2:49:14 PM

Data Last Edit Date: 4/10/2023 2:49:14 PM