View In:
ArcGIS Online Map Viewer
Name: MSQ Service Request Outstanding
Display Field: SRNUMBER
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 10000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Supports Datum Transformation: true
Extent:
XMin: -5631451.143005524
YMin: -412114.384099216
XMax: 1084098.1887891244
YMax: 796980.5709693535
Spatial Reference: 102658
(2236)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
SRNUMBER
(
type: esriFieldTypeString, alias: Service Request, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SRNUMBER
)
-
CONTNAME
(
type: esriFieldTypeString, alias: Contact Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONTNAME
)
-
CONTLAST
(
type: esriFieldTypeString, alias: Contact Last Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONTLAST
)
-
CONTEMAIL
(
type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 70, defaultValue: null, modelName: CONTEMAIL
)
-
CONTNUM
(
type: esriFieldTypeString, alias: Contact Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONTNUM
)
-
SRADDRESS
(
type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SRADDRESS
)
-
ZIPCode
(
type: esriFieldTypeInteger, alias: ZIP Code, editable: true, nullable: true, defaultValue: null, modelName: ZIPCode
)
-
BREEDLOC
(
type: esriFieldTypeString, alias: Breeding Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: BREEDLOC
)
-
INSPPREV
(
type: esriFieldTypeString, alias: Prevent Inspection, editable: true, nullable: true, length: 500, defaultValue: null, modelName: INSPPREV
)
-
IMG311URL
(
type: esriFieldTypeString, alias: IMG311URL, editable: true, nullable: true, length: 150, defaultValue: null, modelName: IMG311URL
)
-
CREATEDDATE
(
type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE
)
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
FOLIO
(
type: esriFieldTypeString, alias: FOLIO, editable: true, nullable: true, length: 13, defaultValue: null, modelName: FOLIO
)
-
INSPECTOR
(
type: esriFieldTypeString, alias: Inspector Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTOR
, Coded Values:
[MD1: Adrian Gilbert]
, [MD2: Carlos Lanzas]
, [MD3: Carlos Varas]
, ...194 more...
)
-
DATETIMEST
(
type: esriFieldTypeDate, alias: Date Started, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEST
)
-
DATETIMEEN
(
type: esriFieldTypeDate, alias: Date Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEEN
)
-
TOTALHRS
(
type: esriFieldTypeDouble, alias: Time to Complete, editable: true, nullable: true, defaultValue: null, modelName: TOTALHRS
)
-
SOURC1
(
type: esriFieldTypeString, alias: Source 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC1
, Coded Values:
[803: 803-Art. Cont./small/Dumpable]
, [804: 804-Boat]
, [815: 815-Flies]
, ...15 more...
)
-
SOURC1PROB
(
type: esriFieldTypeString, alias: Source 1 Problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC1PROB
, Coded Values:
[705: 705-Breeding]
, [706: 706-Dry]
, [710: 710-Other insect]
, ...1 more...
)
-
SOURC1ACT
(
type: esriFieldTypeString, alias: Source 1 Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC1ACT
, Coded Values:
[405: 405-Dump]
, [412: 412-Issue NOV]
, [414: 414-Larvicide]
, ...1 more...
)
-
SOURC1OTH
(
type: esriFieldTypeString, alias: Source 1 OTher Task, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC1OTH
, Coded Values:
[302: 302-Breeding Site Inspection]
, [315: 315-Landing Rate]
, [322: 322-Public Event]
, ...10 more...
)
-
SOURC2
(
type: esriFieldTypeString, alias: Source 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC2
, Coded Values:
[803: 803-Art. Cont./small/Dumpable]
, [804: 804-Boat]
, [815: 815-Flies]
, ...15 more...
)
-
SOURC2PROB
(
type: esriFieldTypeString, alias: Source 2 Problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC2PROB
, Coded Values:
[705: 705-Breeding]
, [706: 706-Dry]
, [710: 710-Other insect]
, ...1 more...
)
-
SOURC2ACT
(
type: esriFieldTypeString, alias: Source 2 Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC2ACT
, Coded Values:
[405: 405-Dump]
, [412: 412-Issue NOV]
, [414: 414-Larvicide]
, ...1 more...
)
-
SOURC2OTH
(
type: esriFieldTypeString, alias: Source 2 Other Task, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC2OTH
, Coded Values:
[302: 302-Breeding Site Inspection]
, [315: 315-Landing Rate]
, [322: 322-Public Event]
, ...10 more...
)
-
SOURC3
(
type: esriFieldTypeString, alias: Source 3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC3
, Coded Values:
[803: 803-Art. Cont./small/Dumpable]
, [804: 804-Boat]
, [815: 815-Flies]
, ...15 more...
)
-
SOURC3PROB
(
type: esriFieldTypeString, alias: Source 3 Problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC3PROB
, Coded Values:
[705: 705-Breeding]
, [706: 706-Dry]
, [710: 710-Other insect]
, ...1 more...
)
-
SOURC3ACT
(
type: esriFieldTypeString, alias: Source 3 Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC3ACT
, Coded Values:
[405: 405-Dump]
, [412: 412-Issue NOV]
, [414: 414-Larvicide]
, ...1 more...
)
-
SOURC3OTH
(
type: esriFieldTypeString, alias: Source 3 Other Task, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC3OTH
, Coded Values:
[302: 302-Breeding Site Inspection]
, [315: 315-Landing Rate]
, [322: 322-Public Event]
, ...10 more...
)
-
SOURC4
(
type: esriFieldTypeString, alias: Source 4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC4
, Coded Values:
[803: 803-Art. Cont./small/Dumpable]
, [804: 804-Boat]
, [815: 815-Flies]
, ...15 more...
)
-
SOURC4PROB
(
type: esriFieldTypeString, alias: Source 4 Problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC4PROB
, Coded Values:
[705: 705-Breeding]
, [706: 706-Dry]
, [710: 710-Other insect]
, ...1 more...
)
-
SOURC4ACT
(
type: esriFieldTypeString, alias: Source 4 Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC4ACT
, Coded Values:
[405: 405-Dump]
, [412: 412-Issue NOV]
, [414: 414-Larvicide]
, ...1 more...
)
-
SOURC4OTH
(
type: esriFieldTypeString, alias: Source 4 Other Task, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURC4OTH
, Coded Values:
[302: 302-Breeding Site Inspection]
, [315: 315-Landing Rate]
, [322: 322-Public Event]
, ...10 more...
)
-
ADULTPROB
(
type: esriFieldTypeInteger, alias: Adult Problem, editable: true, nullable: true, defaultValue: null, modelName: ADULTPROB
)
-
ADULTACT
(
type: esriFieldTypeString, alias: Adulticide Action, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ADULTACT
, Coded Values:
[Y: Yes]
, [N: No]
)
-
MAT1
(
type: esriFieldTypeString, alias: Material 1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MAT1
, Coded Values:
[100: 100-ALTOSID BRIQ XR (EA)]
, [112: 112-GAMBUSIA FISH]
, [130: 130-ALTOSID XR 150 INGOT (EA)]
, ...54 more...
)
-
MAT1AMT
(
type: esriFieldTypeDouble, alias: Material 1 Amount, editable: true, nullable: true, defaultValue: null, modelName: MAT1AMT
)
-
MAT2
(
type: esriFieldTypeString, alias: Material 2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MAT2
, Coded Values:
[100: 100-ALTOSID BRIQ XR (EA)]
, [112: 112-GAMBUSIA FISH]
, [130: 130-ALTOSID XR 150 INGOT (EA)]
, ...54 more...
)
-
MAT2AMT
(
type: esriFieldTypeDouble, alias: Material 2 Amount, editable: true, nullable: true, defaultValue: null, modelName: MAT2AMT
)
-
MAT3
(
type: esriFieldTypeString, alias: Material 3, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MAT3
, Coded Values:
[100: 100-ALTOSID BRIQ XR (EA)]
, [112: 112-GAMBUSIA FISH]
, [130: 130-ALTOSID XR 150 INGOT (EA)]
, ...54 more...
)
-
MAT3AMT
(
type: esriFieldTypeDouble, alias: Material 3 Amount, editable: true, nullable: true, defaultValue: null, modelName: MAT3AMT
)
-
COMMENTS
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: COMMENTS
)
-
COMMDIST
(
type: esriFieldTypeString, alias: Commission District, editable: true, nullable: true, length: 40, defaultValue: null, modelName: COMMDIST
)
-
MUNINAME
(
type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MUNINAME
)
-
SPRYTYPE
(
type: esriFieldTypeString, alias: Spray Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SPRYTYPE
, Coded Values:
[501: 501-Truck Mount Spray Route-Completed]
, [8001: 8001-Aerial Spraying-Completed]
, [502: 502-Truck Mounted Spray Route Larvicide Completed]
)
-
POINTX
(
type: esriFieldTypeDouble, alias: POINTX, editable: true, nullable: true, defaultValue: null, modelName: POINTX
)
-
POINTY
(
type: esriFieldTypeDouble, alias: POINTY, editable: true, nullable: true, defaultValue: null, modelName: POINTY
)
-
SRSTATUS
(
type: esriFieldTypeString, alias: Service Resquest Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SRSTATUS
)
-
SRCREATED
(
type: esriFieldTypeDate, alias: SR Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SRCREATED
)
-
SRUPDATED
(
type: esriFieldTypeDate, alias: SR Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SRUPDATED
)
-
CREATEDBY
(
type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 40, defaultValue: null, modelName: CREATEDBY
)
-
MODIFYBY
(
type: esriFieldTypeString, alias: Modified By, editable: false, nullable: true, length: 40, defaultValue: null, modelName: MODIFYBY
)
-
MODIFYDATE
(
type: esriFieldTypeDate, alias: Modified Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: MODIFYDATE
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
OTHRTASK
(
type: esriFieldTypeString, alias: OTHRTASK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OTHRTASK
, Coded Values:
[325: 325-Residential]
, [328: 328-MC Generated Request]
)
-
MAT4
(
type: esriFieldTypeString, alias: Material 4 Used, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MAT4
, Coded Values:
[100: 100-ALTOSID BRIQ XR (EA)]
, [112: 112-GAMBUSIA FISH]
, [130: 130-ALTOSID XR 150 INGOT (EA)]
, ...54 more...
)
-
MAT4AMT
(
type: esriFieldTypeDouble, alias: Material 4 Amount, editable: true, nullable: true, defaultValue: null, modelName: MAT4AMT
)
-
MAT5
(
type: esriFieldTypeString, alias: Material 5 Used, editable: true, nullable: true, length: 40, defaultValue: null, modelName: MAT5
, Coded Values:
[100: 100-ALTOSID BRIQ XR (EA)]
, [112: 112-GAMBUSIA FISH]
, [130: 130-ALTOSID XR 150 INGOT (EA)]
, ...54 more...
)
-
MAT5AMT
(
type: esriFieldTypeDouble, alias: Material 5 Amount, editable: true, nullable: true, defaultValue: null, modelName: MAT5AMT
)
Templates:
-
Name: MSQ Service Request Assignments
Description:
Prototype:
MAT5: null
SRNUMBER: null
CONTNAME: null
CONTLAST: null
CONTEMAIL: null
CONTNUM: null
SRADDRESS: null
ZIPCode: null
BREEDLOC: null
INSPPREV: null
IMG311URL: null
MAT4AMT: null
FOLIO: null
INSPECTOR: null
DATETIMEST: null
DATETIMEEN: null
TOTALHRS: null
SOURC1: null
SOURC1PROB: null
SOURC1ACT: null
SOURC1OTH: null
SOURC2: null
SOURC2PROB: null
SOURC2ACT: null
SOURC2OTH: null
SOURC3: null
SOURC3PROB: null
SOURC3ACT: null
SOURC3OTH: null
SOURC4: null
SOURC4PROB: null
SOURC4ACT: null
SOURC4OTH: null
ADULTPROB: null
ADULTACT: null
MAT1: null
MAT1AMT: null
MAT2: null
MAT2AMT: null
MAT3: null
MAT3AMT: null
COMMENTS: null
COMMDIST: null
MUNINAME: null
SPRYTYPE: null
POINTX: null
POINTY: null
SRSTATUS: null
SRCREATED: null
SRUPDATED: null
MAT4: null
OTHRTASK: null
MAT5AMT: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Create,Update,Delete,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: CREATEDDATE
- Creator Field: CREATEDBY
- Edit Date Field: MODIFYDATE
- Editor Field: MODIFYBY
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Query Analytic
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata