superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where LAYER = 5, MNG_AGENCY = 17 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_NAME
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 5 ✖
MNG_AGENCY 1
- California Department of General Services · 5 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1079 | 1079 | 1078 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 0.209 | 575 Third St | ||
3571 | 3571 | 3570 | {"type": "Polygon", "coordinates": [[[-122.20351, 38.39474], [-122.20319, 38.39454], [-122.20286, 38.39422], [-122.20272, 38.39405], [-122.20259, 38.39383], [-122.20236, 38.3935], [-122.20227, 38.39332], [-122.20224, 38.39304], [-122.20227, 38.39292], [-122.20234, 38.39283], [-122.20237, 38.39269], [-122.20236, 38.39256], [-122.2023, 38.39242], [-122.20223, 38.3923], [-122.20209, 38.39217], [-122.20207, 38.3921], [-122.20208, 38.392], [-122.20213, 38.39192], [-122.20226, 38.3916], [-122.20265, 38.39132], [-122.20249, 38.39094], [-122.20223, 38.39075], [-122.20181, 38.39006], [-122.20176, 38.38991], [-122.20181, 38.38973], [-122.20189, 38.38957], [-122.20196, 38.38931], [-122.20185, 38.38897], [-122.20163, 38.38873], [-122.20152, 38.38847], [-122.20151, 38.38838], [-122.20155, 38.38829], [-122.20162, 38.38801], [-122.20178, 38.38754], [-122.20178, 38.38737], [-122.20176, 38.38726], [-122.20165, 38.38706], [-122.20158, 38.38698], [-122.20153, 38.38687], [-122.20158, 38.38645], [-122.20157, 38.38591], [-122.20153, 38.38561], [-122.20147, 38.38546], [-122.20134, 38.38522], [-122.20117, 38.38497], [-122.2033, 38.38496], [-122.20351, 38.39474]]]} | Open Access 1 | Department Of Transportation | 18098 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 32.682 | Department Of Transportation | ||
8571 | 8571 | 8570 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 0.203 | Real Estate Services Division | ||
10272 | 10272 | 10271 | {"type": "MultiPolygon", "coordinates": [[[[-122.53085, 38.65457], [-122.52623, 38.65454], [-122.52626, 38.66281], [-122.52163, 38.66281], [-122.52162, 38.65814], [-122.51683, 38.65816], [-122.51707, 38.65772], [-122.517, 38.65768], [-122.51701, 38.65454], [-122.51243, 38.65456], [-122.51247, 38.65095], [-122.5216, 38.65086], [-122.52621, 38.65092], [-122.53085, 38.65095], [-122.53085, 38.65457]]], [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]]} | Open Access 1 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 330.968 | |||
14269 | 14269 | 14268 | {"type": "MultiPolygon", "coordinates": [[[[-122.122, 38.33618], [-122.12148, 38.33658], [-122.12116, 38.33673], [-122.12083, 38.33684], [-122.12005, 38.33619], [-122.1206, 38.33583], [-122.12117, 38.33549], [-122.122, 38.33618]]], [[[-122.12934, 38.45011], [-122.1247, 38.44986], [-122.1229, 38.44968], [-122.12294, 38.44961], [-122.12321, 38.44927], [-122.12353, 38.44842], [-122.12377, 38.44773], [-122.12385, 38.44729], [-122.12381, 38.44696], [-122.12383, 38.44653], [-122.12379, 38.44617], [-122.12468, 38.44627], [-122.12921, 38.44654], [-122.12934, 38.45011]]], [[[-122.27035, 38.24032], [-122.27033, 38.24039], [-122.27027, 38.24044], [-122.26924, 38.24035], [-122.2691, 38.24036], [-122.26909, 38.24025], [-122.27035, 38.24032]]], [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]], [[[-122.57285, 38.57309], [-122.57104, 38.57221], [-122.57064, 38.57205], [-122.57035, 38.57175], [-122.57018, 38.5716], [-122.56976, 38.57131], [-122.56945, 38.57115], [-122.56889, 38.57091], [-122.56913, 38.57052], [-122.56989, 38.5711], [-122.57086, 38.57153], [-122.57176, 38.57199], [-122.57199, 38.57244], [-122.57265, 38.57291], [-122.57285, 38.57309]]], [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]], [[[-122.60006, 38.59944], [-122.59941, 38.60053], [-122.59885, 38.60029], [-122.5995, 38.59921], [-122.60006, 38.59944]]]]} | No Public Access 3 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 58.219 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);