Layers:

Layer: swBMP (0)

Name: swBMP

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

Extent:
XMin: 187144.04515941069
YMin: 1568409.8064042404
XMax: 224250.28459507972
YMax: 1598633.0799470693
Spatial Reference: 2967  (2967)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 85, 0, 255]
Size: 10.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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• facilityid ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...7 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...1 more... )
• type ( type: esriFieldTypeString, alias: Category, length: 25 , Coded Values: [Green: Green] , [Pond: Pond] , [Structure: Structure] )
• bmptype ( type: esriFieldTypeString, alias: BMP Type, length: 50 , Coded Values: [BioSwale: BioSwale] , [Forebay: Forebay] , [BMP ADS: ADS] , ...12 more... )
• watershed ( type: esriFieldTypeString, alias: Watershed, length: 50 )
• locdesc ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• activeflag ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: False] , [1: True] )
• subdivision ( type: esriFieldTypeString, alias: Subdivision, length: 50 , Coded Values: [A. BOONES ADDITION: A. BOONES ADDITION] , [A.L. CARSONS: A.L. CARSONS] , [ABBY VILLAS: ABBY VILLAS] , ...1116 more... )
• legaldrain ( type: esriFieldTypeString, alias: Legal Drain, length: 100 )
• creek ( type: esriFieldTypeString, alias: Creek, length: 100 )
• huc14 ( type: esriFieldTypeString, alias: HUC14, length: 75 , Coded Values: [Grassy Creek - East Grassy Creek: Grassy Creek - East Grassy Creek] , [Honey Creek - Turkey Pen Creek: Honey Creek - Turkey Pen Creek] , [Hurricane Creek (Johnson): Hurricane Creek (Johnson)] , ...3 more... )
• ommanual ( type: esriFieldTypeString, alias: O&M MANUAL, length: 255 )
• installyearnum ( type: esriFieldTypeSmallInteger, alias: InstallYearNum )
• cost ( type: esriFieldTypeDouble, alias: Cost )
• costalt1 ( type: esriFieldTypeDouble, alias: CostAlt1 )
• costlastupdate ( type: esriFieldTypeDate, alias: CostLastUpdate, length: 8 )
• installdate ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Relationships:

• db_bzkm2.hsu_vgv5e.videoLinks (0) -- Related To: videoLinks (4)
• db_bzkm2.hsu_vgv5e.AssetCostTable (1) -- Related To: Asset Cost Table (5)

Layer: swManholes (1)

Name: swManholes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

Extent:
XMin: 187309.31976324692
YMin: 1568697.9347649887
XMax: 224313.92882474512
YMax: 1598592.9133607373
Spatial Reference: 2967  (2967)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: hasvideo
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: No
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Yes
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• facilityid ( type: esriFieldTypeString, alias: Facility ID, length: 20 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...7 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...1 more... )
• watershed ( type: esriFieldTypeString, alias: Watershed, length: 50 )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• highelev ( type: esriFieldTypeDouble, alias: High Pipe Elevation )
• invertelev ( type: esriFieldTypeDouble, alias: Invert Elevation )
• invert ( type: esriFieldTypeDouble, alias: Invert )
• rimelev ( type: esriFieldTypeDouble, alias: Rim Elevation )
• locdesc ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• flowdir ( type: esriFieldTypeString, alias: Flow Direction, length: 25 , Coded Values: [East: East] , [North: North] , [South: South] , ...9 more... )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• activeflag ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: False] , [1: True] )
• subdivision ( type: esriFieldTypeString, alias: Subdivision, length: 50 , Coded Values: [A. BOONES ADDITION: A. BOONES ADDITION] , [A.L. CARSONS: A.L. CARSONS] , [ABBY VILLAS: ABBY VILLAS] , ...1116 more... )
• legaldrain ( type: esriFieldTypeString, alias: Legal Drain, length: 100 )
• creek ( type: esriFieldTypeString, alias: Creek, length: 100 )
• huc14 ( type: esriFieldTypeString, alias: HUC14, length: 75 , Coded Values: [Grassy Creek - East Grassy Creek: Grassy Creek - East Grassy Creek] , [Honey Creek - Turkey Pen Creek: Honey Creek - Turkey Pen Creek] , [Hurricane Creek (Johnson): Hurricane Creek (Johnson)] , ...3 more... )
• hasvideo ( type: esriFieldTypeSmallInteger, alias: hasVideo )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Relationships:

• db_bzkm2.hsu_vgv5e.videoLinks (2) -- Related To: videoLinks (4)
• db_bzkm2.hsu_vgv5e.AssetCostTable (3) -- Related To: Asset Cost Table (5)

Layer: swGavityMain (2)

Name: swGavityMain

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000

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

Extent:
XMin: 187120.17348799482
YMin: 1568375.3793077394
XMax: 224315.43800807744
YMax: 1598697.7625604868
Spatial Reference: 2967  (2967)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: hasvideo
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: No
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [51, 51, 51, 255]
  Width: 8
• Value: 1
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• facilityid ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• pipetype ( type: esriFieldTypeString, alias: Pipe Type, length: 50 , Coded Values: [BioSwale: BioSwale] , [Concrete Swale: Concrete Swale] , [Connectivity Line: Connectivity Line] , ...10 more... )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...7 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [-1: Private] , [-2: Other] , [1: City of Greenwood] , ...1 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• installyear ( type: esriFieldTypeString, alias: Year Built, length: 10 )
• material ( type: esriFieldTypeString, alias: Material, length: 20 , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...34 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...34 more... )
• mainshape ( type: esriFieldTypeString, alias: Main Shape, length: 50 , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more... )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• activeflag ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: False] , [1: True] )
• locdesc ( type: esriFieldTypeString, alias: Location Description, length: 100 )
• subdivision ( type: esriFieldTypeString, alias: Subdivision Section, length: 50 , Coded Values: [A. BOONES ADDITION: A. BOONES ADDITION] , [A.L. CARSONS: A.L. CARSONS] , [ABBY VILLAS: ABBY VILLAS] , ...1116 more... )
• creek ( type: esriFieldTypeString, alias: Creek, length: 50 , Coded Values: [Auburn Branch: Auburn Branch] , [East Grassy Creek: East Grassy Creek] , [Fair Brook: Fair Brook] , ...11 more... )
• legaldrain ( type: esriFieldTypeString, alias: Legal Drain, length: 100 , Coded Values: [AMITY: AMITY] , [ATWOOD: ATWOOD] , [BANTA-RAGSDALE: BANTA-RAGSDALE] , ...55 more... )
• huc14 ( type: esriFieldTypeString, alias: HUC14, length: 75 , Coded Values: [Grassy Creek - East Grassy Creek: Grassy Creek - East Grassy Creek] , [Honey Creek - Turkey Pen Creek: Honey Creek - Turkey Pen Creek] , [Hurricane Creek (Johnson): Hurricane Creek (Johnson)] , ...3 more... )
• watershed ( type: esriFieldTypeString, alias: Watershed, length: 50 )
• cnvyname ( type: esriFieldTypeString, alias: CNVYNAME, length: 50 )
• installyearnum ( type: esriFieldTypeSmallInteger, alias: InstallYearNum )
• cost ( type: esriFieldTypeDouble, alias: Cost )
• costalt1 ( type: esriFieldTypeDouble, alias: CostAlt1 )
• costlastupdate ( type: esriFieldTypeDate, alias: CostLastUpdate, length: 8 )
• hasvideo ( type: esriFieldTypeSmallInteger, alias: hasVideo )
• st_length(shape) ( type: esriFieldTypeDouble, alias: Shape_Length )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Relationships:

• db_bzkm2.hsu_vgv5e.videoLinks (4) -- Related To: videoLinks (4)
• db_bzkm2.hsu_vgv5e.AssetCostTable (5) -- Related To: Asset Cost Table (5)

Layer: Watersheds_All (3)

Name: Watersheds_All

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

Extent:
XMin: 186755.6804505773
YMin: 1553476.8241311535
XMax: 242161.64116074517
YMax: 1607798.8270354867
Spatial Reference: 2967  (2967)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [255, 255, 255, 255]
Outline:
Style: esriSLSSolid
Color: [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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• name ( type: esriFieldTypeString, alias: NAME, length: 80 )
• source ( type: esriFieldTypeString, alias: Source, length: 100 )
• sum_cost ( type: esriFieldTypeDouble, alias: Sum Cost )
• cnt_bmp ( type: esriFieldTypeInteger, alias: BMP Count )
• cnt_gmains ( type: esriFieldTypeInteger, alias: Gavity Main Count )
• sum_gmains_miles ( type: esriFieldTypeDouble, alias: Miles of Gravity Mains )
• acresnum ( type: esriFieldTypeDouble, alias: Acres )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• st_area(shape) ( type: esriFieldTypeDouble, alias: st_area(shape) )
• st_length(shape) ( type: esriFieldTypeDouble, alias: st_length(shape) )

Tables:

Table: videoLinks (4)

Name: videoLinks

Display Field: assetID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: assetID, length: 64 )
• assettype ( type: esriFieldTypeString, alias: assetType, length: 50 )
• workorderid ( type: esriFieldTypeInteger, alias: workorderID )
• workorderdesc ( type: esriFieldTypeString, alias: workorderDesc, length: 50 )
• commentid ( type: esriFieldTypeInteger, alias: commentID )
• datecreated ( type: esriFieldTypeDate, alias: dateCreated, length: 8 )
• datemodified ( type: esriFieldTypeDate, alias: dateModified, length: 8 )
• commentfull ( type: esriFieldTypeString, alias: commentFull, length: 2000 )
• commentgis ( type: esriFieldTypeString, alias: commentGIS, length: 512 )
• videolink ( type: esriFieldTypeString, alias: videoLink, length: 255 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Relationships:

• db_bzkm2.hsu_vgv5e.swBMP (0) -- Related To: swBMP (0)
• db_bzkm2.hsu_vgv5e.swManholes (2) -- Related To: swManholes (1)
• db_bzkm2.hsu_vgv5e.swGavityMain (4) -- Related To: swGavityMain (2)

Table: Asset Cost Table (5)

Name: Asset Cost Table

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
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: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assetid ( type: esriFieldTypeString, alias: AssetID, length: 32 )
• featureclass ( type: esriFieldTypeString, alias: FeatureClass, length: 100 )
• isvalid ( type: esriFieldTypeString, alias: isValid, length: 3 )
• sourcetype ( type: esriFieldTypeString, alias: SourceType, length: 50 )
• sourcerecord ( type: esriFieldTypeString, alias: SourceRecord, length: 100 )
• sourcedate ( type: esriFieldTypeDate, alias: SourceDate, length: 8 )
• sourcetotalcost ( type: esriFieldTypeDouble, alias: SourceTotalCost )
• cost ( type: esriFieldTypeDouble, alias: Cost )
• costtype ( type: esriFieldTypeString, alias: CostType, length: 50 )
• costdate ( type: esriFieldTypeDate, alias: CostDate, length: 8 )
• costyear ( type: esriFieldTypeSmallInteger, alias: CostYear )
• costalt ( type: esriFieldTypeDouble, alias: CostAlt )
• costaltdesc ( type: esriFieldTypeString, alias: CostAltDesc, length: 50 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 100 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )

Relationships:

• db_bzkm2.hsu_vgv5e.swBMP (1) -- Related To: swBMP (0)
• db_bzkm2.hsu_vgv5e.swManholes (3) -- Related To: swManholes (1)
• db_bzkm2.hsu_vgv5e.swGavityMain (5) -- Related To: swGavityMain (2)