View In:
ArcGIS Online Map Viewer
Name: SDEPUB.SDE.Housing_Sale_Values_Rent_ZipCode_2005_2016
Display Field: ZIP
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: This layer was developed by the Research & Analytics Group of the Atlanta Regional Commission, to show data on home sales/rentals and negative equity (Zillow, 2005-2016), by zip code for the Atlanta region.- - - - - -Base Attributes:ZIP = Zip code (text)ZIP_dbl = Zip code (numeric)Total_Population_2010= Total Population, 2010 CensusTotal_Population_2011_2015_ACS= Total Population, 2011-2015 American Community Survey (ACS)- - - - - - Attributes from Zillow:Total_NegEquity_Millions_2015Q1= Total Amount of Negative Equity (Millions), 2015 Quarter 1Total_Homes_NegEquity_2015Q1= Total Number of Homes with Negative Equity, 2015 Quarter 1Pct_Homes_wMortg_NegEqty_2015Q1= Percent of Homes (w/Mortgage) with Negative Equity, 2015 Quarter 1Total_NegEquity_Millions_2015Q2= Total Amount of Negative Equity (Millions), 2015 Quarter 2Total_Homes_NegEquity_2015Q2= Total Number of Homes with Negative Equity, 2015 Quarter 2Pct_Homes_wMortg_NegEqty_2015Q2= Percent of Homes (w/Mortgage) with Negative Equity, 2015 Quarter 2Total_NegEquity_Millions_2016Q1= Total Amount of Negative Equity (Millions), 2016 Quarter 1Total_Homes_NegEquity_2016Q1= Total Number of Homes in Negative Equity, 2016 Quarter 1Pct_Homes_wMortg_NegEqty_2016Q1= Percent of Homes (w/Mortgage) with Negative Equity, 2016 Quarter 1Total_NegEquity_Millions_2016Q3= Total Amount of Negative Equity (Millions), 2016 Quarter 3Total_Homes_NegEquity_2016Q3= Total Number of Homes in Negative Equity, 2016 Quarter 3Pct_Homes_wMortg_NegEqty_2016Q3= Percent of Homes (w/Mortgage) with Negative Equity, 2016 Quarter 3- - - - - - MedHomeSalePrice_2yrAvg_2005_07= Median Home Sale Price (24 Month Average), May 2005 - April 2007MedHomeSalePrice_2yrAvg_2014_16= Median Home Sale Price (24 Month Average), May 2014 - April 2016Chg_MedPrice_2005_07_2014_16= Change in Median Home Sale Price, 2005-2007 & 2014-2016PctChg_MedPrice_2005_07_2014_16= % Change in Median Home Sale Price, 2005-2007 & 2014-2016- - - - - -AvgMoRent_2011_through_Nov = Annual Average of Median Monthly Rent, 2011 (through November)AvgMoRent_2016_through_Nov = Annual Average of Median Monthly Rent, 2016 (through November)Change_AvgMoRent_2011_2016 = Change in Annual Average of Median Monthly Rent, 2011-2016Pct_Change_AvgMoRent_2011_2016 = % Change in Annual Average of Median Monthly Rent, 2011-2016- - - - - - Sources/Dates:Zillow, 2005-2016For additional information, please visit the Atlanta Regional Commission atwww.atlantaregional.com.
Copyright Text: • Zillow
• Atlanta Regional Commission
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: false
Extent:
XMin: 1926462.1604516618
YMin: 1035022.2724484056
XMax: 2497321.161775995
YMax: 1679922.515453741
Spatial Reference: 102667
(2240)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSFSSolid
Color:
[197, 0, 255, 255]
Outline:
Style: esriSLSSolid
Color:
[110, 110, 110, 255]
Width: 0
Label:
Description:
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: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
ZIP
(
type: esriFieldTypeString, alias: Zip code (text), editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIP
)
-
ZIP_dbl
(
type: esriFieldTypeDouble, alias: Zip code (numeric), editable: true, nullable: true, defaultValue: null, modelName: ZIP_dbl
)
-
Weave_Zip_Census_ACS_Total_Popu
(
type: esriFieldTypeInteger, alias: Total_Population_2010, editable: true, nullable: true, defaultValue: null, modelName: Weave_Zip_Census_ACS_Total_Population_csv_Total_Population_2010
)
-
Total_Population_2011_2015_ACS
(
type: esriFieldTypeInteger, alias: Total Population, 2011-2015 American Community Survey (ACS), editable: true, nullable: true, defaultValue: null, modelName: Total_Population_2011_2015_ACS
)
-
MedHomeSalePrice_2yrAvg_2005_07
(
type: esriFieldTypeInteger, alias: Median Home Sale Price (24 Month Average), May 2005 - April 2007, editable: true, nullable: true, defaultValue: null, modelName: MedHomeSalePrice_2yrAvg_2005_07
)
-
MedHomeSalePrice_2yrAvg_2014_16
(
type: esriFieldTypeInteger, alias: Median Home Sale Price (24 Month Average), May 2014 - April 2016, editable: true, nullable: true, defaultValue: null, modelName: MedHomeSalePrice_2yrAvg_2014_16
)
-
Chg_MedPrice_2005_07_2014_16
(
type: esriFieldTypeInteger, alias: Change in Median Home Sale Price, 2005-2007 & 2014-2016, editable: true, nullable: true, defaultValue: null, modelName: Chg_MedPrice_2005_07_2014_16
)
-
PctChg_MedPrice_2005_07_2014_16
(
type: esriFieldTypeDouble, alias: % Change in Median Home Sale Price, 2005-2007 & 2014-2016, editable: true, nullable: true, defaultValue: null, modelName: PctChg_MedPrice_2005_07_2014_16
)
-
AvgMoRent_2011_through_Nov
(
type: esriFieldTypeInteger, alias: Annual Average of Median Monthly Rent, 2011 (through November), editable: true, nullable: true, defaultValue: null, modelName: AvgMoRent_2011_through_Nov
)
-
AvgMoRent_2016_through_Nov
(
type: esriFieldTypeInteger, alias: Annual Average of Median Monthly Rent, 2016 (through November), editable: true, nullable: true, defaultValue: null, modelName: AvgMoRent_2016_through_Nov
)
-
Change_AvgMoRent_2011_2016
(
type: esriFieldTypeInteger, alias: Change in Annual Average of Median Monthly Rent, 2011-2016, editable: true, nullable: true, defaultValue: null, modelName: Change_AvgMoRent_2011_2016
)
-
Pct_Change_AvgMoRent_2011_2016
(
type: esriFieldTypeDouble, alias: % Change in Annual Average of Median Monthly Rent, 2011-2016, editable: true, nullable: true, defaultValue: null, modelName: Pct_Change_AvgMoRent_2011_2016
)
-
Total_NegEquity_Millions_2015Q1
(
type: esriFieldTypeDouble, alias: Total Amount of Negative Equity (Millions), 2015 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Total_NegEquity_Millions_2015Q1
)
-
Total_Homes_NegEquity_2015Q1
(
type: esriFieldTypeDouble, alias: Total Number of Homes with Negative Equity, 2015 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Total_Homes_NegEquity_2015Q1
)
-
Pct_Homes_wMortg_NegEqty_2015Q1
(
type: esriFieldTypeDouble, alias: Percent of Homes (w/Mortgage) with Negative Equity, 2015 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Pct_Homes_wMortg_NegEqty_2015Q1
)
-
Total_NegEquity_Millions_2015Q2
(
type: esriFieldTypeDouble, alias: Total Amount of Negative Equity (Millions), 2015 Quarter 2, editable: true, nullable: true, defaultValue: null, modelName: Total_NegEquity_Millions_2015Q2
)
-
Total_Homes_NegEquity_2015Q2
(
type: esriFieldTypeDouble, alias: Total Number of Homes with Negative Equity, 2015 Quarter 2, editable: true, nullable: true, defaultValue: null, modelName: Total_Homes_NegEquity_2015Q2
)
-
Pct_Homes_wMortg_NegEqty_2015Q2
(
type: esriFieldTypeDouble, alias: Percent of Homes (w/Mortgage) with Negative Equity, 2015 Quarter 2, editable: true, nullable: true, defaultValue: null, modelName: Pct_Homes_wMortg_NegEqty_2015Q2
)
-
Total_NegEquity_Millions_2016Q1
(
type: esriFieldTypeDouble, alias: Total Amount of Negative Equity (Millions), 2016 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Total_NegEquity_Millions_2016Q1
)
-
Total_Homes_NegEquity_2016Q1
(
type: esriFieldTypeInteger, alias: Total Number of Homes in Negative Equity, 2016 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Total_Homes_NegEquity_2016Q1
)
-
Pct_Homes_wMortg_NegEqty_2016Q1
(
type: esriFieldTypeDouble, alias: Percent of Homes (w/Mortgage) with Negative Equity, 2016 Quarter 1, editable: true, nullable: true, defaultValue: null, modelName: Pct_Homes_wMortg_NegEqty_2016Q1
)
-
Total_NegEquity_Millions_2016Q3
(
type: esriFieldTypeDouble, alias: Total Amount of Negative Equity (Millions), 2016 Quarter 3, editable: true, nullable: true, defaultValue: null, modelName: Total_NegEquity_Millions_2016Q3
)
-
Total_Homes_NegEquity_2016Q3
(
type: esriFieldTypeInteger, alias: Total Number of Homes in Negative Equity, 2016 Quarter 3, editable: true, nullable: true, defaultValue: null, modelName: Total_Homes_NegEquity_2016Q3
)
-
Pct_Homes_wMortg_NegEqty_2016Q3
(
type: esriFieldTypeDouble, alias: Percent of Homes (w/Mortgage) with Negative Equity, 2016 Quarter 3, editable: true, nullable: true, defaultValue: null, modelName: Pct_Homes_wMortg_NegEqty_2016Q3
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
Templates:
-
Name: SDEPUB.SDE.Housing_Sale_Values_Rent_ZipCode_2005_2016
Description:
Prototype:
Total_Homes_NegEquity_2016Q3: null
Pct_Homes_wMortg_NegEqty_2016Q3: null
ZIP: null
ZIP_dbl: null
Weave_Zip_Census_ACS_Total_Popu: null
Total_Population_2011_2015_ACS: null
MedHomeSalePrice_2yrAvg_2005_07: null
MedHomeSalePrice_2yrAvg_2014_16: null
Chg_MedPrice_2005_07_2014_16: null
PctChg_MedPrice_2005_07_2014_16: null
AvgMoRent_2011_through_Nov: null
AvgMoRent_2016_through_Nov: null
Change_AvgMoRent_2011_2016: null
Pct_Change_AvgMoRent_2011_2016: null
Total_NegEquity_Millions_2015Q1: null
Total_Homes_NegEquity_2015Q1: null
Pct_Homes_wMortg_NegEqty_2015Q1: null
Total_NegEquity_Millions_2015Q2: null
Total_Homes_NegEquity_2015Q2: null
Pct_Homes_wMortg_NegEqty_2015Q2: null
Total_NegEquity_Millions_2016Q1: null
Total_Homes_NegEquity_2016Q1: null
Pct_Homes_wMortg_NegEqty_2016Q1: null
Total_NegEquity_Millions_2016Q3: null
Drawing Tool: esriFeatureEditToolPolygon
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata