Layers:

Layer: Hard_Surfaces (0)

Name: Hard_Surfaces

Display Field: FacilityName

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 819287.4228258282
YMin: 542920.0968251526
XMax: 846223.554977078
YMax: 582001.1840171516
Spatial Reference: 103444  (103444)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: Type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: BBALLCOURT
  Label: BASKETBALL COURT
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: BUILDING
  Label: BUILDING
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 76, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: INNERFOUT
  Label: INNER FOUNTAIN
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [130, 130, 130, 255]
  Width: 0
• Value: INNERTENNIS
  Label: INNER TENNIS COURT
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [173, 219, 165, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: LANDSCAPING
  Label: LANDSCAPING
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 158, 158, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: OUTERFOUT
  Label: OUTER FOUNTAIN
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [151, 219, 242, 255]
  Outline:
  Style: esriSLSSolid
  Color: [64, 101, 235, 255]
  Width: 0
• Value: OUTERTENNIS
  Label: OUTER TENNIS COURT
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [92, 137, 68, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: PARKINGLOT
  Label: PARKING LOT
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: PLAYGROUND
  Label: PLAYGROUND
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 202, 122, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: ROAD
  Label: ROAD
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: SIDEWALK
  Label: SIDEWALK
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: SOCCER
  Label: SOCCER
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [173, 219, 165, 255]
  Outline:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 0
• Value: STAIRS
  Label: STAIRS
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 194, 158, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: TRAIL
  Label: TRAIL
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 194, 158, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: WALL
  Label: WALL
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [225, 225, 225, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 0
Labeling Info:
Feature Draw Order:
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Area_calculated_sf ( type: esriFieldTypeDouble, alias: Calculated Area (sf) )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Surface GlobalID, length: 38 )
• LastInspection ( type: esriFieldTypeDate, alias: Last Inspection, length: 8 )
• PaverRating ( type: esriFieldTypeSmallInteger, alias: Paver Rating , Range: [1, 10] )
• Type ( type: esriFieldTypeString, alias: Type, length: 20 , Coded Values: [BUILDING: BUILDING] , [LANDSCAPING: LANDSCAPING] , [PARKINGLOT: PARKING LOT] , ...23 more... )
• FacilityName ( type: esriFieldTypeString, alias: Facility Name, length: 50 , Coded Values: [CITYHALL: CITY HALL] , [FIRE1: FIRE STATION 1] , [FIRE2: FIRE STATION 2] , ...49 more... )
• Description ( type: esriFieldTypeString, alias: Description, length: 100 )
• Area_design_sf ( type: esriFieldTypeDouble, alias: Design Area (sf) )
• DateInstalled ( type: esriFieldTypeDate, alias: Date Installed, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 , Coded Values: [ASPHALT: ASPHALT] , [BRICK: BRICK] , [CONCRETE: CONCRETE] , ...7 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Thickness ( type: esriFieldTypeString, alias: Thickness, length: 12 )
• Stalls_Parking ( type: esriFieldTypeSmallInteger, alias: Parking Stalls )
• Stalls_HandicapParking ( type: esriFieldTypeSmallInteger, alias: Handicap Parking Stalls )
• Trail_Length ( type: esriFieldTypeString, alias: Trail Length, length: 12 )
• TrailWidth_ft ( type: esriFieldTypeSmallInteger, alias: Trail Width (ft) )
• SurfaceID ( type: esriFieldTypeString, alias: SurfaceID, length: 20 )
• CreationDate ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STArea() ( type: esriFieldTypeDouble, alias: SHAPE.STArea() )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• Inspected ( type: esriFieldTypeString, alias: Inspected, length: 10 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• (3) -- Related To: tblConcreteInspection (6)
• (0) -- Related To: tblBrickInspection (4)
• (1) -- Related To: tblAsphaltInspection (2)
• (2) -- Related To: tblGravelInspection (8)

Tables:

Table: Hard_Surfaces__ATTACH (1)

Name: Hard_Surfaces__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )

Table: tblAsphaltInspection (2)

Name: tblAsphaltInspection

Display Field: Creator_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 20 , Coded Values: [PatrickGB: Patrick Engineering Field Staff] , [Appleton: Appleton Staff] , [oth: Other] )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SurfaceType ( type: esriFieldTypeInteger, alias: Surface Type , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Gravel] , ...1 more... )
• aspRaveling ( type: esriFieldTypeString, alias: Raveling, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Slight: Slight Raveling] , ...2 more... )
• aspFlushing ( type: esriFieldTypeString, alias: Flushing, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• aspPolishing ( type: esriFieldTypeString, alias: Polishing, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• aspRutting ( type: esriFieldTypeString, alias: Rutting, length: 6 , Coded Values: [NA: N/A] , [None: None] , [Slight: Slight] , ...2 more... )
• aspDistortion ( type: esriFieldTypeString, alias: Distortion, length: 10 )
• aspCracks_Traverse ( type: esriFieldTypeString, alias: Cracks - Traverse, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Tight: Tight Cracks] , ...3 more... )
• AspCracks_Relection ( type: esriFieldTypeString, alias: Cracks - Relection, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• aspCracks_Slippage ( type: esriFieldTypeString, alias: Cracks - Slippage, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Crescent: Crescent Slippage] , ...1 more... )
• aspCracks_Longitudinal ( type: esriFieldTypeString, alias: Cracks - Longitudinal, length: 10 , Coded Values: [NA: N/A] , [None: None] , [CenterLn: Center Line] , ...2 more... )
• aspCracks_Block ( type: esriFieldTypeString, alias: Cracks - Block, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Large: Large blocks (10' or greater across)] , ...2 more... )
• aspCracks_Alligator ( type: esriFieldTypeString, alias: Cracks - Alligator, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• aspPatches ( type: esriFieldTypeString, alias: Patches, length: 10 , Coded Values: [NA: N/A] , [None: None] , [GoodCond: Good Condition] , ...1 more... )
• aspPotholes ( type: esriFieldTypeString, alias: Potholes, length: 10 , Coded Values: [NA: N/A] , [None: None] , [SmIsolat: Small Isolated] , ...2 more... )
• Comments_ADA ( type: esriFieldTypeString, alias: Comments - ADA, length: 255 )
• Comments_SiteDrainage ( type: esriFieldTypeString, alias: Comments - Site Drainage, length: 255 )
• Comments_TrafficMobility ( type: esriFieldTypeString, alias: Comments - Traffic Mobility, length: 255 )
• Comments_Safety ( type: esriFieldTypeString, alias: Comments - Safety, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• HardSurfaceID ( type: esriFieldTypeGUID, alias: HardSurfaceID, length: 38 )
• Cause_HardscapeDistress ( type: esriFieldTypeString, alias: Cause Hardscape Distress, length: 255 )
• Recommend_RepairOptions ( type: esriFieldTypeString, alias: Recommend Repair Options, length: 255 )
• Cost_Repairs ( type: esriFieldTypeString, alias: Cost Repairs, length: 255 )
• Rating ( type: esriFieldTypeSmallInteger, alias: Rating , Range: [1, 10] )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 25 , Coded Values: [CITYHALL: CITY HALL] , [FIRE1: FIRE STATION 1] , [FIRE2: FIRE STATION 2] , ...49 more... )
• Creator_Name ( type: esriFieldTypeString, alias: Creator_Name, length: 30 )
• Creation_Date ( type: esriFieldTypeDate, alias: Creation_Date, length: 8 )
• LastEditor_Name ( type: esriFieldTypeString, alias: LastEditor_Name, length: 30 )
• LastEditor_Date ( type: esriFieldTypeDate, alias: LastEditor_Date, length: 8 )

Relationships:

• (1) -- Related To: Hard_Surfaces (0)

Table: tblAsphaltInspection__ATTACH (3)

Name: tblAsphaltInspection__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )

Table: tblBrickInspection (4)

Name: tblBrickInspection

Display Field: Creator_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 20 , Coded Values: [PatrickGB: Patrick Engineering Field Staff] , [Appleton: Appleton Staff] , [oth: Other] )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SurfaceType ( type: esriFieldTypeInteger, alias: Surface Type , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Gravel] , ...1 more... )
• Comments_ADA ( type: esriFieldTypeString, alias: Comments - ADA, length: 255 )
• Comments_SiteDrainage ( type: esriFieldTypeString, alias: Comments - Site Drainage, length: 255 )
• Comments_TrafficMobility ( type: esriFieldTypeString, alias: Comments - Traffic Mobility, length: 255 )
• Comments_Safety ( type: esriFieldTypeString, alias: Comments - Safety, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• HardSurfaceID ( type: esriFieldTypeGUID, alias: HardSurfaceID, length: 38 )
• Cause_HardscapeDistress ( type: esriFieldTypeString, alias: Cause Hardscape Distress, length: 255 )
• Recommend_RepairOptions ( type: esriFieldTypeString, alias: Recommend Repair Options, length: 255 )
• Cost_Repairs ( type: esriFieldTypeString, alias: Cost Repairs, length: 255 )
• Rating ( type: esriFieldTypeSmallInteger, alias: Rating , Range: [1, 10] )
• brkFading ( type: esriFieldTypeString, alias: Fading, length: 5 , Coded Values: [Yes: Yes] , [Mod: Moderate] , [Minor: Minor] , ...1 more... )
• brkChipping ( type: esriFieldTypeString, alias: Chipping, length: 5 , Coded Values: [Yes: Yes] , [Mod: Moderate] , [Minor: Minor] , ...1 more... )
• brkHeaving ( type: esriFieldTypeString, alias: Heaving, length: 5 , Coded Values: [Yes: Yes] , [Mod: Moderate] , [Minor: Minor] , ...1 more... )
• brkPumping ( type: esriFieldTypeString, alias: Pumping, length: 5 , Coded Values: [Yes: Yes] , [Mod: Moderate] , [Minor: Minor] , ...1 more... )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 25 , Coded Values: [CITYHALL: CITY HALL] , [FIRE1: FIRE STATION 1] , [FIRE2: FIRE STATION 2] , ...49 more... )
• Creator_Name ( type: esriFieldTypeString, alias: Creator_Name, length: 30 )
• Creation_Date ( type: esriFieldTypeDate, alias: Creation_Date, length: 8 )
• LastEditor_Name ( type: esriFieldTypeString, alias: LastEditor_Name, length: 30 )
• LastEditor_Date ( type: esriFieldTypeDate, alias: LastEditor_Date, length: 8 )

Relationships:

• (0) -- Related To: Hard_Surfaces (0)

Table: tblBrickInspection__ATTACH (5)

Name: tblBrickInspection__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )

Table: tblConcreteInspection (6)

Name: tblConcreteInspection

Display Field: Creator_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 20 , Coded Values: [PatrickGB: Patrick Engineering Field Staff] , [Appleton: Appleton Staff] , [oth: Other] )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SurfaceType ( type: esriFieldTypeInteger, alias: Surface Type , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Gravel] , ...1 more... )
• cncWearPolish ( type: esriFieldTypeString, alias: Wear Polish, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncMapCracking ( type: esriFieldTypeString, alias: Map Cracking, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncPopouts ( type: esriFieldTypeString, alias: Popouts, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncScaling ( type: esriFieldTypeString, alias: Scaling, length: 10 )
• cncShallowReinforcing ( type: esriFieldTypeString, alias: Shallow Reinforcing, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Signs: Signs] , ...1 more... )
• cncSpalling ( type: esriFieldTypeString, alias: Spalling, length: 10 , Coded Values: [NA: N/A] , [None: None] , [SmlSpall: Small Surface Spalls] , ...2 more... )
• cncJointsLongitudinal ( type: esriFieldTypeString, alias: Joints - Longitudinal, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Open: Open] , ...2 more... )
• cncJointsTransverse ( type: esriFieldTypeString, alias: Joints - Transverse, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Slight: Slight Faulting And Spalling] , ...1 more... )
• cncCracks_TransvSlabCrabs ( type: esriFieldTypeString, alias: Cracks - Transverse Slab Crabs, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Open: Open] , ...2 more... )
• cncCracks_D ( type: esriFieldTypeString, alias: Cracks - "D", length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncCracks_Corner ( type: esriFieldTypeString, alias: Cracks - Corner, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Minor: Minor] , ...1 more... )
• cncCracks_Meander ( type: esriFieldTypeString, alias: Cracks - Meander, length: 10 , Coded Values: [NA: N/A] , [None: None] , [ParToJnt: Parallel To Joint] , ...2 more... )
• cncBlowups ( type: esriFieldTypeString, alias: Blowups, length: 10 , Coded Values: [NA: N/A] , [None: None] , [InProg: In Progress] , ...1 more... )
• cncFaulting ( type: esriFieldTypeString, alias: Faulting, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Minor: Minor] , ...1 more... )
• cncSettlingHeave ( type: esriFieldTypeString, alias: Settling Heave, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncUtilityRepair ( type: esriFieldTypeString, alias: Utility Repair, length: 10 , Coded Values: [NA: N/A] , [FullCnc: Full Depth Concrete] , [Asphalt: Asphalt] )
• cncManholeInlet ( type: esriFieldTypeString, alias: Manhole Inlet, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• cncCurb ( type: esriFieldTypeString, alias: Curb, length: 2 )
• cncShoulder ( type: esriFieldTypeString, alias: Shoulder, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• Comments_ADA ( type: esriFieldTypeString, alias: Comments - ADA, length: 255 )
• Comments_SiteDrainage ( type: esriFieldTypeString, alias: Comments - Site Drainage, length: 255 )
• Comments_TrafficMobility ( type: esriFieldTypeString, alias: Comments - Traffic Mobility, length: 255 )
• Comments_Safety ( type: esriFieldTypeString, alias: Comments - Safety, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• HardSurfaceID ( type: esriFieldTypeGUID, alias: HardSurfaceID, length: 38 )
• Cause_HardscapeDistress ( type: esriFieldTypeString, alias: Cause Hardscape Distress, length: 255 )
• Recommend_RepairOptions ( type: esriFieldTypeString, alias: Recommend Repair Options, length: 255 )
• Cost_Repairs ( type: esriFieldTypeString, alias: Cost Repairs, length: 255 )
• Rating ( type: esriFieldTypeSmallInteger, alias: Rating , Range: [1, 10] )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 25 , Coded Values: [CITYHALL: CITY HALL] , [FIRE1: FIRE STATION 1] , [FIRE2: FIRE STATION 2] , ...49 more... )
• Creator_Name ( type: esriFieldTypeString, alias: Creator_Name, length: 30 )
• Creation_Date ( type: esriFieldTypeDate, alias: Creation_Date, length: 8 )
• LastEditor_Name ( type: esriFieldTypeString, alias: LastEditor_Name, length: 30 )
• LastEditor_Date ( type: esriFieldTypeDate, alias: LastEditor_Date, length: 8 )

Relationships:

• (3) -- Related To: Hard_Surfaces (0)

Table: tblConcreteInspection__ATTACH (7)

Name: tblConcreteInspection__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )

Table: tblGravelInspection (8)

Name: tblGravelInspection

Display Field: Creator_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 20 , Coded Values: [PatrickGB: Patrick Engineering Field Staff] , [Appleton: Appleton Staff] , [oth: Other] )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• SurfaceType ( type: esriFieldTypeInteger, alias: Surface Type , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Gravel] , ...1 more... )
• grvCrown ( type: esriFieldTypeString, alias: Crown, length: 10 , Coded Values: [Good: Good] , [Excel: Excellent] , [Flat: Flat] , ...2 more... )
• grvDitch ( type: esriFieldTypeString, alias: Ditch, length: 10 , Coded Values: [NA: N/A] , [None: None] , [WorkingD: Working Ditch] , ...2 more... )
• grvCulvert ( type: esriFieldTypeString, alias: Culvert, length: 10 , Coded Values: [work: working] , [plug: plugged] , [damage: damaged] )
• grvGravelLayer ( type: esriFieldTypeString, alias: Gravel Layer, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Excel: Excellent] , ...2 more... )
• grvWashBoarding ( type: esriFieldTypeString, alias: Wash Boarding, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Moderate: Moderate] , ...1 more... )
• grvPotholes ( type: esriFieldTypeString, alias: Potholes, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Sml: Small Isolated] , ...2 more... )
• grvRuts ( type: esriFieldTypeString, alias: Ruts, length: 10 , Coded Values: [NA: N/A] , [None: None] , [Moderate: Moderate] , ...1 more... )
• grvDust ( type: esriFieldTypeString, alias: Dust, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• grvLooseAggregate ( type: esriFieldTypeString, alias: Loose Aggregate, length: 2 , Coded Values: [Y: Yes] , [N: No] , [NA: N/A] )
• Comments_ADA ( type: esriFieldTypeString, alias: Comments - ADA, length: 255 )
• Comments_SiteDrainage ( type: esriFieldTypeString, alias: Comments - Site Drainage, length: 255 )
• Comments_TrafficMobility ( type: esriFieldTypeString, alias: Comments - Traffic Mobility, length: 255 )
• Comments_Safety ( type: esriFieldTypeString, alias: Comments - Safety, length: 255 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• HardSurfaceID ( type: esriFieldTypeGUID, alias: HardSurfaceID, length: 38 )
• Cause_HardscapeDistress ( type: esriFieldTypeString, alias: Cause Hardscape Distress, length: 255 )
• Recommend_RepairOptions ( type: esriFieldTypeString, alias: Recommend Repair Options, length: 255 )
• Cost_Repairs ( type: esriFieldTypeString, alias: Cost Repairs, length: 255 )
• Rating ( type: esriFieldTypeSmallInteger, alias: Rating , Range: [1, 10] )
• Facility ( type: esriFieldTypeString, alias: Facility, length: 25 , Coded Values: [CITYHALL: CITY HALL] , [FIRE1: FIRE STATION 1] , [FIRE2: FIRE STATION 2] , ...49 more... )
• Creator_Name ( type: esriFieldTypeString, alias: Creator_Name, length: 30 )
• Creation_Date ( type: esriFieldTypeDate, alias: Creation_Date, length: 8 )
• LastEditor_Name ( type: esriFieldTypeString, alias: LastEditor_Name, length: 30 )
• LastEditor_Date ( type: esriFieldTypeDate, alias: LastEditor_Date, length: 8 )

Relationships:

• (2) -- Related To: Hard_Surfaces (0)

Table: tblGravelInspection__ATTACH (9)

Name: tblGravelInspection__ATTACH

Display Field: ATT_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: null

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Feature Draw Order:
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:
• ATTACHMENTID ( type: esriFieldTypeOID, alias: ATTACHMENTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• DATA ( type: esriFieldTypeBlob, alias: DATA )