units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

28 rows where MNG_AGENCY = 512 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Banos, City of · 28 ✖

ACCESS_TYP 1

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
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
3507 3507 3506 {"type": "Polygon", "coordinates": [[[-120.8508, 37.05224], [-120.8508, 37.05236], [-120.85041, 37.05236], [-120.85041, 37.05213], [-120.8508, 37.05224]]]} Open Access 1 25980 Little Page Park 21351 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.165 Little Page Park 0 Local Park 2 4
4247 4247 4246 {"type": "Polygon", "coordinates": [[[-120.87444, 37.048], [-120.87444, 37.04918], [-120.87437, 37.04924], [-120.87215, 37.04924], [-120.87213, 37.0491], [-120.87216, 37.04795], [-120.87438, 37.04795], [-120.87444, 37.048]]]} Open Access 1 48321 Oliveira Park 32885 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.201 Oliveira Park 0 Local Park 2 4
4328 4328 4327 {"type": "Polygon", "coordinates": [[[-120.83477, 37.08028], [-120.83422, 37.08027], [-120.83417, 37.08005], [-120.83425, 37.08002], [-120.83433, 37.07998], [-120.8344, 37.07988], [-120.83477, 37.07997], [-120.83477, 37.08028]]]} Open Access 1 48327 Regency Tot Lot 32889 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.458 Regency Tot Lot 0 Local Recreation Area 3 4
5620 5620 5619 {"type": "Polygon", "coordinates": [[[-120.84016, 37.08053], [-120.84011, 37.0806], [-120.84009, 37.08068], [-120.8401, 37.08076], [-120.84015, 37.08085], [-120.84015, 37.08118], [-120.83981, 37.08118], [-120.8398, 37.08128], [-120.83792, 37.08128], [-120.83796, 37.08102], [-120.83796, 37.08054], [-120.83802, 37.08053], [-120.838, 37.07954], [-120.83958, 37.07956], [-120.83955, 37.07964], [-120.83956, 37.07971], [-120.83963, 37.07983], [-120.83968, 37.07986], [-120.83978, 37.0799], [-120.83988, 37.0799], [-120.84005, 37.07986], [-120.84014, 37.07986], [-120.84013, 37.08043], [-120.84016, 37.08053]]]} Open Access 1 48325 Vinyard 14 Basin C 32887 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.527 Vinyard 14 Basin C 0 None 453  
6545 6545 6544 {"type": "Polygon", "coordinates": [[[-120.82205, 37.06929], [-120.82203, 37.0704], [-120.8194, 37.07034], [-120.81944, 37.06924], [-120.82205, 37.06929]]]} Open Access 1 25982 Verona Park 27005 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.1 Verona Park 0 Local Park 2 4
7451 7451 7450 {"type": "Polygon", "coordinates": [[[-120.84796, 37.06232], [-120.84785, 37.06248], [-120.84776, 37.06256], [-120.84764, 37.06262], [-120.84752, 37.06266], [-120.84726, 37.06269], [-120.84715, 37.06267], [-120.84697, 37.06263], [-120.84676, 37.06256], [-120.84659, 37.06246], [-120.84645, 37.06237], [-120.84632, 37.06225], [-120.84626, 37.06214], [-120.84624, 37.06204], [-120.84624, 37.0619], [-120.84627, 37.06181], [-120.84634, 37.06169], [-120.84641, 37.06162], [-120.84796, 37.06232]]]} Open Access 1 48443 Henry Miller Plaza 33148 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.492 Henry Miller Plaza 0 Local Park 2 4
7454 7454 7453 {"type": "MultiPolygon", "coordinates": [[[[-120.83719, 37.05776], [-120.8411, 37.05961], [-120.84094, 37.05985], [-120.83719, 37.05808], [-120.8356, 37.05737], [-120.8356, 37.05723], [-120.83576, 37.05713], [-120.83719, 37.05776]]], [[[-120.84549, 37.06143], [-120.84515, 37.06193], [-120.84227, 37.06065], [-120.84113, 37.06003], [-120.84134, 37.05972], [-120.84254, 37.06023], [-120.84259, 37.06017], [-120.84549, 37.06143]]], [[[-120.84976, 37.06343], [-120.84948, 37.06384], [-120.8454, 37.06203], [-120.84585, 37.06137], [-120.84641, 37.06162], [-120.84634, 37.06169], [-120.84626, 37.06181], [-120.84624, 37.0619], [-120.84624, 37.06204], [-120.84626, 37.06214], [-120.84632, 37.06225], [-120.84645, 37.06237], [-120.84676, 37.06256], [-120.84715, 37.06267], [-120.84735, 37.06269], [-120.84752, 37.06266], [-120.84764, 37.06262], [-120.84776, 37.06256], [-120.84785, 37.06248], [-120.84796, 37.06232], [-120.84802, 37.06234], [-120.84793, 37.06249], [-120.84838, 37.06269], [-120.84849, 37.06255], [-120.84947, 37.06299], [-120.84932, 37.06323], [-120.84976, 37.06343]]], [[[-120.8528, 37.06447], [-120.85219, 37.06535], [-120.85197, 37.06526], [-120.85218, 37.06507], [-120.85217, 37.06491], [-120.85116, 37.06458], [-120.84972, 37.06395], [-120.85, 37.06354], [-120.85245, 37.06462], [-120.85267, 37.06441], [-120.8528, 37.06447]]]]} Open Access 1 48445 Rail Trail 33150 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 19.027 Rail Trail 0 Local Recreation Area 3 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
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
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
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
12268 12268 12267 {"type": "Polygon", "coordinates": [[[-120.81962, 37.06595], [-120.81952, 37.06616], [-120.81949, 37.06634], [-120.81768, 37.06633], [-120.81768, 37.06535], [-120.81776, 37.0653], [-120.81793, 37.0653], [-120.81825, 37.06533], [-120.81846, 37.06537], [-120.81867, 37.06545], [-120.81888, 37.06555], [-120.81917, 37.06575], [-120.81931, 37.06583], [-120.81962, 37.06595]]]} Open Access 1 25979 Jo Lin Park 20416 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.746 Jo Lin Park 0 Local Park 2 4
12274 12274 12273 {"type": "Polygon", "coordinates": [[[-120.88074, 37.0513], [-120.88052, 37.05153], [-120.88038, 37.05151], [-120.88026, 37.05154], [-120.8802, 37.05146], [-120.8801, 37.05143], [-120.88012, 37.05135], [-120.88008, 37.05123], [-120.88029, 37.05101], [-120.88074, 37.0513]]]} Open Access 1 48789 Neighborhood Park 33512 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 http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf Merced 37 0.508 Neighborhood Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);