Layer: SPIRE_Equipment_Approved_by

View In: Map Viewer

Name: SPIRE_Equipment_Approved_by_Hazard

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

Global ID Field: globalid

Type ID Field: equiptype

Fields:

globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
equiptype (type: esriFieldTypeString, alias: Equipment Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [comms_sets: Communication Units/Sets], [comms_towerportable: Communications Tower, Portable (Cell on Wheels)], [comms_trailer: Communication Trailer], ... 39 more ...)
equipdescript (type: esriFieldTypeString, alias: Equipment Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipstatus (type: esriFieldTypeString, alias: Equipment Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [available: Available if Requested], [inuse: Currently in Use], [undermaint: Down for Maintenance], ... 1 more ...)
assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
modelnum (type: esriFieldTypeString, alias: Model Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
serialnum (type: esriFieldTypeString, alias: Serial/VIN/HIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
titlereqd (type: esriFieldTypeString, alias: Title required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
titleapplied (type: esriFieldTypeDate, alias: Title applied date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
titleexpire (type: esriFieldTypeDate, alias: Title expiration date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
licenseplatenum (type: esriFieldTypeString, alias: License Plate Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
keysreqd (type: esriFieldTypeString, alias: Keys required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
keysoemcopy (type: esriFieldTypeString, alias: Does OEM have a copy of the keys?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
requesttype (type: esriFieldTypeString, alias: Equipment Request Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [community: Community], [county: County], [individualorg: Individual Organization], ... 2 more ...)
partneragencies (type: esriFieldTypeString, alias: Partnering Agencies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipmanufdate (type: esriFieldTypeDate, alias: Equipment Manufacture Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equiporderdate (type: esriFieldTypeDate, alias: Equipment Order Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipdeliverdate (type: esriFieldTypeDate, alias: Equipment Delivery Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipcheckin (type: esriFieldTypeDate, alias: Equipment Check-in Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipreceived (type: esriFieldTypeDate, alias: Equipment Received by Recipient Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipadd (type: esriFieldTypeString, alias: Equipment Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipcity (type: esriFieldTypeString, alias: Equipment City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipstate (type: esriFieldTypeString, alias: Equipment State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
equipzip (type: esriFieldTypeString, alias: Equipment Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
agreementnum (type: esriFieldTypeString, alias: Agreement Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grantappnum (type: esriFieldTypeString, alias: Grant Application Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grantagreesent (type: esriFieldTypeDate, alias: Grant Agreement Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grantagreereturn (type: esriFieldTypeDate, alias: Grant Agreement Returned, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grantagreecomplete (type: esriFieldTypeDate, alias: Grant Agreement Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grantagreereturnrecip (type: esriFieldTypeDate, alias: Grant Agreement Returned to Recipient, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: SPIRE Grant Manager Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
orgname (type: esriFieldTypeString, alias: Organization Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgaddequipadd (type: esriFieldTypeString, alias: Is the Organization Address the Same as the Equipment Address?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
orgadd (type: esriFieldTypeString, alias: Organization Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgcity (type: esriFieldTypeString, alias: Organization City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgstate (type: esriFieldTypeString, alias: Organization State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgzip (type: esriFieldTypeString, alias: Organization Zip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgcounty (type: esriFieldTypeString, alias: Organization County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
orgregion (type: esriFieldTypeString, alias: Organization Region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypocname (type: esriFieldTypeString, alias: Primary Point of Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypoctitle (type: esriFieldTypeString, alias: Primary Point of Contact Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypoccell (type: esriFieldTypeString, alias: Primary Point of Contact Cell, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypocoffice (type: esriFieldTypeString, alias: Primary Point of Contact Office Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypocdispatch (type: esriFieldTypeString, alias: Primary Point of Contact Dispatch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
primarypocemail (type: esriFieldTypeString, alias: Primary Point of Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondarypocname (type: esriFieldTypeString, alias: Secondary Point of Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondarypoctitle (type: esriFieldTypeString, alias: Secondary Point of Contact Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondarypoccell (type: esriFieldTypeString, alias: Secondary Point of Contact Cell, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondarypocoffice (type: esriFieldTypeString, alias: Secondary Point of Contact Office Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondyarpocdispatch (type: esriFieldTypeString, alias: Secondary Point of Contact Dispatch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
secondarypocemail (type: esriFieldTypeString, alias: Secondary Point of Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
additionalcontacts (type: esriFieldTypeString, alias: Any additional contacts?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
spireappstatus (type: esriFieldTypeString, alias: SPIRE Application Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [applied: Applied], [approved: Approved], [denied: Denied])
regionrequest (type: esriFieldTypeString, alias: What region(s) or category will this equipment serve (check all that apply)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
trainingquals (type: esriFieldTypeString, alias: If this equipment takes specialized training or certifications, describe your qualifications to use this equipment., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
shareprocedure (type: esriFieldTypeString, alias: Describe the procedures you will use to share this equipment with both internal and external community partners., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
agreepickup (type: esriFieldTypeString, alias: If awarded equipment cannot be delivered directly to my location, I agree to pick it up from an alternate location within 5 working days of notification., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes, I agree to the conditions])
agreeownership (type: esriFieldTypeString, alias: Although ownership will be maintained by the OEM, applicant agrees to include the equipment in its inventory, including all appropriate disposition tracking., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes, I agree to the conditions])
appcomments (type: esriFieldTypeString, alias: Please add any additional information here you believe is relevant and not covered elsewhere in your application., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
equiptypelabel (type: esriFieldTypeString, alias: equiptypelabel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
regionrequestlabel (type: esriFieldTypeString, alias: regionrequestlabel, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
spirepreviouslabel (type: esriFieldTypeString, alias: spirepreviouslabel, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
appcategory (type: esriFieldTypeString, alias: Which category do you wish this application be evaluated under?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [region: Region], [usar: USAR], [tribal: Tribal])
equipmoreusable (type: esriFieldTypeString, alias: Are there any specific types of equipment or features that would make this the most effective and useable for your needs?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
Unit_Category (type: esriFieldTypeString, alias: Unit_Category, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
Winter_Readiness (type: esriFieldTypeString, alias: Winter_Readiness, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
Flood_Readiness (type: esriFieldTypeString, alias: Flood_Readiness, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
Fire_Readiness (type: esriFieldTypeString, alias: Fire_Readiness, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Types:

equiptype: drone

equiptype: emily

equiptype: fueltransport_250

equiptype: fueltransport_500

equiptype: fueltransport_700

equiptype: generator_108kw

equiptype: generator_30kw

equiptype: generator_56kw

equiptype: generator_solar

equiptype: highaxle

equiptype: lightingportable

equiptype: masscasualty

equiptype: mobilecommand

equiptype: morgue

equiptype: radiocommsunit

equiptype: rescueboat_115hp

equiptype: rescueboat_lowwater

equiptype: rescuejetski

equiptype: sandbag

equiptype: snowcat

equiptype: trafficmessageboard

equiptype: usar_sidebyside

equiptype: usar_trailer

equiptype: vehbarriersys

equiptype: veh_10pax

equiptype: veh_tactical

equiptype: waterpurify

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/4/2023 9:45:07 PM

Schema Last Edit Date: 11/14/2023 10:39:59 PM

Data Last Edit Date: 12/2/2023 12:59:39 AM

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

Layer: SPIRE_Equipment_Approved_by_Hazard (ID:0)