units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 3 and MNG_AGENCY = 1036
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14145 | 14145 | 14144 | {"type": "MultiPolygon", "coordinates": [[[[-117.82329, 33.66825], [-117.82295, 33.6685], [-117.82277, 33.66858], [-117.82258, 33.66864], [-117.82239, 33.66867], [-117.82218, 33.66868], [-117.82198, 33.66867], [-117.82179, 33.66863], [-117.8218, 33.6685], [-117.82221, 33.6686], [-117.82243, 33.66796], [-117.82243, 33.66795], [-117.82213, 33.66787], [-117.8221, 33.66795], [-117.82202, 33.66793], [-117.82215, 33.66757], [-117.82212, 33.66736], [-117.82227, 33.66734], [-117.82237, 33.66772], [-117.82271, 33.66762], [-117.82297, 33.66748], [-117.82304, 33.66756], [-117.8228, 33.66774], [-117.82329, 33.66825]]], [[[-117.82433, 33.66078], [-117.82401, 33.6608], [-117.82308, 33.66055], [-117.82318, 33.65985], [-117.82328, 33.65986], [-117.82327, 33.65996], [-117.82358, 33.65999], [-117.8236, 33.65989], [-117.82363, 33.6599], [-117.82363, 33.65998], [-117.82413, 33.66003], [-117.82415, 33.66001], [-117.82427, 33.66002], [-117.82433, 33.66078]]], [[[-117.82532, 33.66672], [-117.8252, 33.66683], [-117.82514, 33.66686], [-117.82509, 33.66686], [-117.82448, 33.66645], [-117.8243, 33.66636], [-117.82411, 33.66631], [-117.82399, 33.6663], [-117.8237, 33.66633], [-117.82422, 33.66595], [-117.82532, 33.66672]]]]} | Restricted Access 2 | 43039 | HOA Community Park | 31961 | 6029 | University Community Association 1080 | Private 7 | Home Owners Association 16 | http://www.ucahoa.com/ | Private 14 | 6029 | University Community Association 1036 | Private 7 | Home Owners Association 15 | Orange 3 | 5.459 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);