Name: RETROFITSDB.dbo.tblRetrofits
Display Field: RetrofitName
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: eb1836d6a7b64b61a7caee3132ed1db7
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 200000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing 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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
RetrofitID
(
type: esriFieldTypeOID, alias: RetrofitID
)
-
RetrofitName
(
type: esriFieldTypeString, alias: RetrofitName, length: 150
)
-
RetrofitTypeId
(
type: esriFieldTypeInteger, alias: RetrofitTypeId
)
-
Site_ID
(
type: esriFieldTypeInteger, alias: Site_ID
)
-
LocationType
(
type: esriFieldTypeString, alias: LocationType, length: 50
)
-
AddressStreetNumber
(
type: esriFieldTypeString, alias: AddressStreetNumber, length: 100
)
-
AddressStreetName
(
type: esriFieldTypeString, alias: AddressStreetName, length: 255
)
-
City
(
type: esriFieldTypeString, alias: City, length: 30
)
-
Zip
(
type: esriFieldTypeSmallInteger, alias: Zip
)
-
Longitude
(
type: esriFieldTypeDouble, alias: Longitude
)
-
Latitude
(
type: esriFieldTypeDouble, alias: Latitude
)
-
RegulatoryBasin
(
type: esriFieldTypeString, alias: RegulatoryBasin, length: 50
)
-
Watershed
(
type: esriFieldTypeString, alias: Watershed, length: 50
)
-
ProjectID
(
type: esriFieldTypeInteger, alias: ProjectID
)
-
PIN
(
type: esriFieldTypeString, alias: PIN, length: 50
)
-
Parcel_ID
(
type: esriFieldTypeInteger, alias: Parcel_ID
)
-
RetrofitComment
(
type: esriFieldTypeString, alias: RetrofitComment, length: 1073741822
)
-
InstallationDate
(
type: esriFieldTypeDate, alias: InstallationDate, length: 8
)
-
OwnershipType
(
type: esriFieldTypeString, alias: OwnershipType, length: 30
)
-
Accessibility
(
type: esriFieldTypeString, alias: Accessibility, length: 100
)
-
RetrofitDescription
(
type: esriFieldTypeString, alias: RetrofitDescription, length: 1073741822
)
-
SCM_Number
(
type: esriFieldTypeInteger, alias: SCM_Number
)
-
EasementTypeId
(
type: esriFieldTypeInteger, alias: EasementTypeId
)
-
RetrofitBenefitComment
(
type: esriFieldTypeString, alias: RetrofitBenefitComment, length: 255
)
-
IAIA_Type_ID
(
type: esriFieldTypeInteger, alias: IAIA_Type_ID
)
-
CreatedBy
(
type: esriFieldTypeString, alias: CreatedBy, length: 20
)
-
CreatedDate
(
type: esriFieldTypeDate, alias: CreatedDate, length: 8
)
-
UpdatedBy
(
type: esriFieldTypeString, alias: UpdatedBy, length: 20
)
-
UpdatedDate
(
type: esriFieldTypeDate, alias: UpdatedDate, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata