units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 3, AGNCY_NAME = 173 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- Non Profit - Land Trust · 4 ✖
MNG_AGENCY 1
DES_TP 1
ACCESS_TYP 1
- No Public Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
535 | 535 | 534 | {"type": "Polygon", "coordinates": [[[-121.91117, 36.50829], [-121.9087, 36.50828], [-121.9087, 36.50744], [-121.9081, 36.50743], [-121.90839, 36.50686], [-121.90839, 36.50628], [-121.90807, 36.50595], [-121.90715, 36.50527], [-121.90671, 36.50464], [-121.91113, 36.50468], [-121.91117, 36.50829]]]} | No Public Access 3 | 2572 | Canavarro | 16797 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 27.752 | Canavarro | 0 | Private Conservation 16 | 2 | |
1426 | 1426 | 1425 | {"type": "Polygon", "coordinates": [[[-121.64639, 36.6877], [-121.64408, 36.6912], [-121.64363, 36.69113], [-121.64368, 36.69104], [-121.64367, 36.69103], [-121.64273, 36.69088], [-121.64213, 36.69135], [-121.64196, 36.69156], [-121.64198, 36.69158], [-121.64139, 36.69215], [-121.63962, 36.69351], [-121.63892, 36.69423], [-121.63884, 36.69428], [-121.63864, 36.69411], [-121.63991, 36.69024], [-121.6399, 36.69023], [-121.63797, 36.69073], [-121.63845, 36.68718], [-121.64106, 36.6865], [-121.64063, 36.68798], [-121.64637, 36.68758], [-121.6464, 36.68763], [-121.64639, 36.6877]]]} | No Public Access 3 | 48978 | Carr Lake | 33675 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | https://bigsurlandtrust.org/wp-content/uploads/2018/10/CarrLake_PublicMap-2.pdf | Monterey 14 | 72.339 | Carr Lake | 2017 | Private Conservation 16 | 2 |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-121.93361, 36.54372], [-121.93342, 36.54391], [-121.9333, 36.54419], [-121.93338, 36.54444], [-121.93337, 36.54452], [-121.93334, 36.54453], [-121.93305, 36.54443], [-121.93288, 36.54441], [-121.93264, 36.54448], [-121.9325, 36.54447], [-121.93239, 36.54448], [-121.93237, 36.54438], [-121.93252, 36.54434], [-121.93284, 36.54436], [-121.93292, 36.54428], [-121.9331, 36.54428], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | 3340 | Carmel Point | 16873 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.545 | Carmel Point | 0 | Private Conservation 16 | 2 | |
10869 | 10869 | 10868 | {"type": "Polygon", "coordinates": [[[-121.4365, 36.23234], [-121.43646, 36.23593], [-121.43251, 36.2359], [-121.43246, 36.24311], [-121.4324, 36.24332], [-121.43238, 36.24354], [-121.43238, 36.24862], [-121.43235, 36.24889], [-121.43229, 36.24915], [-121.43221, 36.24937], [-121.43208, 36.24963], [-121.43187, 36.24995], [-121.4311, 36.25085], [-121.43099, 36.25107], [-121.43094, 36.25131], [-121.43067, 36.25067], [-121.43036, 36.2501], [-121.43024, 36.24999], [-121.43009, 36.24966], [-121.42987, 36.24943], [-121.42976, 36.24913], [-121.42938, 36.24866], [-121.4292, 36.24772], [-121.4289, 36.2473], [-121.42842, 36.24746], [-121.42826, 36.24807], [-121.42726, 36.24837], [-121.42733, 36.24866], [-121.42723, 36.2496], [-121.42781, 36.25056], [-121.42839, 36.25081], [-121.42901, 36.25095], [-121.42919, 36.25147], [-121.42912, 36.25203], [-121.42916, 36.25258], [-121.42972, 36.25465], [-121.43018, 36.25535], [-121.43035, 36.25544], [-121.43041, 36.25571], [-121.43101, 36.25623], [-121.43051, 36.25691], [-121.43031, 36.25709], [-121.43016, 36.25719], [-121.4299, 36.25731], [-121.4291, 36.25764], [-121.42885, 36.25769], [-121.42857, 36.25769], [-121.42807, 36.25758], [-121.42739, 36.2574], [-121.42721, 36.25738], [-121.42709, 36.25738], [-121.42693, 36.25741], [-121.42676, 36.25746], [-121.42605, 36.25783], [-121.42591, 36.25787], [-121.42576, 36.25789], [-121.4256, 36.25789], [-121.42542, 36.25785], [-121.42484, 36.25765], [-121.42432, 36.25743], [-121.42412, 36.25738], [-121.424, 36.25737], [-121.42381, 36.25738], [-121.42365, 36.25741], [-121.42349, 36.25748], [-121.42297, 36.25746], [-121.42297, 36.25739], [-121.42317, 36.25738], [-121.4232, 36.25461], [-121.42319, 36.25337], [-121.41927, 36.25232], [-121.41748, 36.2527], [-121.41683, 36.25293], [-121.41576, 36.2536], [-121.41568, 36.25382], [-121.40519, 36.25382], [-121.40522, 36.24328], [-121.40527, 36.23955], [-121.38756, 36.23965], [-121.38761, 36.23586], [-121.36965, 36.23592], [-121.36971, 36.23232], [-121.3742, 36.2323], [-121.37426, 36.22814], [-121.39659, 36.22837], [-121.39654, 36.23214], [-121.41428, 36.23219], [-121.41405, 36.24315], [-121.41406, 36.24671], [-121.42288, 36.24665], [-121.42746, 36.24668], [-121.42747, 36.24667], [-121.42745, 36.24307], [-121.42758, 36.23226], [-121.4365, 36.23234]]]} | No Public Access 3 | 20682 | Mueller | 22584 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 1712.687 | Mueller | 0 | Private Conservation 16 | 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]);