units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, COUNTY = 15 and YR_EST = 1979
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738 | 738 | 737 | {"type": "Polygon", "coordinates": [[[-122.40328, 37.44532], [-122.40103, 37.44611], [-122.40098, 37.45872], [-122.39616, 37.45869], [-122.39619, 37.46227], [-122.38709, 37.46223], [-122.38707, 37.46593], [-122.36902, 37.46596], [-122.36904, 37.46174], [-122.35145, 37.46151], [-122.34942, 37.45927], [-122.34525, 37.46088], [-122.34419, 37.46048], [-122.34541, 37.45846], [-122.34931, 37.4568], [-122.35186, 37.45784], [-122.36905, 37.45795], [-122.36908, 37.45509], [-122.37805, 37.45507], [-122.37806, 37.44784], [-122.39615, 37.44789], [-122.39624, 37.44405], [-122.40107, 37.44194], [-122.40128, 37.44208], [-122.40148, 37.44228], [-122.4028, 37.44309], [-122.40296, 37.44338], [-122.40306, 37.4438], [-122.40311, 37.44439], [-122.40328, 37.44532]]]} | Open Access 1 | 4867 | Burleigh H. Murray Ranch | 1448 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=535 | San Mateo 15 | 1352.913 | Burleigh H. Murray Ranch | 1979 | State Park 15 | 4 |
2749 | 2749 | 2748 | {"type": "MultiPolygon", "coordinates": [[[[-122.50065, 37.60485], [-122.4993, 37.60417], [-122.49877, 37.60324], [-122.49867, 37.60192], [-122.49898, 37.60135], [-122.4993, 37.60089], [-122.49914, 37.60079], [-122.50042, 37.60116], [-122.50019, 37.60148], [-122.50011, 37.60186], [-122.50035, 37.60191], [-122.50029, 37.60223], [-122.50022, 37.60229], [-122.49985, 37.6031], [-122.49984, 37.60333], [-122.49989, 37.60376], [-122.50013, 37.60436], [-122.50027, 37.60445], [-122.50033, 37.60461], [-122.50038, 37.60467], [-122.50051, 37.60474], [-122.50065, 37.60485]]], [[[-122.50283, 37.59847], [-122.50232, 37.59909], [-122.50166, 37.59977], [-122.50138, 37.59959], [-122.50119, 37.60002], [-122.50077, 37.60059], [-122.50045, 37.60111], [-122.4991, 37.60072], [-122.50017, 37.59959], [-122.50016, 37.59956], [-122.50175, 37.59807], [-122.50283, 37.59847]]], [[[-122.50393, 37.59749], [-122.50371, 37.59763], [-122.50343, 37.59789], [-122.50317, 37.59771], [-122.50282, 37.59802], [-122.50262, 37.59795], [-122.503, 37.59761], [-122.50256, 37.5973], [-122.50279, 37.59709], [-122.50323, 37.59739], [-122.50346, 37.59719], [-122.50393, 37.59749]]]]} | Open Access 1 | 18437 | Pacifica State Beach | 30671 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=524 | San Mateo 15 | 21.183 | Pacifica SB | 1979 | None 229 | |
8661 | 8661 | 8660 | {"type": "Polygon", "coordinates": [[[-122.22752, 37.47069], [-122.22724, 37.47091], [-122.22736, 37.47102], [-122.22714, 37.4712], [-122.22645, 37.47104], [-122.22721, 37.47044], [-122.22752, 37.47069]]]} | Open Access 1 | 13900 | Palm Park | 23345 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.953 | Palm Park | 1979 | Local Park 2 | 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]);