superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Chollas Radio System Open Space"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14833 | 14833 | 14832 | {"type": "MultiPolygon", "coordinates": [[[[-117.07268, 32.71124], [-117.07261, 32.71168], [-117.07263, 32.7117], [-117.07239, 32.71299], [-117.07202, 32.7139], [-117.07108, 32.71512], [-117.07027, 32.71621], [-117.07027, 32.71854], [-117.07021, 32.71855], [-117.07033, 32.71875], [-117.07014, 32.71884], [-117.06999, 32.71894], [-117.0697, 32.71919], [-117.06959, 32.71931], [-117.06947, 32.71946], [-117.06938, 32.71961], [-117.06931, 32.71977], [-117.06923, 32.71999], [-117.069, 32.71994], [-117.06859, 32.71972], [-117.06846, 32.71968], [-117.06834, 32.71985], [-117.06831, 32.71983], [-117.06826, 32.71986], [-117.0682, 32.71985], [-117.06816, 32.71971], [-117.06804, 32.71969], [-117.06805, 32.71848], [-117.06803, 32.71673], [-117.06797, 32.71666], [-117.06797, 32.71664], [-117.06805, 32.71649], [-117.06804, 32.7161], [-117.06807, 32.7161], [-117.06839, 32.71589], [-117.06838, 32.71583], [-117.06871, 32.71558], [-117.0687, 32.71554], [-117.06919, 32.71518], [-117.0694, 32.71504], [-117.07003, 32.71448], [-117.07044, 32.71402], [-117.0705, 32.71396], [-117.0706, 32.71383], [-117.07062, 32.71377], [-117.07079, 32.71353], [-117.07094, 32.71324], [-117.07135, 32.71324], [-117.07147, 32.71318], [-117.07141, 32.7131], [-117.07103, 32.7131], [-117.07116, 32.71285], [-117.07136, 32.71231], [-117.07137, 32.71219], [-117.07148, 32.71186], [-117.07152, 32.71157], [-117.07153, 32.71133], [-117.07193, 32.71133], [-117.07202, 32.71128], [-117.07212, 32.71127], [-117.07212, 32.71123], [-117.07268, 32.71124]]], [[[-117.0682, 32.72017], [-117.06818, 32.72022], [-117.06804, 32.72052], [-117.06804, 32.71997], [-117.06817, 32.72009], [-117.0682, 32.72017]]], [[[-117.07559, 32.72323], [-117.07539, 32.7234], [-117.07481, 32.72421], [-117.07206, 32.72624], [-117.0702, 32.72693], [-117.0696, 32.72708], [-117.06827, 32.72704], [-117.06825, 32.72702], [-117.06823, 32.72697], [-117.06824, 32.72647], [-117.07044, 32.72525], [-117.07229, 32.72419], [-117.07323, 32.72391], [-117.07336, 32.72229], [-117.07486, 32.72154], [-117.07489, 32.72155], [-117.07528, 32.72141], [-117.07545, 32.72138], [-117.07551, 32.72139], [-117.07554, 32.72144], [-117.07522, 32.72244], [-117.07522, 32.72266], [-117.07527, 32.72281], [-117.07534, 32.72297], [-117.07559, 32.72323]]], [[[-117.08137, 32.71131], [-117.07888, 32.7113], [-117.07878, 32.71135], [-117.0788, 32.71157], [-117.0775, 32.71323], [-117.07729, 32.71354], [-117.07703, 32.71385], [-117.07674, 32.71394], [-117.07656, 32.71444], [-117.07626, 32.71426], [-117.07623, 32.71426], [-117.07586, 32.71474], [-117.07583, 32.71467], [-117.07577, 32.71467], [-117.07576, 32.71395], [-117.07586, 32.71395], [-117.07605, 32.7138], [-117.07623, 32.71348], [-117.07621, 32.71258], [-117.07674, 32.71257], [-117.07706, 32.71203], [-117.07718, 32.71177], [-117.07625, 32.71175], [-117.07622, 32.71173], [-117.07586, 32.71174], [-117.07584, 32.7121], [-117.07574, 32.7121], [-117.07573, 32.7118], [-117.07538, 32.71178], [-117.07517, 32.71162], [-117.07512, 32.71161], [-117.07455, 32.71161], [-117.07454, 32.71125], [-117.07282, 32.71122], [-117.07283, 32.71054], [-117.07367, 32.71053], [-117.07369, 32.71051], [-117.0737, 32.71016], [-117.07553, 32.71016], [-117.07647, 32.71039], [-117.07677, 32.71042], [-117.07845, 32.71043], [-117.07847, 32.71052], [-117.07956, 32.71052], [-117.07964, 32.71041], [-117.07974, 32.71052], [-117.08136, 32.71054], [-117.08137, 32.71131]]], [[[-117.08325, 32.71829], [-117.0832, 32.71836], [-117.08317, 32.71838], [-117.08221, 32.71868], [-117.08199, 32.71888], [-117.08181, 32.71894], [-117.07823, 32.72175], [-117.07614, 32.72288], [-117.07591, 32.72302], [-117.07574, 32.72314], [-117.07559, 32.72301], [-117.0755, 32.7229], [-117.07543, 32.72275], [-117.0754, 32.7226], [-117.07539, 32.72251], [-117.07542, 32.7224], [-117.07558, 32.72197], [-117.07559, 32.72193], [-117.07692, 32.72149], [-117.07693, 32.72058], [-117.07695, 32.72049], [-117.07697, 32.72048], [-117.07696, 32.72014], [-117.07715, 32.7201], [-117.07715, 32.71928], [-117.07661, 32.71943], [-117.07652, 32.71937], [-117.07642, 32.71937], [-117.07638, 32.71932], [-117.07584, 32.71946], [-117.07579, 32.71941], [-117.07551, 32.71953], [-117.07513, 32.71891], [-117.07508, 32.71878], [-117.07504, 32.71862], [-117.07531, 32.7186], [-117.07533, 32.7175], [-117.07565, 32.7175], [-117.07563, 32.71813], [-117.07557, 32.71819], [-117.07555, 32.71826], [-117.07557, 32.71831], [-117.07563, 32.71835], [-117.07568, 32.71837], [-117.07574, 32.71836], [-117.07582, 32.71831], [-117.07583, 32.71827], [-117.07579, 32.71826], [-117.07581, 32.71721], [-117.07654, 32.71722], [-117.0767, 32.71827], [-117.08126, 32.7183], [-117.08325, 32.71829]]]]} | Open Access 1 | Chollas Radio System Open Space | 17220 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 149.058 | Chollas Radio System OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);