units_with_maps

Table actions

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

5 rows where COUNTY = 41, DES_TP = 4 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, MNG_AG_ID

MNG_AG_TYP 1

  • Recreation/Parks District · 5 ✖

DES_TP 1

  • Local Conservation Area · 5 ✖

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
3774 3774 3773 {"type": "Polygon", "coordinates": [[[-121.27757, 38.6844], [-121.27735, 38.6846], [-121.27714, 38.68446], [-121.27711, 38.68447], [-121.2769, 38.68433], [-121.27643, 38.68417], [-121.27632, 38.68409], [-121.27631, 38.68391], [-121.27174, 38.68393], [-121.27173, 38.68226], [-121.27214, 38.68226], [-121.27215, 38.68233], [-121.2722, 38.68239], [-121.27221, 38.68272], [-121.27308, 38.68271], [-121.27344, 38.68278], [-121.27471, 38.68354], [-121.27632, 38.68353], [-121.27632, 38.68368], [-121.27663, 38.68395], [-121.27711, 38.68411], [-121.27733, 38.68427], [-121.27736, 38.68425], [-121.27757, 38.6844]]]} Open Access 1 45019 Arcade Creek Park Preserve Development 15564 2199 Sunrise Recreation and Park District 650 Special District 4 Recreation/Parks District 4 http://sunriseparks.com/ Special District 4 2199 Sunrise Recreation and Park District 639 Special District 4 Recreation/Parks District 4   Sacramento 41 10.069 Arcade Creek Park Preserve Development 0 Local Conservation Area 4 2
11621 11621 11620 {"type": "Polygon", "coordinates": [[[-121.26212, 38.68889], [-121.26212, 38.68892], [-121.26177, 38.68897], [-121.26135, 38.6891], [-121.26129, 38.68913], [-121.26129, 38.68956], [-121.26014, 38.68957], [-121.25979, 38.68906], [-121.25915, 38.68886], [-121.25901, 38.68874], [-121.25871, 38.68871], [-121.25849, 38.68884], [-121.2581, 38.689], [-121.25809, 38.68917], [-121.25802, 38.68917], [-121.25802, 38.689], [-121.25767, 38.689], [-121.25759, 38.68872], [-121.25757, 38.68853], [-121.25749, 38.68838], [-121.25768, 38.68856], [-121.25794, 38.68867], [-121.25809, 38.6884], [-121.25827, 38.68844], [-121.25846, 38.68846], [-121.25862, 38.68844], [-121.25883, 38.68839], [-121.25894, 38.68857], [-121.25913, 38.68859], [-121.25926, 38.68854], [-121.25968, 38.6882], [-121.25974, 38.68796], [-121.25972, 38.68785], [-121.25986, 38.68785], [-121.26012, 38.68755], [-121.26018, 38.68757], [-121.26016, 38.68776], [-121.26041, 38.68801], [-121.26059, 38.6879], [-121.26115, 38.6879], [-121.26119, 38.68764], [-121.26125, 38.68765], [-121.26125, 38.68794], [-121.26146, 38.688], [-121.26174, 38.68788], [-121.26211, 38.68785], [-121.26208, 38.688], [-121.26208, 38.68818], [-121.26211, 38.68828], [-121.26209, 38.68847], [-121.26209, 38.68888], [-121.26212, 38.68889]]]} Open Access 1 23902 Sundance Park Natural Area 25989 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4   Sacramento 41 10.407 Sundance Park Natural Area 0 Local Conservation Area 4 2
11662 11662 11661 {"type": "Polygon", "coordinates": [[[-121.29784, 38.64354], [-121.29782, 38.64548], [-121.29476, 38.64548], [-121.29472, 38.64378], [-121.29511, 38.64377], [-121.29526, 38.64369], [-121.29575, 38.64368], [-121.29575, 38.64338], [-121.29616, 38.64337], [-121.29631, 38.64333], [-121.29688, 38.64333], [-121.2969, 38.64339], [-121.29732, 38.6433], [-121.29733, 38.64306], [-121.29776, 38.64306], [-121.29775, 38.64353], [-121.29784, 38.64354]]]} Open Access 1 23954 Schweitzer Grove Nature Area 25198 2306 Carmichael Recreation and Park District 671 Special District 4 Recreation/Parks District 4 http://www.carmichaelpark.com Special District 4 2306 Carmichael Recreation and Park District 659 Special District 4 Recreation/Parks District 4   Sacramento 41 15.105 Schweitzer Grove Nature Area 0 Local Conservation Area 4 2
11852 11852 11851 {"type": "Polygon", "coordinates": [[[-121.3458, 38.65498], [-121.34511, 38.65498], [-121.3451, 38.65518], [-121.34476, 38.65518], [-121.34476, 38.65451], [-121.34502, 38.6545], [-121.3458, 38.65451], [-121.3458, 38.65498]]]} Open Access 1 24287 Holyoke Nature Area 20058 2201 Arcade Creek Recreation and Park District 739 Special District 4 Recreation/Parks District 4 http://www.acrpd.com/ Special District 4 2201 Arcade Creek Recreation and Park District 724 Special District 4 Recreation/Parks District 4   Sacramento 41 1.344 Holyoke Nature Area 0 Local Conservation Area 4 2
13650 13650 13649 {"type": "MultiPolygon", "coordinates": [[[[-121.33733, 38.65608], [-121.33726, 38.65614], [-121.33675, 38.65624], [-121.33626, 38.65622], [-121.33625, 38.65614], [-121.33611, 38.65614], [-121.33612, 38.65605], [-121.33626, 38.65605], [-121.33626, 38.65586], [-121.33595, 38.65586], [-121.33594, 38.65596], [-121.33567, 38.65597], [-121.33544, 38.656], [-121.33528, 38.65609], [-121.33507, 38.65607], [-121.3349, 38.65612], [-121.33473, 38.65611], [-121.33473, 38.65602], [-121.33503, 38.65542], [-121.33588, 38.65516], [-121.33664, 38.65615], [-121.33685, 38.65592], [-121.33686, 38.65596], [-121.3369, 38.65595], [-121.337, 38.65602], [-121.33708, 38.65596], [-121.33714, 38.65588], [-121.33712, 38.65577], [-121.33701, 38.65573], [-121.33713, 38.6556], [-121.33733, 38.65608]]], [[[-121.34277, 38.65129], [-121.3424, 38.65235], [-121.34226, 38.65268], [-121.3423, 38.65301], [-121.34224, 38.65322], [-121.34218, 38.65329], [-121.34119, 38.65388], [-121.34097, 38.65419], [-121.34028, 38.65443], [-121.34023, 38.65451], [-121.34015, 38.65456], [-121.33895, 38.65492], [-121.33851, 38.65508], [-121.33812, 38.65534], [-121.33759, 38.65583], [-121.33737, 38.65531], [-121.33768, 38.65521], [-121.33764, 38.65509], [-121.33794, 38.65502], [-121.33797, 38.65507], [-121.33997, 38.65418], [-121.33999, 38.65419], [-121.34003, 38.65419], [-121.34057, 38.65396], [-121.34096, 38.65375], [-121.34127, 38.65348], [-121.34133, 38.65336], [-121.34178, 38.65282], [-121.34199, 38.65245], [-121.34206, 38.6523], [-121.34193, 38.65232], [-121.34204, 38.65212], [-121.34207, 38.65191], [-121.34226, 38.65143], [-121.34184, 38.65078], [-121.34162, 38.6506], [-121.34115, 38.64998], [-121.34119, 38.64993], [-121.34115, 38.64975], [-121.34121, 38.6493], [-121.34129, 38.64906], [-121.3418, 38.64906], [-121.34176, 38.64925], [-121.34156, 38.64955], [-121.34175, 38.64992], [-121.34179, 38.65006], [-121.34183, 38.65041], [-121.34215, 38.65048], [-121.34264, 38.65089], [-121.34277, 38.65129]]]]} Open Access 1 36015 Arcade Creek Nature Area 15562 2199 Sunrise Recreation and Park District 650 Special District 4 Recreation/Parks District 4 http://sunriseparks.com/ Special District 4 2199 Sunrise Recreation and Park District 639 Special District 4 Recreation/Parks District 4   Sacramento 41 12.32 Arcade Creek Nature Area 0 Local Conservation Area 4 2

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