units_with_maps

Table actions

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

14 rows where DES_TP = 2, MNG_AGENCY = 612 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 14 ✖

MNG_AGENCY 1

  • Galt, City of · 14 ✖

DES_TP 1

  • Local Park · 14 ✖

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
3343 3343 3342 {"type": "Polygon", "coordinates": [[[-121.29859, 38.27323], [-121.29827, 38.27323], [-121.29772, 38.27303], [-121.29772, 38.27294], [-121.29763, 38.27285], [-121.29754, 38.27274], [-121.29747, 38.27261], [-121.29743, 38.27246], [-121.2974, 38.27226], [-121.29741, 38.27183], [-121.29743, 38.27174], [-121.29739, 38.27166], [-121.29733, 38.27162], [-121.29732, 38.27136], [-121.2974, 38.27136], [-121.29748, 38.27138], [-121.29759, 38.27146], [-121.29762, 38.27154], [-121.29764, 38.2719], [-121.29767, 38.27203], [-121.29772, 38.27212], [-121.29788, 38.27231], [-121.29808, 38.27243], [-121.29817, 38.27251], [-121.29823, 38.27262], [-121.29826, 38.27288], [-121.29829, 38.27297], [-121.29835, 38.27304], [-121.29841, 38.27309], [-121.29859, 38.27317], [-121.29859, 38.27323]]]} Open Access 1 24095 Canyon Creek Park 16814 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 1.995 Canyon Creek Park 0 Local Park 2 4
4078 4078 4077 {"type": "Polygon", "coordinates": [[[-121.30625, 38.25317], [-121.30605, 38.25321], [-121.30574, 38.25237], [-121.30594, 38.25233], [-121.30625, 38.25317]]]} Open Access 1 47115 Southern Pacific Park 30786 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 0.434 Southern Pacific Park 0 Local Park 2 4
5236 5236 5235 {"type": "Polygon", "coordinates": [[[-121.32596, 38.25906], [-121.32595, 38.26184], [-121.32404, 38.26185], [-121.32404, 38.26001], [-121.32402, 38.25959], [-121.32423, 38.25956], [-121.3249, 38.25955], [-121.32492, 38.25909], [-121.32596, 38.25906]]]} Open Access 1 48078 Walker Community Park 32580 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2 http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/walker-park Sacramento 41 11.723 Walker Community Park 2011 Local Park 2 4
5237 5237 5236 {"type": "Polygon", "coordinates": [[[-121.29056, 38.28984], [-121.29054, 38.29107], [-121.28929, 38.29108], [-121.2893, 38.29104], [-121.2894, 38.291], [-121.28946, 38.29093], [-121.28974, 38.28982], [-121.28981, 38.28979], [-121.29056, 38.28984]]]} Open Access 1 48079 Monterey Park 32581 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2 http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/monterey-park Sacramento 41 2.941 Monterey Park 0 Local Park 2 4
5238 5238 5237 {"type": "Polygon", "coordinates": [[[-121.29118, 38.26987], [-121.29055, 38.27022], [-121.29037, 38.27002], [-121.29023, 38.26972], [-121.28988, 38.26967], [-121.29008, 38.26883], [-121.29062, 38.26886], [-121.29067, 38.26894], [-121.29055, 38.26919], [-121.2907, 38.26947], [-121.29099, 38.26963], [-121.29118, 38.26987]]]} Open Access 1 48080 Roundstone Park 32582 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2 http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/roundstone-park Sacramento 41 2.211 Roundstone Park 0 Local Park 2 4
5239 5239 5238 {"type": "Polygon", "coordinates": [[[-121.28808, 38.28648], [-121.2873, 38.28653], [-121.28649, 38.28664], [-121.2858, 38.2868], [-121.28515, 38.287], [-121.28514, 38.28575], [-121.28761, 38.28573], [-121.28795, 38.28568], [-121.28803, 38.28612], [-121.28808, 38.28648]]]} Open Access 1 48081 McCaffery Park 32583 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2 http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/mccaffery-park Sacramento 41 6.455 McCaffery Park 0 Local Park 2 4
5240 5240 5239 {"type": "Polygon", "coordinates": [[[-121.30529, 38.25856], [-121.30529, 38.25881], [-121.30473, 38.25881], [-121.30473, 38.25856], [-121.30529, 38.25856]]]} Open Access 1 48082 Lion's Oak Park 32584 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2 http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/lion-s-oak-park Sacramento 41 0.333 Lion's Oak Park 0 Local Park 2 4
11722 11722 11721 {"type": "MultiPolygon", "coordinates": [[[[-121.3074, 38.2507], [-121.30691, 38.25081], [-121.30678, 38.25048], [-121.30727, 38.25037], [-121.3074, 38.2507]]], [[[-121.30834, 38.25155], [-121.30727, 38.25179], [-121.30695, 38.25094], [-121.30802, 38.25069], [-121.30834, 38.25155]]]]} Open Access 1 24101 Harvey Park 19728 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 2.817 Harvey Park 0 Local Park 2 4
11797 11797 11796 {"type": "Polygon", "coordinates": [[[-121.29204, 38.27768], [-121.29211, 38.27781], [-121.29225, 38.27822], [-121.29252, 38.27871], [-121.29252, 38.27875], [-121.29249, 38.27878], [-121.2891, 38.28007], [-121.28904, 38.28006], [-121.28901, 38.28004], [-121.28881, 38.27976], [-121.28864, 38.27957], [-121.28876, 38.27956], [-121.28886, 38.27952], [-121.28895, 38.27946], [-121.28902, 38.27938], [-121.28944, 38.27834], [-121.28978, 38.27838], [-121.28986, 38.27837], [-121.28997, 38.27832], [-121.2901, 38.27821], [-121.29016, 38.27812], [-121.29019, 38.27802], [-121.2902, 38.27744], [-121.29024, 38.27737], [-121.2903, 38.27731], [-121.29038, 38.27728], [-121.29048, 38.27726], [-121.29057, 38.27728], [-121.29065, 38.27731], [-121.29072, 38.27737], [-121.29083, 38.27761], [-121.29091, 38.27771], [-121.29102, 38.27778], [-121.29122, 38.27786], [-121.29136, 38.27788], [-121.29158, 38.27785], [-121.29204, 38.27768]]]} Open Access 1 24093 Galt Community Park 19181 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 12.207 Galt Community Park 0 Local Park 2 4
11798 11798 11797 {"type": "Polygon", "coordinates": [[[-121.30404, 38.27616], [-121.30399, 38.27618], [-121.30342, 38.27634], [-121.30297, 38.27653], [-121.30278, 38.27657], [-121.3027, 38.27655], [-121.30268, 38.27652], [-121.30264, 38.27633], [-121.30259, 38.27594], [-121.30258, 38.27535], [-121.30262, 38.27523], [-121.3026, 38.27516], [-121.30254, 38.27509], [-121.30256, 38.27507], [-121.30256, 38.27477], [-121.30354, 38.27477], [-121.30404, 38.27616]]]} Open Access 1 24094 Emerald Vista Park 18620 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 4.767 Emerald Vista Park 0 Local Park 2 4
11800 11800 11799 {"type": "Polygon", "coordinates": [[[-121.30202, 38.25468], [-121.30084, 38.25469], [-121.30084, 38.25455], [-121.30188, 38.25429], [-121.30202, 38.25468]]]} Open Access 1 24097 SMUD Park 33379 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 0.741 SMUD Park 0 Local Park 2 4
11801 11801 11800 {"type": "Polygon", "coordinates": [[[-121.32095, 38.25247], [-121.32095, 38.25302], [-121.32042, 38.25302], [-121.32041, 38.25335], [-121.3201, 38.25359], [-121.32011, 38.25455], [-121.31912, 38.25456], [-121.31906, 38.25453], [-121.31904, 38.25449], [-121.31904, 38.2525], [-121.32095, 38.25247]]]} Open Access 1 24098 Greer Basin Park 19493 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 6.695 Greer Basin Park 0 Local Park 2 4
14242 14242 14241 {"type": "Polygon", "coordinates": [[[-121.31175, 38.2403], [-121.31174, 38.24169], [-121.31079, 38.24169], [-121.31078, 38.24152], [-121.31041, 38.24152], [-121.31041, 38.24036], [-121.31043, 38.24032], [-121.31047, 38.2403], [-121.31175, 38.2403]]]} Open Access 1 44133 Meadowview Park 22101 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 4.303 Meadowview Park 0 Local Park 2 4
14248 14248 14247 {"type": "Polygon", "coordinates": [[[-121.2979, 38.28722], [-121.29743, 38.28722], [-121.29718, 38.28678], [-121.29688, 38.28635], [-121.29687, 38.2863], [-121.29689, 38.28627], [-121.29711, 38.28618], [-121.29749, 38.28606], [-121.29778, 38.286], [-121.29786, 38.28602], [-121.29787, 38.28605], [-121.29794, 38.28649], [-121.29791, 38.2866], [-121.29792, 38.28715], [-121.2979, 38.28722]]]} Open Access 1 44147 Lake Canyon Park 20878 1407 Galt, City of 623 City 2 City Agency 2 http://www.ci.galt.ca.us/index.aspx?page=71 City 2 1407 Galt, City of 612 City 2 City Agency 2   Sacramento 41 2.16 Lake Canyon 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]);