Name: Cityworks_NMB.azteca.INSPECTION

Display Field: INSPTEMPLATENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• INSPECTIONID ( type: esriFieldTypeDouble, alias: INSPECTIONID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, length: 60 )
• INSPTEMPLATEID ( type: esriFieldTypeDouble, alias: INSPTEMPLATEID )
• INSPTEMPLATENAME ( type: esriFieldTypeString, alias: INSPTEMPLATENAME, length: 30 )
• ENTITYUID ( type: esriFieldTypeString, alias: ENTITYUID, length: 50 )
• ENTITYTYPE ( type: esriFieldTypeString, alias: ENTITYTYPE, length: 50 )
• INSPDATE ( type: esriFieldTypeDate, alias: INSPDATE, length: 8 )
• INSPECTEDBY ( type: esriFieldTypeString, alias: INSPECTEDBY, length: 50 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 256 )
• OBSERVATIONSUM ( type: esriFieldTypeString, alias: OBSERVATIONSUM, length: 900 )
• REPAIRSMADE ( type: esriFieldTypeString, alias: REPAIRSMADE, length: 900 )
• FOREMANRECOMND ( type: esriFieldTypeString, alias: FOREMANRECOMND, length: 900 )
• REQUESTID ( type: esriFieldTypeInteger, alias: REQUESTID )
• PRJSTARTDATE ( type: esriFieldTypeDate, alias: PRJSTARTDATE, length: 8 )
• PRJFINISHDATE ( type: esriFieldTypeDate, alias: PRJFINISHDATE, length: 8 )
• ACTFINISHDATE ( type: esriFieldTypeDate, alias: ACTFINISHDATE, length: 8 )
• DATECLOSED ( type: esriFieldTypeDate, alias: DATECLOSED, length: 8 )
• CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, length: 100 )
• CLOSESR ( type: esriFieldTypeSmallInteger, alias: CLOSESR )
• CANCEL ( type: esriFieldTypeSmallInteger, alias: CANCEL )
• DATECANCELLED ( type: esriFieldTypeDate, alias: DATECANCELLED, length: 8 )
• CANCELLEDBY ( type: esriFieldTypeString, alias: CANCELLEDBY, length: 100 )
• CANCELREASON ( type: esriFieldTypeString, alias: CANCELREASON, length: 100 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 )
• INSPX ( type: esriFieldTypeDouble, alias: INSPX )
• INSPY ( type: esriFieldTypeDouble, alias: INSPY )
• DOMAINID ( type: esriFieldTypeInteger, alias: DOMAINID )
• FEATURETYPE ( type: esriFieldTypeString, alias: FEATURETYPE, length: 50 )
• FEATUREID ( type: esriFieldTypeInteger, alias: FEATUREID )
• FEATUREUID ( type: esriFieldTypeString, alias: FEATUREUID, length: 50 )
• ENTITYSID ( type: esriFieldTypeInteger, alias: ENTITYSID )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, length: 100 )
• INITIATEDATE ( type: esriFieldTypeDate, alias: INITIATEDATE, length: 8 )
• SHOP ( type: esriFieldTypeString, alias: SHOP, length: 100 )
• MAPPAGE ( type: esriFieldTypeString, alias: MAPPAGE, length: 100 )
• TILENO ( type: esriFieldTypeString, alias: TILENO, length: 50 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 50 )
• RESOLUTION ( type: esriFieldTypeString, alias: RESOLUTION, length: 100 )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, length: 50 )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, length: 50 )
• CONDRATING ( type: esriFieldTypeDouble, alias: CONDRATING )
• TEXT1 ( type: esriFieldTypeString, alias: TEXT1, length: 100 )
• TEXT2 ( type: esriFieldTypeString, alias: TEXT2, length: 100 )
• TEXT3 ( type: esriFieldTypeString, alias: TEXT3, length: 100 )
• TEXT4 ( type: esriFieldTypeString, alias: TEXT4, length: 100 )
• TEXT5 ( type: esriFieldTypeString, alias: TEXT5, length: 100 )
• TEXT6 ( type: esriFieldTypeString, alias: TEXT6, length: 100 )
• TEXT7 ( type: esriFieldTypeString, alias: TEXT7, length: 100 )
• TEXT8 ( type: esriFieldTypeString, alias: TEXT8, length: 100 )
• TEXT9 ( type: esriFieldTypeString, alias: TEXT9, length: 100 )
• TEXT10 ( type: esriFieldTypeString, alias: TEXT10, length: 100 )
• NUM1 ( type: esriFieldTypeDouble, alias: NUM1 )
• NUM2 ( type: esriFieldTypeDouble, alias: NUM2 )
• NUM3 ( type: esriFieldTypeDouble, alias: NUM3 )
• NUM4 ( type: esriFieldTypeDouble, alias: NUM4 )
• NUM5 ( type: esriFieldTypeDouble, alias: NUM5 )
• DATE1 ( type: esriFieldTypeDate, alias: DATE1, length: 8 )
• DATE2 ( type: esriFieldTypeDate, alias: DATE2, length: 8 )
• DATE3 ( type: esriFieldTypeDate, alias: DATE3, length: 8 )
• DATE4 ( type: esriFieldTypeDate, alias: DATE4, length: 8 )
• DATE5 ( type: esriFieldTypeDate, alias: DATE5, length: 8 )
• CONDSCORE ( type: esriFieldTypeDouble, alias: CONDSCORE )
• UPDATEMAP ( type: esriFieldTypeString, alias: UPDATEMAP, length: 1 )
• SUBMITTOEMPLOYEESID ( type: esriFieldTypeDouble, alias: SUBMITTOEMPLOYEESID )
• SUBMITTONAME ( type: esriFieldTypeString, alias: SUBMITTONAME, length: 100 )
• DATESUBMITTO ( type: esriFieldTypeDate, alias: DATESUBMITTO, length: 8 )
• EFFORT ( type: esriFieldTypeDouble, alias: EFFORT )
• PARENTINSPID ( type: esriFieldTypeInteger, alias: PARENTINSPID )
• CYCLETYPE ( type: esriFieldTypeString, alias: CYCLETYPE, length: 20 )
• CYCLEFROM ( type: esriFieldTypeString, alias: CYCLEFROM, length: 30 )
• CYCLEINTERVALNUM ( type: esriFieldTypeInteger, alias: CYCLEINTERVALNUM )
• CYCLEINTERVALUNIT ( type: esriFieldTypeString, alias: CYCLEINTERVALUNIT, length: 1 )
• CREATEDBYCYCLE ( type: esriFieldTypeSmallInteger, alias: CREATEDBYCYCLE )
• FROMDATE ( type: esriFieldTypeDate, alias: FROMDATE, length: 8 )
• INITIATEDBYAPP ( type: esriFieldTypeString, alias: INITIATEDBYAPP, length: 50 )
• INSPECTEDBYSID ( type: esriFieldTypeInteger, alias: INSPECTEDBYSID )
• CANCELLEDBYSID ( type: esriFieldTypeInteger, alias: CANCELLEDBYSID )
• INITIATEDBYSID ( type: esriFieldTypeInteger, alias: INITIATEDBYSID )
• CLOSEDBYSID ( type: esriFieldTypeInteger, alias: CLOSEDBYSID )
• FACILITY_ID ( type: esriFieldTypeString, alias: FACILITY_ID, length: 256 )
• LEVEL_ID ( type: esriFieldTypeString, alias: LEVEL_ID, length: 256 )
• PROJECTSID ( type: esriFieldTypeDouble, alias: PROJECTSID )
• PROJECTPHASEID ( type: esriFieldTypeInteger, alias: PROJECTPHASEID )
• METADATA ( type: esriFieldTypeString, alias: METADATA, length: 1073741822 )
• INSPZ ( type: esriFieldTypeDouble, alias: INSPZ )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata