Layer: OntarioColleges_GeocodeAddr (ID:0)

View In: Map Viewer

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:

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:

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:

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

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