units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, AGNCY_TYP = 10 and COUNTY = 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14880 | 14880 | 14879 | {"type": "Polygon", "coordinates": [[[-121.65082, 36.93893], [-121.65074, 36.93899], [-121.65013, 36.93931], [-121.64972, 36.93948], [-121.64959, 36.93956], [-121.64915, 36.94008], [-121.64901, 36.9403], [-121.64895, 36.94043], [-121.64908, 36.94046], [-121.64913, 36.94067], [-121.64911, 36.94075], [-121.64895, 36.94122], [-121.64869, 36.94149], [-121.64819, 36.94181], [-121.6478, 36.94195], [-121.64696, 36.94253], [-121.64675, 36.94246], [-121.64666, 36.94258], [-121.64615, 36.94303], [-121.64598, 36.94328], [-121.64615, 36.9443], [-121.64636, 36.94445], [-121.6463, 36.94468], [-121.64597, 36.94506], [-121.64561, 36.94531], [-121.64542, 36.94528], [-121.64511, 36.94532], [-121.64484, 36.9454], [-121.64429, 36.94577], [-121.64369, 36.94589], [-121.64274, 36.94653], [-121.64255, 36.94661], [-121.64201, 36.94667], [-121.64156, 36.94676], [-121.64127, 36.94675], [-121.64121, 36.94687], [-121.64119, 36.94695], [-121.64052, 36.947], [-121.63823, 36.94697], [-121.63793, 36.94702], [-121.63764, 36.94711], [-121.63622, 36.94719], [-121.63535, 36.94721], [-121.63495, 36.94726], [-121.63339, 36.94802], [-121.63372, 36.94846], [-121.63381, 36.94863], [-121.63362, 36.94871], [-121.63354, 36.94862], [-121.63361, 36.94848], [-121.63315, 36.94785], [-121.63308, 36.94786], [-121.63303, 36.94833], [-121.63297, 36.94783], [-121.63358, 36.94777], [-121.63365, 36.94733], [-121.63384, 36.94717], [-121.63383, 36.94679], [-121.63409, 36.94661], [-121.63419, 36.94632], [-121.63414, 36.94575], [-121.63338, 36.94548], [-121.63291, 36.94549], [-121.63265, 36.94534], [-121.63249, 36.94475], [-121.63236, 36.94473], [-121.63225, 36.9443], [-121.63216, 36.94421], [-121.63139, 36.94396], [-121.63072, 36.94383], [-121.63052, 36.94371], [-121.63033, 36.94371], [-121.63028, 36.9436], [-121.63017, 36.94343], [-121.62995, 36.94329], [-121.62947, 36.94307], [-121.62915, 36.94265], [-121.62766, 36.94204], [-121.62739, 36.94197], [-121.62692, 36.94129], [-121.62692, 36.94111], [-121.62672, 36.94098], [-121.62616, 36.94082], [-121.6259, 36.94069], [-121.62525, 36.94025], [-121.62459, 36.9401], [-121.62441, 36.93996], [-121.62424, 36.93987], [-121.62377, 36.93952], [-121.6235, 36.93873], [-121.62319, 36.93731], [-121.62337, 36.93654], [-121.62324, 36.9362], [-121.62345, 36.93606], [-121.62359, 36.93642], [-121.62374, 36.93765], [-121.62392, 36.93804], [-121.62552, 36.93901], [-121.62633, 36.93924], [-121.62716, 36.93918], [-121.628, 36.93918], [-121.62857, 36.93896], [-121.62877, 36.93864], [-121.62918, 36.93774], [-121.62937, 36.93763], [-121.62976, 36.93699], [-121.63005, 36.93676], [-121.63091, 36.93616], [-121.63176, 36.93582], [-121.63257, 36.93555], [-121.63302, 36.93529], [-121.63326, 36.93508], [-121.63367, 36.93477], [-121.63406, 36.93468], [-121.63471, 36.93467], [-121.63535, 36.93435], [-121.63561, 36.93389], [-121.63609, 36.93318], [-121.63517, 36.93023], [-121.63936, 36.93044], [-121.65082, 36.93893]]]} | Restricted Access 2 | 45401 | Star Creek Ranch | 25798 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Clara 19 | 599.708 | Star Creek Ranch | 0 | Private Conservation 16 | 2 | |
15522 | 15522 | 15521 | {"type": "MultiPolygon", "coordinates": [[[[-121.76287, 37.21275], [-121.76286, 37.21293], [-121.76232, 37.21425], [-121.76156, 37.21457], [-121.75906, 37.21586], [-121.75756, 37.21692], [-121.75681, 37.21661], [-121.75677, 37.2165], [-121.75526, 37.21583], [-121.75502, 37.2157], [-121.75509, 37.21561], [-121.75502, 37.21557], [-121.75493, 37.21565], [-121.75319, 37.21469], [-121.75016, 37.21265], [-121.74665, 37.2101], [-121.74643, 37.20993], [-121.7455, 37.20914], [-121.74074, 37.20483], [-121.74055, 37.20464], [-121.74057, 37.20462], [-121.73814, 37.20241], [-121.73713, 37.20145], [-121.73718, 37.20083], [-121.73835, 37.20002], [-121.73913, 37.20073], [-121.73972, 37.20031], [-121.73945, 37.1997], [-121.73921, 37.19949], [-121.73914, 37.19948], [-121.74116, 37.19815], [-121.74122, 37.1982], [-121.74157, 37.19796], [-121.74319, 37.20032], [-121.74378, 37.20104], [-121.74407, 37.20122], [-121.74544, 37.20166], [-121.74641, 37.20203], [-121.74615, 37.20311], [-121.74637, 37.20329], [-121.7467, 37.20335], [-121.74933, 37.20352], [-121.74953, 37.20417], [-121.74961, 37.20654], [-121.75096, 37.20684], [-121.75129, 37.20723], [-121.75125, 37.20755], [-121.75157, 37.20836], [-121.75306, 37.20872], [-121.75332, 37.20916], [-121.75357, 37.20931], [-121.7554, 37.20946], [-121.75584, 37.20998], [-121.75725, 37.21072], [-121.75917, 37.21126], [-121.76136, 37.21145], [-121.76287, 37.21275]]], [[[-121.74608, 37.21559], [-121.74531, 37.21653], [-121.7452, 37.21672], [-121.74475, 37.21634], [-121.74574, 37.2153], [-121.74608, 37.21559]]], [[[-121.75111, 37.21385], [-121.75028, 37.21433], [-121.74959, 37.21442], [-121.74862, 37.21468], [-121.74773, 37.21479], [-121.74709, 37.21504], [-121.74681, 37.21488], [-121.74704, 37.21434], [-121.74675, 37.21408], [-121.74686, 37.21397], [-121.74691, 37.21362], [-121.74654, 37.21065], [-121.74935, 37.21263], [-121.75111, 37.21385]]]]} | Restricted Access 2 | 49042 | Northern Coyote Valley Conservation Area | 33748 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 374.267 | Northern Coyote Valley Conservation Area | 0 | 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]);