units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 4, COUNTY = 4 and GAP_STS = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4278 | 4278 | 4277 | {"type": "MultiPolygon", "coordinates": [[[[-116.584, 32.62899], [-116.58381, 32.62893], [-116.58043, 32.62894], [-116.58043, 32.62888], [-116.58398, 32.62886], [-116.584, 32.62899]]], [[[-116.60233, 32.63994], [-116.59384, 32.63985], [-116.59345, 32.63629], [-116.58904, 32.6363], [-116.58933, 32.63975], [-116.585, 32.63974], [-116.58464, 32.63618], [-116.58059, 32.63617], [-116.58043, 32.6291], [-116.58377, 32.62909], [-116.58401, 32.62918], [-116.58433, 32.63245], [-116.58868, 32.6325], [-116.58869, 32.63248], [-116.58834, 32.62897], [-116.59286, 32.62901], [-116.59317, 32.62899], [-116.60121, 32.62905], [-116.6016, 32.63273], [-116.60233, 32.63994]]]]} | Unknown Access 4 | 45247 | San Diego Mountain Ranch | 24856 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 471.918 | San Diego Mtn. Ranch | 0 | Private Conservation 16 | 2 | |
13166 | 13166 | 13165 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16668], [-117.35696, 33.1667], [-117.35728, 33.16704], [-117.35724, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | 45147 | Buena Vista Lagoon Ecological Reserve | 16489 | 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 | San Diego 4 | 0.497 | Buena Vista Lagoon ER | 1968 | Local Conservation Area 4 | 2 | |
14641 | 14641 | 14640 | {"type": "MultiPolygon", "coordinates": [[[[-116.56634, 32.63655], [-116.56633, 32.63969], [-116.56352, 32.63968], [-116.56358, 32.64082], [-116.56185, 32.64104], [-116.56185, 32.64021], [-116.55769, 32.64018], [-116.55772, 32.63652], [-116.56634, 32.63655]]], [[[-116.6012, 32.62905], [-116.59837, 32.62903], [-116.59317, 32.62899], [-116.59319, 32.62897], [-116.59318, 32.62895], [-116.59344, 32.62873], [-116.59351, 32.62863], [-116.59356, 32.62851], [-116.59366, 32.628], [-116.59372, 32.62789], [-116.59379, 32.6278], [-116.59502, 32.62687], [-116.59524, 32.62673], [-116.59556, 32.62659], [-116.59593, 32.62649], [-116.59665, 32.62643], [-116.59792, 32.62625], [-116.59822, 32.62623], [-116.60025, 32.62627], [-116.60052, 32.6263], [-116.60079, 32.62638], [-116.60093, 32.62639], [-116.6012, 32.62905]]]]} | Unknown Access 4 | 44886 | Long Potrero | 21450 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 128.12 | Long Potrero | 0 | Private Conservation 16 | 2 | |
14768 | 14768 | 14767 | {"type": "Polygon", "coordinates": [[[-117.31758, 33.10576], [-117.31739, 33.10582], [-117.31597, 33.10271], [-117.3161, 33.10265], [-117.31758, 33.10576]]]} | Unknown Access 4 | 45154 | Poinsettia Lane Vernal Pools | 23843 | 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 | San Diego 4 | 1.476 | Poinsettia Lane Vernal Pools | 0 | 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]);