units_with_maps

Table actions

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

8 rows where COUNTY = 41, DES_TP = 2 and MNG_AGENCY = 940

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • Fair Oaks Recreation and Park District · 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
11393 11393 11392 {"type": "Polygon", "coordinates": [[[-121.24668, 38.66644], [-121.24542, 38.66644], [-121.24542, 38.66616], [-121.24668, 38.66616], [-121.24668, 38.66644]]]} Open Access 1 22202 Madison Place Park 32865 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4 https://www.facebook.com/events/5524-cannes-way-fair-oaks-ca-95628-2677-united-states/madison-place-park-grand-opening/1890095377727994/ Sacramento 41 0.828 Madison Place Park 2018 Local Park 2 4
11647 11647 11646 {"type": "Polygon", "coordinates": [[[-121.2662, 38.66382], [-121.26373, 38.66386], [-121.26369, 38.6623], [-121.26389, 38.66229], [-121.26389, 38.66219], [-121.26226, 38.66221], [-121.26225, 38.66057], [-121.26226, 38.66033], [-121.2623, 38.66015], [-121.26237, 38.66015], [-121.26235, 38.6603], [-121.2625, 38.6603], [-121.26251, 38.66015], [-121.26617, 38.6601], [-121.2662, 38.66382]], [[-121.26539, 38.66175], [-121.2654, 38.66164], [-121.26525, 38.66165], [-121.26526, 38.66175], [-121.26539, 38.66175]]]} Open Access 1 23939 Fair Oaks Park 18787 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 29.034 Fair Oaks Park 0 Local Park 2 4
11650 11650 11649 {"type": "Polygon", "coordinates": [[[-121.21909, 38.66139], [-121.21865, 38.66139], [-121.21862, 38.66057], [-121.21865, 38.66053], [-121.21871, 38.66051], [-121.21908, 38.66051], [-121.21909, 38.66139]]]} Open Access 1 23942 Little Phoenix Park 21353 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 0.953 Little Phoenix Park 0 Local Park 2 4
11657 11657 11656 {"type": "Polygon", "coordinates": [[[-121.2224, 38.65237], [-121.22232, 38.65242], [-121.22229, 38.65248], [-121.22232, 38.65257], [-121.22233, 38.65309], [-121.22228, 38.65313], [-121.2217, 38.65314], [-121.22169, 38.65318], [-121.22148, 38.65318], [-121.22147, 38.65317], [-121.22141, 38.65319], [-121.22099, 38.65319], [-121.22098, 38.65318], [-121.22086, 38.65318], [-121.22085, 38.65319], [-121.2195, 38.65321], [-121.21949, 38.6532], [-121.21937, 38.6532], [-121.21936, 38.65321], [-121.21796, 38.65323], [-121.21795, 38.65321], [-121.21783, 38.65322], [-121.21782, 38.65323], [-121.21668, 38.65324], [-121.21629, 38.65324], [-121.21629, 38.65321], [-121.21621, 38.65321], [-121.2162, 38.65318], [-121.21615, 38.65317], [-121.21609, 38.64973], [-121.21618, 38.64971], [-121.21617, 38.6491], [-121.22086, 38.64906], [-121.2209, 38.65119], [-121.22238, 38.65118], [-121.2224, 38.65237]]]} Open Access 1 23948 Phoenix Park 23646 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 53.924 Phoenix Park 0 Local Park 2 4
11659 11659 11658 {"type": "Polygon", "coordinates": [[[-121.24678, 38.65162], [-121.24678, 38.65168], [-121.24675, 38.65169], [-121.24676, 38.65289], [-121.24435, 38.6529], [-121.2443, 38.65288], [-121.24428, 38.65286], [-121.24424, 38.65205], [-121.24423, 38.65129], [-121.24674, 38.65127], [-121.24675, 38.65161], [-121.24678, 38.65162]]]} Open Access 1 23950 Miller Park 22246 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 9.642 Miller Park 0 Local Park 2 4
11661 11661 11660 {"type": "Polygon", "coordinates": [[[-121.28399, 38.64583], [-121.28397, 38.64588], [-121.28322, 38.6465], [-121.28307, 38.64657], [-121.28287, 38.64662], [-121.28282, 38.64661], [-121.28278, 38.64656], [-121.28275, 38.64656], [-121.28273, 38.64477], [-121.28275, 38.64472], [-121.28281, 38.6447], [-121.28366, 38.6447], [-121.28378, 38.64472], [-121.2838, 38.64476], [-121.28382, 38.64552], [-121.28389, 38.64569], [-121.28399, 38.64583]]]} Open Access 1 23953 Montview Park 22443 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 4.439 Montview Park 0 Local Park 2 4
11663 11663 11662 {"type": "Polygon", "coordinates": [[[-121.27007, 38.64269], [-121.27001, 38.64271], [-121.26947, 38.64272], [-121.26947, 38.64236], [-121.26971, 38.64239], [-121.27, 38.64235], [-121.27005, 38.64236], [-121.27008, 38.64241], [-121.27007, 38.64269]]]} Open Access 1 23956 Fair Oaks Plaza Park 18788 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 0.495 Fair Oaks Plaza Park 0 Local Park 2 4
11665 11665 11664 {"type": "Polygon", "coordinates": [[[-121.28701, 38.63469], [-121.28548, 38.63471], [-121.28524, 38.63296], [-121.28538, 38.633], [-121.28549, 38.63297], [-121.28699, 38.63292], [-121.28701, 38.63469]]]} Open Access 1 23958 Bannister Park 15799 2221 Fair Oaks Recreation and Park District 975 Special District 4 Recreation/Parks District 4 http://www.fairoakspark.org/ Special District 4 2221 Fair Oaks Recreation and Park District 940 Special District 4 Recreation/Parks District 4   Sacramento 41 6.872 Bannister 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]);