Property Sales
Property Sales
nan
[{'name': 'sale_id', 'type': 'esriFieldTypeDouble', 'alias': 'Sales ID', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique identification number assigned to a specific sale transaction.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'parcel_number', 'type': 'esriFieldTypeString', 'alias': 'Parcel Number', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique identification number assigned to a specific parcel of land or property.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'address', 'type': 'esriFieldTypeString', 'alias': 'Street Address', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Full street address of the property named in the sale transaction.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_number', 'type': 'esriFieldTypeString', 'alias': 'Street Number', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street number of the property named in the sale transaction.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_prefix', 'type': 'esriFieldTypeString', 'alias': 'Street Prefix', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street prefix (e.g., N, S, E, or W) of the property named in the sale transaction.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_name', 'type': 'esriFieldTypeString', 'alias': 'Street Name', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street name of the property named in the sale transaction.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'unit_number', 'type': 'esriFieldTypeString', 'alias': 'Unit Number', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unit number of the property named in the sale transaction. Used for condos or other properties that have unit numbers on file.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'sale_number', 'type': 'esriFieldTypeString', 'alias': 'Sale Number', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None}, {'name': 'sale_date', 'type': 'esriFieldTypeDate', 'alias': 'Sale Date', 'sqlType': 'sqlTypeOther', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Date on which the property sale took place.","fieldValueType":"dateAndTime"}', 'precision': 1}, {'name': 'sale_price', 'type': 'esriFieldTypeDouble', 'alias': 'Sale Price', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Price at which the property was sold.","fieldValueType":"currency"}'}, {'name': 'grantor', 'type': 'esriFieldTypeString', 'alias': 'Grantor', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Party (individual or entity) who transfers the property to the buyer (grantee) through the sale.","fieldValueType":"nameOrTitle"}'}, {'name': 'grantee', 'type': 'esriFieldTypeString', 'alias': 'Grantee', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Party (individual or entity) who acquires ownership of the property through the sale.","fieldValueType":"nameOrTitle"}'}, {'name': 'liber_page', 'type': 'esriFieldTypeString', 'alias': 'Liber Page', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Reference to the specific record or page number in the land records or property records where the sale transaction is documented.","fieldValueType":"description"}'}, {'name': 'term_of_sale', 'type': 'esriFieldTypeString', 'alias': 'Terms of Sale', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Any specific terms or conditions associated with the sale transaction, such as financing arrangements or contingencies. Note: Only Arms length (including multiparcel arms length) sales are included in the Assessor\'s Sales Study.","fieldValueType":"typeOrCategory"}'}, {'name': 'sale_verification', 'type': 'esriFieldTypeString', 'alias': 'Sale Verification', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Type of individual or entity responsible for verifying the accuracy or authenticity of the sale transaction details.","fieldValueType":"typeOrCategory"}'}, {'name': 'sale_instrument', 'type': 'esriFieldTypeString', 'alias': 'Sale Instrument', 'sqlType': 'sqlTypeOther', 'length': 60000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Type of legal document or instrument used to transfer ownership of the property, such as a deed or contract.","fieldValueType":"typeOrCategory"}'}, {'name': 'property_transferred_percentage', 'type': 'esriFieldTypeDouble', 'alias': 'Property Transfer Percentage', 'sqlType': 'sqlTypeOther', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Percentage of the property transferred in the sale transaction.","fieldValueType":"percentageOrRatio"}'}, {'name': 'property_class_code', '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 or category assigned to the property based on its characteristics, use, or zoning regulations. A property is classified according to its current use annually by the first Monday of March, as required by MCL 211.34c.","fieldValueType":"typeOrCategory"}'}, {'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': 'ESRI_OID', 'type': 'esriFieldTypeOID', 'alias': 'ESRI_OID', 'sqlType': 'sqlTypeOther', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__PROPERTY__EEA048A56C5A6BB6', 'fields': 'ESRI_OID', 'isAscending': True, 'isUnique': True, 'description': '', 'indexType': 'Attribute'}, {'name': 'user_45103.PROPERTY_SALES_DETROIT_DEVELOPMENT_DBT_MART_PROPERTY_PROPERTY_SALES2_Shape_sidx', 'fields': 'Shape', 'isAscending': True, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'UX_PROPERTY_SALES_DETROIT_DEVELOPMENT_DBT_MART_PROPERTY_PROPERTY_SALES2_sale_id_ASC', 'fields': 'sale_id', 'isAscending': True, 'isUnique': True, 'description': 'Field properties', 'indexType': 'Attribute'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriSMS', 'style': 'esriSMSCircle', 'color': [137, 45, 82, 255], 'size': 4, 'angle': 0, 'xoffset': 0, 'yoffset': 0, 'outline': {'color': [0, 0, 0, 255], 'width': 0.7}}}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': None}
[]
[{'name': 'development.dbt_mart_property.property_sales', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'economic_condition_factor_neigh': None, 'sale_id': None, 'parcel_number': None, 'address': None, 'street_number': None, 'street_prefix': None, 'street_name': None, 'unit_number': None, 'sale_number': None, 'sale_date': None, 'sale_price': None, 'grantor': None, 'grantee': None, 'liber_page': None, 'term_of_sale': None, 'sale_verification': None, 'sale_instrument': None, 'property_transferred_percentage': None, 'property_class_code': None}}}]