Name: Warehouse
Display Field: FIRM_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: This service depicts public/contract freight warehousing facilities in the state. These facilities have the ability to produce significant freight-related traffic. Note: not all of the warehouses have access to multiple modes of transportation. Source: Leonard’s Guide National Warehouse and Distribution Directory.
Copyright Text: Iowa Department of Transportation - Office of Systems Planning
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON
Use Standardized Queries: True
Extent:
XMin: -10749527.495052
YMin: 4986671.2221209
XMax: -10039720.6557799
YMax: 5322705.88438975
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GLOBALID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- 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: Full Address, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
- SIDE (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- LONGITUDE (type: esriFieldTypeDouble, alias: Longitude (WGS84 LL), SQL Type: sqlTypeOther, nullable: true, editable: true)
- LATITUDE (type: esriFieldTypeDouble, alias: Latitude (WGS84 LL), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ADDR_TYPE (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- STREET (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- CITY_NAME (type: esriFieldTypeString, alias: City Name (1), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATE_NAME (type: esriFieldTypeString, alias: State Name (1), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ZIP_CODE (type: esriFieldTypeString, alias: ZIP Code (1), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- FIRM_NAME (type: esriFieldTypeString, alias: Firm Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDRESS (type: esriFieldTypeString, alias: Address (1), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ADDRESS_2 (type: esriFieldTypeString, alias: Address (2), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CITY_NAME_2 (type: esriFieldTypeString, alias: City Name (2), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATE_NAME_2 (type: esriFieldTypeString, alias: State Name (2), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ZIP_CODE_2 (type: esriFieldTypeDouble, alias: ZIP Code (2), SQL Type: sqlTypeOther, nullable: true, editable: true)
- CONTACT_NAME (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PHONE (type: esriFieldTypeDouble, alias: Phone Number (1), SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHONE_2 (type: esriFieldTypeDouble, alias: Phone Number (2), SQL Type: sqlTypeOther, nullable: true, editable: true)
- PHONE_3 (type: esriFieldTypeDouble, alias: Phone Number (3), SQL Type: sqlTypeOther, nullable: true, editable: true)
- FAX (type: esriFieldTypeDouble, alias: FAX Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EMAIL (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- WEBSITE (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CLASSIFICATION (type: esriFieldTypeString, alias: Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- STORAGE_AREA (type: esriFieldTypeString, alias: Storage Area, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- FACILITY_DESC (type: esriFieldTypeString, alias: Facility Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- RAIL_SIDING (type: esriFieldTypeString, alias: Rail Siding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TRUCK_DOCK (type: esriFieldTypeString, alias: Truck Dock, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PROTECTION (type: esriFieldTypeString, alias: Protection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- LIABILITY (type: esriFieldTypeString, alias: Liability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DISTRIBUTION (type: esriFieldTypeString, alias: Distribution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GEOLIBRARY_WAREHOUSE_AREA (type: esriFieldTypeString, alias: GEOLIBRARY_WAREHOUSE_AREA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- PRODUCTS_HANDLED (type: esriFieldTypeString, alias: Products Handled, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- HANDLING_EQUIPMENT (type: esriFieldTypeString, alias: Handling Equipment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- BANK_REFERENCE (type: esriFieldTypeString, alias: Bank Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ASSOCIATION (type: esriFieldTypeString, alias: Association, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- ESTABLISHED (type: esriFieldTypeDouble, alias: Date Established, SQL Type: sqlTypeOther, nullable: true, editable: true)
- EMPLOYEES (type: esriFieldTypeDouble, alias: Number of Employees, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WAREHOUSE_ID (type: esriFieldTypeInteger, alias: WAREHOUSE_ID, SQL Type: sqlTypeOther, nullable: false, editable: true)
- MOD_DATE (type: esriFieldTypeDate, alias: Date Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- REST_UPDATED (type: esriFieldTypeDate, alias: Rest Service Last Updated (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- REST_UTC_OFFSET (type: esriFieldTypeString, alias: UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- CITY_NUMBER (type: esriFieldTypeInteger, alias: City Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Warehouse
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/22/2024 1:15:12 AM
Schema Last Edit Date: 11/11/2022 2:15:14 AM
Data Last Edit Date: 3/22/2024 1:15:12 AM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates