ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
_UtilitiesWater
>
GEMS_Tap (MapServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (_UtilitiesWater/GEMS_Tap)
Layers:
Layer:
Utilities_Water.DBO.Fire_Facilities
(0)
Name:
Utilities_Water.DBO.Fire_Facilities
Display Field:
X
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Service Item Id:
ec469f334ff14ea7870ebbfc891d2891
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.7804143867
YMin: 382141.7576491335
XMax: 2506391.517428384
YMax: 408650.02254589205
Spatial Reference: 103191 (6609)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[131, 50, 145, 255]
Size:
4.0
Angle:
0.0
XOffset:
0
YOffset:
0
Outline:
[0, 0, 0, 255]
Width:
0
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.CustInfo
(1)
Name:
Utilities_Water.DBO.CustInfo
Display Field:
CUSTNAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
ec469f334ff14ea7870ebbfc891d2891
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:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
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.Gems_Usage
(2)
Name:
Utilities_Water.DBO.Gems_Usage
Display Field:
TRANSDATE
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
ec469f334ff14ea7870ebbfc891d2891
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:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
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 )