superunits_with_maps

Table actions

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

17 rows where ACCESS_TYP = 1 and MNG_AGENCY = 463

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 17 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
1438 1438 1437 {"type": "Polygon", "coordinates": [[[-120.58918, 37.34515], [-120.58917, 37.34574], [-120.58912, 37.34686], [-120.58835, 37.34684], [-120.58786, 37.34686], [-120.5876, 37.34684], [-120.58758, 37.34649], [-120.5876, 37.34644], [-120.58761, 37.34609], [-120.58819, 37.34609], [-120.58822, 37.34561], [-120.58823, 37.34513], [-120.58918, 37.34515]]]} Open Access 1 Albiani Park   15342 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 5.063 Albiani Park  
1653 1653 1652 {"type": "Polygon", "coordinates": [[[-120.60175, 37.3593], [-120.60132, 37.35982], [-120.60126, 37.35998], [-120.60081, 37.36], [-120.60081, 37.35939], [-120.59996, 37.35936], [-120.60049, 37.35872], [-120.60085, 37.3589], [-120.60101, 37.35891], [-120.60175, 37.3593]]]} Open Access 1 Atwater holding 2   15679 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 2.538 Atwater holding 2  
1654 1654 1653 {"type": "Polygon", "coordinates": [[[-120.60546, 37.3466], [-120.60475, 37.34779], [-120.60365, 37.34736], [-120.60433, 37.34619], [-120.60546, 37.3466]]]} Open Access 1 Atwater Memorial Ball Park   15680 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 3.938 Atwater Memorial Ball Park  
2063 2063 2062 {"type": "MultiPolygon", "coordinates": [[[[-120.6075, 37.34682], [-120.60734, 37.3471], [-120.60672, 37.34688], [-120.60688, 37.34659], [-120.6075, 37.34682]]], [[[-120.60769, 37.34648], [-120.60753, 37.34676], [-120.60692, 37.34654], [-120.60708, 37.34626], [-120.60769, 37.34648]]]]} Open Access 1 Bloss Mansion   16171 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1.031 Bloss Mansion  
2064 2064 2063 {"type": "Polygon", "coordinates": [[[-120.60725, 37.34726], [-120.60704, 37.34761], [-120.60642, 37.34736], [-120.60662, 37.34704], [-120.60725, 37.34726]]]} Open Access 1 Bloss Park   16172 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 0.631 Bloss Park  
3759 3759 3758 {"type": "Polygon", "coordinates": [[[-120.60208, 37.35563], [-120.60167, 37.35573], [-120.60119, 37.35579], [-120.601, 37.35557], [-120.60082, 37.35544], [-120.60075, 37.3554], [-120.60116, 37.35494], [-120.6014, 37.35464], [-120.60181, 37.35486], [-120.60208, 37.35563]]]} Open Access 1 E L Walter Park   18330 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 2.216 E L Walter Park  
4184 4184 4183 {"type": "Polygon", "coordinates": [[[-120.58817, 37.35139], [-120.58803, 37.35234], [-120.58724, 37.35357], [-120.58661, 37.35356], [-120.58663, 37.35261], [-120.58532, 37.35254], [-120.58534, 37.35248], [-120.58538, 37.35243], [-120.58547, 37.35208], [-120.58551, 37.35134], [-120.58817, 37.35139]]]} Open Access 1 Faul Park   18853 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 9.98 Faul Park  
4571 4571 4570 {"type": "Polygon", "coordinates": [[[-120.6065, 37.35074], [-120.60603, 37.35154], [-120.60511, 37.35118], [-120.60557, 37.35038], [-120.6065, 37.35074]]]} Open Access 1 Girl Scout Hut Park   19302 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 2.203 Girl Scout Hut Park  
5019 5019 5018 {"type": "Polygon", "coordinates": [[[-120.61843, 37.35282], [-120.61826, 37.35311], [-120.61742, 37.3528], [-120.6176, 37.3525], [-120.61843, 37.35282]]]} Open Access 1 Heller Park   19805 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 0.743 Heller Park  
6594 6594 6593 {"type": "Polygon", "coordinates": [[[-120.59237, 37.37012], [-120.59233, 37.37135], [-120.59104, 37.37136], [-120.59075, 37.37119], [-120.59077, 37.37005], [-120.5912, 37.37008], [-120.59129, 37.37013], [-120.59137, 37.37017], [-120.59145, 37.37017], [-120.5916, 37.37012], [-120.59237, 37.37012]]]} Open Access 1 Manuel Balros Park   21763 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 4.755 Manuel Balros Park  
7136 7136 7135 {"type": "Polygon", "coordinates": [[[-120.59553, 37.36756], [-120.59552, 37.36772], [-120.59325, 37.36772], [-120.59325, 37.36758], [-120.59331, 37.36754], [-120.59351, 37.36756], [-120.59388, 37.36766], [-120.59412, 37.36768], [-120.59445, 37.36764], [-120.59479, 37.36753], [-120.59499, 37.3675], [-120.59544, 37.36749], [-120.59553, 37.36756]]]} Open Access 1 Powerline Park   23972 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 0.773 Powerline Park  
7777 7777 7776 {"type": "Polygon", "coordinates": [[[-120.59246, 37.36059], [-120.59241, 37.3635], [-120.59095, 37.36273], [-120.5894, 37.36117], [-120.58928, 37.36074], [-120.58931, 37.3606], [-120.59246, 37.36059]]]} Open Access 1 Osborn Park   23233 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 14.331 Osborn Park  
8488 8488 8487 {"type": "MultiPolygon", "coordinates": [[[[-120.60698, 37.34989], [-120.60658, 37.35059], [-120.60568, 37.35024], [-120.60609, 37.34955], [-120.60698, 37.34989]]], [[[-120.60858, 37.35052], [-120.60819, 37.3512], [-120.60683, 37.35068], [-120.60724, 37.34998], [-120.60858, 37.35052]]]]} Open Access 1 Ralston Park   24105 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 4.659 Ralston Park  
9267 9267 9266 {"type": "Polygon", "coordinates": [[[-120.61369, 37.35729], [-120.61303, 37.35729], [-120.61302, 37.35763], [-120.61251, 37.35763], [-120.61249, 37.3575], [-120.61223, 37.3575], [-120.61207, 37.35711], [-120.61262, 37.35713], [-120.61266, 37.35686], [-120.6128, 37.35687], [-120.61298, 37.35692], [-120.61315, 37.35689], [-120.6132, 37.35694], [-120.61368, 37.35694], [-120.61369, 37.35729]]]} Open Access 1 Sandlewood Park   25018 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1.768 Sandlewood Park  
9276 9276 9275 {"type": "Polygon", "coordinates": [[[-120.57652, 37.35744], [-120.57649, 37.36043], [-120.57413, 37.36044], [-120.57417, 37.35745], [-120.57652, 37.35744]]]} Open Access 1 Veterans Park   27037 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 17.115 Veterans Park  
10550 10550 10549 {"type": "Polygon", "coordinates": [[[-120.57279, 37.33992], [-120.57265, 37.3401], [-120.57267, 37.34039], [-120.57259, 37.3405], [-120.5726, 37.34095], [-120.57249, 37.34105], [-120.5724, 37.34106], [-120.57232, 37.34106], [-120.57227, 37.34104], [-120.57218, 37.34095], [-120.57211, 37.34093], [-120.57203, 37.34095], [-120.57198, 37.341], [-120.5719, 37.3409], [-120.57188, 37.34081], [-120.57192, 37.34054], [-120.57198, 37.34035], [-120.57212, 37.34018], [-120.57226, 37.34011], [-120.57259, 37.34], [-120.57277, 37.33991], [-120.57279, 37.33992]]]} Open Access 1 Unamed Park   26651 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1.503 Unamed Park  
11054 11054 11053 {"type": "Polygon", "coordinates": [[[-120.61346, 37.35119], [-120.61287, 37.35095], [-120.61316, 37.35044], [-120.61316, 37.35044], [-120.61346, 37.35119]]]} Open Access 1 Water Tower Park   27296 1014 Atwater, City of 463 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 0.448 Water Tower Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);