units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 4, MNG_AG_TYP = 2 and UNIT_NAME = "Shaw Valley Open Space"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15986 | 15986 | 15985 | {"type": "MultiPolygon", "coordinates": [[[[-117.20876, 32.93618], [-117.20864, 32.93616], [-117.20842, 32.9361], [-117.20825, 32.9361], [-117.20801, 32.93615], [-117.20761, 32.9362], [-117.20682, 32.93637], [-117.20679, 32.93639], [-117.2068, 32.93645], [-117.2048, 32.93683], [-117.20432, 32.93685], [-117.20379, 32.93676], [-117.20287, 32.93647], [-117.20283, 32.93634], [-117.20268, 32.93619], [-117.20263, 32.9361], [-117.20257, 32.93604], [-117.20234, 32.93588], [-117.20215, 32.93568], [-117.2018, 32.9354], [-117.20164, 32.93523], [-117.20155, 32.93517], [-117.20136, 32.9351], [-117.20114, 32.93504], [-117.20086, 32.93492], [-117.2006, 32.93484], [-117.20042, 32.93483], [-117.19997, 32.93475], [-117.19916, 32.93448], [-117.19895, 32.93444], [-117.1954, 32.93441], [-117.19541, 32.93419], [-117.19447, 32.93379], [-117.19388, 32.93351], [-117.19345, 32.93327], [-117.19256, 32.93268], [-117.19214, 32.93234], [-117.1918, 32.93203], [-117.19147, 32.9317], [-117.19106, 32.93125], [-117.19105, 32.92944], [-117.19118, 32.9296], [-117.19147, 32.9298], [-117.19168, 32.92988], [-117.19386, 32.93036], [-117.1941, 32.93039], [-117.19456, 32.93043], [-117.19557, 32.93043], [-117.19582, 32.93074], [-117.19626, 32.93093], [-117.1963, 32.93106], [-117.19617, 32.93132], [-117.19592, 32.93195], [-117.19622, 32.93217], [-117.19639, 32.93226], [-117.19659, 32.93228], [-117.19667, 32.93227], [-117.19688, 32.93232], [-117.19695, 32.93235], [-117.19708, 32.93247], [-117.19736, 32.93277], [-117.19758, 32.9329], [-117.19787, 32.93301], [-117.19862, 32.93319], [-117.19919, 32.93313], [-117.19941, 32.9332], [-117.19991, 32.9334], [-117.20021, 32.93348], [-117.20054, 32.93352], [-117.20082, 32.93349], [-117.20104, 32.93351], [-117.20143, 32.93373], [-117.20173, 32.93415], [-117.20193, 32.93426], [-117.20214, 32.93445], [-117.20182, 32.93445], [-117.20181, 32.93447], [-117.20344, 32.93566], [-117.20467, 32.9361], [-117.20574, 32.93608], [-117.2069, 32.93587], [-117.20723, 32.93567], [-117.20839, 32.93597], [-117.20876, 32.93618]], [[-117.19431, 32.93312], [-117.19506, 32.93291], [-117.19511, 32.93288], [-117.19477, 32.93231], [-117.1946, 32.93223], [-117.19449, 32.93239], [-117.19436, 32.93247], [-117.19425, 32.93248], [-117.19391, 32.93242], [-117.19377, 32.93246], [-117.19377, 32.93274], [-117.19431, 32.93312]]], [[[-117.21147, 32.92856], [-117.21149, 32.92873], [-117.21146, 32.92888], [-117.21138, 32.92899], [-117.21126, 32.92927], [-117.21116, 32.9296], [-117.21107, 32.9296], [-117.21101, 32.92964], [-117.21083, 32.92967], [-117.21085, 32.92969], [-117.21104, 32.92974], [-117.21101, 32.9298], [-117.21112, 32.9299], [-117.21113, 32.93005], [-117.21108, 32.9301], [-117.21107, 32.93015], [-117.21117, 32.93028], [-117.21131, 32.9303], [-117.21132, 32.93038], [-117.2114, 32.9304], [-117.21147, 32.93045], [-117.21148, 32.93063], [-117.21144, 32.93101], [-117.21055, 32.931], [-117.21054, 32.93354], [-117.21046, 32.93361], [-117.21046, 32.93423], [-117.21044, 32.93427], [-117.21017, 32.93427], [-117.21021, 32.9341], [-117.21021, 32.93384], [-117.21013, 32.93359], [-117.21006, 32.93347], [-117.20996, 32.93335], [-117.20973, 32.93312], [-117.20951, 32.93294], [-117.20923, 32.93281], [-117.20899, 32.93274], [-117.20868, 32.93269], [-117.20758, 32.93266], [-117.20668, 32.93251], [-117.20642, 32.9325], [-117.20613, 32.93253], [-117.20572, 32.93264], [-117.2055, 32.93254], [-117.20545, 32.93241], [-117.2053, 32.93221], [-117.20519, 32.93215], [-117.20488, 32.93174], [-117.2046, 32.93156], [-117.20428, 32.9314], [-117.20425, 32.93131], [-117.20414, 32.93117], [-117.20381, 32.93101], [-117.20355, 32.93098], [-117.20332, 32.93102], [-117.20321, 32.931], [-117.20284, 32.93102], [-117.20234, 32.93116], [-117.20213, 32.93119], [-117.20192, 32.93117], [-117.20168, 32.93108], [-117.20151, 32.93093], [-117.2014, 32.93073], [-117.20137, 32.93059], [-117.20137, 32.93009], [-117.20116, 32.93004], [-117.20121, 32.93002], [-117.20116, 32.92987], [-117.20049, 32.92938], [-117.20009, 32.92913], [-117.20005, 32.92908], [-117.2, 32.92891], [-117.19978, 32.9289], [-117.19978, 32.92857], [-117.20029, 32.92857], [-117.20038, 32.92851], [-117.20052, 32.92861], [-117.20117, 32.92887], [-117.20156, 32.92896], [-117.20192, 32.92909], [-117.20226, 32.92926], [-117.20265, 32.92938], [-117.20269, 32.92937], [-117.20291, 32.92988], [-117.20286, 32.92993], [-117.2029, 32.92997], [-117.20302, 32.92998], [-117.20305, 32.93004], [-117.20276, 32.93017], [-117.20293, 32.9305], [-117.20299, 32.93051], [-117.20307, 32.93047], [-117.20306, 32.93045], [-117.20325, 32.93036], [-117.20302, 32.9299], [-117.20295, 32.92989], [-117.20275, 32.92936], [-117.20308, 32.9293], [-117.2034, 32.9291], [-117.20377, 32.92865], [-117.20385, 32.9286], [-117.2041, 32.92866], [-117.20411, 32.92874], [-117.20435, 32.92881], [-117.20443, 32.92887], [-117.20447, 32.92895], [-117.20454, 32.92929], [-117.20467, 32.92955], [-117.20486, 32.92978], [-117.2051, 32.92997], [-117.20539, 32.93011], [-117.2057, 32.93019], [-117.20607, 32.93024], [-117.20613, 32.93027], [-117.2054, 32.93085], [-117.20541, 32.93086], [-117.20548, 32.93086], [-117.2062, 32.9303], [-117.20635, 32.9304], [-117.20648, 32.93069], [-117.20665, 32.93091], [-117.20682, 32.93116], [-117.20721, 32.9311], [-117.20748, 32.93101], [-117.20759, 32.93101], [-117.20788, 32.93116], [-117.20815, 32.93115], [-117.20831, 32.93106], [-117.20838, 32.93113], [-117.20861, 32.9312], [-117.20866, 32.93123], [-117.20897, 32.93138], [-117.20934, 32.93136], [-117.20968, 32.93108], [-117.20977, 32.93091], [-117.20983, 32.93088], [-117.21014, 32.93065], [-117.21015, 32.93041], [-117.20994, 32.93005], [-117.20981, 32.92991], [-117.21014, 32.92961], [-117.21011, 32.92959], [-117.20977, 32.92988], [-117.20959, 32.92974], [-117.20958, 32.9297], [-117.2096, 32.92952], [-117.21019, 32.92908], [-117.21015, 32.92879], [-117.21006, 32.92854], [-117.20978, 32.92831], [-117.20954, 32.9282], [-117.20887, 32.92803], [-117.20878, 32.92799], [-117.20853, 32.92796], [-117.20857, 32.92789], [-117.20989, 32.92777], [-117.21005, 32.92778], [-117.21025, 32.92785], [-117.21068, 32.92785], [-117.21071, 32.9278], [-117.21129, 32.92834], [-117.21147, 32.92856]], [[-117.20597, 32.93151], [-117.20582, 32.93148], [-117.20578, 32.93153], [-117.20594, 32.93164], [-117.20619, 32.93174], [-117.20663, 32.93189], [-117.2075, 32.93215], [-117.20769, 32.93218], [-117.20785, 32.93225], [-117.20795, 32.93209], [-117.20776, 32.93179], [-117.20597, 32.93151]]], [[[-117.21134, 32.93823], [-117.21125, 32.93829], [-117.21112, 32.9382], [-117.21096, 32.93819], [-117.20405, 32.93807], [-117.20404, 32.93796], [-117.20467, 32.93798], [-117.20482, 32.93797], [-117.20516, 32.93791], [-117.20552, 32.93789], [-117.2065, 32.93795], [-117.20679, 32.93791], [-117.20706, 32.93785], [-117.20736, 32.93773], [-117.20777, 32.93744], [-117.2081, 32.93729], [-117.20829, 32.93724], [-117.20853, 32.93722], [-117.20912, 32.93731], [-117.20941, 32.93741], [-117.20975, 32.93757], [-117.20999, 32.93763], [-117.2103, 32.93764], [-117.21052, 32.93759], [-117.21075, 32.93752], [-117.2108, 32.93753], [-117.21084, 32.93755], [-117.21134, 32.93823]]], [[[-117.21409, 32.92736], [-117.21272, 32.92738], [-117.21271, 32.93104], [-117.21172, 32.93102], [-117.21175, 32.93067], [-117.21175, 32.93046], [-117.2117, 32.93032], [-117.21159, 32.93018], [-117.2117, 32.93016], [-117.21169, 32.93011], [-117.21176, 32.93007], [-117.21172, 32.92994], [-117.21164, 32.92986], [-117.21153, 32.92961], [-117.21152, 32.92946], [-117.21162, 32.92917], [-117.21176, 32.9289], [-117.21173, 32.9288], [-117.21171, 32.92879], [-117.21155, 32.92886], [-117.2116, 32.92844], [-117.21163, 32.92844], [-117.21164, 32.92836], [-117.21146, 32.92834], [-117.21135, 32.92831], [-117.21074, 32.92775], [-117.21096, 32.9274], [-117.21107, 32.92707], [-117.21103, 32.92667], [-117.21093, 32.92648], [-117.21069, 32.92622], [-117.21057, 32.92612], [-117.21053, 32.92606], [-117.21052, 32.92602], [-117.21055, 32.9259], [-117.21061, 32.92582], [-117.2107, 32.92574], [-117.21079, 32.92559], [-117.21079, 32.92533], [-117.21077, 32.92511], [-117.21072, 32.9249], [-117.21056, 32.92446], [-117.21044, 32.92425], [-117.20996, 32.92368], [-117.2099, 32.92368], [-117.2102, 32.9233], [-117.21058, 32.92295], [-117.21067, 32.92289], [-117.21071, 32.92301], [-117.21103, 32.92329], [-117.21101, 32.92333], [-117.21118, 32.92341], [-117.2112, 32.92358], [-117.21122, 32.92366], [-117.21125, 32.92369], [-117.21131, 32.92369], [-117.21141, 32.92397], [-117.21188, 32.92478], [-117.21135, 32.92498], [-117.21134, 32.92497], [-117.21129, 32.92498], [-117.21132, 32.92506], [-117.21191, 32.92483], [-117.2125, 32.92585], [-117.21276, 32.9262], [-117.21295, 32.9264], [-117.21315, 32.92658], [-117.21385, 32.92708], [-117.21397, 32.9272], [-117.21409, 32.92736]]], [[[-117.21105, 32.93642], [-117.21071, 32.93641], [-117.21061, 32.936], [-117.21049, 32.93568], [-117.21041, 32.93558], [-117.21037, 32.93549], [-117.2101, 32.93517], [-117.21025, 32.93492], [-117.2103, 32.93478], [-117.21033, 32.93474], [-117.21039, 32.93473], [-117.21043, 32.93475], [-117.21046, 32.93479], [-117.21047, 32.93484], [-117.21054, 32.93492], [-117.21054, 32.93525], [-117.21056, 32.93526], [-117.21105, 32.93642]]]]} | Open Access 1 | 46798 | Shaw Valley Open Space | 30257 | 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 | 169.03 | Shaw Valley 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]);