units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
85 rows where MNG_AGENCY = 510 and MNG_AG_TYP = 2 sorted by GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2832 | 2832 | 2831 | {"type": "Polygon", "coordinates": [[[-120.93016, 37.6523], [-120.92947, 37.65269], [-120.92127, 37.65274], [-120.92127, 37.65251], [-120.92223, 37.65239], [-120.92764, 37.65119], [-120.92985, 37.65081], [-120.93014, 37.65079], [-120.93016, 37.6523]]]} | Open Access 1 | 18718 | McClure Country Place | 22002 | 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 | 22.887 | McClure Country Place | None 235 | |||
10485 | 10485 | 10484 | {"type": "MultiPolygon", "coordinates": [[[[-120.9619, 37.65205], [-120.96156, 37.65207], [-120.96121, 37.65206], [-120.96053, 37.65221], [-120.96019, 37.65225], [-120.95986, 37.65225], [-120.95985, 37.65228], [-120.95951, 37.65229], [-120.9595, 37.65225], [-120.95918, 37.65217], [-120.95917, 37.65219], [-120.95883, 37.65222], [-120.95882, 37.65217], [-120.95849, 37.65221], [-120.95849, 37.65227], [-120.9577, 37.6525], [-120.95768, 37.65098], [-120.95949, 37.65086], [-120.96187, 37.64995], [-120.9619, 37.65205]]], [[[-120.95701, 37.65256], [-120.95682, 37.6526], [-120.95627, 37.65278], [-120.95603, 37.65279], [-120.9558, 37.65279], [-120.95544, 37.65261], [-120.95515, 37.65256], [-120.95504, 37.65251], [-120.95473, 37.65244], [-120.95417, 37.65217], [-120.95382, 37.65205], [-120.9535, 37.65189], [-120.95349, 37.6519], [-120.95349, 37.65194], [-120.9528, 37.6514], [-120.95268, 37.65143], [-120.95243, 37.65144], [-120.9522, 37.65133], [-120.95198, 37.65124], [-120.95188, 37.65117], [-120.95164, 37.65108], [-120.95164, 37.651], [-120.95152, 37.65096], [-120.9511, 37.65073], [-120.95075, 37.65047], [-120.95033, 37.65004], [-120.95005, 37.64959], [-120.94996, 37.64947], [-120.94982, 37.64935], [-120.94908, 37.64902], [-120.9483, 37.64864], [-120.94829, 37.64798], [-120.94835, 37.64801], [-120.94836, 37.64799], [-120.94918, 37.64837], [-120.95029, 37.64902], [-120.95085, 37.64902], [-120.95392, 37.65049], [-120.95528, 37.65085], [-120.95699, 37.65101], [-120.95701, 37.65256]]]]} | Open Access 1 | 18576 | Dry Creek Park (Site) | 18282 | 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 | 45.996 | Dry Creek Park (Site) | 0 | None 917 | ||
2362 | 2362 | 2361 | {"type": "Polygon", "coordinates": [[[-121.04345, 37.67763], [-121.04306, 37.67767], [-121.04258, 37.67768], [-121.04263, 37.67694], [-121.04306, 37.67726], [-121.04345, 37.67763]]]} | Open Access 1 | 18529 | City Gate Children's Park | 17292 | 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.829 | City Gate Children's Park | 0 | Local Park 2 | 4 | |
2369 | 2369 | 2368 | {"type": "Polygon", "coordinates": [[[-120.98306, 37.69832], [-120.98171, 37.6983], [-120.98157, 37.6983], [-120.98139, 37.69834], [-120.98133, 37.69827], [-120.98124, 37.6981], [-120.9812, 37.69795], [-120.98115, 37.69617], [-120.98299, 37.69619], [-120.98306, 37.69832]]]} | Open Access 1 | 18542 | Coffee Claratina Park | 17474 | 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 | 9.482 | Coffee Claratina Park | 0 | Local Park 2 | 4 | |
2371 | 2371 | 2370 | {"type": "Polygon", "coordinates": [[[-120.97023, 37.67442], [-120.96913, 37.67442], [-120.9691, 37.67259], [-120.96911, 37.67256], [-120.96916, 37.67255], [-120.96973, 37.67261], [-120.9702, 37.67263], [-120.97023, 37.67442]]]} | Open Access 1 | 18548 | Coleman F. Brown Park | 17490 | 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 | 4.879 | Coleman F. Brown Park | 0 | Local Park 2 | 4 | |
2379 | 2379 | 2378 | {"type": "Polygon", "coordinates": [[[-120.97212, 37.64848], [-120.97097, 37.64875], [-120.9708, 37.64866], [-120.97066, 37.64869], [-120.97053, 37.64864], [-120.97034, 37.64867], [-120.97005, 37.64877], [-120.96984, 37.64876], [-120.96972, 37.64879], [-120.96959, 37.6488], [-120.96944, 37.64882], [-120.96928, 37.6488], [-120.96903, 37.64882], [-120.96867, 37.64882], [-120.96764, 37.64952], [-120.96632, 37.64978], [-120.96631, 37.64974], [-120.96613, 37.64978], [-120.9658, 37.64993], [-120.9654, 37.65002], [-120.96501, 37.65018], [-120.96415, 37.65072], [-120.9635, 37.65102], [-120.96318, 37.65131], [-120.96279, 37.65182], [-120.96256, 37.65195], [-120.96222, 37.65202], [-120.9619, 37.65204], [-120.96187, 37.64949], [-120.96204, 37.64948], [-120.96225, 37.64943], [-120.96226, 37.6502], [-120.96227, 37.65021], [-120.96293, 37.65001], [-120.96333, 37.64984], [-120.96415, 37.64926], [-120.96532, 37.64901], [-120.96597, 37.6488], [-120.96631, 37.6488], [-120.96765, 37.64816], [-120.96868, 37.64787], [-120.97096, 37.6479], [-120.97211, 37.64753], [-120.97212, 37.64848]]]} | Open Access 1 | 18589 | East La Loma Park | 18372 | 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 | 29.203 | East La Loma Park | 0 | Local Park 2 | 4 | |
2386 | 2386 | 2385 | {"type": "Polygon", "coordinates": [[[-121.00253, 37.62066], [-121.00252, 37.62417], [-121.00205, 37.62417], [-121.00205, 37.62353], [-121.00149, 37.62352], [-121.0015, 37.62067], [-121.00253, 37.62066]]]} | Open Access 1 | 18606 | Fairway Park | 18824 | 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 | 7.896 | Fairway Park | 0 | Local Park 2 | 4 | |
2387 | 2387 | 2386 | {"type": "Polygon", "coordinates": [[[-120.93047, 37.67448], [-120.92816, 37.6745], [-120.92813, 37.67234], [-120.93044, 37.67232], [-120.93047, 37.67448]]]} | Open Access 1 | 18611 | Freedom Park | 19086 | 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 | 12.078 | Freedom Park | 0 | Local Park 2 | 4 | |
2403 | 2403 | 2402 | {"type": "Polygon", "coordinates": [[[-120.98447, 37.64363], [-120.98433, 37.64418], [-120.98416, 37.64434], [-120.98364, 37.6446], [-120.98285, 37.64502], [-120.98211, 37.64528], [-120.98161, 37.64548], [-120.98116, 37.64563], [-120.98005, 37.6461], [-120.98004, 37.64555], [-120.98018, 37.64547], [-120.98046, 37.64543], [-120.98057, 37.64537], [-120.98082, 37.64513], [-120.98107, 37.64505], [-120.98155, 37.64499], [-120.98169, 37.64493], [-120.98158, 37.64453], [-120.98168, 37.64427], [-120.98203, 37.6441], [-120.98253, 37.64376], [-120.98276, 37.64367], [-120.98302, 37.64362], [-120.98447, 37.64363]]]} | Open Access 1 | 18662 | Kewin Park | 20639 | 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 | 9.604 | Kewin Park | 0 | Local Park 2 | 4 | |
2411 | 2411 | 2410 | {"type": "Polygon", "coordinates": [[[-120.95264, 37.64545], [-120.9483, 37.64545], [-120.94823, 37.64529], [-120.95262, 37.64529], [-120.95264, 37.64545]]]} | Open Access 1 | 18678 | Lateral No. 2 Park | 21076 | 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 | 1.694 | Lateral No. 2 Park | 0 | Local Park 2 | 4 | |
2421 | 2421 | 2420 | {"type": "Polygon", "coordinates": [[[-121.03756, 37.69876], [-121.03628, 37.69877], [-121.03622, 37.69689], [-121.03751, 37.69688], [-121.03756, 37.69876]]]} | Open Access 1 | 18722 | Mckinney Colony Park | 22051 | 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 | 5.838 | Mckinney Colony Park | 0 | Local Park 2 | 4 | |
2434 | 2434 | 2433 | {"type": "Polygon", "coordinates": [[[-120.97202, 37.64556], [-120.97094, 37.64555], [-120.97093, 37.64535], [-120.97201, 37.64535], [-120.97202, 37.64556]]]} | Open Access 1 | 18784 | Pierre Park | 23665 | 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.537 | Pierre Park | 0 | Local Park 2 | 4 | |
2457 | 2457 | 2456 | {"type": "Polygon", "coordinates": [[[-120.98467, 37.65083], [-120.98241, 37.65082], [-120.98242, 37.65055], [-120.98239, 37.65], [-120.98465, 37.65], [-120.98467, 37.65083]]]} | Open Access 1 | 18857 | Thomas B. Scott Park | 26306 | 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 | 4.478 | Thomas B. Scott Park | 0 | Local Park 2 | 4 | |
2762 | 2762 | 2761 | {"type": "Polygon", "coordinates": [[[-121.0241, 37.69426], [-121.02375, 37.69426], [-121.02374, 37.69383], [-121.02259, 37.69381], [-121.02257, 37.69257], [-121.02258, 37.69254], [-121.02262, 37.69253], [-121.02407, 37.69255], [-121.0241, 37.69426]]]} | Open Access 1 | 18461 | Aqueduct Park | 15550 | 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 | 5.048 | Aqueduct Park | 0 | Local Park 2 | 4 | |
2765 | 2765 | 2764 | {"type": "Polygon", "coordinates": [[[-120.9697, 37.69312], [-120.96964, 37.68905], [-120.97159, 37.68904], [-120.97162, 37.68908], [-120.97164, 37.68943], [-120.97171, 37.68961], [-120.97183, 37.68977], [-120.97208, 37.68996], [-120.9721, 37.68999], [-120.97178, 37.69031], [-120.9717, 37.69044], [-120.97165, 37.69064], [-120.97167, 37.69308], [-120.97163, 37.69311], [-120.9697, 37.69312]]]} | Open Access 1 | 18471 | Beyer Park | 16059 | 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 | 19.974 | Beyer Park | 0 | Local Park 2 | 4 | |
2773 | 2773 | 2772 | {"type": "Polygon", "coordinates": [[[-121.04521, 37.68382], [-121.04325, 37.6844], [-121.04323, 37.68302], [-121.0452, 37.68299], [-121.04521, 37.68382]]]} | Open Access 1 | 18509 | Chrysler 99 Park | 17235 | 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 | 5.253 | Chrysler 99 Park | 0 | Local Park 2 | 4 | |
2794 | 2794 | 2793 | {"type": "MultiPolygon", "coordinates": [[[[-120.97132, 37.66022], [-120.97118, 37.66023], [-120.97109, 37.66025], [-120.97108, 37.65921], [-120.97126, 37.65948], [-120.97137, 37.65961], [-120.97162, 37.65984], [-120.97177, 37.65994], [-120.97209, 37.66011], [-120.97244, 37.66023], [-120.97292, 37.66036], [-120.97295, 37.6604], [-120.97281, 37.66074], [-120.9727, 37.66088], [-120.97261, 37.66095], [-120.9725, 37.66102], [-120.97231, 37.66108], [-120.97218, 37.6611], [-120.97184, 37.6611], [-120.97182, 37.66109], [-120.9718, 37.66106], [-120.97179, 37.66059], [-120.97175, 37.66045], [-120.97167, 37.66036], [-120.97157, 37.66029], [-120.97145, 37.66024], [-120.97132, 37.66022]]], [[[-120.97548, 37.65992], [-120.97549, 37.66111], [-120.97547, 37.66114], [-120.97544, 37.66115], [-120.97541, 37.66114], [-120.97529, 37.661], [-120.97515, 37.66089], [-120.975, 37.66078], [-120.97467, 37.66059], [-120.9743, 37.66046], [-120.97238, 37.65995], [-120.97223, 37.65989], [-120.97195, 37.65974], [-120.97171, 37.65955], [-120.9716, 37.65944], [-120.97143, 37.65921], [-120.97131, 37.65896], [-120.97127, 37.65883], [-120.97123, 37.65856], [-120.97439, 37.65856], [-120.9744, 37.65991], [-120.97548, 37.65992]]]]} | Open Access 1 | 18570 | Downey Community Park | 18254 | 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 | 16.389 | Downey Community Park | 0 | Local Park 2 | 4 | |
2809 | 2809 | 2808 | {"type": "Polygon", "coordinates": [[[-121.01348, 37.6259], [-121.01188, 37.6259], [-121.01185, 37.62423], [-121.01345, 37.62422], [-121.01348, 37.6259]]]} | Open Access 1 | 18652 | James Marshall Park | 20349 | 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 | 6.525 | James Marshall Park | 0 | Local Park 2 | 4 | |
2814 | 2814 | 2813 | {"type": "Polygon", "coordinates": [[[-121.01985, 37.65775], [-121.01675, 37.65773], [-121.01674, 37.65692], [-121.01984, 37.65694], [-121.01985, 37.65775]]]} | Open Access 1 | 18645 | J.M. Pike Park | 20295 | 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 | 6.063 | J.M. Pike Park | 0 | Local Park 2 | 4 | |
2830 | 2830 | 2829 | {"type": "Polygon", "coordinates": [[[-120.97872, 37.62191], [-120.9787, 37.62486], [-120.97827, 37.62465], [-120.97688, 37.62378], [-120.97593, 37.62349], [-120.97539, 37.62304], [-120.97539, 37.62105], [-120.97594, 37.62112], [-120.97688, 37.6213], [-120.97787, 37.62188], [-120.97872, 37.62191]]]} | Open Access 1 | 18697 | Mancini Park | 21732 | 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 | 20.054 | Mancini Park | 0 | Local Park 2 | 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]);