ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
_UtilitiesWater
>
GEMS_Live (MapServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (_UtilitiesWater/GEMS_Live)
Layers:
Layer:
Utilities_Water.DBO.Fire_Facilities
(0)
Name:
Utilities_Water.DBO.Fire_Facilities
Display Field:
FeatureType
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text:
Default Visibility: true
MaxRecordCount:
1000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0
Max Scale:
0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 2485134.7804143876
YMin: 382141.75764913857
XMax: 2506391.517428383
YMax: 408650.022545889
Spatial Reference: 2930 (2930)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[112, 143, 0, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
1
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: 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:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
ID
( type: esriFieldTypeOID, alias: ID )
X
( type: esriFieldTypeDouble, alias: X )
Y
( type: esriFieldTypeDouble, alias: Y )
FeatureType
( type: esriFieldTypeString, alias: FeatureType, length: 20 )
AboveGround
( type: esriFieldTypeString, alias: AboveGround, length: 5 )
Comments
( type: esriFieldTypeString, alias: Comments, length: 250 )
EditDate
( type: esriFieldTypeDate, alias: EditDate, length: 8 )
UserID
( type: esriFieldTypeString, alias: UserID, length: 50 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
Tables:
Table:
Utilities_Water.DBO.%vMeter_GIS_1
(1)
Name:
Utilities_Water.DBO.%vMeter_GIS_1
Display Field:
METERSIZE
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
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:
UniqIDs
( type: esriFieldTypeOID, alias: UniqIDs )
INSTALDATE
( type: esriFieldTypeInteger, alias: INSTALDATE )
METERSIZE
( type: esriFieldTypeString, alias: METERSIZE, length: 25 )
DISTRICT
( type: esriFieldTypeInteger, alias: DISTRICT )
METERBOOK
( type: esriFieldTypeString, alias: METERBOOK, length: 4 )
METERSTATUS
( type: esriFieldTypeString, alias: METERSTATUS, length: 25 )
SERIALNBR
( type: esriFieldTypeString, alias: SERIALNBR, length: 14 )
REGUOM
( type: esriFieldTypeString, alias: REGUOM, length: 5 )
ROUTE
( type: esriFieldTypeInteger, alias: ROUTE )
METERPAGE
( type: esriFieldTypeInteger, alias: METERPAGE )
MXU
( type: esriFieldTypeInteger, alias: MXU )
PARCELNO
( type: esriFieldTypeString, alias: PARCELNO, length: 20 )
Table:
Utilities_Water.DBO.%vTaps_GIS_2
(2)
Name:
Utilities_Water.DBO.%vTaps_GIS_2
Display Field:
ATDES
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
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:
UniqID
( type: esriFieldTypeOID, alias: UniqID )
TAPNBR
( type: esriFieldTypeInteger, alias: TAPNBR )
ATDES
( type: esriFieldTypeString, alias: ATDES, length: 25 )
FRAHOUSE
( type: esriFieldTypeString, alias: FRAHOUSE, length: 5 )
TAPSIZE_DESC
( type: esriFieldTypeString, alias: TAPSIZE_DESC, length: 25 )
SETDAT
( type: esriFieldTypeInteger, alias: SETDAT )
CURBDATE
( type: esriFieldTypeInteger, alias: CURBDATE )
MAINSIZE_DESC
( type: esriFieldTypeString, alias: MAINSIZE_DESC, length: 25 )
MAIN_MATL_DESC
( type: esriFieldTypeString, alias: MAIN_MATL_DESC, length: 25 )
MAIN_CURB_SIZE_DESC
( type: esriFieldTypeString, alias: MAIN_CURB_SIZE_DESC, length: 25 )
MAIN_CURB_MATL_DESC
( type: esriFieldTypeString, alias: MAIN_CURB_MATL_DESC, length: 25 )
CURB_BLDG_SIZE_DESC
( type: esriFieldTypeString, alias: CURB_BLDG_SIZE_DESC, length: 25 )
BLDGDATE
( type: esriFieldTypeInteger, alias: BLDGDATE )
COMMENT1
( type: esriFieldTypeString, alias: COMMENT1, length: 50 )
COMMENT2
( type: esriFieldTypeString, alias: COMMENT2, length: 50 )
COMMENT3
( type: esriFieldTypeString, alias: COMMENT3, length: 50 )
COMMENT4
( type: esriFieldTypeString, alias: COMMENT4, length: 50 )
COMMENT5
( type: esriFieldTypeString, alias: COMMENT5, length: 50 )
COMMENT6
( type: esriFieldTypeString, alias: COMMENT6, length: 50 )
COMMENT7
( type: esriFieldTypeString, alias: COMMENT7, length: 50 )
COMMENT8
( type: esriFieldTypeString, alias: COMMENT8, length: 50 )
COMMENT9
( type: esriFieldTypeString, alias: COMMENT9, length: 50 )
COMMENT10
( type: esriFieldTypeString, alias: COMMENT10, length: 50 )
CURB_BLDG_MATL_DESC
( type: esriFieldTypeString, alias: CURB_BLDG_MATL_DESC, length: 25 )
PINNBR
( type: esriFieldTypeString, alias: PINNBR, length: 40 )
Table:
Utilities_Water.dbo.vCustInfo_GIS
(3)
Name:
Utilities_Water.dbo.vCustInfo_GIS
Display Field:
CUSTNAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
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:
UniqIDs
( type: esriFieldTypeOID, alias: UniqIDs )
DESCRIPT_1
( type: esriFieldTypeString, alias: DESCRIPT_1, length: 25 )
OLDACCTNBR
( type: esriFieldTypeString, alias: OLDACCTNBR, length: 18 )
COUNTRY
( type: esriFieldTypeString, alias: COUNTRY, length: 15 )
COLLBAL
( type: esriFieldTypeDouble, alias: COLLBAL )
WORKPHONE
( type: esriFieldTypeDouble, alias: WORKPHONE )
TAX_PCT_I
( type: esriFieldTypeSingle, alias: TAX_PCT_I )
STREETPRF2
( type: esriFieldTypeString, alias: STREETPRF2, length: 2 )
ZIPCODE
( type: esriFieldTypeString, alias: ZIPCODE, length: 10 )
STREETDIR2
( type: esriFieldTypeString, alias: STREETDIR2, length: 2 )
PHONETIC
( type: esriFieldTypeString, alias: PHONETIC, length: 5 )
WOFFAMOUNT
( type: esriFieldTypeDouble, alias: WOFFAMOUNT )
PYMTDTE
( type: esriFieldTypeInteger, alias: PYMTDTE )
COLLAGENCY
( type: esriFieldTypeString, alias: COLLAGENCY, length: 5 )
BUDAMT
( type: esriFieldTypeDouble, alias: BUDAMT )
DRVLICNO2
( type: esriFieldTypeString, alias: DRVLICNO2, length: 15 )
REMSWDISC
( type: esriFieldTypeDouble, alias: REMSWDISC )
SEWRUSG
( type: esriFieldTypeInteger, alias: SEWRUSG )
PYMTDTNUM
( type: esriFieldTypeInteger, alias: PYMTDTNUM )
RELATION
( type: esriFieldTypeString, alias: RELATION, length: 10 )
EXEMPT
( type: esriFieldTypeString, alias: EXEMPT, length: 1 )
USERTYPE
( type: esriFieldTypeString, alias: USERTYPE, length: 5 )
HOLDBILL
( type: esriFieldTypeString, alias: HOLDBILL, length: 1 )
HOLDDEP
( type: esriFieldTypeString, alias: HOLDDEP, length: 1 )
AIDAMT
( type: esriFieldTypeSingle, alias: AIDAMT )
ORG_NBR
( type: esriFieldTypeSmallInteger, alias: ORG_NBR )
TAX_PCT
( type: esriFieldTypeSingle, alias: TAX_PCT )
XSTATUS
( type: esriFieldTypeString, alias: XSTATUS, length: 2 )
ACHACCTNBR
( type: esriFieldTypeString, alias: ACHACCTNBR, length: 17 )
COLLDATNUM
( type: esriFieldTypeInteger, alias: COLLDATNUM )
SURETYAMT
( type: esriFieldTypeDouble, alias: SURETYAMT )
OUTSIDER
( type: esriFieldTypeString, alias: OUTSIDER, length: 1 )
STREETTYP2
( type: esriFieldTypeString, alias: STREETTYP2, length: 5 )
CITY
( type: esriFieldTypeString, alias: CITY, length: 25 )
RETCHDT
( type: esriFieldTypeInteger, alias: RETCHDT )
PHONENBR
( type: esriFieldTypeDouble, alias: PHONENBR )
OPENDATE
( type: esriFieldTypeInteger, alias: OPENDATE )
CUSTNAME
( type: esriFieldTypeString, alias: CUSTNAME, length: 25 )
SURETYEXP
( type: esriFieldTypeInteger, alias: SURETYEXP )
ACHBANKNBR
( type: esriFieldTypeInteger, alias: ACHBANKNBR )
COLLDATE
( type: esriFieldTypeInteger, alias: COLLDATE )
CLOSEDATE
( type: esriFieldTypeInteger, alias: CLOSEDATE )
CLSEDATNUM
( type: esriFieldTypeInteger, alias: CLSEDATNUM )
CUSTNAME2
( type: esriFieldTypeString, alias: CUSTNAME2, length: 25 )
ACCTBAL
( type: esriFieldTypeDouble, alias: ACCTBAL )
AUTOPAYFL
( type: esriFieldTypeString, alias: AUTOPAYFL, length: 1 )
SSN
( type: esriFieldTypeInteger, alias: SSN )
BUDSETDTE
( type: esriFieldTypeInteger, alias: BUDSETDTE )
STATE
( type: esriFieldTypeString, alias: STATE, length: 2 )
MAILSUITE
( type: esriFieldTypeString, alias: MAILSUITE, length: 10 )
CARRIERRTE
( type: esriFieldTypeString, alias: CARRIERRTE, length: 4 )
ACCT_STAT
( type: esriFieldTypeString, alias: ACCT_STAT, length: 5 )
STREET2
( type: esriFieldTypeString, alias: STREET2, length: 25 )
STREETNBR2
( type: esriFieldTypeInteger, alias: STREETNBR2 )
REASON
( type: esriFieldTypeString, alias: REASON, length: 67 )
BUDTYP
( type: esriFieldTypeString, alias: BUDTYP, length: 6 )
REL_DATE
( type: esriFieldTypeInteger, alias: REL_DATE )
SSN2
( type: esriFieldTypeInteger, alias: SSN2 )
O_R
( type: esriFieldTypeString, alias: O_R, length: 1 )
DOLLARAID
( type: esriFieldTypeString, alias: DOLLARAID, length: 1 )
ADDLNAME
( type: esriFieldTypeString, alias: ADDLNAME, length: 25 )
DOB
( type: esriFieldTypeInteger, alias: DOB )
BILL
( type: esriFieldTypeString, alias: BILL, length: 1 )
LASTBILL
( type: esriFieldTypeInteger, alias: LASTBILL )
ACHACCTYPE
( type: esriFieldTypeString, alias: ACHACCTYPE, length: 1 )
APPLYDEPIN
( type: esriFieldTypeString, alias: APPLYDEPIN, length: 1 )
CHECKDIGIT
( type: esriFieldTypeSmallInteger, alias: CHECKDIGIT )
WORD4
( type: esriFieldTypeString, alias: WORD4, length: 25 )
WORD3
( type: esriFieldTypeString, alias: WORD3, length: 25 )
MAINT
( type: esriFieldTypeString, alias: MAINT, length: 1 )
WORD2
( type: esriFieldTypeString, alias: WORD2, length: 25 )
WORD1
( type: esriFieldTypeString, alias: WORD1, length: 25 )
SPECHANDFL
( type: esriFieldTypeString, alias: SPECHANDFL, length: 5 )
EXPIRDATE
( type: esriFieldTypeInteger, alias: EXPIRDATE )
COMPANY
( type: esriFieldTypeString, alias: COMPANY, length: 22 )
APPLYDEP
( type: esriFieldTypeString, alias: APPLYDEP, length: 1 )
EXEMPTDIS
( type: esriFieldTypeString, alias: EXEMPTDIS, length: 1 )
ADDRESS1
( type: esriFieldTypeString, alias: ADDRESS1, length: 25 )
BUDBILDTE
( type: esriFieldTypeInteger, alias: BUDBILDTE )
AUTHCD
( type: esriFieldTypeString, alias: AUTHCD, length: 5 )
LSTDELQDT
( type: esriFieldTypeInteger, alias: LSTDELQDT )
DRVLICNO
( type: esriFieldTypeString, alias: DRVLICNO, length: 15 )
HOLDPRNT
( type: esriFieldTypeString, alias: HOLDPRNT, length: 1 )
LIENDT
( type: esriFieldTypeInteger, alias: LIENDT )
REMWADISC
( type: esriFieldTypeDouble, alias: REMWADISC )
OWNERSNAME
( type: esriFieldTypeDouble, alias: OWNERSNAME )
CUSTNO
( type: esriFieldTypeDouble, alias: CUSTNO )
WOFFDATE
( type: esriFieldTypeInteger, alias: WOFFDATE )
EXEMPTCOL
( type: esriFieldTypeString, alias: EXEMPTCOL, length: 1 )
REQTIME
( type: esriFieldTypeInteger, alias: REQTIME )
MESSAGENBR
( type: esriFieldTypeSmallInteger, alias: MESSAGENBR )
SRVCKY
( type: esriFieldTypeInteger, alias: SRVCKY )
ADDRSNBR
( type: esriFieldTypeSmallInteger, alias: ADDRSNBR )
FRAHOUSE2
( type: esriFieldTypeString, alias: FRAHOUSE2, length: 5 )
PRVCLSDTNM
( type: esriFieldTypeInteger, alias: PRVCLSDTNM )
INQBUT
( type: esriFieldTypeString, alias: INQBUT, length: 1 )
OPENDATNUM
( type: esriFieldTypeInteger, alias: OPENDATNUM )
CONTFLOW
( type: esriFieldTypeString, alias: CONTFLOW, length: 1 )
EMAILADDR
( type: esriFieldTypeString, alias: EMAILADDR, length: 40 )
PRVCLSDATE
( type: esriFieldTypeInteger, alias: PRVCLSDATE )
SPHFREQ
( type: esriFieldTypeSmallInteger, alias: SPHFREQ )
EXEMPTLTE
( type: esriFieldTypeString, alias: EXEMPTLTE, length: 1 )
TRCODE
( type: esriFieldTypeString, alias: TRCODE, length: 6 )
QUANTITY
( type: esriFieldTypeDouble, alias: QUANTITY )
STREETPREF
( type: esriFieldTypeString, alias: STREETPREF, length: 2 )
STREETNBR
( type: esriFieldTypeInteger, alias: STREETNBR )
STREET
( type: esriFieldTypeString, alias: STREET, length: 25 )
STREETTYPE
( type: esriFieldTypeString, alias: STREETTYPE, length: 5 )
STREETDIR
( type: esriFieldTypeString, alias: STREETDIR, length: 2 )
SUITE
( type: esriFieldTypeString, alias: SUITE, length: 10 )
FRAHOUSE
( type: esriFieldTypeString, alias: FRAHOUSE, length: 5 )
ADKEY
( type: esriFieldTypeInteger, alias: ADKEY )
PROP_ID
( type: esriFieldTypeString, alias: PROP_ID, length: 40 )
Table:
Utilities_Water.dbo.vConsumption_GIS
(4)
Name:
Utilities_Water.dbo.vConsumption_GIS
Display Field:
OVERIDEDT
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
fe991c69a9f44f0da5b97a0eead93cfc
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
1000
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:
UniqIDs
( type: esriFieldTypeOID, alias: UniqIDs )
TRANSDATE
( type: esriFieldTypeInteger, alias: TRANSDATE )
ACTUALUSED
( type: esriFieldTypeInteger, alias: ACTUALUSED )
SERVDAYS
( type: esriFieldTypeSmallInteger, alias: SERVDAYS )
OVERIDEDT
( type: esriFieldTypeString, alias: OVERIDEDT, length: 1 )
SERIALNBR
( type: esriFieldTypeString, alias: SERIALNBR, length: 14 )
READING
( type: esriFieldTypeInteger, alias: READING )
ESTRECD
( type: esriFieldTypeString, alias: ESTRECD, length: 2 )
DEMANDREAD
( type: esriFieldTypeDouble, alias: DEMANDREAD )
OFFPDEMDUS
( type: esriFieldTypeDouble, alias: OFFPDEMDUS )
CONSUMED
( type: esriFieldTypeInteger, alias: CONSUMED )
TRANSNBR
( type: esriFieldTypeDouble, alias: TRANSNBR )
ADKEY
( type: esriFieldTypeInteger, alias: ADKEY )
USAGEMONTH
( type: esriFieldTypeInteger, alias: USAGEMONTH )
READDATNUM
( type: esriFieldTypeInteger, alias: READDATNUM )
OFFPDEMDRD
( type: esriFieldTypeDouble, alias: OFFPDEMDRD )
READCODE
( type: esriFieldTypeSmallInteger, alias: READCODE )
CURRENTCUS
( type: esriFieldTypeSmallInteger, alias: CURRENTCUS )
CUSTNO
( type: esriFieldTypeDouble, alias: CUSTNO )
DEMANDUSED
( type: esriFieldTypeDouble, alias: DEMANDUSED )
RMOVED
( type: esriFieldTypeString, alias: RMOVED, length: 1 )
WORS
( type: esriFieldTypeString, alias: WORS, length: 1 )
BILLED
( type: esriFieldTypeInteger, alias: BILLED )
METERKY
( type: esriFieldTypeInteger, alias: METERKY )
MXCONSUMED
( type: esriFieldTypeInteger, alias: MXCONSUMED )
USGFLAG2
( type: esriFieldTypeString, alias: USGFLAG2, length: 1 )
USGFLAG1
( type: esriFieldTypeString, alias: USGFLAG1, length: 1 )
OLDMETERKY
( type: esriFieldTypeInteger, alias: OLDMETERKY )
MNCONSUMED
( type: esriFieldTypeInteger, alias: MNCONSUMED )
KWRDORIG
( type: esriFieldTypeDouble, alias: KWRDORIG )
KVRHREAD
( type: esriFieldTypeInteger, alias: KVRHREAD )
CALCPWRF
( type: esriFieldTypeSingle, alias: CALCPWRF )
KVRHUSED
( type: esriFieldTypeInteger, alias: KVRHUSED )
BILLEDKW
( type: esriFieldTypeDouble, alias: BILLEDKW )
KWUSED
( type: esriFieldTypeDouble, alias: KWUSED )
SONBR
( type: esriFieldTypeInteger, alias: SONBR )
STREETDIR
( type: esriFieldTypeString, alias: STREETDIR, length: 2 )
STREETPREF
( type: esriFieldTypeString, alias: STREETPREF, length: 2 )
STREETNBR
( type: esriFieldTypeInteger, alias: STREETNBR )
SUITE
( type: esriFieldTypeString, alias: SUITE, length: 10 )
FRAHOUSE
( type: esriFieldTypeString, alias: FRAHOUSE, length: 5 )
STREETTYPE
( type: esriFieldTypeString, alias: STREETTYPE, length: 5 )
STREET
( type: esriFieldTypeString, alias: STREET, length: 25 )