production.dbt_mart_property.parcels
production.dbt_mart_property.parcels
nan
[{'name': 'object_id', 'type': 'esriFieldTypeOID', 'alias': 'object_id', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'parcel_number', 'type': 'esriFieldTypeString', 'alias': 'Parcel Number', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique tax parcel identifier for the property.","fieldValueType":""}'}, {'name': 'ward', 'type': 'esriFieldTypeString', 'alias': 'Ward', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Historic ward number. Corresponds with the first two digits of the parcel number.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'address', 'type': 'esriFieldTypeString', 'alias': 'Address', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Full street address associated with the tax parcel.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'council_district', 'type': 'esriFieldTypeString', 'alias': 'Council District', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"City of Detroit Council District. (See map at https://detroitmi.gov/webapp/interactive-district-map)","fieldValueType":"locationOrPlaceName"}'}, {'name': 'zip_code', 'type': 'esriFieldTypeString', 'alias': 'Zip Code', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Postal zip code for the tax parcel.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'taxpayer_1', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer 1', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of the primary taxpayer.","fieldValueType":"nameOrTitle"}'}, {'name': 'taxpayer_2', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer 2', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of a second taxpayer.","fieldValueType":"nameOrTitle"}'}, {'name': 'taxpayer_street', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer Address', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Full street address on record for taxpayer 1.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'taxpayer_city', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer City', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"City on record for address of taxpayer 1.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'taxpayer_state', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer State', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"State on record for address of taxpayer 1.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'taxpayer_zip', 'type': 'esriFieldTypeString', 'alias': 'Taxpayer Zip', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Postal zip code on record for address of taxpayer 1.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'property_class', 'type': 'esriFieldTypeString', 'alias': 'Property Class Code', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"State Tax Commission property classification code. A property is classfied according to its current use annually by the first Monday of March, as required by MCL 211.34c.","fieldValueType":"typeOrCategory"}'}, {'name': 'property_class_desc', 'type': 'esriFieldTypeString', 'alias': 'Property Class Description', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"State Tax Commission property classification description for the associated Property Class code.","fieldValueType":"typeOrCategory"}'}, {'name': 'property_class_previous', 'type': 'esriFieldTypeString', 'alias': 'Previous Property Class Code', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Property code classification from the assessment cycle of the previous year.","fieldValueType":"typeOrCategory"}'}, {'name': 'use_code', 'type': 'esriFieldTypeString', 'alias': 'Use Code', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"CAMA (State of Michigan Computer Assisted Mass Appraisal Data Standard) Use Code.","fieldValueType":"typeOrCategory"}'}, {'name': 'use_code_desc', 'type': 'esriFieldTypeString', 'alias': 'Use Code Description', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Description of the CAMA Use Code (e.g., single family, two family, etc.).","fieldValueType":"typeOrCategory"}'}, {'name': 'tax_status', 'type': 'esriFieldTypeString', 'alias': 'Tax Status', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Indicates whether parcel is taxable or exempt from property taxes. For exempt properties, the MCL section providing exemption is identified.","fieldValueType":"typeOrCategory"}'}, {'name': 'tax_status_description', 'type': 'esriFieldTypeString', 'alias': 'Tax Status Description', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Description of the current taxable status of the property.","fieldValueType":"typeOrCategory"}'}, {'name': 'tax_status_previous', 'type': 'esriFieldTypeString', 'alias': 'Previous Tax Status', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Taxable status of the property in the assessment cycle of the previous year.","fieldValueType":"typeOrCategory"}'}, {'name': 'total_square_footage', 'type': 'esriFieldTypeDouble', 'alias': 'Total Square Footage', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Total square footage of the tax parcel.","fieldValueType":"measurement"}'}, {'name': 'total_acreage', 'type': 'esriFieldTypeDouble', 'alias': 'Total Acreage', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Total acreage of the tax parcel.","fieldValueType":"measurement"}'}, {'name': 'frontage', 'type': 'esriFieldTypeDouble', 'alias': 'Frontage', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Length of the tax parcel along the street or other right of way, in feet.","fieldValueType":"measurement"}'}, {'name': 'depth', 'type': 'esriFieldTypeDouble', 'alias': 'Depth', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Measure of the depth of the tax parcel, in feet.","fieldValueType":"measurement"}'}, {'name': 'homestead_pre', 'type': 'esriFieldTypeDouble', 'alias': 'Principle Residence Exemption', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Principle Residence Exemption (PRE, or \\"Homestead\\") -  exempts a residence from portion of the local school district taxes (school operating millages). (https://www.michigan.gov/taxes/property/principal/what-is-a-principal-residence-exemption-pre-1)","fieldValueType":"percentageOrRatio"}'}, {'name': 'nez', 'type': 'esriFieldTypeString', 'alias': 'NEZ', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of the Neighborhood Enterprise Zone (NEZ) Homestead in which the tax parcel is located. The NEZ-Homestead program provides owners with a tax abatement that reduces the City and County operation millages if certain conditions are met. (See https://detroitmi.gov/departments/office-chief-financial-officer/ocfo-divisions/office-assessor/nez-homestead)","fieldValueType":"locationOrPlaceName"}'}, {'name': 'is_improved', 'type': 'esriFieldTypeDouble', 'alias': 'Improved Property', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Indicates whether the parcel is a vacant (0) or improved (1) property.","fieldValueType":"binary"}'}, {'name': 'num_bldgs', 'type': 'esriFieldTypeDouble', 'alias': 'Building Count', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Count of residential and commercial/industrial buildings associated with the parcel.","fieldValueType":"countOrAmount"}'}, {'name': 'total_floor_area', 'type': 'esriFieldTypeInteger', 'alias': 'Total Floor Area', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Total floor area across all buildings associated with the parcel, in square feet.","fieldValueType":"measurement"}'}, {'name': 'style', 'type': 'esriFieldTypeString', 'alias': 'Style', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Building style of the main building associated with the parcel.","fieldValueType":"typeOrCategory"}'}, {'name': 'year_built', 'type': 'esriFieldTypeInteger', 'alias': 'Year Built', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Year the oldest building associated with the parcel was built.","fieldValueType":"dateAndTime"}'}, {'name': 'sale_price', 'type': 'esriFieldTypeDouble', 'alias': 'Sale Price', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Last recorded valid sale price in dollars.","fieldValueType":"currency"}'}, {'name': 'sale_date', 'type': 'esriFieldTypeDate', 'alias': 'Sale Date', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Last Recorded valid sale date.","fieldValueType":"dateAndTime"}', 'precision': 1}, {'name': 'assessed_value', 'type': 'esriFieldTypeDouble', 'alias': 'Assessed Value', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Current assessed value, in dollars. The Michigan Constitution requires property to be uniformly assessed at 50% of the usual selling price.","fieldValueType":"currency"}'}, {'name': 'assessed_value_previous', 'type': 'esriFieldTypeDouble', 'alias': 'Previous Assessed Value', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Assessed value from the previous year\'s assessment cycle.","fieldValueType":"currency"}'}, {'name': 'taxable_value', 'type': 'esriFieldTypeDouble', 'alias': 'Taxable Value', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Current taxable value, in dollars. Taxable Value is used to calculate property taxes.","fieldValueType":"currency"}'}, {'name': 'taxable_value_previous', 'type': 'esriFieldTypeDouble', 'alias': 'Previous Taxable Value', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Taxable value in the previous year\'s assessment cycle, in dollars. Previous Taxable Value was used to calculate property taxes for the previous year. ","fieldValueType":"currency"}'}, {'name': 'economic_condition_factor_neigh', 'type': 'esriFieldTypeString', 'alias': 'ECF Neighborhood', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Indicates which local neighborhood market a property belongs to. Economic Condition Factor (ECF) Neighborhoods or areas encompass properties with similar physical and/or economic characteristics so that the properties can be analyzed together.","fieldValueType":"typeOrCategory"}'}, {'name': 'landmap', 'type': 'esriFieldTypeString', 'alias': 'Landmap', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Land value map reference number.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'related', 'type': 'esriFieldTypeString', 'alias': 'Related Property', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Related personal property or special act parcel number.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'zoning', 'type': 'esriFieldTypeString', 'alias': 'Zoning', 'sqlType': 'sqlTypeOther', 'length': 255, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Zoning classification code of the zoning district where the parcel is located. If a parcel overlaps multiple zoning districts, the zoning code associated with the greatest proportion of the parcel is indicated. Zoning data are updated daily using the Open Data Portal Zoning dataset.","fieldValueType":"typeOrCategory"}'}, {'name': 'subdivision', 'type': 'esriFieldTypeString', 'alias': 'Subdivision', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Subdivision name or code.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'legal_description', 'type': 'esriFieldTypeString', 'alias': 'Legal Description', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The geographical description of real estate that identifies its precise location, boundaries and any easements for the purpose of a legal transaction, such as a transfer of ownership. A legal description is kept with the deed and filed with the clerk or tax assessor office.","fieldValueType":"description"}'}, {'name': 'Shape__Area', 'type': 'esriFieldTypeDouble', 'alias': 'Shape Area', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None, 'description': '{"value":"Parcel shape information.","fieldValueType":"measurement"}'}, {'name': 'Shape__Length', 'type': 'esriFieldTypeDouble', 'alias': 'Shape Length', 'sqlType': 'sqlTypeDouble', 'nullable': True, 'editable': False, 'domain': None, 'defaultValue': None, 'description': '{"value":"Parcel shape information.","fieldValueType":"measurement"}'}]
[{'name': 'PK__PARCELS___3DC088B593E384C3', 'fields': 'object_id', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'Shape__Area_Index', 'fields': 'Shape__Area', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'Shape__Length_Index', 'fields': 'Shape__Length', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_45103.PARCELS_CURRENT_PRODUCTION_DBT_MART_PROPERTY_PARCELS_Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'IX_PARCELS_CURRENT_PRODUCTION_DBT_MART_PROPERTY_PARCELS_parcel_number_ASC', 'fields': 'parcel_number', 'isAscending': True, 'isUnique': False, 'description': 'Layer settings', 'indexType': 'Attribute'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSFS', 'style': 'esriSFSSolid', 'color': [206, 186, 252, 255], 'outline': {'type': 'esriSLS', 'style': 'esriSLSSolid', 'color': [110, 110, 110, 255], 'width': 0.7}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'production.dbt_mart_property.parcels', 'description': '', 'drawingTool': 'esriFeatureEditToolPolygon', 'prototype': {'attributes': {'legal_description': None, 'subdivision': None, 'parcel_number': None, 'ward': None, 'address': None, 'council_district': None, 'zip_code': None, 'taxpayer_1': None, 'taxpayer_2': None, 'taxpayer_street': None, 'taxpayer_city': None, 'taxpayer_state': None, 'taxpayer_zip': None, 'property_class': None, 'property_class_desc': None, 'property_class_previous': None, 'use_code': None, 'use_code_desc': None, 'tax_status': None, 'tax_status_description': None, 'tax_status_previous': None, 'total_square_footage': None, 'total_acreage': None, 'frontage': None, 'depth': None, 'homestead_pre': None, 'nez': None, 'is_improved': None, 'num_bldgs': None, 'total_floor_area': None, 'style': None, 'year_built': None, 'sale_price': None, 'sale_date': None, 'assessed_value': None, 'assessed_value_previous': None, 'taxable_value': None, 'taxable_value_previous': None, 'economic_condition_factor_neigh': None, 'landmap': None, 'related': None, 'zoning': None}}}]