units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "Chollas Radio System OS" and MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2863 | 2863 | 2862 | {"type": "Polygon", "coordinates": [[[-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.07324, 32.72391], [-117.07336, 32.72229], [-117.07486, 32.72154], [-117.07488, 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.72267], [-117.07527, 32.72281], [-117.07534, 32.72297], [-117.07559, 32.72323]]]} | Open Access 1 | 1921 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 33.615 | Chollas Radio System OS | 0 | Local Recreation Area 3 | 4 | |
10436 | 10436 | 10435 | {"type": "MultiPolygon", "coordinates": [[[[-117.07268, 32.71124], [-117.07261, 32.71169], [-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.0702, 32.71854], [-117.07033, 32.71875], [-117.07014, 32.71884], [-117.06999, 32.71895], [-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.06845, 32.71968], [-117.06834, 32.71985], [-117.06831, 32.71983], [-117.06826, 32.71986], [-117.0682, 32.71985], [-117.06816, 32.71971], [-117.06808, 32.7197], [-117.06804, 32.71969], [-117.06805, 32.71848], [-117.06803, 32.71672], [-117.06797, 32.71666], [-117.06797, 32.71664], [-117.06805, 32.71649], [-117.06804, 32.7161], [-117.06807, 32.7161], [-117.06839, 32.71588], [-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.07148, 32.71318], [-117.07141, 32.7131], [-117.07103, 32.7131], [-117.07116, 32.71285], [-117.07136, 32.71231], [-117.07137, 32.7122], [-117.07148, 32.71186], [-117.07152, 32.71157], [-117.07153, 32.71133], [-117.07193, 32.71133], [-117.07202, 32.71128], [-117.07212, 32.71128], [-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.08137, 32.71131], [-117.07888, 32.7113], [-117.07877, 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.07625, 32.71426], [-117.07623, 32.71426], [-117.07586, 32.71474], [-117.07582, 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.07719, 32.71176], [-117.07625, 32.71175], [-117.07622, 32.71173], [-117.07585, 32.71174], [-117.07584, 32.7121], [-117.07574, 32.7121], [-117.07573, 32.7118], [-117.07538, 32.71178], [-117.07516, 32.71162], [-117.07512, 32.71161], [-117.07455, 32.71161], [-117.07455, 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.07846, 32.71052], [-117.07956, 32.71052], [-117.07964, 32.71041], [-117.07973, 32.71052], [-117.08136, 32.71054], [-117.08137, 32.71131]]]]} | Open Access 1 | 2003 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 71.13 | Chollas Radio System OS | 0 | Local Recreation Area 3 | 4 | |
15541 | 15541 | 15540 | {"type": "Polygon", "coordinates": [[[-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.07559, 32.72196], [-117.07559, 32.72193], [-117.07692, 32.72149], [-117.07693, 32.72058], [-117.07695, 32.72049], [-117.07697, 32.72049], [-117.07696, 32.72014], [-117.07715, 32.7201], [-117.07716, 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.7194], [-117.07551, 32.71953], [-117.07513, 32.71891], [-117.07508, 32.71878], [-117.07504, 32.71862], [-117.07531, 32.71861], [-117.07533, 32.7175], [-117.07565, 32.7175], [-117.07563, 32.71813], [-117.07557, 32.71819], [-117.07555, 32.71826], [-117.07556, 32.7183], [-117.07563, 32.71835], [-117.07568, 32.71837], [-117.07574, 32.71836], [-117.07582, 32.71832], [-117.07583, 32.71827], [-117.07579, 32.71826], [-117.07581, 32.71721], [-117.07654, 32.71722], [-117.07669, 32.71827], [-117.08126, 32.7183], [-117.08325, 32.71829]]]} | Open Access 1 | 2011 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 44.245 | Chollas Radio System OS | 0 | Local Recreation Area 3 | 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]);