units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 84
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
240 | 240 | 239 | {"type": "Polygon", "coordinates": [[[-117.08384, 33.16747], [-117.08271, 33.16759], [-117.08326, 33.16655], [-117.08332, 33.16648], [-117.08345, 33.1664], [-117.08359, 33.16635], [-117.08368, 33.16634], [-117.08367, 33.16648], [-117.08368, 33.16662], [-117.08384, 33.16747]]]} | Open Access 1 | 645 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.034 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
1730 | 1730 | 1729 | {"type": "Polygon", "coordinates": [[[-117.08435, 33.17012], [-117.08438, 33.17027], [-117.08433, 33.17032], [-117.082, 33.17124], [-117.08208, 33.17105], [-117.08221, 33.17108], [-117.08271, 33.17089], [-117.08333, 33.17055], [-117.0842, 33.17013], [-117.08435, 33.17012]]]} | Open Access 1 | 12924 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.911 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
4913 | 4913 | 4912 | {"type": "Polygon", "coordinates": [[[-117.0835, 33.16545], [-117.08297, 33.16569], [-117.08281, 33.16578], [-117.08258, 33.16596], [-117.0824, 33.16616], [-117.0823, 33.16631], [-117.08099, 33.1689], [-117.08055, 33.16784], [-117.08057, 33.16783], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08107, 33.16808], [-117.08126, 33.1679], [-117.0813, 33.16781], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16777], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.0818, 33.16611], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]]} | Open Access 1 | 12921 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 3.546 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
4915 | 4915 | 4914 | {"type": "Polygon", "coordinates": [[[-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.08057, 33.16782], [-117.08055, 33.16784], [-117.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636]]]} | Open Access 1 | 12925 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.075 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
6021 | 6021 | 6020 | {"type": "Polygon", "coordinates": [[[-117.09032, 33.16855], [-117.09013, 33.16916], [-117.08888, 33.17318], [-117.08881, 33.17309], [-117.08922, 33.17174], [-117.08935, 33.17106], [-117.08962, 33.17044], [-117.08971, 33.17017], [-117.08973, 33.16987], [-117.08969, 33.16963], [-117.08924, 33.16964], [-117.08917, 33.16947], [-117.08972, 33.1694], [-117.08988, 33.16933], [-117.08991, 33.16921], [-117.08957, 33.16847], [-117.08962, 33.16834], [-117.08975, 33.16834], [-117.08977, 33.16836], [-117.08986, 33.16835], [-117.09023, 33.16843], [-117.09032, 33.16855]]]} | Open Access 1 | 694 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 2.827 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
9911 | 9911 | 9910 | {"type": "Polygon", "coordinates": [[[-117.08784, 33.16292], [-117.08766, 33.16301], [-117.08764, 33.16311], [-117.08733, 33.16327], [-117.08703, 33.1634], [-117.08533, 33.16436], [-117.08531, 33.16463], [-117.08614, 33.16695], [-117.08671, 33.16777], [-117.08676, 33.16801], [-117.08668, 33.16843], [-117.08677, 33.16863], [-117.08682, 33.16885], [-117.08701, 33.16933], [-117.08698, 33.16938], [-117.08688, 33.16936], [-117.08685, 33.16937], [-117.08646, 33.16833], [-117.08611, 33.16841], [-117.08592, 33.16863], [-117.08565, 33.16874], [-117.08537, 33.16882], [-117.08451, 33.16922], [-117.0843, 33.16813], [-117.08477, 33.16806], [-117.08548, 33.16786], [-117.08572, 33.16781], [-117.08576, 33.16782], [-117.08605, 33.16771], [-117.08616, 33.16749], [-117.08577, 33.16643], [-117.08575, 33.1663], [-117.08537, 33.16528], [-117.08428, 33.16511], [-117.08423, 33.16493], [-117.08413, 33.16472], [-117.08498, 33.16422], [-117.08497, 33.16419], [-117.0876, 33.16268], [-117.0877, 33.1627], [-117.08784, 33.16292]]]} | Open Access 1 | 643 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 12.097 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
14670 | 14670 | 14669 | {"type": "MultiPolygon", "coordinates": [[[[-117.05334, 33.14072], [-117.052, 33.14174], [-117.05186, 33.14187], [-117.05187, 33.14191], [-117.04901, 33.14418], [-117.04851, 33.14452], [-117.04849, 33.14452], [-117.04716, 33.14528], [-117.047, 33.14503], [-117.04826, 33.14426], [-117.04825, 33.14423], [-117.04853, 33.14406], [-117.05037, 33.14262], [-117.05045, 33.14259], [-117.05073, 33.14237], [-117.05076, 33.1423], [-117.05316, 33.1404], [-117.05324, 33.14058], [-117.05327, 33.14057], [-117.05334, 33.14072]]], [[[-117.06021, 33.13542], [-117.06016, 33.13545], [-117.0602, 33.13557], [-117.06005, 33.13562], [-117.06002, 33.13559], [-117.05878, 33.13609], [-117.05872, 33.13619], [-117.05868, 33.13606], [-117.05867, 33.13605], [-117.05764, 33.1365], [-117.05703, 33.13685], [-117.05678, 33.13703], [-117.05654, 33.13722], [-117.05619, 33.13758], [-117.05513, 33.13885], [-117.05498, 33.13909], [-117.05478, 33.1393], [-117.05407, 33.14016], [-117.05383, 33.14042], [-117.05366, 33.14057], [-117.05367, 33.14061], [-117.05357, 33.1407], [-117.05335, 33.14025], [-117.05351, 33.14015], [-117.05365, 33.14003], [-117.05546, 33.13784], [-117.05545, 33.13782], [-117.05556, 33.13767], [-117.05558, 33.13767], [-117.05606, 33.13714], [-117.05634, 33.13691], [-117.05671, 33.13664], [-117.05693, 33.1365], [-117.05744, 33.13624], [-117.05795, 33.13603], [-117.05797, 33.13605], [-117.05848, 33.13584], [-117.05849, 33.13582], [-117.05844, 33.13576], [-117.06006, 33.13509], [-117.06017, 33.13526], [-117.06021, 33.13542]]]]} | Open Access 1 | 48308 | Escondido Creek Trail | 32877 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | https://www.escondido.org/Data/Sites/1/media/PDFs/BikingEscondido.pdf | San Diego 4 | 15.735 | Escondido Creek Trail | 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]);