Name: DBO.OntarioCollege_GeocodeAddres

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point feature class shows where every college in the province of Ontario is located and contains attributes related to their location. Every feature contains attributes for their address in long form as well as short form. Individual address components are also listed separately within the attribute table. Geographic coordinates are also available for identifying the colleges' location. Some other information such as neighbourhood name, zone name, and language code are also available.The point locations associated with this feature class are highly accurate, with the lowest geocoding match score of 91.52, while most of the scores lie between 99 and 100.This feature class can be used to locate Ontario colleges within a certain distance around a specified location by applying a buffer to that location. It can also be used as a means to find information about each college in the province. Under the attributes for this feature class, a field titled "More Info" contains links to a page on the OntarioColleges website for each college.This feature class is projected using the WGS 1984 Web Mercator (auxiliary sphere) projected coordinate system.

Copyright Text: Ontario Colleges

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.2672020154484
YMin: 42.2479979981418
XMax: -75.6278674193208
YMax: 48.4872780132443
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}},"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_GeocodeAddres
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/13/2024 6:26:55 PM

Schema Last Edit Date: 4/13/2024 6:26:55 PM

Data Last Edit Date: 4/13/2024 6:26:55 PM

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