units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 4, DES_TP = 4 and YR_EST = 1983
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4932 | 4932 | 4931 | {"type": "Polygon", "coordinates": [[[-117.25556, 33.02003], [-117.25123, 33.02002], [-117.25123, 33.0188], [-117.25221, 33.01809], [-117.2555, 33.01812], [-117.25556, 33.02003]]]} | Open Access 1 | 730 | San Elijo Lagoon Ecological Reserve | 24879 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 20.255 | San Elijo Lagoon ER | 1983 | Local Conservation Area 4 | 2 | |
6918 | 6918 | 6917 | {"type": "MultiPolygon", "coordinates": [[[[-117.23536, 33.03391], [-117.23513, 33.03422], [-117.2342, 33.03397], [-117.23474, 33.03348], [-117.23477, 33.03348], [-117.23517, 33.03379], [-117.23536, 33.03391]]], [[[-117.23609, 33.03514], [-117.23555, 33.03678], [-117.23459, 33.03653], [-117.23477, 33.03601], [-117.23609, 33.03514]]], [[[-117.23732, 33.03115], [-117.23555, 33.03272], [-117.23531, 33.03354], [-117.23553, 33.03368], [-117.23569, 33.03369], [-117.23557, 33.03381], [-117.23525, 33.0336], [-117.23497, 33.03337], [-117.23493, 33.03326], [-117.23496, 33.03324], [-117.2351, 33.03295], [-117.23513, 33.03282], [-117.23514, 33.0326], [-117.23511, 33.03241], [-117.23505, 33.03223], [-117.23496, 33.03209], [-117.23577, 33.03136], [-117.23603, 33.03158], [-117.23624, 33.0314], [-117.23625, 33.03135], [-117.23668, 33.03095], [-117.23612, 33.03046], [-117.23629, 33.0303], [-117.23732, 33.03115]]], [[[-117.24184, 33.03031], [-117.24168, 33.03057], [-117.24148, 33.03079], [-117.24127, 33.03094], [-117.24071, 33.03129], [-117.24106, 33.03011], [-117.24184, 33.03031]]], [[[-117.27719, 33.00739], [-117.27719, 33.00739], [-117.27717, 33.00818], [-117.27696, 33.00739], [-117.27719, 33.00739]]], [[[-117.27882, 33.01168], [-117.27819, 33.01179], [-117.27803, 33.01121], [-117.27846, 33.01114], [-117.2784, 33.01123], [-117.2784, 33.01129], [-117.27872, 33.01159], [-117.2788, 33.01158], [-117.27882, 33.01168]]]]} | Open Access 1 | 724 | San Elijo Lagoon Ecological Reserve | 24878 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SanElijo.html | San Diego 4 | 12.338 | San Elijo Lagoon ER | 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]);