Name: vw_GISViewer_AddressPointEXTActiveLookup

Display Field: StreetName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7f7f36eb1697414582aa8423f38a3b5e

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

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

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: 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 )
• AddressID ( type: esriFieldTypeInteger, alias: AddressID, editable: false, nullable: false, defaultValue: null, modelName: AddressID )
• FullAddress ( type: esriFieldTypeString, alias: FullAddress, editable: false, nullable: true, length: 255, defaultValue: null, modelName: FullAddress )
• BuildingIDNumber ( type: esriFieldTypeInteger, alias: BuildingIDNumber, editable: false, nullable: true, defaultValue: null, modelName: BuildingIDNumber )
• StreetNumber ( type: esriFieldTypeString, alias: StreetNumber, editable: false, nullable: true, length: 50, defaultValue: null, modelName: StreetNumber )
• StreetPreDirection ( type: esriFieldTypeString, alias: StreetPreDirection, editable: false, nullable: true, length: 10, defaultValue: null, modelName: StreetPreDirection )
• StreetName ( type: esriFieldTypeString, alias: StreetName, editable: false, nullable: true, length: 100, defaultValue: null, modelName: StreetName )
• StreetSuffix ( type: esriFieldTypeString, alias: StreetSuffix, editable: false, nullable: true, length: 20, defaultValue: null, modelName: StreetSuffix )
• StreetPostDirection ( type: esriFieldTypeString, alias: StreetPostDirection, editable: false, nullable: true, length: 10, defaultValue: null, modelName: StreetPostDirection )
• AddressUnitType ( type: esriFieldTypeString, alias: AddressUnitType, editable: false, nullable: true, length: 20, defaultValue: null, modelName: AddressUnitType )
• AddressUnit ( type: esriFieldTypeString, alias: AddressUnit, editable: false, nullable: true, length: 50, defaultValue: null, modelName: AddressUnit )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, editable: false, nullable: true, length: 10, defaultValue: null, modelName: ZipCode )
• StreetID ( type: esriFieldTypeInteger, alias: StreetID, editable: false, nullable: true, defaultValue: null, modelName: StreetID )
• StreetSegID ( type: esriFieldTypeInteger, alias: StreetSegID, editable: false, nullable: true, defaultValue: null, modelName: StreetSegID )
• GPIN ( type: esriFieldTypeString, alias: GPIN, editable: false, nullable: true, length: 50, defaultValue: null, modelName: GPIN )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PIN )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: false, nullable: true, length: 100, defaultValue: null, modelName: Neighborhood )
• Precinct ( type: esriFieldTypeString, alias: Precinct, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Precinct )
• School ( type: esriFieldTypeString, alias: School, editable: false, nullable: true, length: 100, defaultValue: null, modelName: School )
• Sector ( type: esriFieldTypeString, alias: Sector, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Sector )
• SectorName ( type: esriFieldTypeString, alias: SectorName, editable: false, nullable: true, length: 100, defaultValue: null, modelName: SectorName )
• CouncilDistrict ( type: esriFieldTypeString, alias: CouncilDistrict, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CouncilDistrict )
• PoliceBeat ( type: esriFieldTypeString, alias: PoliceBeat, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PoliceBeat )
• FireDistrict ( type: esriFieldTypeString, alias: FireDistrict, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FireDistrict )
• TrashRoute ( type: esriFieldTypeString, alias: TrashRoute, editable: false, nullable: true, length: 50, defaultValue: null, modelName: TrashRoute )
• SnowRoute ( type: esriFieldTypeString, alias: SnowRoute, editable: false, nullable: true, length: 50, defaultValue: null, modelName: SnowRoute )
• ServiceArea ( type: esriFieldTypeString, alias: ServiceArea, editable: false, nullable: true, length: 100, defaultValue: null, modelName: ServiceArea )
• Impervious_Grid ( type: esriFieldTypeString, alias: Impervious_Grid, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Impervious_Grid )
• Zoning ( type: esriFieldTypeString, alias: Zoning, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Zoning )
• OwnerName ( type: esriFieldTypeString, alias: OwnerName, editable: false, nullable: true, length: 255, defaultValue: null, modelName: OwnerName )
• LandUse ( type: esriFieldTypeString, alias: LandUse, editable: false, nullable: true, length: 100, defaultValue: null, modelName: LandUse )
• AssessedValue ( type: esriFieldTypeDouble, alias: AssessedValue, editable: false, nullable: true, defaultValue: null, modelName: AssessedValue )
• YearBuilt ( type: esriFieldTypeInteger, alias: YearBuilt, editable: false, nullable: true, defaultValue: null, modelName: YearBuilt )
• InCity ( type: esriFieldTypeSmallInteger, alias: InCity, editable: false, nullable: true, defaultValue: null, modelName: InCity )
• InServiceArea ( type: esriFieldTypeSmallInteger, alias: InServiceArea, editable: false, nullable: true, defaultValue: null, modelName: InServiceArea )
• LastRefreshDate ( type: esriFieldTypeDate, alias: LastRefreshDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: LastRefreshDate )
• HistoricDistrict ( type: esriFieldTypeString, alias: HistoricDistrict, editable: false, nullable: true, length: 100, defaultValue: null, modelName: HistoricDistrict )
• OverlayDistrict ( type: esriFieldTypeString, alias: OverlayDistrict, editable: false, nullable: true, length: 100, defaultValue: null, modelName: OverlayDistrict )
• FloodZone ( type: esriFieldTypeString, alias: FloodZone, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FloodZone )
• VotingWard ( type: esriFieldTypeString, alias: VotingWard, editable: false, nullable: true, length: 50, defaultValue: null, modelName: VotingWard )
• RefreshRunID ( type: esriFieldTypeGUID, alias: RefreshRunID, editable: false, nullable: true, length: 38, defaultValue: null, modelName: RefreshRunID )
• RefreshNote ( type: esriFieldTypeString, alias: RefreshNote, editable: false, nullable: true, length: 255, defaultValue: null, modelName: RefreshNote )
• ParcelMatchMethod ( type: esriFieldTypeString, alias: ParcelMatchMethod, editable: false, nullable: true, length: 50, defaultValue: null, modelName: ParcelMatchMethod )
• ParcelMatchNote ( type: esriFieldTypeString, alias: ParcelMatchNote, editable: false, nullable: true, length: 255, defaultValue: null, modelName: ParcelMatchNote )
• SpatialFallbackApplied ( type: esriFieldTypeSmallInteger, alias: SpatialFallbackApplied, editable: false, nullable: true, defaultValue: null, modelName: SpatialFallbackApplied )
• SpatialFallbackDate ( type: esriFieldTypeDate, alias: SpatialFallbackDate, editable: false, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: SpatialFallbackDate )
• SpatialFallbackNote ( type: esriFieldTypeString, alias: SpatialFallbackNote, editable: false, nullable: true, length: 255, defaultValue: null, modelName: SpatialFallbackNote )
• LeafCollectionArea ( type: esriFieldTypeString, alias: LeafCollectionArea, editable: false, nullable: true, length: 100, defaultValue: null, modelName: LeafCollectionArea )
• RecyclingArea ( type: esriFieldTypeString, alias: RecyclingArea, editable: false, nullable: true, length: 100, defaultValue: null, modelName: RecyclingArea )
• NoServiceArea ( type: esriFieldTypeString, alias: NoServiceArea, editable: false, nullable: true, length: 100, defaultValue: null, modelName: NoServiceArea )
• InLeafServiceArea ( type: esriFieldTypeSmallInteger, alias: InLeafServiceArea, editable: false, nullable: true, defaultValue: null, modelName: InLeafServiceArea )
• InRecyclingServiceArea ( type: esriFieldTypeSmallInteger, alias: InRecyclingServiceArea, editable: false, nullable: true, defaultValue: null, modelName: InRecyclingServiceArea )
• LeafCollectionSector ( type: esriFieldTypeString, alias: LeafCollectionSector, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LeafCollectionSector )
• RecyclingDay ( type: esriFieldTypeString, alias: RecyclingDay, editable: false, nullable: true, length: 20, defaultValue: null, modelName: RecyclingDay )
• EntranceCorridor ( type: esriFieldTypeSmallInteger, alias: EntranceCorridor, editable: false, nullable: true, defaultValue: null, modelName: EntranceCorridor )
• CoreNeighborhoodCorridorOverlay ( type: esriFieldTypeSmallInteger, alias: CoreNeighborhoodCorridorOverlay, editable: false, nullable: true, defaultValue: null, modelName: CoreNeighborhoodCorridorOverlay )
• HistoricConservationDistrict ( type: esriFieldTypeSmallInteger, alias: HistoricConservationDistrict, editable: false, nullable: true, defaultValue: null, modelName: HistoricConservationDistrict )
• RegulatoryFloodway ( type: esriFieldTypeSmallInteger, alias: RegulatoryFloodway, editable: false, nullable: true, defaultValue: null, modelName: RegulatoryFloodway )
• OnePercentFloodplain ( type: esriFieldTypeSmallInteger, alias: OnePercentFloodplain, editable: false, nullable: true, defaultValue: null, modelName: OnePercentFloodplain )
• TwoTenthPercentFloodplain ( type: esriFieldTypeSmallInteger, alias: TwoTenthPercentFloodplain, editable: false, nullable: true, defaultValue: null, modelName: TwoTenthPercentFloodplain )
• InNoServiceArea ( type: esriFieldTypeSmallInteger, alias: InNoServiceArea, editable: false, nullable: true, defaultValue: null, modelName: InNoServiceArea )
• ArchitecturalDesignControlDistrict ( type: esriFieldTypeSmallInteger, alias: ArchitecturalDesignControlDistrict, editable: false, nullable: true, defaultValue: null, modelName: ArchitecturalDesignControlDistrict )
• RCLAccepted ( type: esriFieldTypeString, alias: RCLAccepted, editable: false, nullable: true, length: 10, defaultValue: null, modelName: RCLAccepted )
• PWAccepted ( type: esriFieldTypeString, alias: PWAccepted, editable: false, nullable: true, length: 10, defaultValue: null, modelName: PWAccepted )
• PWStreetName ( type: esriFieldTypeString, alias: PWStreetName, editable: false, nullable: true, length: 100, defaultValue: null, modelName: PWStreetName )
• PWPriority ( type: esriFieldTypeString, alias: PWPriority, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PWPriority )
• PWSnowRoute ( type: esriFieldTypeString, alias: PWSnowRoute, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PWSnowRoute )
• PWLeafRoute ( type: esriFieldTypeString, alias: PWLeafRoute, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PWLeafRoute )
• PWTrashRoute ( type: esriFieldTypeString, alias: PWTrashRoute, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PWTrashRoute )
• PWOneWay ( type: esriFieldTypeString, alias: PWOneWay, editable: false, nullable: true, length: 20, defaultValue: null, modelName: PWOneWay )
• PWSpeed ( type: esriFieldTypeInteger, alias: PWSpeed, editable: false, nullable: true, defaultValue: null, modelName: PWSpeed )
• PWParkZone ( type: esriFieldTypeString, alias: PWParkZone, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PWParkZone )
• PWStreetSegID ( type: esriFieldTypeInteger, alias: PWStreetSegID, editable: false, nullable: true, defaultValue: null, modelName: PWStreetSegID )

Templates:

• Name: vw_GISViewer_AddressPointEXTActiveLookup
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata