units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 512 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB
DES_TP 15
MNG_AG_TYP 1
- City Agency 40
MNG_AGENCY 1
- Los Banos, City of · 40 ✖
ACCESS_TYP 1
- Open Access 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2366 | 2366 | 2365 | {"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]} | Open Access 1 | 17156 | Airport Park | 15303 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.388 | Airport Park | 0 | Local Park 2 | 4 | |
9974 | 9974 | 9973 | {"type": "Polygon", "coordinates": [[[-120.83251, 37.0478], [-120.8325, 37.04919], [-120.83102, 37.0492], [-120.83096, 37.04915], [-120.83095, 37.04844], [-120.83092, 37.04831], [-120.83088, 37.04825], [-120.83085, 37.04816], [-120.83131, 37.04813], [-120.83133, 37.04778], [-120.83251, 37.0478]]]} | Open Access 1 | 17160 | College Green Park | 17503 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 5.007 | College Green Park | 0 | Local Park 2 | 4 | |
9976 | 9976 | 9975 | {"type": "Polygon", "coordinates": [[[-120.86345, 37.06099], [-120.86343, 37.06202], [-120.86271, 37.06203], [-120.86293, 37.06176], [-120.86305, 37.06159], [-120.86338, 37.06099], [-120.86345, 37.06099]]]} | Open Access 1 | 17162 | Big Page Park | 16084 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.921 | Big Page Park | 0 | Local Park 2 | 4 | |
9080 | 9080 | 9079 | {"type": "Polygon", "coordinates": [[[-120.83167, 37.06186], [-120.83167, 37.06285], [-120.83164, 37.06345], [-120.8315, 37.06346], [-120.83099, 37.06346], [-120.82896, 37.06343], [-120.82894, 37.06181], [-120.83167, 37.06186]]]} | Open Access 1 | 17165 | Talbott Park | 26173 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 10.697 | Talbott Park | 0 | Local Park 2 | 4 | |
2370 | 2370 | 2369 | {"type": "Polygon", "coordinates": [[[-120.83479, 37.08983], [-120.83269, 37.08984], [-120.83279, 37.08797], [-120.83477, 37.08796], [-120.83479, 37.08983]]]} | Open Access 1 | 17169 | Ag Sports Complex | 15283 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 9.306 | Ag Sports Complex | 0 | Local Recreation Area 3 | 4 | |
11941 | 11941 | 11940 | {"type": "Polygon", "coordinates": [[[-120.8521, 37.07214], [-120.85209, 37.0729], [-120.85185, 37.0729], [-120.85118, 37.07263], [-120.85117, 37.07269], [-120.85052, 37.07269], [-120.85053, 37.07214], [-120.8521, 37.07214]]]} | Open Access 1 | 24557 | Citrus Terrace Park II | 17287 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 2.351 | Citrus Terrace Park II | None 1050 | |||
11942 | 11942 | 11941 | {"type": "Polygon", "coordinates": [[[-120.84713, 37.04245], [-120.84713, 37.04345], [-120.84567, 37.04345], [-120.84567, 37.04249], [-120.84573, 37.04244], [-120.84713, 37.04245]]]} | Open Access 1 | 24559 | Cresthills Park | 17807 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 3.569 | Cresthills Park | 0 | Local Park 2 | 4 | |
11943 | 11943 | 11942 | {"type": "Polygon", "coordinates": [[[-120.86657, 37.05677], [-120.86547, 37.0568], [-120.86547, 37.0568], [-120.86569, 37.05635], [-120.86618, 37.05655], [-120.86657, 37.05677]]]} | Open Access 1 | 24560 | Wolfsen Park | 33697 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.633 | Wolfsen Park | 0 | Local Park 2 | 4 | |
11944 | 11944 | 11943 | {"type": "Polygon", "coordinates": [[[-120.86689, 37.05334], [-120.8667, 37.05372], [-120.86651, 37.05366], [-120.86618, 37.05375], [-120.86598, 37.0537], [-120.86624, 37.05316], [-120.86655, 37.05326], [-120.86657, 37.05324], [-120.86689, 37.05334]]]} | Open Access 1 | 24561 | Gardens Park I | 19206 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.817 | Gardens Park I | None 1051 | |||
11945 | 11945 | 11944 | {"type": "Polygon", "coordinates": [[[-120.86874, 37.05209], [-120.86844, 37.05234], [-120.86842, 37.05229], [-120.86826, 37.05216], [-120.8681, 37.05227], [-120.86796, 37.05215], [-120.86814, 37.05202], [-120.86814, 37.05168], [-120.8685, 37.05176], [-120.86848, 37.05186], [-120.86852, 37.05196], [-120.8686, 37.05204], [-120.86874, 37.05209]]]} | Open Access 1 | 24562 | Gardens Park III | 19207 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.601 | Gardens Park III | None 1052 | |||
11947 | 11947 | 11946 | {"type": "Polygon", "coordinates": [[[-120.86434, 37.05547], [-120.86298, 37.0554], [-120.86298, 37.05515], [-120.86305, 37.05514], [-120.86311, 37.05509], [-120.86314, 37.05503], [-120.86312, 37.05497], [-120.86142, 37.05281], [-120.86144, 37.05275], [-120.86219, 37.0525], [-120.86201, 37.05197], [-120.86178, 37.05147], [-120.86136, 37.0508], [-120.86102, 37.05034], [-120.86092, 37.05016], [-120.8608, 37.04986], [-120.86075, 37.04956], [-120.86161, 37.04955], [-120.86176, 37.0498], [-120.86179, 37.0501], [-120.86186, 37.05038], [-120.86198, 37.05065], [-120.86226, 37.05108], [-120.86248, 37.05149], [-120.86265, 37.05191], [-120.86277, 37.05234], [-120.8634, 37.05223], [-120.86434, 37.05547]]]} | Open Access 1 | 24563 | Gardens Park V | 19208 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 17.006 | Gardens Park V | None 1053 | |||
11948 | 11948 | 11947 | {"type": "Polygon", "coordinates": [[[-120.81052, 37.05943], [-120.81051, 37.05977], [-120.81052, 37.05995], [-120.81021, 37.06006], [-120.80999, 37.06017], [-120.80924, 37.06057], [-120.80881, 37.06056], [-120.80837, 37.05981], [-120.80936, 37.05947], [-120.80962, 37.0594], [-120.80991, 37.05937], [-120.81047, 37.05938], [-120.81052, 37.05943]]]} | Open Access 1 | 24564 | Meadowlands Park II | 22088 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 4.114 | Meadowlands Park II | None 1054 | |||
11949 | 11949 | 11948 | {"type": "Polygon", "coordinates": [[[-120.81302, 37.06411], [-120.81242, 37.06442], [-120.81216, 37.06448], [-120.81198, 37.06446], [-120.81168, 37.06435], [-120.81145, 37.06413], [-120.81138, 37.06384], [-120.81145, 37.06362], [-120.81156, 37.06347], [-120.81227, 37.06311], [-120.81302, 37.06411]]]} | Open Access 1 | 24565 | Meadowlands Park III | 22089 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 3.422 | Meadowlands Park III | None 1055 | |||
11950 | 11950 | 11949 | {"type": "Polygon", "coordinates": [[[-120.81874, 37.06099], [-120.81873, 37.06123], [-120.81853, 37.06124], [-120.81852, 37.06151], [-120.8182, 37.0615], [-120.81821, 37.0609], [-120.81853, 37.06082], [-120.81856, 37.06088], [-120.81862, 37.06093], [-120.81874, 37.06099]]]} | Open Access 1 | 24566 | Rancho Dos Amigos Park | 24142 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.665 | Rancho Dos Amigos Park | 0 | Local Park 2 | 4 | |
11951 | 11951 | 11950 | {"type": "Polygon", "coordinates": [[[-120.84485, 37.07714], [-120.84483, 37.07869], [-120.84364, 37.07869], [-120.84367, 37.07737], [-120.84365, 37.07719], [-120.84371, 37.07714], [-120.84485, 37.07714]]]} | Open Access 1 | 24567 | Ranchwood Park | 24183 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 4.494 | Ranchwood Park | 0 | Local Park 2 | 4 | |
11952 | 11952 | 11951 | {"type": "Polygon", "coordinates": [[[-120.84517, 37.06501], [-120.84392, 37.06683], [-120.84248, 37.0662], [-120.84374, 37.06437], [-120.84517, 37.06501]]]} | Open Access 1 | 24568 | Little League Park | 21349 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 8.359 | Little League Park | 0 | Local Park 2 | 4 | |
11953 | 11953 | 11952 | {"type": "Polygon", "coordinates": [[[-120.83199, 37.08099], [-120.83182, 37.08135], [-120.83169, 37.08146], [-120.83194, 37.08167], [-120.83168, 37.08187], [-120.83138, 37.08166], [-120.83116, 37.08181], [-120.83116, 37.08263], [-120.82995, 37.08262], [-120.82989, 37.08257], [-120.82991, 37.08075], [-120.82996, 37.08071], [-120.83118, 37.08072], [-120.83118, 37.08099], [-120.83199, 37.08099]]]} | Open Access 1 | 24569 | Skylark Park | 25536 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 7.202 | Skylark Park | 0 | Local Park 2 | 4 | |
11954 | 11954 | 11953 | {"type": "Polygon", "coordinates": [[[-120.85005, 37.07911], [-120.85002, 37.0805], [-120.84822, 37.0805], [-120.84824, 37.07911], [-120.85005, 37.07911]]]} | Open Access 1 | 24570 | Vineyards Basin Park A | 27141 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 6.119 | Vineyards Basin Park A | None 1056 | |||
12313 | 12313 | 12312 | {"type": "Polygon", "coordinates": [[[-120.84651, 37.08288], [-120.84651, 37.08435], [-120.84397, 37.08439], [-120.84396, 37.08294], [-120.84405, 37.08287], [-120.84651, 37.08288]]]} | Open Access 1 | 25974 | Vineyard Basin Park B | 27134 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 9.288 | Vineyard Basin Park B | None 1073 | |||
12314 | 12314 | 12313 | {"type": "Polygon", "coordinates": [[[-120.85118, 37.05874], [-120.85101, 37.05897], [-120.85057, 37.05878], [-120.85048, 37.05889], [-120.85003, 37.05869], [-120.85107, 37.05869], [-120.85118, 37.05874]]]} | Open Access 1 | 25975 | Catholic Park | 16978 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.408 | Catholic 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]);