units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where MNG_AGENCY = 798 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9240 | 9240 | 9239 | {"type": "MultiPolygon", "coordinates": [[[[-121.54901, 36.93552], [-121.549, 36.93611], [-121.54882, 36.93705], [-121.5486, 36.93685], [-121.54862, 36.93671], [-121.54872, 36.9366], [-121.54873, 36.93648], [-121.54867, 36.93646], [-121.5487, 36.93629], [-121.54861, 36.93569], [-121.54765, 36.93513], [-121.54763, 36.935], [-121.54515, 36.93499], [-121.54345, 36.93831], [-121.54138, 36.93918], [-121.54121, 36.93996], [-121.541, 36.94031], [-121.54047, 36.94128], [-121.53849, 36.94129], [-121.53673, 36.94358], [-121.53605, 36.94437], [-121.53605, 36.9465], [-121.53608, 36.94709], [-121.53607, 36.94755], [-121.53593, 36.94879], [-121.53593, 36.94916], [-121.53288, 36.94791], [-121.53326, 36.94725], [-121.53339, 36.9469], [-121.53349, 36.94609], [-121.53361, 36.94562], [-121.53373, 36.94514], [-121.53399, 36.94451], [-121.53398, 36.94417], [-121.53409, 36.94385], [-121.5344, 36.94343], [-121.5352, 36.94296], [-121.53533, 36.94274], [-121.53554, 36.94223], [-121.53583, 36.94169], [-121.53613, 36.94152], [-121.5366, 36.94107], [-121.53708, 36.94057], [-121.53739, 36.94022], [-121.53765, 36.94005], [-121.53796, 36.93996], [-121.53848, 36.93963], [-121.53873, 36.93952], [-121.53905, 36.93942], [-121.53931, 36.93929], [-121.53947, 36.93915], [-121.53996, 36.93831], [-121.54011, 36.93814], [-121.5404, 36.93796], [-121.54127, 36.93765], [-121.54166, 36.93754], [-121.54203, 36.93714], [-121.54223, 36.93682], [-121.54249, 36.93648], [-121.54252, 36.93618], [-121.5425, 36.93566], [-121.54256, 36.93528], [-121.54275, 36.93504], [-121.54359, 36.93439], [-121.54367, 36.93419], [-121.54371, 36.93387], [-121.54367, 36.93359], [-121.54351, 36.93318], [-121.54321, 36.93265], [-121.54301, 36.93193], [-121.54284, 36.93149], [-121.54251, 36.93097], [-121.5423, 36.93054], [-121.54211, 36.92995], [-121.54197, 36.92966], [-121.54181, 36.92901], [-121.54178, 36.92873], [-121.54167, 36.92818], [-121.54113, 36.92744], [-121.54088, 36.92687], [-121.54069, 36.92647], [-121.54061, 36.9261], [-121.5407, 36.92576], [-121.54068, 36.92576], [-121.5404, 36.92599], [-121.53995, 36.92599], [-121.53994, 36.92598], [-121.5401, 36.92588], [-121.54048, 36.92572], [-121.54081, 36.92545], [-121.54092, 36.92515], [-121.54089, 36.92486], [-121.54082, 36.92472], [-121.54051, 36.92429], [-121.54031, 36.92409], [-121.54008, 36.9239], [-121.53984, 36.92368], [-121.53949, 36.92343], [-121.53923, 36.92302], [-121.53919, 36.92291], [-121.54048, 36.92421], [-121.54068, 36.92418], [-121.54125, 36.92449], [-121.54134, 36.92457], [-121.54213, 36.92541], [-121.54282, 36.92621], [-121.54293, 36.92628], [-121.54308, 36.92635], [-121.54349, 36.92644], [-121.54377, 36.92647], [-121.54438, 36.9265], [-121.54449, 36.92652], [-121.54466, 36.9266], [-121.54508, 36.9269], [-121.54522, 36.92703], [-121.54535, 36.92722], [-121.54559, 36.92765], [-121.54568, 36.92777], [-121.5465, 36.92859], [-121.54681, 36.92879], [-121.54713, 36.92881], [-121.54738, 36.92913], [-121.54803, 36.92996], [-121.54809, 36.93056], [-121.54454, 36.93123], [-121.54454, 36.93125], [-121.54508, 36.9325], [-121.54551, 36.93284], [-121.54631, 36.93284], [-121.54665, 36.93301], [-121.5474, 36.93298], [-121.54763, 36.9334], [-121.54758, 36.93377], [-121.5477, 36.93414], [-121.54788, 36.93444], [-121.54796, 36.93491], [-121.54901, 36.93552]]], [[[-121.55239, 36.94284], [-121.55219, 36.94286], [-121.55189, 36.94222], [-121.55171, 36.94155], [-121.55116, 36.94063], [-121.55112, 36.93858], [-121.54879, 36.93856], [-121.54916, 36.93661], [-121.55147, 36.93685], [-121.5515, 36.93708], [-121.5516, 36.9394], [-121.55153, 36.94059], [-121.55207, 36.94146], [-121.55238, 36.94236], [-121.55239, 36.94284]]]]} | No Public Access 3 | 15376 | Carnadero Preserve | 16881 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 196.338 | Carnadero Preserve | 0 | Local Conservation Area 4 | 2 | |
9840 | 9840 | 9839 | {"type": "MultiPolygon", "coordinates": [[[[-121.89924, 37.3355], [-121.89884, 37.33569], [-121.89868, 37.33547], [-121.89885, 37.33538], [-121.89861, 37.33506], [-121.89884, 37.33495], [-121.89924, 37.3355]]], [[[-121.90042, 37.33596], [-121.8999, 37.33606], [-121.89902, 37.33487], [-121.89968, 37.33457], [-121.89985, 37.33495], [-121.89995, 37.33526], [-121.90009, 37.33556], [-121.90042, 37.33596]]], [[[-121.89948, 37.33581], [-121.89908, 37.336], [-121.89906, 37.33598], [-121.89912, 37.33575], [-121.8991, 37.33573], [-121.89933, 37.33562], [-121.89948, 37.33581]]]]} | Open Access 1 | 16820 | Guadalupe River Park | 11940 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | http://www.sanjoseca.gov/index.aspx?nid=2833 | Santa Clara 19 | 2.779 | Guadalupe River Park | 0 | Local Park 2 | 4 |
12352 | 12352 | 12351 | {"type": "MultiPolygon", "coordinates": [[[[-121.89775, 37.33349], [-121.8975, 37.33361], [-121.8974, 37.33308], [-121.89744, 37.33307], [-121.89775, 37.33349]]], [[[-121.89812, 37.33398], [-121.89762, 37.33422], [-121.89752, 37.33373], [-121.89783, 37.33359], [-121.89812, 37.33398]]], [[[-121.90026, 37.3341], [-121.89891, 37.33473], [-121.89762, 37.33298], [-121.89903, 37.33231], [-121.89928, 37.33223], [-121.90012, 37.33219], [-121.90026, 37.3341]]], [[[-121.89873, 37.33481], [-121.89853, 37.33491], [-121.89838, 37.33472], [-121.89818, 37.33481], [-121.89813, 37.33476], [-121.89775, 37.33492], [-121.89764, 37.33433], [-121.89819, 37.33408], [-121.89873, 37.33481]]]]} | Restricted Access 2 | 26060 | Arena Green | 15579 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 12.575 | Arena Green | 0 | Local Park 2 | 4 | |
14450 | 14450 | 14449 | {"type": "Polygon", "coordinates": [[[-121.75129, 37.41746], [-121.71353, 37.41782], [-121.71343, 37.41754], [-121.7134, 37.41721], [-121.71337, 37.4171], [-121.71325, 37.41691], [-121.71295, 37.41659], [-121.7129, 37.41649], [-121.71289, 37.41632], [-121.71292, 37.41622], [-121.71301, 37.4161], [-121.71306, 37.41609], [-121.71333, 37.41609], [-121.71358, 37.41603], [-121.7138, 37.41592], [-121.71397, 37.41577], [-121.71405, 37.41564], [-121.71411, 37.41544], [-121.71411, 37.41515], [-121.71409, 37.41499], [-121.71403, 37.41484], [-121.71388, 37.41464], [-121.71375, 37.41453], [-121.71338, 37.41431], [-121.71319, 37.41417], [-121.71303, 37.41401], [-121.71283, 37.41375], [-121.7127, 37.41345], [-121.71265, 37.41314], [-121.71266, 37.41294], [-121.71258, 37.41271], [-121.7124, 37.41239], [-121.71219, 37.4121], [-121.71206, 37.41178], [-121.71195, 37.41155], [-121.7118, 37.41134], [-121.71154, 37.41105], [-121.71145, 37.4109], [-121.7114, 37.41075], [-121.71136, 37.41041], [-121.7113, 37.41022], [-121.7112, 37.41004], [-121.711, 37.40979], [-121.70956, 37.40776], [-121.70916, 37.40728], [-121.7087, 37.40684], [-121.70819, 37.40644], [-121.70782, 37.40619], [-121.70714, 37.40581], [-121.70696, 37.40569], [-121.7065, 37.40523], [-121.70617, 37.40494], [-121.70581, 37.40466], [-121.70537, 37.40435], [-121.70523, 37.40419], [-121.70517, 37.40407], [-121.70514, 37.40387], [-121.70517, 37.40374], [-121.70526, 37.40355], [-121.70542, 37.4034], [-121.70599, 37.40306], [-121.70635, 37.40288], [-121.70672, 37.40273], [-121.73202, 37.40241], [-121.73192, 37.40006], [-121.734, 37.40076], [-121.73402, 37.3996], [-121.74087, 37.39735], [-121.74514, 37.40143], [-121.74665, 37.40506], [-121.75046, 37.40635], [-121.75129, 37.41746]]]} | Restricted Access 2 | 47062 | Rancho Canada de Pala | 30715 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 1557.569 | Rancho Canada de Pala | 0 | None 1229 | ||
14932 | 14932 | 14931 | {"type": "Polygon", "coordinates": [[[-121.75938, 37.40226], [-121.75072, 37.40644], [-121.74665, 37.40506], [-121.74514, 37.40143], [-121.74087, 37.39735], [-121.74693, 37.39537], [-121.75232, 37.39823], [-121.75202, 37.39839], [-121.75117, 37.39869], [-121.75076, 37.39886], [-121.75052, 37.39905], [-121.74922, 37.39947], [-121.74866, 37.39979], [-121.74921, 37.40099], [-121.7496, 37.4008], [-121.75015, 37.40085], [-121.75079, 37.40043], [-121.75107, 37.40035], [-121.75232, 37.40037], [-121.75349, 37.40049], [-121.75403, 37.40063], [-121.75477, 37.40095], [-121.75528, 37.40133], [-121.75628, 37.40129], [-121.75699, 37.40077], [-121.75938, 37.40226]]]} | Open Access 1 | 45518 | Upper Penitencia Creek Property | 28353 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 216.953 | Upper Penitencia Creek Property | 0 | Local Other or Unknown 14 | 4 |
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]);