units_with_maps

Table actions

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

8 rows where DES_TP = 2 and 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 ✖

DES_TP 1

  • Local Park · 8 ✖

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
3225 3225 3224 {"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 48098 Fillmore Dog Park 32603 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park/dog-park Ventura 8 0.753 Fillmore Dog Park 0 Local Park 2 4
5489 5489 5488 {"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 25029 Central Park 17065 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2   Ventura 8 5.662 Central Park 0 Local Park 2 4
5491 5491 5490 {"type": "Polygon", "coordinates": [[[-118.90873, 34.39979], [-118.90865, 34.39987], [-118.90766, 34.40001], [-118.90754, 34.39991], [-118.90614, 34.4001], [-118.90608, 34.39983], [-118.90634, 34.39979], [-118.90633, 34.3997], [-118.90855, 34.3994], [-118.90862, 34.39973], [-118.90873, 34.39979]]]} Open Access 1 25031 Main Street Park 21694 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2   Ventura 8 2.606 Main Street Park 0 Local Park 2 4
5492 5492 5491 {"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.93091, 34.4029], [-118.93094, 34.40291]]]} Open Access 1 25032 Shiells Park 25409 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2   Ventura 8 9.213 Shiells Park 0 Local Park 2 4
11399 11399 11398 {"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 48099 Fillmore Bike Park 32604 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park Ventura 8 2.006 Fillmore Bike Park 0 Local Park 2 4
11429 11429 11428 {"type": "Polygon", "coordinates": [[[-118.93143, 34.39244], [-118.92918, 34.39273], [-118.92687, 34.39306], [-118.92684, 34.39299], [-118.92663, 34.39198], [-118.92729, 34.39189], [-118.92719, 34.39141], [-118.93059, 34.39041], [-118.93091, 34.39216], [-118.93109, 34.39215], [-118.93135, 34.39204], [-118.93143, 34.39244]]]} Open Access 1 48097 Two Rivers Park 32602 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2 http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park Ventura 8 18.615 Two Rivers Park 0 Local Park 2 4
11461 11461 11460 {"type": "Polygon", "coordinates": [[[-118.92622, 34.40137], [-118.92584, 34.40136], [-118.92572, 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 48697 Meadowlark Park 33432 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2   Ventura 8 0.726 Meadowlark Park 0 Local Park 2 4
12269 12269 12268 {"type": "Polygon", "coordinates": [[[-118.9277, 34.40717], [-118.92762, 34.40751], [-118.92752, 34.40771], [-118.92692, 34.40854], [-118.92688, 34.40856], [-118.92683, 34.40856], [-118.92669, 34.40853], [-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.40692], [-118.9273, 34.40665], [-118.92552, 34.40689], [-118.92551, 34.40687], [-118.92771, 34.40657], [-118.92778, 34.40661], [-118.9278, 34.40667], [-118.9277, 34.40717]]]} Open Access 1 48753 Delores Day Park 33480 1423 Fillmore, City of 600 City 2 City Agency 2 http://www.fillmoreca.com/rec-dept.htm City 2 1423 Fillmore, City of 590 City 2 City Agency 2 https://www.fillmoreca.com/departments/parks-and-recreation-department/parks/delores-day-park Ventura 8 2.659 Delores Day Park 0 Local Park 2 4

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