Name: Hydrants

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2479314.35958005
YMin: 637789.153871387
XMax: 2708916.66272967
YMax: 919098.06594488
Spatial Reference: PROJCS["NAD_1983_StatePlane_South_Carolina_FIPS_3900",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Standard_Parallel_1",32.5],PARAMETER["Standard_Parallel_2",34.83333333333334],PARAMETER["Latitude_Of_Origin",31.83333333333333],UNIT["Foot",0.3048]]

Drawing Info:

{"renderer":{"visualVariables":[{"type":"colorInfo","field":"YearBuilt","stops":[{"value":455534166636,"color":[123,66,56,255],"label":"< 6/8/1984"},{"value":659906083318,"color":[194,61,51,255],"label":null},{"value":864278000000,"color":[236,82,68,255],"label":"5/21/1997"},{"value":1068649916682,"color":[249,129,108,255],"label":null},{"value":1273021833364,"color":[255,196,174,255],"label":"> 5/4/2010"}]},{"type":"sizeInfo","valueExpression":"var startTime = $feature.InspectionDate;\nvar endTime = 1465344360000;\nvar retVal = null;\nif (startTime != null && endTime != null) {\nstartTime = Date(startTime);\nendTime = Date(endTime);\nretVal = DateDiff(endTime, startTime, 'years');\n}\nreturn retVal;","valueUnit":"unknown","legendOptions":{"title":"Age, in years, from InspectionDate to 6/7/2016"},"minSize":6,"maxSize":37.5,"minDataValue":2,"maxDataValue":4.60656503678336}],"authoringInfo":{"visualVariables":[{"type":"colorInfo","minSliderValue":-1893456000000,"maxSliderValue":1451606400000,"theme":"high-to-low"},{"type":"sizeInfo","minSliderValue":0.00397009766615931,"maxSliderValue":4.60656503678336,"units":"years","startTime":"InspectionDate","endTime":1465344360000,"field":"InspectionDate"}]},"type":"classBreaks","field":"YearBuilt","valueExpression":"var startTime = $feature.InspectionDate;\nvar endTime = 1465344377330;\nvar retVal = null;\nif (startTime != null && endTime != null) {\nstartTime = Date(startTime);\nendTime = Date(endTime);\nretVal = DateDiff(endTime, startTime, 'months');\n}\nreturn retVal;","minValue":-9007199254740991,"classBreakInfos":[{"symbol":{"color":[227,139,79,255],"size":9,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSSquare","outline":{"color":[255,255,255,129],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"classMaxValue":9007199254740991}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Inspection_Required (type: esriFieldTypeString, alias: Inspection_Required, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Hydrant_Status (type: esriFieldTypeString, alias: Hydrant_Status, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 16, nullable: false, editable: true)
• Owned_by_GSWSA (type: esriFieldTypeString, alias: Owned_by_GSWSA, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Inspection_Report_Link (type: esriFieldTypeString, alias: Inspection_Report_Link, SQL Type: sqlTypeNVarchar, length: 250, nullable: true, editable: true)
• HYDRANT_NUMBER (type: esriFieldTypeInteger, alias: Hydrant_Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeNVarchar, length: 200, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: InspectionDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Subdivision (type: esriFieldTypeString, alias: Subdivision, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• HydrantZone (type: esriFieldTypeSmallInteger, alias: HydrantZone, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Insp_By (type: esriFieldTypeString, alias: Insp_By, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Static_PSI (type: esriFieldTypeSmallInteger, alias: Static_PSI, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Discharge_GPM (type: esriFieldTypeString, alias: Discharge_GPM, SQL Type: sqlTypeNVarchar, length: 5, nullable: true, editable: true)
• Flow_Pressure_Full (type: esriFieldTypeSmallInteger, alias: Flow_Pressure_Full, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Fire_Dep (type: esriFieldTypeString, alias: Fire_Dep, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Size_of_Main (type: esriFieldTypeDouble, alias: Size_of_Main, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• Hydrant_GV (type: esriFieldTypeString, alias: Hydrant_GV, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Year_Made (type: esriFieldTypeSmallInteger, alias: Year_Made, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Residual_Hydrant_Number (type: esriFieldTypeString, alias: Residual_Hydrant_Number, SQL Type: sqlTypeNVarchar, length: 50, nullable: true, editable: true)
• Residual_Pressure_Full (type: esriFieldTypeSmallInteger, alias: Residual_Pressure_Full, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• Residual_Pressure_500GPM (type: esriFieldTypeString, alias: Residual_Pressure_500GPM, SQL Type: sqlTypeNVarchar, length: 5, nullable: true, editable: true)
• Flow_Test_Date (type: esriFieldTypeDate, alias: Flow_Test_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Comment_ (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeNVarchar, length: 200, nullable: true, editable: true)
• Lucity_Hydrant_Rec_Number (type: esriFieldTypeInteger, alias: Lucity_Hydrant_Rec_Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GPS_Required (type: esriFieldTypeString, alias: GPS_Required, SQL Type: sqlTypeNVarchar, length: 3, nullable: true, editable: true)
• WO_Number (type: esriFieldTypeDouble, alias: WO_Number, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• WO_Completion_Date (type: esriFieldTypeDate, alias: WO_Completion_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Inspection_Link (type: esriFieldTypeString, alias: Inspection_Link, SQL Type: sqlTypeNVarchar, length: 300, nullable: true, editable: true)
• YearBuilt (type: esriFieldTypeDate, alias: Year Built, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• temp (type: esriFieldTypeString, alias: temp, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• temp2 (type: esriFieldTypeString, alias: temp2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• temp3 (type: esriFieldTypeString, alias: temp3, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• temp4 (type: esriFieldTypeString, alias: temp4, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• try2 (type: esriFieldTypeDate, alias: try2, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• GlobalID: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/7/2018 5:08:52 PM

Schema Last Edit Date: 11/7/2018 5:08:52 PM

Data Last Edit Date: 11/7/2018 5:08:52 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat