Name: Property Flattened

Display Field: SUB_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: The Property_Flattened_Py layer is a combination of the Property shapes and the Maryland Department of Assessment and Taxation (SDAT) information. The Property shapes, from the Property_Py layer, are edited daily by Planning Department staff, while the SDAT information, the Land Data File (LDF) table, is updated at the end of each month. These two items are combined and exported into the Property_Flattened_Py layer on a nightly basis. Normally this data is kept separately and has a many-to-many relationship between the properties and the account information. For example, the largest condominium parcel in the county has over five hundred SDAT issued tax accounts associated with a single property shape. The combination process, or flattening, into a one-to-one relationship from its native many-to-many relationship, creates multiple identical polygons for those properties that have multiple associated account numbers. For most of the properties in the county this results in a single shape with the corresponding SDAT information. However, for example, the previously mentioned condominium parcel will have over five hundred identical property shapes stacked on top of each other. There are many more properties that have two or three accounts per property. Warnings: Do not use this layer for most spatial analysis, based on the Shape.Area field. Due to the multiple property shapes your totals will be greatly inflated. Best uses:  For querying any of SDAT information from the property shapes to find locations (Locate, Zoom To, Highlight, etc)  For labeling the SDAT information on a map/document based on the property shape(s). Keep in mind the multiple polygons while setting up your labeling rules.  For finding counts of data. For example how many subdivided accounts have an improvement value greater than $100,000, and are tax exempt (etc.).

Service Item Id: c0dee972a2a94a87a114084fa8bcabf2

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: 1290362.2887140661
YMin: 317961.41977605224
XMax: 1406389.8811334819
YMax: 533363.041137293
Spatial Reference: 102685  (2248)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 0, 0]
Outline:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 0
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
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• ACCOUNT ( type: esriFieldTypeString, alias: ACCOUNT, length: 7 )
• ASSESS_DIST ( type: esriFieldTypeString, alias: ASSESS_DIST, length: 2 )
• LAND_AREA_ACRE ( type: esriFieldTypeDouble, alias: LAND_AREA_ACRE )
• LAND_AREA_SQFT ( type: esriFieldTypeDouble, alias: LAND_AREA_SQFT )
• PLAT ( type: esriFieldTypeString, alias: PLAT, length: 8 )
• LOT ( type: esriFieldTypeString, alias: LOT, length: 5 )
• BLOCK ( type: esriFieldTypeString, alias: BLOCK, length: 4 )
• PROPERTY_DESC ( type: esriFieldTypeString, alias: PROPERTY_DESC, length: 72 )
• PARCEL ( type: esriFieldTypeString, alias: PARCEL, length: 3 )
• LIBER ( type: esriFieldTypeString, alias: LIBER, length: 5 )
• FOLIO ( type: esriFieldTypeString, alias: FOLIO, length: 3 )
• SUB_NAME ( type: esriFieldTypeString, alias: SUB_NAME, length: 72 )
• CONDO_PLAT_NUMBER ( type: esriFieldTypeString, alias: CONDO_PLAT_NUMBER, length: 3 )
• CONDO_PHASE_NUMBER ( type: esriFieldTypeString, alias: CONDO_PHASE_NUMBER, length: 6 )
• CONDO_BUILDING_NUMBER ( type: esriFieldTypeString, alias: CONDO_BUILDING_NUMBER, length: 4 )
• CONDO_UNIT_NUMBER ( type: esriFieldTypeString, alias: CONDO_UNIT_NUMBER, length: 6 )
• SUBDIVIDED ( type: esriFieldTypeString, alias: SUBDIVIDED, length: 1 )
• SUB_CODE ( type: esriFieldTypeString, alias: SUB_CODE, length: 6 )
• SUBDIVISION_PLAT_DATE ( type: esriFieldTypeDate, alias: SUBDIVISION_PLAT_DATE, length: 8 )
• SECTION ( type: esriFieldTypeString, alias: SECTION, length: 2 )
• PLAT_PARCEL ( type: esriFieldTypeString, alias: PLAT_PARCEL, length: 5 )
• OUT_LOT ( type: esriFieldTypeString, alias: OUT_LOT, length: 5 )
• OUT_PARCEL ( type: esriFieldTypeString, alias: OUT_PARCEL, length: 5 )
• FIVE_DASH ( type: esriFieldTypeString, alias: FIVE_DASH, length: 5 )
• TAXMAPGRID ( type: esriFieldTypeString, alias: TAXMAPGRID, length: 5 )
• WSSCGRID ( type: esriFieldTypeString, alias: WSSCGRID, length: 7 )
• TAXMAP ( type: esriFieldTypeString, alias: TAXMAP, length: 3 )
• TAXGRID ( type: esriFieldTypeString, alias: TAXGRID, length: 2 )
• OWNER_NAME ( type: esriFieldTypeString, alias: OWNER_NAME, length: 36 )
• ICO_NAME ( type: esriFieldTypeString, alias: ICO_NAME, length: 36 )
• MAIL_STREET ( type: esriFieldTypeString, alias: MAIL_STREET, length: 45 )
• MAIL_CITY ( type: esriFieldTypeString, alias: MAIL_CITY, length: 30 )
• MAIL_STATE ( type: esriFieldTypeString, alias: MAIL_STATE, length: 2 )
• MAIL_ZIP5 ( type: esriFieldTypeString, alias: MAIL_ZIP5, length: 5 )
• MAIL_ZIP4 ( type: esriFieldTypeString, alias: MAIL_ZIP4, length: 4 )
• MAIL_IND ( type: esriFieldTypeString, alias: MAIL_IND, length: 1 )
• HOUSE_NUMBER ( type: esriFieldTypeString, alias: HOUSE_NUMBER, length: 6 )
• HOUSE_SUFFIX ( type: esriFieldTypeString, alias: HOUSE_SUFFIX, length: 1 )
• UNIT ( type: esriFieldTypeString, alias: UNIT, length: 5 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 28 )
• STREET_TYPE ( type: esriFieldTypeString, alias: STREET_TYPE, length: 4 )
• STREET_DIRECTION ( type: esriFieldTypeString, alias: STREET_DIRECTION, length: 2 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 28 )
• ZIP5 ( type: esriFieldTypeString, alias: ZIP5, length: 5 )
• PROP_ADDR_SOURCE ( type: esriFieldTypeString, alias: PROP_ADDR_SOURCE, length: 3 )
• AZC ( type: esriFieldTypeString, alias: AZC, length: 3 )
• BPRUC ( type: esriFieldTypeString, alias: BPRUC, length: 5 )
• DWELLING_TYPE ( type: esriFieldTypeString, alias: DWELLING_TYPE, length: 4 )
• DWELLING_UNITS ( type: esriFieldTypeString, alias: DWELLING_UNITS, length: 4 )
• DWELLING_STORY_CODE ( type: esriFieldTypeString, alias: DWELLING_STORY_CODE, length: 4 )
• STRUCTURE_SQ_FT ( type: esriFieldTypeString, alias: STRUCTURE_SQ_FT, length: 7 )
• YEAR_BUILT ( type: esriFieldTypeString, alias: YEAR_BUILT, length: 4 )
• SALES_PRICE ( type: esriFieldTypeInteger, alias: SALES_PRICE )
• SALES_PRICE_IND ( type: esriFieldTypeString, alias: SALES_PRICE_IND, length: 2 )
• TRANSFER_DATE ( type: esriFieldTypeString, alias: TRANSFER_DATE, length: 8 )
• TENANCY_CODE ( type: esriFieldTypeString, alias: TENANCY_CODE, length: 2 )
• DEVELOPED ( type: esriFieldTypeString, alias: DEVELOPED, length: 1 )
• RESIDENTIAL_IND ( type: esriFieldTypeString, alias: RESIDENTIAL_IND, length: 1 )
• FCV_IMPS ( type: esriFieldTypeInteger, alias: FCV_IMPS )
• FCV_LAND ( type: esriFieldTypeInteger, alias: FCV_LAND )
• CURR_ASSESS ( type: esriFieldTypeInteger, alias: CURR_ASSESS )
• PREF_ASSESS ( type: esriFieldTypeInteger, alias: PREF_ASSESS )
• CYCLE_CODE ( type: esriFieldTypeString, alias: CYCLE_CODE, length: 1 )
• CYCLE_YEAR ( type: esriFieldTypeString, alias: CYCLE_YEAR, length: 1 )
• AGRICULTURE_INDICATOR ( type: esriFieldTypeString, alias: AGRICULTURE_INDICATOR, length: 1 )
• AGRICULTURE_CODE ( type: esriFieldTypeString, alias: AGRICULTURE_CODE, length: 1 )
• AG_TAX_DUE_UNTIL_DATE ( type: esriFieldTypeDate, alias: AG_TAX_DUE_UNTIL_DATE, length: 8 )
• CURTILAGE_ASSESS_IND ( type: esriFieldTypeString, alias: CURTILAGE_ASSESS_IND, length: 1 )
• TOWN_CODE ( type: esriFieldTypeString, alias: TOWN_CODE, length: 2 )
• PREF_CODE ( type: esriFieldTypeString, alias: PREF_CODE, length: 6 )
• EXEMPT_CLASS ( type: esriFieldTypeString, alias: EXEMPT_CLASS, length: 3 )
• EXEMPT_STATUS ( type: esriFieldTypeString, alias: EXEMPT_STATUS, length: 1 )
• SCENIC_EASEMENT_IND ( type: esriFieldTypeString, alias: SCENIC_EASEMENT_IND, length: 1 )
• ZONE_CODE1 ( type: esriFieldTypeString, alias: ZONE_CODE1, length: 5 )
• ZONE_CODE2 ( type: esriFieldTypeString, alias: ZONE_CODE2, length: 5 )
• ZONE_CODE3 ( type: esriFieldTypeString, alias: ZONE_CODE3, length: 5 )
• ZONE_CODE4 ( type: esriFieldTypeString, alias: ZONE_CODE4, length: 5 )
• ZONE_CODE5 ( type: esriFieldTypeString, alias: ZONE_CODE5, length: 5 )
• CHESBAY_CRIT_AREA_CD ( type: esriFieldTypeString, alias: CHESBAY_CRIT_AREA_CD, length: 3 )
• CHESBAY_CA_ADOPT_DATE ( type: esriFieldTypeDate, alias: CHESBAY_CA_ADOPT_DATE, length: 8 )
• PLANAREA ( type: esriFieldTypeString, alias: PLANAREA, length: 3 )
• PGTAZ ( type: esriFieldTypeString, alias: PGTAZ, length: 5 )
• COGTAZ ( type: esriFieldTypeString, alias: COGTAZ, length: 5 )
• HISTORIC_RESOURCE ( type: esriFieldTypeString, alias: HISTORIC_RESOURCE, length: 2 )
• HISTORIC_SITE ( type: esriFieldTypeString, alias: HISTORIC_SITE, length: 1 )
• HISTORIC_SITE_DATE ( type: esriFieldTypeDate, alias: HISTORIC_SITE_DATE, length: 8 )
• HISTORIC_DISTRICT_ID ( type: esriFieldTypeString, alias: HISTORIC_DISTRICT_ID, length: 2 )
• HISTORIC_DISTRICT_DATE ( type: esriFieldTypeDate, alias: HISTORIC_DISTRICT_DATE, length: 8 )
• HISTORIC_PARENT_ACCOUNT ( type: esriFieldTypeString, alias: HISTORIC_PARENT_ACCOUNT, length: 7 )
• CENSUS_TRACT ( type: esriFieldTypeString, alias: CENSUS_TRACT, length: 6 )
• CENSUS_BLOCK ( type: esriFieldTypeString, alias: CENSUS_BLOCK, length: 4 )
• FLOOD_PLAIN ( type: esriFieldTypeString, alias: FLOOD_PLAIN, length: 1 )
• MNCPPC_USE ( type: esriFieldTypeString, alias: MNCPPC_USE, length: 3 )
• PRIOR_CENSUS_TRACT ( type: esriFieldTypeString, alias: PRIOR_CENSUS_TRACT, length: 4 )
• PRIOR_CENSUS_BLOCK ( type: esriFieldTypeString, alias: PRIOR_CENSUS_BLOCK, length: 4 )
• ZIP4 ( type: esriFieldTypeString, alias: ZIP4, length: 4 )
• ZONE_MULTIPLES ( type: esriFieldTypeString, alias: ZONE_MULTIPLES, length: 1 )
• LAND_AREA_RAW ( type: esriFieldTypeDouble, alias: LAND_AREA_RAW )
• LAND_AREA_UNIT ( type: esriFieldTypeString, alias: LAND_AREA_UNIT, length: 1 )
• PROPERTY_ID ( type: esriFieldTypeString, alias: PROPERTY_ID, length: 9 )
• DOS_ACCOUNT ( type: esriFieldTypeString, alias: DOS_ACCOUNT, length: 7 )
• PARENT_ACCOUNT ( type: esriFieldTypeString, alias: PARENT_ACCOUNT, length: 7 )
• UPDATED_DATE ( type: esriFieldTypeDate, alias: UPDATED_DATE, length: 8 )
• CONFLICTS ( type: esriFieldTypeString, alias: CONFLICTS, length: 1 )
• ACTIVE_DATE ( type: esriFieldTypeDate, alias: ACTIVE_DATE, length: 8 )
• INACTIVE_DATE ( type: esriFieldTypeDate, alias: INACTIVE_DATE, length: 8 )
• SDAT_ACCOUNT_URL ( type: esriFieldTypeString, alias: SDAT_ACCOUNT_URL, length: 125 )
• IMPRT_DATE ( type: esriFieldTypeDate, alias: IMPRT_DATE, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PG_TAX_CLASS ( type: esriFieldTypeString, alias: PG_TAX_CLASS, length: 2 )
• EXEMPT_ASSESSMENT ( type: esriFieldTypeInteger, alias: EXEMPT_ASSESSMENT )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, length: 15 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata