superunits_with_maps

Table actions

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

8 rows where MNG_AGENCY = 590

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • Fillmore, City of · 8 ✖

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
58 58 57 {"type": "Polygon", "coordinates": [[[-118.9278, 34.40667], [-118.92762, 34.40751], [-118.92752, 34.40771], [-118.92692, 34.40853], [-118.92688, 34.40856], [-118.92653, 34.40851], [-118.92642, 34.40797], [-118.92664, 34.40792], [-118.92683, 34.40784], [-118.92704, 34.40769], [-118.92716, 34.40754], [-118.92727, 34.40733], [-118.92733, 34.40712], [-118.92734, 34.40691], [-118.9273, 34.40666], [-118.92552, 34.40689], [-118.92551, 34.40687], [-118.92771, 34.40657], [-118.92778, 34.40661], [-118.9278, 34.40667]]]} Open Access 1 Delores Day Park https://www.fillmoreca.com/departments/parks-and-recreation-department/parks/delores-day-park 33480 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 2.664 Delores Day 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  
6539 6539 6538 {"type": "Polygon", "coordinates": [[[-118.90873, 34.39979], [-118.90864, 34.39987], [-118.90766, 34.40001], [-118.90754, 34.39991], [-118.90614, 34.4001], [-118.90608, 34.39983], [-118.90633, 34.39979], [-118.90633, 34.3997], [-118.90855, 34.3994], [-118.90862, 34.39972], [-118.90873, 34.39979]]]} Open Access 1 Main Street Park   21694 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 2.607 Main Street Park  
9590 9590 9589 {"type": "Polygon", "coordinates": [[[-118.93094, 34.40291], [-118.93097, 34.40316], [-118.93097, 34.4034], [-118.93094, 34.40362], [-118.93089, 34.4038], [-118.93077, 34.40408], [-118.93027, 34.40498], [-118.93023, 34.405], [-118.93016, 34.40499], [-118.9292, 34.40449], [-118.92887, 34.40283], [-118.93084, 34.40256], [-118.9309, 34.4029], [-118.93094, 34.40291]]]} Open Access 1 Shiells Park   25409 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 9.213 Shiells Park  
13379 13379 13378 {"type": "Polygon", "coordinates": [[[-118.92622, 34.40137], [-118.92584, 34.40136], [-118.92573, 34.40141], [-118.92553, 34.40166], [-118.92549, 34.40178], [-118.92542, 34.40186], [-118.9253, 34.4018], [-118.92553, 34.4015], [-118.92556, 34.40139], [-118.92547, 34.40109], [-118.92613, 34.401], [-118.92622, 34.40137]]]} Open Access 1 Meadowlark Park   33432 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 0.728 Meadowlark Park  
14031 14031 14030 {"type": "Polygon", "coordinates": [[[-118.93143, 34.39244], [-118.92918, 34.39273], [-118.92687, 34.39306], [-118.92683, 34.39299], [-118.92663, 34.39198], [-118.92728, 34.39189], [-118.9272, 34.39141], [-118.93059, 34.39041], [-118.93091, 34.39215], [-118.93109, 34.39215], [-118.93135, 34.39204], [-118.93143, 34.39244]]]} Open Access 1 Two Rivers Park http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park 32602 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 18.621 Two Rivers Park  
14032 14032 14031 {"type": "Polygon", "coordinates": [[[-118.92729, 34.39189], [-118.92663, 34.39198], [-118.92655, 34.39159], [-118.92719, 34.3914], [-118.92729, 34.39189]]]} Open Access 1 Fillmore Dog Park http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park/dog-park 32603 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 0.753 Fillmore Dog Park  
14033 14033 14032 {"type": "Polygon", "coordinates": [[[-118.93135, 34.39204], [-118.93109, 34.39215], [-118.93091, 34.39217], [-118.93059, 34.39041], [-118.931, 34.39029], [-118.93135, 34.39204]]]} Open Access 1 Fillmore Bike Park http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park 32604 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 2.005 Fillmore Bike 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]);