units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where COUNTY = 2 and DES_TP = 14
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-121.1454, 37.46398], [-121.14539, 37.46422], [-121.14474, 37.46421], [-121.14469, 37.46417], [-121.14469, 37.46347], [-121.1453, 37.46348], [-121.14529, 37.46374], [-121.14524, 37.46379], [-121.14522, 37.46387], [-121.14527, 37.46394], [-121.14534, 37.46398], [-121.1454, 37.46398]]]} | Open Access 1 | 48546 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.121 | 0 | Local Other or Unknown 14 | 4 | ||
12247 | 12247 | 12246 | {"type": "MultiPolygon", "coordinates": [[[[-120.45234, 37.66491], [-120.45126, 37.66492], [-120.4513, 37.66851], [-120.44674, 37.6685], [-120.44673, 37.66851], [-120.44674, 37.67122], [-120.45132, 37.67124], [-120.45137, 37.67588], [-120.44916, 37.67588], [-120.44916, 37.674], [-120.44573, 37.674], [-120.44575, 37.67587], [-120.44458, 37.67586], [-120.44457, 37.67654], [-120.44205, 37.67462], [-120.44382, 37.67412], [-120.44455, 37.67299], [-120.44461, 37.67256], [-120.44475, 37.67257], [-120.4449, 37.67256], [-120.44505, 37.67252], [-120.44514, 37.67246], [-120.44483, 37.67199], [-120.44468, 37.67196], [-120.44507, 37.6707], [-120.44499, 37.67024], [-120.44449, 37.66942], [-120.44291, 37.66834], [-120.44239, 37.66704], [-120.44248, 37.66673], [-120.44261, 37.66672], [-120.44265, 37.66654], [-120.4428, 37.6663], [-120.44314, 37.66621], [-120.4433, 37.66615], [-120.4436, 37.66606], [-120.4438, 37.66594], [-120.44446, 37.66575], [-120.4451, 37.6655], [-120.44525, 37.66542], [-120.4455, 37.66526], [-120.44561, 37.66517], [-120.44655, 37.66479], [-120.44745, 37.66461], [-120.44802, 37.66442], [-120.4486, 37.66415], [-120.4489, 37.66403], [-120.44896, 37.66403], [-120.44897, 37.66546], [-120.44841, 37.66516], [-120.446, 37.66557], [-120.4447, 37.6664], [-120.44362, 37.66685], [-120.4434, 37.66746], [-120.44475, 37.66857], [-120.44489, 37.6691], [-120.44555, 37.66955], [-120.44602, 37.67113], [-120.44528, 37.67163], [-120.44515, 37.67243], [-120.44517, 37.67244], [-120.4453, 37.67229], [-120.44557, 37.6718], [-120.4461, 37.67146], [-120.44637, 37.67123], [-120.44639, 37.67116], [-120.44594, 37.66953], [-120.44588, 37.66942], [-120.4452, 37.66891], [-120.44506, 37.66845], [-120.44381, 37.66745], [-120.44378, 37.66737], [-120.44391, 37.66706], [-120.44474, 37.66674], [-120.44475, 37.66672], [-120.44619, 37.66585], [-120.44834, 37.66548], [-120.44899, 37.66585], [-120.44902, 37.66671], [-120.44904, 37.66672], [-120.44902, 37.66585], [-120.44936, 37.66604], [-120.45033, 37.66568], [-120.45153, 37.66468], [-120.45209, 37.66468], [-120.45234, 37.66491]]], [[[-120.45863, 37.66709], [-120.45837, 37.66745], [-120.45807, 37.66728], [-120.45701, 37.66699], [-120.45657, 37.66648], [-120.45591, 37.66655], [-120.45586, 37.66493], [-120.45287, 37.66491], [-120.4523, 37.66438], [-120.45142, 37.66437], [-120.45017, 37.66539], [-120.44941, 37.66567], [-120.449, 37.66546], [-120.44899, 37.66389], [-120.45094, 37.66331], [-120.45214, 37.6633], [-120.45292, 37.66353], [-120.45469, 37.6645], [-120.45597, 37.66483], [-120.45707, 37.66528], [-120.45808, 37.66542], [-120.45807, 37.66685], [-120.45863, 37.66709]]], [[[-120.4581, 37.66852], [-120.45593, 37.66852], [-120.45592, 37.66685], [-120.45642, 37.6668], [-120.45679, 37.66726], [-120.45787, 37.66754], [-120.45809, 37.66767], [-120.4581, 37.66852]]], [[[-120.46353, 37.67073], [-120.46336, 37.67081], [-120.46178, 37.67083], [-120.46161, 37.67074], [-120.46152, 37.67035], [-120.46215, 37.67035], [-120.46214, 37.67076], [-120.46273, 37.67071], [-120.46274, 37.67073], [-120.46353, 37.67073]]], [[[-120.46732, 37.67226], [-120.46714, 37.6722], [-120.46709, 37.67244], [-120.4668, 37.67265], [-120.46662, 37.67282], [-120.46272, 37.67278], [-120.46272, 37.67151], [-120.46155, 37.67149], [-120.46156, 37.67114], [-120.46174, 37.67122], [-120.46355, 37.67119], [-120.46422, 37.67085], [-120.4647, 37.67087], [-120.46593, 37.67124], [-120.46653, 37.67153], [-120.46679, 37.67169], [-120.46732, 37.67226]]], [[[-120.47223, 37.67317], [-120.4708, 37.6731], [-120.47028, 37.6729], [-120.47027, 37.67258], [-120.47085, 37.67281], [-120.47222, 37.6729], [-120.47223, 37.67317]]], [[[-120.47225, 37.67253], [-120.47103, 37.67244], [-120.4703, 37.67214], [-120.47223, 37.67225], [-120.47225, 37.67253]]], [[[-120.48912, 37.6657], [-120.4889, 37.66599], [-120.48853, 37.66657], [-120.48791, 37.6663], [-120.48855, 37.6654], [-120.48912, 37.6657]]], [[[-120.48983, 37.66609], [-120.48929, 37.66695], [-120.48896, 37.66679], [-120.48931, 37.66621], [-120.48953, 37.66592], [-120.48983, 37.66609]]]]} | Open Access 1 | 25750 | Modesto Irrigation District | 22339 | 2081 | Modesto Irrigation District 1015 | Special District 4 | Irrigation District 17 | http://www.mid.org/ | Special District 4 | 2081 | Modesto Irrigation District 977 | Special District 4 | Irrigation District 16 | Stanislaus 2 | 199.046 | Modesto Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
12249 | 12249 | 12248 | {"type": "MultiPolygon", "coordinates": [[[[-120.4581, 37.66306], [-120.45807, 37.66498], [-120.45808, 37.66542], [-120.45707, 37.66528], [-120.45597, 37.66483], [-120.45469, 37.6645], [-120.45292, 37.66353], [-120.45213, 37.6633], [-120.45095, 37.66331], [-120.44582, 37.66483], [-120.44264, 37.66619], [-120.44239, 37.66704], [-120.4429, 37.66834], [-120.44449, 37.66942], [-120.44499, 37.67024], [-120.44507, 37.6707], [-120.44468, 37.67196], [-120.44451, 37.67195], [-120.44413, 37.67231], [-120.4442, 37.67238], [-120.44432, 37.67247], [-120.44448, 37.67253], [-120.4446, 37.67256], [-120.44456, 37.67299], [-120.44383, 37.67412], [-120.44205, 37.67462], [-120.44139, 37.67412], [-120.44162, 37.67396], [-120.44164, 37.67392], [-120.44164, 37.67374], [-120.44175, 37.67357], [-120.44237, 37.67322], [-120.44307, 37.67272], [-120.44313, 37.67155], [-120.44304, 37.67151], [-120.44276, 37.67145], [-120.44258, 37.67117], [-120.44266, 37.67084], [-120.44264, 37.67077], [-120.44247, 37.67048], [-120.44211, 37.6702], [-120.44208, 37.67012], [-120.44206, 37.66974], [-120.44176, 37.66924], [-120.44155, 37.66915], [-120.44135, 37.66925], [-120.44115, 37.66917], [-120.44061, 37.66888], [-120.44022, 37.66903], [-120.43995, 37.66926], [-120.43956, 37.66936], [-120.43934, 37.66911], [-120.43942, 37.66889], [-120.43942, 37.66882], [-120.43957, 37.66846], [-120.4396, 37.66791], [-120.43965, 37.66758], [-120.43945, 37.66728], [-120.4389, 37.66694], [-120.43818, 37.667], [-120.43768, 37.66672], [-120.44064, 37.66672], [-120.44097, 37.66699], [-120.44097, 37.66722], [-120.44079, 37.66791], [-120.4408, 37.66808], [-120.44211, 37.66906], [-120.44333, 37.67067], [-120.44409, 37.67222], [-120.4441, 37.67221], [-120.44365, 37.67056], [-120.44239, 37.66888], [-120.44115, 37.66795], [-120.4413, 37.667], [-120.4411, 37.66672], [-120.44116, 37.6667], [-120.44105, 37.66585], [-120.44105, 37.66569], [-120.44115, 37.66504], [-120.44114, 37.66479], [-120.44096, 37.66429], [-120.44096, 37.66418], [-120.44127, 37.66392], [-120.4415, 37.66402], [-120.44191, 37.66403], [-120.44322, 37.66379], [-120.44355, 37.66352], [-120.44365, 37.6635], [-120.44613, 37.66348], [-120.44737, 37.66286], [-120.44899, 37.66304], [-120.45008, 37.66282], [-120.45062, 37.66228], [-120.45064, 37.66133], [-120.45102, 37.66105], [-120.45126, 37.66104], [-120.45125, 37.66305], [-120.4581, 37.66306]]], [[[-120.44902, 37.65939], [-120.44899, 37.66234], [-120.4484, 37.66246], [-120.44757, 37.66236], [-120.44763, 37.65939], [-120.44902, 37.65939]]], [[[-120.46249, 37.65702], [-120.46152, 37.6619], [-120.4597, 37.66152], [-120.45905, 37.66151], [-120.45764, 37.66153], [-120.45682, 37.66144], [-120.45634, 37.66131], [-120.45689, 37.66107], [-120.45787, 37.66141], [-120.4592, 37.66132], [-120.45958, 37.66118], [-120.45969, 37.66071], [-120.46021, 37.66014], [-120.46075, 37.65941], [-120.46119, 37.65892], [-120.46133, 37.65826], [-120.46115, 37.65782], [-120.46028, 37.65721], [-120.45968, 37.65721], [-120.45897, 37.65657], [-120.45841, 37.65564], [-120.45827, 37.65464], [-120.45845, 37.65412], [-120.45853, 37.65405], [-120.45959, 37.65373], [-120.45956, 37.65386], [-120.4595, 37.6545], [-120.46249, 37.65702]]]]} | Open Access 1 | 25751 | Turlock Irrigation District | 26581 | 2273 | Turlock Irrigation District 1016 | Special District 4 | Irrigation District 17 | http://www.tid.org/ | Special District 4 | 2273 | Turlock Irrigation District 978 | Special District 4 | Irrigation District 16 | Stanislaus 2 | 152.049 | Turlock Irrigation District | 0 | Local Other or Unknown 14 | 4 | |
13763 | 13763 | 13762 | {"type": "Polygon", "coordinates": [[[-120.97866, 37.6451], [-120.97872, 37.64511], [-120.97873, 37.64514], [-120.97872, 37.64516], [-120.97864, 37.64523], [-120.97846, 37.64535], [-120.97815, 37.64548], [-120.97793, 37.64552], [-120.97788, 37.6455], [-120.97788, 37.64545], [-120.97793, 37.64541], [-120.97866, 37.6451]]]} | Open Access 1 | 36284 | Modesto holding 2 | 22338 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.29 | Modesto holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13764 | 13764 | 13763 | {"type": "Polygon", "coordinates": [[[-120.9913, 37.64285], [-120.99095, 37.64312], [-120.99036, 37.64263], [-120.99071, 37.64236], [-120.9913, 37.64285]]]} | Open Access 1 | 36285 | Modesto holding 1 | 22337 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.794 | Modesto holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13776 | 13776 | 13775 | {"type": "Polygon", "coordinates": [[[-121.15526, 37.46194], [-121.15507, 37.46228], [-121.15456, 37.46207], [-121.15465, 37.46189], [-121.15464, 37.46185], [-121.15461, 37.46182], [-121.15454, 37.46182], [-121.15434, 37.46192], [-121.15427, 37.46191], [-121.15422, 37.46189], [-121.15457, 37.46164], [-121.1549, 37.4618], [-121.15526, 37.46194]]]} | Open Access 1 | 36322 | Patterson holding 1 | 23519 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.674 | Patterson holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13780 | 13780 | 13779 | {"type": "Polygon", "coordinates": [[[-121.02895, 37.31704], [-121.02791, 37.31731], [-121.02765, 37.31665], [-121.02793, 37.31658], [-121.02778, 37.31619], [-121.02855, 37.316], [-121.02895, 37.31704]]]} | Open Access 1 | 36327 | Newman holding 1 | 22729 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 2.641 | Newman holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13783 | 13783 | 13782 | {"type": "Polygon", "coordinates": [[[-120.86505, 37.75339], [-120.86502, 37.75345], [-120.86242, 37.75402], [-120.86235, 37.75399], [-120.8622, 37.75369], [-120.86223, 37.75363], [-120.86306, 37.75346], [-120.86339, 37.75335], [-120.86362, 37.75324], [-120.86446, 37.7527], [-120.86456, 37.75272], [-120.86505, 37.75339]]]} | Open Access 1 | 36339 | Oakdale holding 1 | 23024 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.574 | Oakdale holding 1 | 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]);