Layer: OntarioColleges_GeocodeAddr (ID:0)

View In: Map Viewer

Name: OntarioColleges_GeocodeAddr

Display Field: Loc_name

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)
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_College (type: esriFieldTypeString, alias: College, SQL Type: sqlTypeOther, length: 8000, 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:
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/10/2021 10:01:56 PM

Schema Last Edit Date: 4/10/2021 10:01:56 PM

Data Last Edit Date: 4/10/2021 10:01:56 PM

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