units_with_maps

Table actions

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

10 rows where DES_TP = 3, MNG_AGENCY = 14 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 10 ✖

MNG_AGENCY 1

  • Fresno, City of · 10 ✖

DES_TP 1

  • Local Recreation Area · 10 ✖
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
122 122 121 {"type": "Polygon", "coordinates": [[[-119.79182, 36.7434], [-119.79182, 36.74417], [-119.7913, 36.74417], [-119.79129, 36.74413], [-119.79071, 36.74413], [-119.79072, 36.7434], [-119.79182, 36.7434]]]} Open Access 1 419 Dicky Playground 18152 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 2.025 Dicky Playground 0 Local Recreation Area 3 4
462 462 461 {"type": "Polygon", "coordinates": [[[-119.82186, 36.78834], [-119.81967, 36.78838], [-119.81975, 36.78668], [-119.82184, 36.78661], [-119.82186, 36.78834]]]} Open Access 1 1856 Quigley Playground 24064 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 8.955 Quigley Playground 0 Local Recreation Area 3 4
466 466 465 {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} Open Access 1 922 Holmes Playground 20056 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 6.725 Holmes Playground 0 Local Recreation Area 3 4
508 508 507 {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} Open Access 1 2073 Romain Playground 24586 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 7.876 Romain Playground 0 Local Recreation Area 3 4
6366 6366 6365 {"type": "MultiPolygon", "coordinates": [[[[-119.78683, 36.85228], [-119.78498, 36.85367], [-119.7841, 36.85433], [-119.78406, 36.85412], [-119.78674, 36.85212], [-119.78683, 36.85228]]], [[[-119.78372, 36.85461], [-119.76849, 36.86602], [-119.76817, 36.86623], [-119.76778, 36.86623], [-119.76811, 36.86606], [-119.76841, 36.86586], [-119.78372, 36.85438], [-119.78372, 36.85461]]], [[[-119.76748, 36.86652], [-119.76705, 36.86663], [-119.7667, 36.86669], [-119.76634, 36.86671], [-119.7659, 36.86671], [-119.7659, 36.86654], [-119.76748, 36.86652]]], [[[-119.76569, 36.86671], [-119.75699, 36.86679], [-119.75698, 36.86662], [-119.76569, 36.86654], [-119.76569, 36.86671]]], [[[-119.75657, 36.86679], [-119.74799, 36.86687], [-119.74799, 36.86678], [-119.74786, 36.86677], [-119.74786, 36.86671], [-119.75512, 36.86667], [-119.75657, 36.86663], [-119.75657, 36.86679]]], [[[-119.74761, 36.86687], [-119.74389, 36.8669], [-119.7389, 36.86694], [-119.7389, 36.86679], [-119.74183, 36.86677], [-119.74187, 36.86679], [-119.74761, 36.86677], [-119.74761, 36.86687]]], [[[-119.73869, 36.86694], [-119.73431, 36.86698], [-119.73431, 36.86683], [-119.73869, 36.8668], [-119.73869, 36.86694]]]]} Open Access 1 1743 Sugar Pine Trail 25944 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 21.648 Sugar Pine Trail 0 Local Recreation Area 3 4
6516 6516 6515 {"type": "Polygon", "coordinates": [[[-119.79424, 36.75293], [-119.794, 36.75293], [-119.79398, 36.75284], [-119.79363, 36.75283], [-119.7936, 36.75262], [-119.7929, 36.75264], [-119.7929, 36.75233], [-119.79402, 36.75232], [-119.79402, 36.75259], [-119.79421, 36.75258], [-119.79424, 36.75293]]]} Open Access 1 2496 Ted C Wills Park & Community Center 26212 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 1.226 Ted C Wills Park & Community Ctr. 0 Local Recreation Area 3 4
10619 10619 10618 {"type": "Polygon", "coordinates": [[[-119.79872, 36.7241], [-119.79791, 36.72469], [-119.797, 36.72386], [-119.79782, 36.72328], [-119.79872, 36.7241]]]} Open Access 1 18921 Ball Playground 15785 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 2.938 Ball Playground 0 Local Recreation Area 3 4
11830 11830 11829 {"type": "Polygon", "coordinates": [[[-119.75449, 36.7259], [-119.75449, 36.72681], [-119.75239, 36.72681], [-119.75238, 36.72591], [-119.75449, 36.7259]]]} Open Access 1 24155 East Fresno Boys Club 18368 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 4.671 East Fresno Boys Club 0 Local Recreation Area 3 4
15707 15707 15706 {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} Restricted Access 2 25456 Airways Municipal Golf Course 33086 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 88.161 Airways Municipal GC 0 Local Recreation Area 3 4
16845 16845 16844 {"type": "Polygon", "coordinates": [[[-119.83569, 36.69941], [-119.83184, 36.69942], [-119.83183, 36.69403], [-119.83132, 36.69402], [-119.83132, 36.6923], [-119.83569, 36.69229], [-119.83569, 36.69941]]]} Open Access 1 24165 Regional Sports Park 24277 1114 Fresno, City of 14 City 2 City Agency 2 http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm City 2 1114 Fresno, City of 14 City 2 City Agency 2   Fresno 9 69.372 Reg. Sports Park 0 Local Recreation Area 3 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]);