units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 3 and LABEL_NAME = "Murray Reservoir"
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11537 | 11537 | 11536 | {"type": "Polygon", "coordinates": [[[-117.0486, 32.7894], [-117.04835, 32.78961], [-117.04833, 32.78997], [-117.04827, 32.79007], [-117.0482, 32.7901], [-117.04802, 32.79011], [-117.04794, 32.79007], [-117.04786, 32.78998], [-117.04737, 32.78925], [-117.04693, 32.7887], [-117.04674, 32.7886], [-117.04656, 32.78859], [-117.04647, 32.78865], [-117.04639, 32.78874], [-117.04613, 32.79004], [-117.04591, 32.79039], [-117.04574, 32.79053], [-117.0456, 32.7906], [-117.04548, 32.7906], [-117.04536, 32.79056], [-117.04522, 32.79045], [-117.04521, 32.79013], [-117.04522, 32.78947], [-117.04519, 32.7892], [-117.0451, 32.78876], [-117.0449, 32.78852], [-117.04461, 32.78837], [-117.04434, 32.78864], [-117.04419, 32.78962], [-117.04371, 32.78954], [-117.04284, 32.78998], [-117.04086, 32.79171], [-117.04012, 32.79278], [-117.03984, 32.79352], [-117.04011, 32.79405], [-117.04009, 32.79452], [-117.04001, 32.79427], [-117.03971, 32.79409], [-117.03942, 32.79413], [-117.03887, 32.79482], [-117.03869, 32.79532], [-117.03819, 32.79565], [-117.03811, 32.79563], [-117.03808, 32.79554], [-117.03811, 32.79545], [-117.03834, 32.79523], [-117.03841, 32.79512], [-117.03843, 32.79504], [-117.03833, 32.79497], [-117.03819, 32.79495], [-117.03813, 32.79497], [-117.03816, 32.79486], [-117.03817, 32.79473], [-117.03813, 32.79467], [-117.03805, 32.79462], [-117.03791, 32.79461], [-117.03785, 32.79455], [-117.03783, 32.79437], [-117.03793, 32.79427], [-117.03807, 32.79421], [-117.03807, 32.79409], [-117.038, 32.79397], [-117.03799, 32.79391], [-117.03802, 32.79379], [-117.03833, 32.79304], [-117.03849, 32.79231], [-117.03854, 32.79214], [-117.03873, 32.79176], [-117.03853, 32.79142], [-117.03943, 32.79047], [-117.0404, 32.78811], [-117.04039, 32.78806], [-117.04036, 32.78801], [-117.03996, 32.78782], [-117.03992, 32.78782], [-117.03987, 32.78783], [-117.03939, 32.78814], [-117.03926, 32.78819], [-117.03922, 32.78819], [-117.03919, 32.78816], [-117.03919, 32.78805], [-117.03915, 32.78794], [-117.03922, 32.78778], [-117.03921, 32.78773], [-117.03899, 32.7875], [-117.03895, 32.78749], [-117.03849, 32.78753], [-117.0384, 32.78752], [-117.03827, 32.78749], [-117.03765, 32.78752], [-117.03696, 32.78761], [-117.03661, 32.78772], [-117.03634, 32.7877], [-117.03628, 32.78771], [-117.0362, 32.78768], [-117.03617, 32.78763], [-117.03609, 32.78741], [-117.03609, 32.78722], [-117.0366, 32.78705], [-117.03773, 32.78646], [-117.03818, 32.78581], [-117.03892, 32.78572], [-117.03891, 32.78587], [-117.03882, 32.78601], [-117.03882, 32.78608], [-117.0389, 32.7862], [-117.03898, 32.78624], [-117.03911, 32.78625], [-117.03927, 32.78623], [-117.03941, 32.78619], [-117.0395, 32.78621], [-117.04, 32.78624], [-117.04051, 32.78618], [-117.04079, 32.78607], [-117.04089, 32.78595], [-117.0409, 32.78581], [-117.04115, 32.78577], [-117.04128, 32.78581], [-117.04154, 32.78577], [-117.04161, 32.78574], [-117.04165, 32.7858], [-117.04164, 32.78582], [-117.04207, 32.78639], [-117.04214, 32.78637], [-117.04177, 32.78569], [-117.0418, 32.78567], [-117.04194, 32.78577], [-117.04201, 32.78572], [-117.04174, 32.78546], [-117.04216, 32.78516], [-117.04226, 32.78505], [-117.04235, 32.78493], [-117.04239, 32.78482], [-117.04238, 32.78475], [-117.0423, 32.78466], [-117.04252, 32.78442], [-117.04257, 32.78443], [-117.04259, 32.78437], [-117.04246, 32.78427], [-117.04241, 32.78433], [-117.04244, 32.78437], [-117.04219, 32.78464], [-117.04195, 32.78456], [-117.0417, 32.78456], [-117.0415, 32.78448], [-117.04126, 32.78433], [-117.04123, 32.78435], [-117.0413, 32.78443], [-117.04133, 32.78451], [-117.04133, 32.78456], [-117.04127, 32.78464], [-117.04107, 32.78468], [-117.0407, 32.78481], [-117.04063, 32.78478], [-117.0406, 32.7847], [-117.04048, 32.78469], [-117.04046, 32.78466], [-117.04043, 32.78456], [-117.04039, 32.78451], [-117.04016, 32.78437], [-117.04004, 32.78423], [-117.0401, 32.78407], [-117.04012, 32.78395], [-117.04005, 32.78394], [-117.03993, 32.78402], [-117.03985, 32.78414], [-117.03983, 32.78419], [-117.03971, 32.78417], [-117.03963, 32.78412], [-117.03956, 32.78412], [-117.0393, 32.78398], [-117.039, 32.78389], [-117.03892, 32.78378], [-117.0389, 32.78364], [-117.03892, 32.78344], [-117.03935, 32.78295], [-117.03947, 32.78286], [-117.03961, 32.7828], [-117.03983, 32.78279], [-117.03995, 32.78279], [-117.04, 32.78283], [-117.04002, 32.7829], [-117.03998, 32.78296], [-117.03999, 32.78303], [-117.04026, 32.78319], [-117.04035, 32.78327], [-117.04046, 32.78331], [-117.04055, 32.78331], [-117.04073, 32.78321], [-117.04102, 32.78316], [-117.04115, 32.78317], [-117.04135, 32.78329], [-117.04179, 32.78326], [-117.04224, 32.78326], [-117.0424, 32.78335], [-117.04263, 32.78344], [-117.04282, 32.78343], [-117.04297, 32.78339], [-117.04306, 32.78331], [-117.04309, 32.78317], [-117.04323, 32.78305], [-117.04329, 32.78296], [-117.04334, 32.78285], [-117.04332, 32.78271], [-117.04346, 32.78265], [-117.04349, 32.78257], [-117.04349, 32.78248], [-117.0434, 32.78245], [-117.04332, 32.78239], [-117.04335, 32.78233], [-117.04349, 32.78227], [-117.04354, 32.7822], [-117.04348, 32.7821], [-117.04343, 32.78206], [-117.04337, 32.78194], [-117.04327, 32.78185], [-117.04337, 32.78169], [-117.04358, 32.78157], [-117.0439, 32.78146], [-117.04415, 32.78145], [-117.04468, 32.78124], [-117.04618, 32.78194], [-117.04683, 32.78235], [-117.04659, 32.78242], [-117.04632, 32.78255], [-117.04632, 32.78257], [-117.04672, 32.78273], [-117.04609, 32.7834], [-117.04615, 32.78367], [-117.04623, 32.78392], [-117.04638, 32.78418], [-117.04672, 32.78458], [-117.04686, 32.78472], [-117.04722, 32.78483], [-117.04771, 32.7849], [-117.04743, 32.78562], [-117.04743, 32.78566], [-117.04758, 32.78602], [-117.04728, 32.78609], [-117.04724, 32.78629], [-117.04747, 32.78674], [-117.04768, 32.78689], [-117.04789, 32.78727], [-117.04813, 32.78784], [-117.04821, 32.78881], [-117.04832, 32.78923], [-117.0486, 32.7894]]]} | Open Access 1 | 46818 | Murray Reservoir | 30282 | 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 | http://www.sandiego.gov/water/recreation/reservoirs/murray.shtml | San Diego 4 | 171.108 | Murray Reservoir | 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]);