units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_LEV = 4 and YR_EST = 1983
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 2
MNG_AGENCY 2
ACCESS_TYP 2
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10620 | 10620 | 10619 | {"type": "Polygon", "coordinates": [[[-122.29814, 37.47974], [-122.29767, 37.48022], [-122.29771, 37.48047], [-122.29746, 37.48165], [-122.29725, 37.48185], [-122.29728, 37.48219], [-122.29705, 37.4826], [-122.29733, 37.48316], [-122.29557, 37.48494], [-122.29607, 37.48697], [-122.29293, 37.48879], [-122.28993, 37.48678], [-122.29047, 37.48655], [-122.29108, 37.48676], [-122.29146, 37.48671], [-122.29166, 37.48656], [-122.29125, 37.486], [-122.29163, 37.48569], [-122.29103, 37.48475], [-122.291, 37.48476], [-122.28655, 37.48076], [-122.28812, 37.47949], [-122.28532, 37.4779], [-122.28375, 37.47647], [-122.28283, 37.475], [-122.28287, 37.47498], [-122.28297, 37.47477], [-122.28375, 37.4747], [-122.28407, 37.47452], [-122.28496, 37.47407], [-122.287, 37.47526], [-122.28839, 37.47379], [-122.28666, 37.47272], [-122.28682, 37.47257], [-122.28736, 37.47177], [-122.28761, 37.47145], [-122.28788, 37.47137], [-122.28949, 37.47041], [-122.28996, 37.47023], [-122.29053, 37.47014], [-122.29123, 37.46999], [-122.29144, 37.47036], [-122.29205, 37.47038], [-122.29228, 37.47023], [-122.29162, 37.47214], [-122.2944, 37.47203], [-122.29505, 37.4729], [-122.2957, 37.47355], [-122.29639, 37.4744], [-122.29749, 37.47578], [-122.29792, 37.47677], [-122.29793, 37.47736], [-122.29774, 37.47763], [-122.2965, 37.47799], [-122.29641, 37.47803], [-122.29633, 37.47809], [-122.29628, 37.47816], [-122.29625, 37.47825], [-122.29625, 37.47834], [-122.2963, 37.47845], [-122.29636, 37.47852], [-122.29647, 37.47858], [-122.2966, 37.47862], [-122.29764, 37.47853], [-122.2977, 37.47853], [-122.29775, 37.47856], [-122.29779, 37.47862], [-122.29804, 37.47936], [-122.29814, 37.47974]]]} | Open Access 1 | 18908 | Pulgas Ridge Open Space Preserve | 31453 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_pulgas_ridge.asp | San Mateo 15 | 364.968 | Pulgas Ridge OSP | 1983 | Local Conservation Area 4 | 2 |
15640 | 15640 | 15639 | {"type": "MultiPolygon", "coordinates": [[[[-117.31035, 33.08979], [-117.31028, 33.08985], [-117.31002, 33.08986], [-117.3097, 33.08907], [-117.30937, 33.08815], [-117.30811, 33.08419], [-117.30836, 33.08424], [-117.30846, 33.08445], [-117.30841, 33.08445], [-117.3084, 33.0845], [-117.30846, 33.08469], [-117.30861, 33.0851], [-117.30879, 33.0855], [-117.30911, 33.08636], [-117.30926, 33.08685], [-117.30936, 33.08707], [-117.30944, 33.08752], [-117.30948, 33.08757], [-117.30958, 33.0876], [-117.3098, 33.08825], [-117.3098, 33.08832], [-117.30977, 33.0884], [-117.30987, 33.08879], [-117.31004, 33.08917], [-117.31007, 33.08927], [-117.31015, 33.08935], [-117.31023, 33.08954], [-117.31034, 33.0897], [-117.31035, 33.08979]]], [[[-117.31092, 33.09038], [-117.31087, 33.09039], [-117.31078, 33.09031], [-117.31073, 33.09017], [-117.31058, 33.08993], [-117.31056, 33.0898], [-117.31043, 33.08945], [-117.31048, 33.08939], [-117.31045, 33.08926], [-117.31027, 33.08887], [-117.31021, 33.08862], [-117.31001, 33.08829], [-117.30994, 33.08824], [-117.30987, 33.08814], [-117.30966, 33.08762], [-117.30966, 33.08759], [-117.30968, 33.08746], [-117.30965, 33.0873], [-117.30953, 33.08701], [-117.30946, 33.08676], [-117.30932, 33.08638], [-117.30928, 33.0862], [-117.30915, 33.08591], [-117.30901, 33.08547], [-117.30893, 33.08529], [-117.30884, 33.08484], [-117.30877, 33.08464], [-117.30875, 33.08445], [-117.30868, 33.08417], [-117.30878, 33.08405], [-117.30986, 33.08748], [-117.31068, 33.08968], [-117.31077, 33.08988], [-117.31076, 33.08997], [-117.31079, 33.09011], [-117.3109, 33.09029], [-117.31092, 33.09038]]]]} | Unknown Access 4 | 45153 | Batiquitos Lagoon Ecological Reserve | 15865 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 7.116 | Batiquitos Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
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]);