ArcGIS REST Services Directory
Login
Home
>
services
>
AAProjectsPublicFS (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (AAProjectsPublicFS)
Layers:
Layer:
SDE.DBO.aaProject
(0)
Name:
SDE.DBO.aaProject
Display Field:
PROJECTNAME
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
191aac50d85d446e8768033a1a4bf800
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
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -17791200
YMin: -47526900
XMax: 745430.171744246
YMax: 1441613.3875804916
Spatial Reference: 102755 (3736)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1:
SUBTYPEDESC
Field 2:
N/A
Field 3:
N/A
Field Delimiter:
,
Default Symbol:
N/A
Default Label:
N/A
UniqueValueInfos:
Value:
Drainage Projects
Label:
Drainage Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[0, 255, 197, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Miscellaneous Projects
Label:
Miscellaneous Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[255, 170, 0, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Parks/Beautification Projects
Label:
Parks/Beautification Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[76, 230, 0, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Sewer Projects
Label:
Sewer Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[115, 76, 0, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Street/Sidewalk Projects
Label:
Street/Sidewalk Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[197, 0, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Traffic Signal Projects
Label:
Traffic Signal Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[115, 178, 255, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Value:
Water Projects
Label:
Water Projects
Description:
N/A
Symbol:
Style:
esriSFSSolid
Color:
[0, 92, 230, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
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: true
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
SUBTYPEDESC
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
BIDAWARDED
( type: esriFieldTypeDate, alias: Bid Awarded, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BIDAWARDED )
CADlayer
( type: esriFieldTypeString, alias: AutoCAD Layer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CADlayer )
COGID
( type: esriFieldTypeString, alias: City ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: COGID )
COMMENT
( type: esriFieldTypeString, alias: GIS Comment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENT )
COMPLETED
( type: esriFieldTypeDate, alias: Date Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMPLETED )
CONTRACTOR
( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR )
LASTEDITOR
( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LASTEDITOR )
MANAGER
( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANAGER )
LASTUPDATE
( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
LIFECYCLE
( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LIFECYCLE )
PRJCITY
( type: esriFieldTypeSmallInteger, alias: City Project, editable: true, nullable: true, defaultValue: null, modelName: PRJCITY )
PRJONE
( type: esriFieldTypeSmallInteger, alias: 1 % Project, editable: true, nullable: true, defaultValue: null, modelName: PRJONE )
PROJECTCODE
( type: esriFieldTypeString, alias: Project Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECTCODE )
PROJECTNAME
( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROJECTNAME )
PROJECTYEAR
( type: esriFieldTypeSmallInteger, alias: Project Year, editable: true, nullable: true, defaultValue: null, modelName: PROJECTYEAR )
SOURCEDATE
( type: esriFieldTypeDate, alias: Source Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SOURCEDATE )
SOURCEENTITY
( type: esriFieldTypeString, alias: Source Entity, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCEENTITY )
SOURCETYPE
( type: esriFieldTypeString, alias: Source Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCETYPE )
SubtypeCD
( type: esriFieldTypeSmallInteger, alias: Subtype Code, editable: true, nullable: true, defaultValue: 0, modelName: SubtypeCD )
TOTALCOST
( type: esriFieldTypeDouble, alias: Total Cost, editable: true, nullable: true, defaultValue: null, modelName: TOTALCOST )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
DPTCONTACT
( type: esriFieldTypeString, alias: Department Contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DPTCONTACT ,
Coded Values:
[Admin: Administration and Administrative Services] , [EDS: Engineering and Developmental Services] , [PW: Public Works]
, ...2 more...
)
DPTPHONE
( type: esriFieldTypeString, alias: Department Phone #, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DPTPHONE )
CONSULTANT
( type: esriFieldTypeString, alias: Consultant, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONSULTANT )
SUBTYPEDESC
( type: esriFieldTypeString, alias: Subtype Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBTYPEDESC )
CIPPROJECT
( type: esriFieldTypeSmallInteger, alias: CIP Project, editable: true, nullable: true, defaultValue: null, modelName: CIPPROJECT ,
Coded Values:
[0: False] , [1: True] )
STARTDATE
( type: esriFieldTypeString, alias: Start Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STARTDATE )
ENDDATE
( type: esriFieldTypeString, alias: End Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ENDDATE )
FUNDING
( type: esriFieldTypeString, alias: Funding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FUNDING )
COUNCILDATE
( type: esriFieldTypeDate, alias: Council Acceptance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COUNCILDATE )
WARRANTYDATE
( type: esriFieldTypeDate, alias: Warranty End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
DIVCONTACT
( type: esriFieldTypeString, alias: Division Contact, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DIVCONTACT ,
Coded Values:
[NA: Not Applicable] , [Water: Water Division] , [Wastewater: Wastewater Division]
, ...9 more...
)
Shape__Area
( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
Shape__Length
( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
URL
( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 250, defaultValue: null, modelName: URL )
FISCALYEAR
( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FISCALYEAR ,
Coded Values:
[2018 / 2019: 2018 / 2019] , [2019 / 2020: 2019 / 2020] , [2020 / 2021: 2020 / 2021]
, ...19 more...
)
CONAPP
( type: esriFieldTypeSmallInteger, alias: Construction App, editable: true, nullable: true, defaultValue: null, modelName: CONAPP ,
Coded Values:
[0: False] , [1: True] )
FUNDINGSOURCE
( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FUNDINGSOURCE )
SYNOPSIS
( type: esriFieldTypeString, alias: Project Synopsis, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: SYNOPSIS )
SHOWONCOG
( type: esriFieldTypeSmallInteger, alias: Show on COG Maps, editable: true, nullable: true, defaultValue: null, modelName: SHOWONCOG ,
Coded Values:
[0: False] , [1: True] )
Types:
ID: Drainage Projects
Name: Drainage Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Drainage Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Drainage Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Miscellaneous Projects
Name: Miscellaneous Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Miscellaneous Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Miscellaneous Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Parks/Beautification Projects
Name: Parks/Beautification Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Parks/Beautification Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Parks/Beautification Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Sewer Projects
Name: Sewer Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Sewer Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Sewer Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Street/Sidewalk Projects
Name: Street/Sidewalk Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Street/Sidewalk Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Street/Sidewalk Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Traffic Signal Projects
Name: Traffic Signal Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Traffic Signal Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Traffic Signal Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon
ID: Water Projects
Name: Water Projects
Domains:
DPTCONTACT:
Inherited
CIPPROJECT:
Inherited
DIVCONTACT:
Inherited
FISCALYEAR:
Inherited
CONAPP:
Inherited
SHOWONCOG:
Inherited
Templates:
Name: Water Projects
Description:
Prototype:
BIDAWARDED:
null
CONTRACTOR:
null
SOURCEDATE:
null
SOURCEENTITY:
COGGIS
SOURCETYPE:
Sketch
CONSULTANT:
null
FISCALYEAR:
null
SYNOPSIS:
null
CADlayer:
AA-PROJ-____-POLY-E
COGID:
null
COMMENT:
null
COMPLETED:
null
LASTEDITOR:
JillM
MANAGER:
null
LASTUPDATE:
null
LIFECYCLE:
null
PRJCITY:
null
PRJONE:
null
PROJECTCODE:
null
PROJECTNAME:
null
PROJECTYEAR:
null
SubtypeCD:
0
TOTALCOST:
null
SHOWONCOG:
null
DPTCONTACT:
null
DPTPHONE:
null
SUBTYPEDESC:
Water Projects
CIPPROJECT:
null
STARTDATE:
null
ENDDATE:
null
FUNDING:
null
COUNCILDATE:
null
WARRANTYDATE:
null
DIVCONTACT:
null
FUNDINGSOURCE:
null
CONAPP:
1
URL:
null
Drawing Tool: esriFeatureEditToolPolygon