Layer: OCACS 2021 ZIP Code Demographics (ID:0)

View In: Map Viewer

Name: OCACS 2021 ZIP Code Demographics

Display Field: ZCTA5CE20

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

US Census American Community Survey (ACS) 2021, 5-year estimates of the key demographic characteristics of ZIP Code Tabulation Areas geographic level in Orange County, California. The data contains 105 fields for the variable groups D01: Sex and age (universe: total population, table X1, 49 fields); D02: Median age by sex and race (universe: total population, table X1, 12 fields); D03: Race (universe: total population, table X2, 8 fields); D04: Race alone or in combination with one or more other races (universe: total population, table X2, 7 fields); D05: Hispanic or Latino and race (universe: total population, table X3, 21 fields), and; D06: Citizen voting age population (universe: citizen, 18 and over, table X5, 8 fields). The US Census geodemographic data are based on the 2021 TigerLines across multiple geographies. The spatial geographies were merged with ACS data tables. See full documentation at the OCACS project GitHub page (https://github.com/ktalexan/OCACS-Geodemographics).

Copyright Text: Original datasets from US Census TigerLine Geography (https://www.census.gov/geo/maps-data/data/tiger-line.html), and American FactFinder (https://factfinder.census.gov/) for the selected tables of the American Community Survey (ACS, 2021). Linking and merging geographic with demographic tables along with final production of the merged spatial geodatabase and online datasets are performed by Orange County Public Works, OC Survey Geospatial Services, Dr. Kostas Alexandridis, GISP.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"classBreaks","authoringInfo":{"type":"classedColor","colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,226,193,255],"toColor":[247,226,193,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,153,140,255],"toColor":[230,153,140,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,104,104,255],"toColor":[217,104,104,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[176,70,93,255],"toColor":[176,70,93,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[135,35,82,255],"toColor":[135,35,82,255]}]},"classificationMethod":"esriClassifyNaturalBreaks"},"field":"PopDens","classificationMethod":"esriClassifyNaturalBreaks","minValue":0,"classBreakInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[248,227,194,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":2045.7050964281882,"label":"0 - 2,046"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[229,153,140,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":4694.5111654958791,"label":"2,047 - 4,695"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[216,104,104,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":6937.2358344556542,"label":"4,696 - 6,937"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[175,70,93,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":9774.414177543571,"label":"6,938 - 9,774"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[135,35,81,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"classMaxValue":15198.254709524741,"label":"9,775 - 15,198"}],"legendOptions":{"order":"ascendingValues"}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ZCTA5CE20 (type: esriFieldTypeString, alias: ZCTA5CE20, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
GEOID20 (type: esriFieldTypeString, alias: GEOID20, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
CLASSFP20 (type: esriFieldTypeString, alias: CLASSFP20, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
MTFCC20 (type: esriFieldTypeString, alias: MTFCC20, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
FUNCSTAT20 (type: esriFieldTypeString, alias: FUNCSTAT20, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ALAND20 (type: esriFieldTypeDouble, alias: ALAND20, SQL Type: sqlTypeOther, nullable: true, editable: true)
AWATER20 (type: esriFieldTypeDouble, alias: AWATER20, SQL Type: sqlTypeOther, nullable: true, editable: true)
INTPTLAT20 (type: esriFieldTypeString, alias: INTPTLAT20, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
INTPTLON20 (type: esriFieldTypeString, alias: INTPTLON20, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
GEOID_Data (type: esriFieldTypeString, alias: GEOID_Data, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
D01B01001e1 (type: esriFieldTypeDouble, alias: D01: Total population, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e2 (type: esriFieldTypeDouble, alias: D01: Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e3 (type: esriFieldTypeDouble, alias: D01: Male, under 5 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e4 (type: esriFieldTypeDouble, alias: D01: Male, 5 to 9 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e5 (type: esriFieldTypeDouble, alias: D01: Male, 10 to 14 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e6 (type: esriFieldTypeDouble, alias: D01: Male, 15 to 17 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e7 (type: esriFieldTypeDouble, alias: D01: Male, 18 and 19 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e8 (type: esriFieldTypeDouble, alias: D01: Male, 20 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e9 (type: esriFieldTypeDouble, alias: D01: Male, 21 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e10 (type: esriFieldTypeDouble, alias: D01: Male, 22 to 24 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e11 (type: esriFieldTypeDouble, alias: D01: Male, 25 to 29 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e12 (type: esriFieldTypeDouble, alias: D01: Male, 30 to 34 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e13 (type: esriFieldTypeDouble, alias: D01: Male, 35 to 39 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e14 (type: esriFieldTypeDouble, alias: D01: Male, 40 to 44 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e15 (type: esriFieldTypeDouble, alias: D01: Male, 45 to 49 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e16 (type: esriFieldTypeDouble, alias: D01: Male, 50 to 54 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e17 (type: esriFieldTypeDouble, alias: D01: Male, 55 to 59 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e18 (type: esriFieldTypeDouble, alias: D01: Male, 60 and 61 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e19 (type: esriFieldTypeDouble, alias: D01: Male, 62 to 64 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e20 (type: esriFieldTypeDouble, alias: D01: Male, 65 and 66 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e21 (type: esriFieldTypeDouble, alias: D01: Male, 67 to 69 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e22 (type: esriFieldTypeDouble, alias: D01: Male, 70 to 74 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e23 (type: esriFieldTypeDouble, alias: D01: Male, 75 to 79 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e24 (type: esriFieldTypeDouble, alias: D01: Male, 80 to 84 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e25 (type: esriFieldTypeDouble, alias: D01: Male, 85 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e26 (type: esriFieldTypeDouble, alias: D01: Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e27 (type: esriFieldTypeDouble, alias: D01: Female, under 5 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e28 (type: esriFieldTypeDouble, alias: D01: Female, 5 to 9 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e29 (type: esriFieldTypeDouble, alias: D01: Female, 10 to 14 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e30 (type: esriFieldTypeDouble, alias: D01: Female, 15 to 17 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e31 (type: esriFieldTypeDouble, alias: D01: Female, 18 and 19 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e32 (type: esriFieldTypeDouble, alias: D01: Female, 20 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e33 (type: esriFieldTypeDouble, alias: D01: Female, 21 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e34 (type: esriFieldTypeDouble, alias: D01: Female, 22 to 24 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e35 (type: esriFieldTypeDouble, alias: D01: Female, 25 to 29 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e36 (type: esriFieldTypeDouble, alias: D01: Female, 30 to 34 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e37 (type: esriFieldTypeDouble, alias: D01: Female, 35 to 39 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e38 (type: esriFieldTypeDouble, alias: D01: Female, 40 to 44 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e39 (type: esriFieldTypeDouble, alias: D01: Female, 45 to 49 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e40 (type: esriFieldTypeDouble, alias: D01: Female, 50 to 54 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e41 (type: esriFieldTypeDouble, alias: D01: Female, 55 to 59 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e42 (type: esriFieldTypeDouble, alias: D01: Female, 60 and 61 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e43 (type: esriFieldTypeDouble, alias: D01: Female, 62 to 64 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e44 (type: esriFieldTypeDouble, alias: D01: Female, 65 and 66 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e45 (type: esriFieldTypeDouble, alias: D01: Female, 67 to 69 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e46 (type: esriFieldTypeDouble, alias: D01: Female, 70 to 74 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e47 (type: esriFieldTypeDouble, alias: D01: Female, 75 to 79 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e48 (type: esriFieldTypeDouble, alias: D01: Female, 80 to 84 years, SQL Type: sqlTypeOther, nullable: true, editable: true)
D01B01001e49 (type: esriFieldTypeDouble, alias: D01: Female, 85 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002e1 (type: esriFieldTypeDouble, alias: D02: Median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002e2 (type: esriFieldTypeDouble, alias: D02: Male, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002e3 (type: esriFieldTypeDouble, alias: D02: Female, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Ae1 (type: esriFieldTypeDouble, alias: D02: White alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Be1 (type: esriFieldTypeDouble, alias: D02: Black or African American alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Ce1 (type: esriFieldTypeDouble, alias: D02: American Indian and Alaska Native alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002De1 (type: esriFieldTypeDouble, alias: D02: Asian alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Ee1 (type: esriFieldTypeDouble, alias: D02: Native Hawaiian and Other Pacific Islander alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Fe1 (type: esriFieldTypeDouble, alias: D02: Some other race alone, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Ge1 (type: esriFieldTypeDouble, alias: D02: Two or more races, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002He1 (type: esriFieldTypeDouble, alias: D02: White alone, not Hispanic or Latino, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D02B01002Ie1 (type: esriFieldTypeDouble, alias: D02: Hispanic or Latino, median age (years), SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e1 (type: esriFieldTypeDouble, alias: D03: Total population, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e2 (type: esriFieldTypeDouble, alias: D03: White alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e3 (type: esriFieldTypeDouble, alias: D03: Black or African American alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e4 (type: esriFieldTypeDouble, alias: D03: American Indian and Alaska Native alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e5 (type: esriFieldTypeDouble, alias: D03: Asian alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e6 (type: esriFieldTypeDouble, alias: D03: Native Hawaiian and Other Pacific Islander alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e7 (type: esriFieldTypeDouble, alias: D03: Some other race alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D03B02001e8 (type: esriFieldTypeDouble, alias: D03: Two or more races, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02001e1 (type: esriFieldTypeDouble, alias: D04: Total population, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02008e1 (type: esriFieldTypeDouble, alias: D04: White, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02009e1 (type: esriFieldTypeDouble, alias: D04: Black or African American, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02010e1 (type: esriFieldTypeDouble, alias: D04: American Indian and Alaska Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02011e1 (type: esriFieldTypeDouble, alias: D04: Asian, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02012e1 (type: esriFieldTypeDouble, alias: D04: Native Hawaiian and Other Pacific Islander, SQL Type: sqlTypeOther, nullable: true, editable: true)
D04B02013e1 (type: esriFieldTypeDouble, alias: D04: Some other race, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e1 (type: esriFieldTypeDouble, alias: D05: Total population, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e2 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e3 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, White alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e4 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Black or African American alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e5 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, American Indian and Alaska Native alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e6 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Asian alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e7 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Native Hawaiian and Other Pacific Islander alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e8 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Some other race alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e9 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Two or more races, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e10 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Two races including some other race, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e11 (type: esriFieldTypeDouble, alias: D05: Not Hispanic or Latino, Two races excluding some other race, and three or more races, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e12 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e13 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, White alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e14 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Black or African American alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e15 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, American Indian and Alaska Native alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e16 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Asian alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e17 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Native Hawaiian and Other Pacific Islander alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e18 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Some other race alone, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e19 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Two or more races, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e20 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Two races including some other race, SQL Type: sqlTypeOther, nullable: true, editable: true)
D05B03002e21 (type: esriFieldTypeDouble, alias: D05: Hispanic or Latino, Two races excluding some other race, and three or more races, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e8 (type: esriFieldTypeDouble, alias: D06: Male, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e9 (type: esriFieldTypeDouble, alias: D06: Male, Native US Citizen, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e11 (type: esriFieldTypeDouble, alias: D06: Male, Foreign-born Naturalized US Citizen, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e12 (type: esriFieldTypeDouble, alias: D06: Male, Foreign-born, not a US Citizen, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e19 (type: esriFieldTypeDouble, alias: D06: Female, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e20 (type: esriFieldTypeDouble, alias: D06: Female, Native US Citizem, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e22 (type: esriFieldTypeDouble, alias: D06: Female, Foreign-born, Naturalized US Citizen, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
D06B05003e23 (type: esriFieldTypeDouble, alias: D06: Female, Foreign-born, not a US Citizen, 18 years and over, SQL Type: sqlTypeOther, nullable: true, editable: true)
AreaSqMi (type: esriFieldTypeDouble, alias: AreaSqMi, SQL Type: sqlTypeOther, nullable: true, editable: true)
PopDens (type: esriFieldTypeDouble, alias: Population Density (per square mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/5/2023 6:58:14 PM

Schema Last Edit Date: 9/5/2023 6:58:14 PM

Data Last Edit Date: 9/5/2023 6:58:14 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat