Layers:

Layer: OntarioColleges_GeocodeAddr (0)


Name: OntarioColleges_GeocodeAddr

Display Field: USER_College

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

This map is part of the final project for the Spatial Relational Database Management course offered online through Ontario Learn in the spring of 2021. It is part of an exercise designed to teach how to geocode a non-spatial table of addresses into a point spatial dataset; to query a list of colleges that intersect a buffer of 500 km around an input point geometry; and to publish this to the web using ArcGIS Online.



Copyright Text: Michelle Dobrin, Mohawk College; ESRI

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: -181720.284677413
YMin: 4685066.810257
XMax: 942192.077451383
YMax: 5403740.62592942
Spatial Reference: 26917 (26917)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"44c28ab285c7fcbe3d2b830f9f68cee7","imageData":"iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAYAAAA6RwvCAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAEgUlEQVRYhdWXz08aaRjHvy/UXSZxDxiTdaYnmNho4aLjXprCoYkeqrQhMVBq4mUXet2sp+5J/gD3XoyXJoi8ITFd0j1g4kGanqS9gJrdDpw604NlDjXB1IS3B5hZBmYQars/vsdnnvd9P3mfX+9cw39E1/5tAF3/f5A0pZITTomxpqDbGEiJkaayEomUvipImlLJwUiIwLHEGJMYGABifCcACHNgO5tTCUMe7CIZi8WULwaSplRyNMk6GFniOBcEngfHcRCECYy53YZfo3EORVUhyzW+rmkJkJFEZieXGgToUpA0pRJhjjwIeNHrgSh6TId3iuNcEL0eiF4PAKBcOUa5cpRgZCSUpjTUL2R9QbazuRBh+H3M7YbfNw1B4C/jNqm1ZgLFFy/5RuP8ME3pnB2MLUjrJloQgdu3wHGuoSB0jbnduB9aRGFvH3VNs4WxBNHDcRnEq10Zr3dlAEAw7sdkQLD0A4CF+Tso7O3jvablAfQ4WoI4mmQdBLzfN20JoQOoJ5phy64VwU+5cffXH8BPWedQ4PYtPMs/5zM7uSexB8uP+oKkKZXAyJLo9fTkhHqi4WCzjL+K1gWgnmjYWi3YAunJLFdriTSlqc4Q9YA4GAlxnAui6BkYYBggv+8m5GoNTjglAPYgBI4lgeeNEs2uFQcGsAOaDAiIbgQA/H0rb6q1dQApS5A0pRJjTOI4zrBFNwI42KzgYLM8NMjoOIez0waCcb/Jfl3gIVdrfCaTEfRGZwJxwikxMAjChGlhMO5DMO4bGGh0nMONgICZsIit1QK+GzcnvKtdAMT5zRLat2ICaQ0wYts5g3EfJgMCXu/KeNUu227NhkXMhEXbygFguf/Q01c9ruPu4znMhEVTAncCnJ02Btqrc3IPDdIKTwWLj+cQ3QgYvYSfckM90ZBdK0I91vDzH/ds92g0znts5tCAlEjbsV9LPzttmBoYYK6u0XHOdm33edYgpKkQ5oCiqsYE7Se9PLvVnZzdUlTVOM8SZCUSKW1nc6os13g7kOhvAWR/KdrmAT/l7inXbr1VVDBA7dtZCUO+rmkJu034KTd+ejqPP4uKMfA+nJ7jRkDA6DiH2bC3b2jqmgZFUUEY8p323mRlF0mQkUS5cgy/b9pys9aBImbDou2Bnfpwem7AKco7AEDT0Ux1+vSAxGIxJbOTS5UrR4nup+DnKBj3Y2u1gB+fLuDb74Fy5QhgSK1EzW8S6/JlF0lGRkLFFy/5+6HFK4K0unJd01CuHIOAlBj7mOz2swSJxWJKmtJQo3F+WNjbx8L8nSvB6BBKK0mTDy0e0rYNbSUSKaUpnatr2mFhb/+zn4tdEPceRpfzVn59O6sO817T8s/yz3nR64Hfd3MgoFZ1vEO5ctQKB5C0g7gURIcBIGR2ck/kai0hV2sQvR5cF3i4OJeRzHrbVlQVbxUVitJqWmBIMfbRMhxDgeiKPVh+lKY05YRTelOtrcvVmu2/BQNUwpBvOpo91XFlEMC4nRKAVCaTEdrvCWOK/mP/vp1qv6xSlzp+bZAvrU+iXiNmK0xHvAAAAABJRU5ErkJggg==","contentType":"image/png","width":25,"height":25,"angle":0,"xoffset":0,"yoffset":0}},"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)
• USER_College (type: esriFieldTypeString, alias: College, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• 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)
• 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: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_More_Info (type: esriFieldTypeString, alias: More Info, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: OntarioColleges_GeocodeAddr
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2021 5:50:23 PM

Schema Last Edit Date: 4/15/2021 5:50:23 PM

Data Last Edit Date: 4/15/2021 5:50:23 PM