superunits_with_maps

Table actions

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

18 rows where LABEL_NAME = "Central Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 18 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
514 514 513 {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52372, 34.43439], [-118.52367, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52355, 34.43443], [-118.52349, 34.43445], [-118.52293, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.5183, 34.43207], [-118.5183, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42935], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52383, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.52531, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} Open Access 1 Central Park http://www.santa-clarita.com/index.aspx?page=409 5954 1319 Santa Clarita, City of 322 City 2 City Agency 2 http://www.santa-clarita.com/index.aspx?page=186 City 2 122.859 Central Park  
2066 2066 2065 {"type": "Polygon", "coordinates": [[[-122.01909, 36.97734], [-122.01892, 36.97736], [-122.01872, 36.97737], [-122.01879, 36.97715], [-122.01894, 36.97709], [-122.01909, 36.97734]]]} Open Access 1 Central Park   17062 1320 Santa Cruz, City of 9 City 2 City Agency 2 http://www.cityofsantacruz.com/departments/parks-recreation City 2 0.156 Central Park  
2067 2067 2066 {"type": "Polygon", "coordinates": [[[-120.8462, 37.49432], [-120.846, 37.49446], [-120.84529, 37.49384], [-120.8455, 37.4937], [-120.8462, 37.49432]]]} Open Access 1 Central Park   17063 1358 Turlock, City of 41 City 2 City Agency 2 http://www.ci.turlock.ca.us/ City 2 0.538 Central Park  
2762 2762 2761 {"type": "MultiPolygon", "coordinates": [[[[-121.97732, 37.33988], [-121.97695, 37.34006], [-121.97664, 37.34028], [-121.97635, 37.34057], [-121.97615, 37.34086], [-121.97599, 37.34123], [-121.97576, 37.34199], [-121.9758, 37.34212], [-121.97582, 37.34226], [-121.97578, 37.34246], [-121.97567, 37.34265], [-121.9755, 37.34281], [-121.97522, 37.34371], [-121.9751, 37.34394], [-121.97405, 37.34517], [-121.97337, 37.34517], [-121.97332, 37.34112], [-121.97605, 37.34024], [-121.97606, 37.34022], [-121.97594, 37.33997], [-121.97718, 37.33952], [-121.97732, 37.33988]]], [[[-121.97748, 37.34379], [-121.97712, 37.34379], [-121.97711, 37.34265], [-121.9771, 37.34264], [-121.97612, 37.34267], [-121.97614, 37.34379], [-121.97547, 37.3438], [-121.97558, 37.34312], [-121.9759, 37.34282], [-121.976, 37.34268], [-121.97607, 37.34253], [-121.97612, 37.34238], [-121.97612, 37.34222], [-121.97607, 37.34198], [-121.97635, 37.34113], [-121.97643, 37.34097], [-121.97658, 37.34075], [-121.97684, 37.34048], [-121.97702, 37.34033], [-121.97714, 37.34026], [-121.97739, 37.34013], [-121.97743, 37.3404], [-121.97745, 37.34068], [-121.97748, 37.34379]]]]} Open Access 1 Central Park   17060 1318 Santa Clara, City of 395 City 2 City Agency 2 http://santaclaraca.gov/index.aspx?page=123 City 2 32.939 Central Park 1961
2766 2766 2765 {"type": "Polygon", "coordinates": [[[-119.00864, 35.37632], [-119.00863, 35.37719], [-119.00843, 35.37723], [-119.00844, 35.37794], [-119.00843, 35.37799], [-119.00643, 35.37799], [-119.00669, 35.37726], [-119.00715, 35.37631], [-119.00864, 35.37632]]]} Open Access 1 Central Park   17050 1019 Bakersfield, City of 244 City 2 City Agency 2 http://www.bakersfieldcity.us/recreation/ City 2 7.425 Central Park  
2767 2767 2766 {"type": "Polygon", "coordinates": [[[-117.68909, 34.01304], [-117.6881, 34.01305], [-117.68809, 34.01215], [-117.68817, 34.01208], [-117.68899, 34.01207], [-117.68908, 34.01214], [-117.68909, 34.01304]]]} Open Access 1 Central Park http://www.cityofchino.org/government-services/community-services/parks/central-park 17051 1053 Chino, City of 261 City 2 City Agency 2 http://www.cityofchino.org/residents/parks City 2 2.409 Central Park  
2768 2768 2767 {"type": "Polygon", "coordinates": [[[-121.74523, 38.54626], [-121.74471, 38.54656], [-121.74447, 38.5466], [-121.7438, 38.54423], [-121.74462, 38.54409], [-121.74523, 38.54626]]]} Open Access 1 Central Park   17052 1081 Davis, City of 167 City 2 City Agency 2 http://parks.cityofdavis.org/ City 2 4.734 Central Park  
2769 2769 2768 {"type": "Polygon", "coordinates": [[[-118.03947, 33.84995], [-118.03745, 33.84997], [-118.03741, 33.84852], [-118.03945, 33.84849], [-118.03947, 33.84995]]]} Open Access 1 Central Park   17053 1159 La Palma, City of 624 City 2 City Agency 2 http://www.cityoflapalma.org/index.aspx?nid=225 City 2 7.487 Central Park  
2770 2770 2769 {"type": "Polygon", "coordinates": [[[-122.40194, 37.59953], [-122.4014, 37.59984], [-122.40143, 37.5999], [-122.40009, 37.60067], [-122.40003, 37.60074], [-122.40003, 37.60079], [-122.40005, 37.60083], [-122.4001, 37.6009], [-122.39917, 37.60143], [-122.39834, 37.60052], [-122.40124, 37.59884], [-122.40194, 37.59953]]]} Open Access 1 Central Park   17054 1205 Millbrae, City of 398 City 2 City Agency 2 http://www.ci.millbrae.ca.us/ City 2 8.687 Central Park 1969
2771 2771 2770 {"type": "Polygon", "coordinates": [[[-121.8726, 38.01947], [-121.87261, 38.01955], [-121.87177, 38.02147], [-121.87121, 38.02134], [-121.87144, 38.02063], [-121.87071, 38.02046], [-121.87061, 38.02039], [-121.87059, 38.0203], [-121.87101, 38.01918], [-121.87113, 38.01907], [-121.87131, 38.01906], [-121.87133, 38.01903], [-121.87252, 38.01941], [-121.8726, 38.01947]]]} Open Access 1 Central Park   17055 1254 Pittsburg, City of 380 City 2 City Agency 2 http://www.ci.pittsburg.ca.us/index.aspx?page=238 City 2 6.784 Central Park  
2772 2772 2771 {"type": "MultiPolygon", "coordinates": [[[[-117.56281, 34.1216], [-117.56283, 34.12193], [-117.56279, 34.12211], [-117.56269, 34.1223], [-117.56263, 34.1225], [-117.56259, 34.12278], [-117.56252, 34.12304], [-117.56237, 34.12323], [-117.56219, 34.12338], [-117.56211, 34.12352], [-117.56203, 34.1237], [-117.56198, 34.12388], [-117.56185, 34.12404], [-117.56168, 34.12419], [-117.56152, 34.1243], [-117.56122, 34.12437], [-117.56085, 34.12438], [-117.5605, 34.12442], [-117.5601, 34.12451], [-117.55978, 34.12461], [-117.55959, 34.1247], [-117.5594, 34.12471], [-117.55923, 34.12466], [-117.55858, 34.12465], [-117.55858, 34.1216], [-117.56281, 34.1216]]], [[[-117.57053, 34.12177], [-117.56857, 34.12529], [-117.55858, 34.12512], [-117.55858, 34.12486], [-117.55924, 34.12484], [-117.5594, 34.12479], [-117.55955, 34.12478], [-117.55994, 34.12463], [-117.56027, 34.12453], [-117.5606, 34.12447], [-117.56086, 34.12445], [-117.56107, 34.12445], [-117.5613, 34.12443], [-117.56155, 34.12435], [-117.56176, 34.12423], [-117.5619, 34.12411], [-117.56204, 34.12393], [-117.56217, 34.12359], [-117.56227, 34.12344], [-117.56243, 34.12326], [-117.56258, 34.12306], [-117.56267, 34.12283], [-117.56272, 34.12247], [-117.56279, 34.12228], [-117.56289, 34.1221], [-117.56305, 34.12193], [-117.56305, 34.12161], [-117.57045, 34.12161], [-117.57046, 34.12166], [-117.57053, 34.12177]]]]} Open Access 1 Central Park   17056 1263 Rancho Cucamonga, City of 192 City 2 City Agency 2 http://www.cityofrc.us/cityhall/cs/parks/default.asp City 2 98.797 Central Park  
2773 2773 2772 {"type": "Polygon", "coordinates": [[[-122.30787, 37.90159], [-122.30773, 37.90176], [-122.30731, 37.90245], [-122.30705, 37.9025], [-122.30678, 37.90164], [-122.30779, 37.90148], [-122.30787, 37.90159]]]} Open Access 1 Central Park   17057 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1.506 Central Park  
2774 2774 2773 {"type": "Polygon", "coordinates": [[[-121.27975, 38.78866], [-121.27802, 38.79079], [-121.27802, 38.79158], [-121.27738, 38.79117], [-121.27687, 38.7909], [-121.27644, 38.79071], [-121.27466, 38.79], [-121.27461, 38.78994], [-121.27462, 38.78989], [-121.27478, 38.78965], [-121.27697, 38.78962], [-121.27697, 38.78808], [-121.27663, 38.78743], [-121.27717, 38.78714], [-121.27771, 38.7868], [-121.27778, 38.7868], [-121.27783, 38.78683], [-121.27793, 38.78698], [-121.27816, 38.78725], [-121.2783, 38.78738], [-121.27856, 38.78767], [-121.27887, 38.78798], [-121.2793, 38.78834], [-121.27975, 38.78866]]]} Open Access 1 Central Park   17058 1285 Roseville, City of 533 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 22.901 Central Park  
2775 2775 2774 {"type": "Polygon", "coordinates": [[[-122.32427, 37.56169], [-122.3221, 37.56319], [-122.32082, 37.56202], [-122.32141, 37.56161], [-122.32141, 37.56159], [-122.32012, 37.5604], [-122.32038, 37.56022], [-122.32089, 37.56067], [-122.32219, 37.55977], [-122.32427, 37.56169]]]} Open Access 1 Central Park   17059 1310 San Mateo, City of 96 City 2 City Agency 2 http://www.cityofsanmateo.org/index.aspx?nid=324 City 2 16.266 Central Park 1940
2776 2776 2775 {"type": "Polygon", "coordinates": [[[-118.03492, 33.98096], [-118.03491, 33.98163], [-118.03392, 33.98163], [-118.03394, 33.98096], [-118.03492, 33.98096]]]} Open Access 1 Central Park   17064 1380 Whittier, City of 287 City 2 City Agency 2 http://www.cityofwhittier.org/depts/prcs/default.asp City 2 1.688 Central Park  
2778 2778 2777 {"type": "MultiPolygon", "coordinates": [[[[-118.91332, 34.39908], [-118.90881, 34.3997], [-118.90873, 34.39929], [-118.91324, 34.39866], [-118.91332, 34.39908]]], [[[-118.91138, 34.39885], [-118.91068, 34.39894], [-118.91062, 34.39865], [-118.91106, 34.39859], [-118.91108, 34.39863], [-118.91133, 34.3986], [-118.91138, 34.39885]]], [[[-118.91263, 34.39868], [-118.91217, 34.39875], [-118.91212, 34.39849], [-118.91258, 34.39843], [-118.91263, 34.39868]]]]} Open Access 1 Central Park   17065 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 5.661 Central Park  
2779 2779 2778 {"type": "Polygon", "coordinates": [[[-122.20871, 39.51772], [-122.20669, 39.51777], [-122.20663, 39.51685], [-122.20675, 39.51683], [-122.2068, 39.51669], [-122.20669, 39.51658], [-122.20869, 39.51658], [-122.20871, 39.51772]]]} Open Access 1 Central Park   17066 1424 Willows, City of 950 City 2 City Agency 2 http://www.cityofwillows.org/index.asp?Type=B_BASIC&SEC={015394F5-8E1E-4589-8D14-61CADB23BEE6} City 2 5.545 Central Park  
13771 13771 13770 {"type": "Polygon", "coordinates": [[[-121.95991, 37.77099], [-121.95916, 37.77133], [-121.95755, 37.76909], [-121.95614, 37.76973], [-121.95547, 37.76887], [-121.95514, 37.76854], [-121.95568, 37.76829], [-121.95516, 37.76776], [-121.95458, 37.76799], [-121.95222, 37.76585], [-121.95221, 37.76579], [-121.95401, 37.76453], [-121.95488, 37.76399], [-121.95991, 37.77099]]]} Open Access 1 Central Park   31279 1313 San Ramon, City of 68 City 2 City Agency 2 http://www.ci.san-ramon.ca.us/Parks/default.htm City 2 41.392 Central Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);