Layers:

Layer: Green Infrastructure Reference (0)

Name: Green Infrastructure Reference

Display Field: DDOT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: 392535.7484000027
YMin: 126929.40349999815
XMax: 407193.72900000215
YMax: 147431.66640000045
Spatial Reference: 26985  (26985)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [140, 99, 63, 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: true
Supports Returning Geometry Centroid: false
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GREEN_INFRA_ID ( type: esriFieldTypeGUID, alias: GREEN_INFRA_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GREEN_INFRA_ID )
• DDOT_ID ( type: esriFieldTypeString, alias: DDOT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DDOT_ID )
• PROJECT_ADDRESS ( type: esriFieldTypeString, alias: PROJECT ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PROJECT_ADDRESS )
• PROJECT_ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PROJECT_ZIP )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• WATERSHED_8DIGIT ( type: esriFieldTypeString, alias: WATERSHED 8DIGIT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WATERSHED_8DIGIT , Coded Values: [02140205: Anacostia River] , [02140202: Potomac River MO County] , [02140201: Potomac River Upper Tidal] , ...2 more... )
• SEWER_SYSTEM ( type: esriFieldTypeString, alias: SEWER SYSTEM, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SEWER_SYSTEM , Coded Values: [MS4: MS4] , [CSO: CSO] )
• WARD ( type: esriFieldTypeString, alias: WARD, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WARD , Coded Values: [1: Ward 1] , [2: Ward 2] , [3: Ward 3] , ...5 more... )
• ANC ( type: esriFieldTypeString, alias: ANC, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ANC , Coded Values: [1A: ANC 1A] , [1B: ANC 1B] , [1D: ANC 1D] , ...37 more... )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDIT_USER ( type: esriFieldTypeString, alias: LAST EDIT USER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_EDIT_USER )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST EDIT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_DATE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CREATED_USER )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [Active: Active] , [Inactive: Inactive] )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Green Infrastructure Reference
  Description:
  Prototype:
  STATUS: null
  GREEN_INFRA_ID: null
  DDOT_ID: null
  PROJECT_ADDRESS: null
  PROJECT_ZIP: null
  LONGITUDE: null
  LATITUDE: null
  WATERSHED_8DIGIT: null
  SEWER_SYSTEM: null
  WARD: null
  ANC: null
  LAST_EDIT_DATE: null
  LAST_EDIT_USER: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Green_Infrastructure (0) -- Related To: Green Infrastructure (1)

Layer: Green Infrastructure (1)

Name: Green Infrastructure

Display Field: REVIEWER_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: 392507.9882000014
YMin: 126881.24439999834
XMax: 407245.05110000074
YMax: 147479.6484999992
Spatial Reference: 26985  (26985)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [230, 213, 204, 255]
Outline:
N/A
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: 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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GREEN_INFRA_ID ( type: esriFieldTypeGUID, alias: GREEN_INFRA_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GREEN_INFRA_ID )
• DOEE_ID ( type: esriFieldTypeString, alias: DOEE_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DOEE_ID )
• DDOT_ID ( type: esriFieldTypeString, alias: DDOT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DDOT_ID )
• MASTER_TYPE ( type: esriFieldTypeString, alias: MASTER_TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MASTER_TYPE , Coded Values: [BR: Bioretention] , [FS: Filtering Systems] , [ID: Impervious Surface Disconnection] , ...7 more... )
• DESIGN_SUB ( type: esriFieldTypeString, alias: DESIGN_SUB, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DESIGN_SUB , Coded Values: [AL: Alley] , [BR: Bioretention] , [BS: Bioswale] , ...16 more... )
• DESIGN_SUB_MATERIAL ( type: esriFieldTypeString, alias: DESIGN_SUB_MATERIAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DESIGN_SUB_MATERIAL , Coded Values: [PP: Permeable Pavers] , [PC: Pervious Concrete] , [PGP: Plastic Grid Pavers] , ...2 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATUS , Coded Values: [AB: Abandoned] , [EX: Existing] , [PR: Proposed] , ...3 more... )
• PUBLIC_ROW_TYPE ( type: esriFieldTypeString, alias: PUBLIC_ROW_TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PUBLIC_ROW_TYPE , Coded Values: [AL: Alley] , [ST: Street] , [O: Other] )
• FACILITY_PLACEMENT ( type: esriFieldTypeString, alias: FACILITY_PLACEMENT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FACILITY_PLACEMENT , Coded Values: [CURB: Bumpout/Curb Extension] , [MEDIAN: Median] , [OTHER: Other - Comment] , ...1 more... )
• UNDERDRAIN ( type: esriFieldTypeString, alias: UNDERDRAIN, editable: true, nullable: true, length: 2, defaultValue: null, modelName: UNDERDRAIN , Coded Values: [EU: Enhanced w/ Underdrain] , [EN: Enhanced w/out Underdrain] , [ST: Standard] , ...1 more... )
• UNDERDRAIN_LENGTH_FT ( type: esriFieldTypeDouble, alias: UNDERDRAIN_LENGTH_FT, editable: true, nullable: true, defaultValue: null, modelName: UNDERDRAIN_LENGTH_FT )
• UNDERDRAIN_CONNECTION ( type: esriFieldTypeString, alias: UNDERDRAIN_CONNECTION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UNDERDRAIN_CONNECTION , Coded Values: [SSP: Storm Sewer Pipe] , [CB: Catch Basin] , [MH: Manhole] , ...1 more... )
• UNDERDRAIN_CONTROL_TYPE ( type: esriFieldTypeString, alias: UNDERDRAIN_CONTROL_TYPE, editable: true, nullable: true, length: 7, defaultValue: null, modelName: UNDERDRAIN_CONTROL_TYPE , Coded Values: [ORIFICE: Orifice] , [VALVE: Valve] , [NA: N/A] )
• INFLOW ( type: esriFieldTypeString, alias: INFLOW, editable: true, nullable: true, length: 4, defaultValue: null, modelName: INFLOW , Coded Values: [CCO: Curb Cut Open] , [CCC: Curb Cut Covered] , [INL: Inlet] , ...2 more... )
• OUTFLOW ( type: esriFieldTypeString, alias: OUTFLOW, editable: true, nullable: true, length: 4, defaultValue: null, modelName: OUTFLOW , Coded Values: [CCO: Curb Cut Open] , [CCC: Curb Cut Covered] , [TD: Trench Drain] , ...5 more... )
• VELOCITY_DISSIPATER ( type: esriFieldTypeString, alias: VELOCITY_DISSIPATER, editable: true, nullable: true, length: 4, defaultValue: null, modelName: VELOCITY_DISSIPATER , Coded Values: [ROCK: Rock/ Gravel] , [CONC: Concrete] , [NONE: None] )
• AREA_SQFT ( type: esriFieldTypeDouble, alias: AREA_SQFT, editable: true, nullable: true, defaultValue: null, modelName: AREA_SQFT )
• DEPTH_FT ( type: esriFieldTypeDouble, alias: DEPTH_FT, editable: true, nullable: true, defaultValue: null, modelName: DEPTH_FT )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: GEN_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• LAST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: LAST_INSPECTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• LAST_INSPECTION_CONDITION ( type: esriFieldTypeString, alias: LAST_INSPECTION_CONDITION, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LAST_INSPECTION_CONDITION , Coded Values: [EX: Excellent] , [GO: Good] , [FA: Fair] , ...2 more... )
• CONTRACT_ID ( type: esriFieldTypeGUID, alias: CONTRACT_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CONTRACT_ID )
• PUBLIC_SPACE_PERMIT_ID ( type: esriFieldTypeGUID, alias: PUBLIC_SPACE_PERMIT_ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PUBLIC_SPACE_PERMIT_ID )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• HISTORIC_BMP_ID ( type: esriFieldTypeString, alias: HISTORIC_BMP_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HISTORIC_BMP_ID )
• CONDITION_NOTES ( type: esriFieldTypeString, alias: CONDITION_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONDITION_NOTES )
• REVIEWER_NAME ( type: esriFieldTypeString, alias: REVIEWER_NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REVIEWER_NAME )
• INSPECTOR_NAME ( type: esriFieldTypeString, alias: INSPECTOR_NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INSPECTOR_NAME )
• ROUTINE_MAINTENANCE_CREW ( type: esriFieldTypeString, alias: ROUTINE_MAINTENANCE_CREW, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ROUTINE_MAINTENANCE_CREW )
• STATUS_GI ( type: esriFieldTypeString, alias: STATUS_GI, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS_GI , Coded Values: [Active: Active] , [Inactive: Inactive] )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STArea() )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, required: true, nullable: true, defaultValue: null, modelName: Shape.STLength() )
Templates:
• Name: Green Infrastructure
  Description:
  Prototype:
  STATUS_GI: null
  GREEN_INFRA_ID: null
  DOEE_ID: null
  DDOT_ID: null
  MASTER_TYPE: null
  DESIGN_SUB: null
  DESIGN_SUB_MATERIAL: null
  STATUS: null
  PUBLIC_ROW_TYPE: null
  FACILITY_PLACEMENT: null
  UNDERDRAIN: null
  UNDERDRAIN_LENGTH_FT: null
  UNDERDRAIN_CONNECTION: null
  UNDERDRAIN_CONTROL_TYPE: null
  INFLOW: null
  OUTFLOW: null
  VELOCITY_DISSIPATER: null
  AREA_SQFT: null
  DEPTH_FT: null
  GEN_COMMENTS: null
  LAST_INSPECTION_DATE: null
  LAST_INSPECTION_CONDITION: null
  CONTRACT_ID: null
  PUBLIC_SPACE_PERMIT_ID: null
  ROUTINE_MAINTENANCE_CREW: null
  INSPECTOR_NAME: null
  REVIEWER_NAME: null
  CONDITION_NOTES: null
  HISTORIC_BMP_ID: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• Green_Infra_Ref (0) -- Related To: Green Infrastructure Reference (0)
• Green_Infra_Activity (1) -- Related To: Green Infrastructure (2)
• Public_Space_Permit (2) -- Related To: Public Space Permit (6)
• DDOT_Contract (3) -- Related To: DDOT Contract (3)

Tables:

Table: Green Infrastructure (2)

Name: Green Infrastructure

Display Field: AS_BUILT_STATUS

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GREEN_INFRA_ID ( type: esriFieldTypeGUID, alias: GREEN INFRA ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GREEN_INFRA_ID )
• AS_BUILT_STATUS ( type: esriFieldTypeString, alias: AS BUILT STATUS, editable: true, nullable: true, length: 2, defaultValue: null, modelName: AS_BUILT_STATUS , Coded Values: [RE: Required] , [IP: In Progress] , [CO: Completed] )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OWNER , Coded Values: [DOEE: Department of Energy & Environment] , [DDOT: District Department of Transportation] , [DGS: Department of General Services] , ...3 more... )
• MAINT_ORGANIZATION ( type: esriFieldTypeString, alias: MAINTENANCE ORGANIZATION, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MAINT_ORGANIZATION , Coded Values: [DOEE: Department of Energy & Environment] , [DDOT: District Department of Transportation] , [DGS: Department of General Services] , ...3 more... )
• MAINT_AGREEMENT ( type: esriFieldTypeString, alias: MAINTENANCE AGREEMENT, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MAINT_AGREEMENT , Coded Values: [COV: Covenant] , [MOA: Memorandum of Agreement] , [MOU: Memorandum of Understanding] , ...2 more... )
• CONSTRUCTION_INSTALL_DATE ( type: esriFieldTypeDate, alias: CONSTRUCTION INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONSTRUCTION_INSTALL_DATE )
• PLANTING_INSTALL_DATE ( type: esriFieldTypeDate, alias: PLANTING INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANTING_INSTALL_DATE )
• SUBSTANTIAL_COMPLETION ( type: esriFieldTypeDate, alias: SUBSTANTIAL COMPLETION, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SUBSTANTIAL_COMPLETION )
• FINAL_ACCEPTANCE ( type: esriFieldTypeDate, alias: FINAL ACCEPTANCE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINAL_ACCEPTANCE )
• PLANT_GUARANTEE_END_DATE ( type: esriFieldTypeDate, alias: PLANT GUARANTEE END DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANT_GUARANTEE_END_DATE )
• WARRANTY_END_DATE ( type: esriFieldTypeDate, alias: WARRANTY END DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTY_END_DATE )
• DATE_REMOVED ( type: esriFieldTypeDate, alias: DATE REMOVED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_REMOVED )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED USER, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CREATED_USER )
• LAST_EDIT_USER ( type: esriFieldTypeString, alias: LAST EDIT USER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_EDIT_USER )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST EDIT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_DATE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Green Infrastructure
  Description:
  Prototype:
  LAST_EDIT_USER: null
  GREEN_INFRA_ID: null
  AS_BUILT_STATUS: null
  OWNER: null
  MAINT_ORGANIZATION: null
  MAINT_AGREEMENT: null
  CONSTRUCTION_INSTALL_DATE: null
  PLANTING_INSTALL_DATE: null
  SUBSTANTIAL_COMPLETION: null
  FINAL_ACCEPTANCE: null
  PLANT_GUARANTEE_END_DATE: null
  WARRANTY_END_DATE: null
  DATE_REMOVED: null
  LAST_EDIT_DATE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Green_Infrastructure (1) -- Related To: Green Infrastructure (1)

Table: DDOT Contract (3)

Name: DDOT Contract

Display Field: PROJECT_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CONTRACT_ID ( type: esriFieldTypeGUID, alias: CONTRACT ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CONTRACT_ID )
• CONTRACT_NUMBER ( type: esriFieldTypeString, alias: CONTRACT NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACT_NUMBER )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_NAME )
• PROJECT_LIMITS ( type: esriFieldTypeString, alias: PROJECT LIMITS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_LIMITS )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OWNER , Coded Values: [DOEE: Department of Energy & Environment] , [DDOT: District Department of Transportation] , [DGS: Department of General Services] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATUS , Coded Values: [AB: As Built Approved] , [CC: Construction Complete] , [DE: Design] , ...3 more... )
• PLAN_DATE ( type: esriFieldTypeDate, alias: PLAN DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: DDOT Contract
  Description:
  Prototype:
  Editor: null
  CONTRACT_ID: null
  CONTRACT_NUMBER: null
  PROJECT_NAME: null
  PROJECT_LIMITS: null
  OWNER: null
  STATUS: null
  PLAN_DATE: null
  GEN_COMMENTS: null
  CreationDate: null
  Creator: null
  EditDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• FILE_ATTACH (4) -- Related To: File Attachments (4)
• Green_Infrastructure (3) -- Related To: Green Infrastructure (1)

Table: File Attachments (4)

Name: File Attachments

Display Field: FILENAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FILE_ATTACH_ID ( type: esriFieldTypeGUID, alias: FILE ATTACH ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: FILE_ATTACH_ID )
• CONTRACT_ID ( type: esriFieldTypeGUID, alias: CONTRACT ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CONTRACT_ID )
• PUBLIC_SPACE_PERMIT_ID ( type: esriFieldTypeGUID, alias: PUBLIC SPACE PERMIT ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PUBLIC_SPACE_PERMIT_ID )
• FILENAME ( type: esriFieldTypeString, alias: FILENAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FILENAME )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: File Attachments
  Description:
  Prototype:
  Editor: null
  FILE_ATTACH_ID: null
  CONTRACT_ID: null
  PUBLIC_SPACE_PERMIT_ID: null
  FILENAME: null
  GEN_COMMENTS: null
  CreationDate: null
  Creator: null
  EditDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DDOT_Contract (4) -- Related To: DDOT Contract (3)
• Public_Space_Permit (6) -- Related To: Public Space Permit (6)

Table: Public Space Permit (6)

Name: Public Space Permit

Display Field: PROJECT_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PUBLIC_SPACE_PERMIT_ID ( type: esriFieldTypeGUID, alias: PUBLIC SPACE PERMIT ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PUBLIC_SPACE_PERMIT_ID )
• PERMIT_NUMBER ( type: esriFieldTypeString, alias: PERMIT NUMBER, editable: true, nullable: true, length: 7, defaultValue: null, modelName: PERMIT_NUMBER )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_NAME )
• PROJECT_LIMITS ( type: esriFieldTypeString, alias: PROJECT LIMITS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_LIMITS )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OWNER , Coded Values: [DOEE: Department of Energy & Environment] , [DDOT: District Department of Transportation] , [DGS: Department of General Services] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATUS , Coded Values: [AB: As Built Approved] , [CC: Construction Complete] , [DE: Design] , ...3 more... )
• PLAN_DATE ( type: esriFieldTypeDate, alias: PLAN DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAN_DATE )
• GEN_COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GEN_COMMENTS )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED USER, editable: false, nullable: true, length: 48, defaultValue: null, modelName: CREATED_USER )
• LAST_EDIT_USER ( type: esriFieldTypeString, alias: LAST EDIT USER, editable: true, nullable: true, length: 48, defaultValue: null, modelName: LAST_EDIT_USER )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST EDIT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_DATE )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
Templates:
• Name: Public Space Permit
  Description:
  Prototype:
  EditDate: null
  PUBLIC_SPACE_PERMIT_ID: null
  PERMIT_NUMBER: null
  PROJECT_NAME: null
  PROJECT_LIMITS: null
  OWNER: null
  STATUS: null
  PLAN_DATE: null
  GEN_COMMENTS: null
  Creator: null
  Editor: null
  LAST_EDIT_USER: null
  LAST_EDIT_DATE: null
  CreationDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• FILE_ATTACH (6) -- Related To: File Attachments (4)
• Green_Infrastructure (2) -- Related To: Green Infrastructure (1)