Name: survey

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)
• date_submitted (type: esriFieldTypeDate, alias: Date Submitted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_submitted (type: esriFieldTypeString, alias: Time Submitted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• type_of_request (type: esriFieldTypeString, alias: Type of Request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Procurement: Procurement], [Purchase: Purchase], [Travel / Training: Travel / Training])
• title_of_request (type: esriFieldTypeString, alias: Title of Request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• category_logistics_or_technolog (type: esriFieldTypeString, alias: Category: Logistics or Technology (select one), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Logistics: Logistics], [Technology: Technology])
• requestors_rank (type: esriFieldTypeString, alias: Rank, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Captain: Captain], [Administrator: Administrator], [Lieutenant: Lieutenant], ... 9 more ...)
• requestors_name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requesting_bureau (type: esriFieldTypeString, alias: Bureau, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [EOB: EOB (Executive Office)], [PSB: PSB (Patrol Services)], [ISB: ISB (Investigative Services)], ... 2 more ...)
• requesting_division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requesting_section (type: esriFieldTypeString, alias: Section, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requesting_unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestors_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestors_telephone_number (type: esriFieldTypeString, alias: Telephone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• synopsis_of_business_need (type: esriFieldTypeString, alias: Synopsis of Business Need, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• upfront_costs (type: esriFieldTypeDouble, alias: Estimated Upfront Costs (Year 1), SQL Type: sqlTypeOther, nullable: true, editable: true)
• annual_costs (type: esriFieldTypeDouble, alias: Estimated Annual Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• long_term_costs (type: esriFieldTypeDouble, alias: Estimated Long Term Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• procurement_exception_reason (type: esriFieldTypeString, alias: Procurement Exception Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No Exception: No Exception], [Sole Brand: Sole Brand], [Sole Source: Sole Source], ... 1 more ...)
• procurement_exception_justifica (type: esriFieldTypeString, alias: Special Procurement Exception Justification, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• teams_affected (type: esriFieldTypeString, alias: City Teams Affected, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• teams_affected_other (type: esriFieldTypeString, alias: Other - City Teams Affected, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• purchase_type (type: esriFieldTypeString, alias: Purchase Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Purchase: Purchase], [Travel / Training: Travel / Training])
• travel_costs (type: esriFieldTypeDouble, alias: Transportation Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lodging_costs (type: esriFieldTypeDouble, alias: Lodging Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• estimated_total_cost (type: esriFieldTypeDouble, alias: Estimated Total Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• funding_source (type: esriFieldTypeString, alias: Funding String, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• purchase_order_number (type: esriFieldTypeString, alias: Purchase Order Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestors_payroll (type: esriFieldTypeString, alias: Payroll, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• vendor (type: esriFieldTypeString, alias: Vendor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• field_35 (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Department Budget: Department Budget], [Grant Funding: Grant Funding], [City Budget: City Budget], ... 1 more ...)
• stakeholders (type: esriFieldTypeString, alias: Stakeholders, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• focus_for_discussion (type: esriFieldTypeString, alias: Focus for Discussion, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• focus_for_input (type: esriFieldTypeString, alias: Focus for Input, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• training_cost (type: esriFieldTypeDouble, alias: Training or Conference Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• commanders_email (type: esriFieldTypeString, alias: Lieutenant or Superintendent Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• purchase_order_number_requested (type: esriFieldTypeString, alias: Purchase Order Number Requested, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• registered_supplier (type: esriFieldTypeString, alias: Registered Supplier with the City of Tucson, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• funding_string (type: esriFieldTypeString, alias: Funding String, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• po_requested (type: esriFieldTypeString, alias: Purchase Order Number Requested, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CA_email (type: esriFieldTypeString, alias: Captain or Administrator Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DCAC_email (type: esriFieldTypeString, alias: Deputy or Assistant Chief Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• special_funding_source (type: esriFieldTypeString, alias: Special Funding Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/26/2024 8:35:18 PM

Schema Last Edit Date: 6/26/2024 8:35:01 PM

Data Last Edit Date: 6/26/2024 8:35:18 PM

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