units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, DES_TP = 560 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6880 | 6880 | 6879 | {"type": "MultiPolygon", "coordinates": [[[[-122.44736, 37.75022], [-122.44723, 37.75056], [-122.44717, 37.75089], [-122.44689, 37.7512], [-122.44672, 37.75149], [-122.44662, 37.75147], [-122.44705, 37.75049], [-122.44687, 37.75043], [-122.44689, 37.75038], [-122.44675, 37.75021], [-122.44662, 37.75022], [-122.44534, 37.7493], [-122.44542, 37.74921], [-122.44552, 37.74932], [-122.44563, 37.74942], [-122.44674, 37.75004], [-122.44699, 37.75014], [-122.44736, 37.75022]]], [[[-122.44813, 37.74837], [-122.44807, 37.74864], [-122.44798, 37.74863], [-122.44804, 37.74853], [-122.44813, 37.74837]]], [[[-122.44996, 37.75106], [-122.44994, 37.75108], [-122.44977, 37.75112], [-122.44966, 37.75095], [-122.44996, 37.75095], [-122.44996, 37.75106]]], [[[-122.4502, 37.74979], [-122.45002, 37.75052], [-122.44997, 37.75081], [-122.44974, 37.75081], [-122.45001, 37.7503], [-122.44998, 37.74979], [-122.4502, 37.74979]]], [[[-122.45601, 37.75981], [-122.45564, 37.76031], [-122.45562, 37.7603], [-122.45519, 37.76058], [-122.45509, 37.76058], [-122.45508, 37.76067], [-122.4538, 37.76173], [-122.45355, 37.76154], [-122.45349, 37.76158], [-122.45248, 37.7614], [-122.45245, 37.76128], [-122.45205, 37.76133], [-122.45203, 37.76127], [-122.45244, 37.76121], [-122.45227, 37.76034], [-122.45201, 37.76037], [-122.45201, 37.7588], [-122.45288, 37.75881], [-122.45288, 37.75995], [-122.45309, 37.7601], [-122.45415, 37.76012], [-122.45483, 37.75976], [-122.4559, 37.75978], [-122.45601, 37.75981]]], [[[-122.45331, 37.75675], [-122.45338, 37.75678], [-122.45348, 37.7569], [-122.45353, 37.757], [-122.45357, 37.75711], [-122.45358, 37.75721], [-122.45356, 37.75733], [-122.45353, 37.75742], [-122.45347, 37.75752], [-122.45326, 37.75768], [-122.45278, 37.75797], [-122.45229, 37.75819], [-122.45206, 37.75825], [-122.45203, 37.75696], [-122.45206, 37.75696], [-122.45213, 37.75704], [-122.45223, 37.7571], [-122.45234, 37.75712], [-122.45244, 37.75712], [-122.45256, 37.75708], [-122.45317, 37.75676], [-122.45324, 37.75674], [-122.45331, 37.75675]]], [[[-122.45251, 37.75697], [-122.45245, 37.75699], [-122.45239, 37.757], [-122.45227, 37.75696], [-122.45251, 37.75697]]], [[[-122.45531, 37.75382], [-122.45511, 37.75413], [-122.45502, 37.75433], [-122.45497, 37.75454], [-122.45492, 37.75493], [-122.45486, 37.75509], [-122.45462, 37.75553], [-122.45417, 37.75615], [-122.45407, 37.75633], [-122.45399, 37.75658], [-122.45394, 37.75697], [-122.45389, 37.7571], [-122.45381, 37.75722], [-122.45377, 37.75705], [-122.45367, 37.75685], [-122.45356, 37.75673], [-122.45342, 37.75666], [-122.45326, 37.75663], [-122.45314, 37.75664], [-122.45272, 37.75685], [-122.45271, 37.75669], [-122.45302, 37.75653], [-122.45319, 37.7565], [-122.45336, 37.7565], [-122.45354, 37.75655], [-122.45369, 37.75663], [-122.45382, 37.75677], [-122.45383, 37.75677], [-122.45388, 37.75651], [-122.454, 37.75622], [-122.45445, 37.75552], [-122.45471, 37.75502], [-122.45478, 37.75478], [-122.45482, 37.75436], [-122.45491, 37.75413], [-122.45514, 37.75376], [-122.45529, 37.75379], [-122.45531, 37.75382]]], [[[-122.45565, 37.75336], [-122.45545, 37.75366], [-122.45542, 37.75366], [-122.45525, 37.75363], [-122.45547, 37.75332], [-122.45565, 37.75336]]], [[[-122.45981, 37.75986], [-122.45974, 37.76001], [-122.45953, 37.76007], [-122.45919, 37.76008], [-122.45907, 37.76011], [-122.45901, 37.7602], [-122.45901, 37.76032], [-122.45909, 37.76051], [-122.4591, 37.76063], [-122.45905, 37.76086], [-122.45899, 37.76093], [-122.45888, 37.76096], [-122.45877, 37.76095], [-122.45869, 37.7609], [-122.45865, 37.76081], [-122.45865, 37.76076], [-122.45869, 37.7607], [-122.45879, 37.76064], [-122.45892, 37.76063], [-122.45897, 37.76059], [-122.45897, 37.76055], [-122.45887, 37.76033], [-122.45887, 37.76018], [-122.45898, 37.76002], [-122.45916, 37.75997], [-122.4595, 37.75996], [-122.45963, 37.75992], [-122.45967, 37.75985], [-122.45962, 37.7597], [-122.45934, 37.75907], [-122.4595, 37.75911], [-122.45975, 37.75966], [-122.45981, 37.75986]]]]} | Open Access 1 | 5595 | Interior Green Belt | 20223 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 21.314 | Interior Green Belt | None 560 |
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]);