Name: master_spreadsheet_by_individual_award__GIS_version__07302026_ZIP_Geocoded

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: -19002566.6397643
YMin: -1605588.09291669
XMax: 16220415.9804336
YMax: 11110336.4361087
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[63,170,138,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 Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: Long Label, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: Short Label, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Address 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: Place Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 30, 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: Address Building, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: Address Number From, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: Address Number To, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: Address Range, 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: Prefix Directional, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: Prefix Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: Suffix Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: Suffix Directional, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgComp (type: esriFieldTypeString, alias: Building Complex, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: Building Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: Level Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: Level Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: Unit Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RoomType (type: esriFieldTypeString, alias: Room Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RoomName (type: esriFieldTypeString, alias: Room Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WingType (type: esriFieldTypeString, alias: Wing Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WingName (type: esriFieldTypeString, alias: Wing Name, 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: Street Address, 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: Metro Area, 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: Region Abbreviation, 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: Postal Extension, 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: Country Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: Language Code, 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: Display X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: Display Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Minimum X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Maximum X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Minimum Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Maximum Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: Extra Info, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MatchID (type: esriFieldTypeString, alias: MatchID, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• PotentialID (type: esriFieldTypeString, alias: PotentialID, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• MatchNarrative (type: esriFieldTypeString, alias: Match Narrative, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• StrucType (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StrucDet (type: esriFieldTypeString, alias: Structure Details, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 100, 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_Orig_Order_UNIQID (type: esriFieldTypeInteger, alias: Orig_Order_UNIQID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_month (type: esriFieldTypeString, alias: month, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_year (type: esriFieldTypeInteger, alias: year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_grant_number (type: esriFieldTypeString, alias: grant_number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_grant_type (type: esriFieldTypeString, alias: grant_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_award_amount (type: esriFieldTypeInteger, alias: award_amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_eligible_cost (type: esriFieldTypeInteger, alias: eligible_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_award_date (type: esriFieldTypeDateOnly, alias: award_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_application_recieved (type: esriFieldTypeDateOnly, alias: application_recieved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_state (type: esriFieldTypeString, alias: state, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZIP_code (type: esriFieldTypeInteger, alias: ZIP_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_region (type: esriFieldTypeInteger, alias: region, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_census_population (type: esriFieldTypeString, alias: census_population, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_census_true_population (type: esriFieldTypeString, alias: census_true_population, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_days_between (type: esriFieldTypeInteger, alias: days_between, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_moneyratio (type: esriFieldTypeDouble, alias: moneyratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_moneytrue (type: esriFieldTypeString, alias: moneytrue, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_City_Missing (type: esriFieldTypeString, alias: City.Missing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_city_deducible (type: esriFieldTypeString, alias: city_deducible, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_County_Missing (type: esriFieldTypeString, alias: County.Missing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_county_deducible (type: esriFieldTypeString, alias: county_deducible, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Zip_Missing (type: esriFieldTypeString, alias: Zip.Missing, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_zip_deducible (type: esriFieldTypeString, alias: zip_deducible, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LowestGeocodable (type: esriFieldTypeString, alias: LowestGeocodable, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_LocInfoAvail_Text (type: esriFieldTypeString, alias: LocInfoAvail_Text, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_city_GIS (type: esriFieldTypeString, alias: city_GIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_county_GIS (type: esriFieldTypeString, alias: county_GIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_state_GIS (type: esriFieldTypeString, alias: state_GIS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_ZIP_code_GIS (type: esriFieldTypeInteger, alias: ZIP_code_GIS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_citystatezip (type: esriFieldTypeString, alias: citystatezip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: master_spreadsheet_by_individual_award__GIS_version__07302026_ZIP_Geocoded
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_Longitude: 0
• USER_Country:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_Orig_Order_UNIQID: 0
• USER_month:
• USER_year: 0
• USER_grant_number:
• USER_grant_type:
• USER_award_amount: 0
• USER_eligible_cost: 0
• USER_city:
• USER_county:
• USER_state:
• USER_ZIP_code: 0
• USER_region: 0
• USER_census_population:
• USER_census_true_population:
• USER_days_between: 0
• USER_moneyratio: 0
• USER_moneytrue:
• USER_City_Missing:
• USER_city_deducible:
• USER_County_Missing:
• USER_county_deducible:
• USER_Zip_Missing:
• USER_zip_deducible:
• USER_LowestGeocodable:
• USER_LocInfoAvail_Text:
• USER_city_GIS:
• USER_county_GIS:
• USER_state_GIS:
• USER_ZIP_code_GIS: 0
• USER_citystatezip:
• USER_Latitude: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/30/2026 7:17:18 PM

Schema Last Edit Date: 7/30/2026 7:17:18 PM

Data Last Edit Date: 7/30/2026 7:17:18 PM

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