Name: Address Points

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Data in this Address_Points layer was loaded from the interim Building_Points_Joined layer, the result of a spatial join performed between Building_Points (centroids) and Parcels.The Building_Points layer was created on 11/ 08/2013 using the Feature to Point geoprocessing tool; input feature class was Building_Footprints_2010.Process outline:Create a copy of Building_Footprints_2010 in a local, file geodatabasePerform Feature to Point on copy of Building_Footprints_2010; result - Building_PointsPerform spatial join of Parcels to Building_Points; give each point the attribute values of the parcel within which it fallsAdd fields to Building_Points_Joined (FULLNAME, ADDRNUMSUF, ADDRCLASS) and calculate based on values in other attribute fieldsFULLNAME values are the result of a function which concacatenated, then trimmed, using STREET_DIR, STREET_NAM, STREET_TYP from the Parcels table.ADDRNUMSUF values are the result of a parsing operation in which '1/2' addresses were split from applicable HOUSE values. ADDRCLASS values resulted from a calculation based on the Parcels' BLDG_TYPE field.Data loaded to SiteAddressPoint feature class in a local gdb, sourced by Building_Points_Joined.SiteAddressPoint feature class copied to vector.GIS sdeSITEADDID calculated by GENERATE_ID value method using the DynamicValue table.On_Create rule established for SITEADDID when new features are created.Municipality calculated by INTERSECTING_FEATURE value method using the Dynamic Value table.CAPTUREMETH populated with value "Other" to match the PointCollectionMethoddomain for that field.ZIP will require calculation when a reliable ZIP Codes layer has been secured.

Copyright Text: DCGIS

Default Visibility: false

MaxRecordCount: 1000

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

Supports Datum Transformation: true

Extent:

XMin: -1.1797362726867987E7
YMin: 4819755.134206597
XMax: -1.0672686995049726E7
YMax: 5081051.895598755
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [156, 83, 0, 255]
Size: 4.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: 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• SITEADDID ( type: esriFieldTypeString, alias: SITEADDID, length: 20 )
• ADDPTKEY ( type: esriFieldTypeString, alias: ADDPTKEY, length: 20 )
• PREADDRNUM ( type: esriFieldTypeString, alias: PREADDRNUM, length: 5 )
• ADDRNUMSUF ( type: esriFieldTypeString, alias: ADDRNUMSUF, length: 5 )
• ADDRNUM ( type: esriFieldTypeString, alias: ADDRNUM, length: 20 )
• ADDRRANGE ( type: esriFieldTypeString, alias: ADDRRANGE, length: 50 )
• UNITTYPE ( type: esriFieldTypeString, alias: UNITTYPE, length: 10 , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 10 )
• ALTUNITTYPE ( type: esriFieldTypeString, alias: ALTUNITTYPE, length: 10 , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• ALTUNITID ( type: esriFieldTypeString, alias: ALTUNITID, length: 10 )
• FULLNAME ( type: esriFieldTypeString, alias: FULLNAME, length: 125 )
• FULLADDR ( type: esriFieldTypeString, alias: FULLADDR, length: 250 )
• PLACENAME ( type: esriFieldTypeString, alias: PLACENAME, length: 250 )
• MUNICIPALITY ( type: esriFieldTypeString, alias: MUNICIPALITY, length: 100 , Coded Values: [Omaha: Omaha] , [Ralston: Ralston] , [Valley: Valley] , ...3 more... )
• ESN ( type: esriFieldTypeString, alias: ESN, length: 5 )
• PSAP ( type: esriFieldTypeString, alias: PSAP, length: 4 )
• MSAG ( type: esriFieldTypeString, alias: MSAG, length: 35 )
• USNGCOORD ( type: esriFieldTypeString, alias: USNGCOORD, length: 50 )
• ADDRCLASS ( type: esriFieldTypeInteger, alias: ADDRCLASS , Coded Values: [990: Residential] , [720: Commercial and Retail] , [710: Industry] , ...17 more... )
• POINTTYPE ( type: esriFieldTypeString, alias: POINTTYPE, length: 30 , Coded Values: [Building: Building] , [Parcel: Parcel] , [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite] , ...3 more... )
• CAPTUREMETH ( type: esriFieldTypeString, alias: CAPTUREMETH, length: 30 , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...3 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 30 , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...3 more... )
• PIN ( type: esriFieldTypeString, alias: PIN, length: 10 )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 30 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 5 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 2 )
• SUBDIV_PARENT ( type: esriFieldTypeString, alias: SUBDIV_PARENT, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata