units_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)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Atwater, City of · 17 ✖

ACCESS_TYP 1

  • Open Access · 17 ✖
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
2035 2035 2034 {"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 17066 Heller Park 19805 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 0.743 Heller Park 0 Local Park 2 4
2037 2037 2036 {"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 17077 Veterans Park 27037 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 17.116 Veterans Park 0 Local Park 2 4
2324 2324 2323 {"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 17040 Albiani Park 15342 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 5.058 Albiani Park 0 Local Park 2 4
2326 2326 2325 {"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 17043 Atwater Memorial Ball Park 15680 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 3.939 Atwater Memorial Ball Park 0 Local Recreation Area 3 4
2336 2336 2335 {"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 17045 Bloss Mansion 16171 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 1.032 Bloss Mansion   None 197  
2340 2340 2339 {"type": "Polygon", "coordinates": [[[-120.58817, 37.35139], [-120.58803, 37.35234], [-120.58724, 37.35357], [-120.58661, 37.35356], [-120.58664, 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 17063 Faul Park 18853 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 9.972 Faul Park 0 Local Park 2 4
2343 2343 2342 {"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 17072 Osborn Park 23233 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 14.332 Osborn Park 0 Local Park 2 4
2344 2344 2343 {"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 17074 Ralston Park 24105 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 4.66 Ralston Park 0 Local Park 2 4
4526 4526 4525 {"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 17053 Bloss Park 16172 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 0.631 Bloss Park 0 Local Park 2 4
9917 9917 9916 {"type": "Polygon", "coordinates": [[[-120.60208, 37.35563], [-120.60167, 37.35573], [-120.60119, 37.35579], [-120.601, 37.35558], [-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 17060 E L Walter Park 18330 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 2.216 E L Walter Park 0 Local Park 2 4
9928 9928 9927 {"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.59128, 37.37013], [-120.59137, 37.37017], [-120.59145, 37.37017], [-120.5916, 37.37012], [-120.59237, 37.37012]]]} Open Access 1 17069 Manuel Balros Park 21763 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 4.755 Manuel Balros Park 0 Local Park 2 4
9931 9931 9930 {"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 17080 Water Tower Park 27296 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 0.448 Water Tower Park 0 Local Park 2 4
11938 11938 11937 {"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 24554 Girl Scout Hut Park 19302 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 2.203 Girl Scout Hut Park 0 Local Park 2 4
11939 11939 11938 {"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 24555 Powerline Park 23972 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 0.774 Powerline Park 0 Local Park 2 4
11940 11940 11939 {"type": "Polygon", "coordinates": [[[-120.61369, 37.35729], [-120.61302, 37.35729], [-120.61302, 37.35763], [-120.61251, 37.35763], [-120.6125, 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 24556 Sandlewood Park 25018 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 1.761 Sandlewood Park 0 Local Park 2 4
12324 12324 12323 {"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.5721, 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.57211, 37.34018], [-120.57226, 37.34011], [-120.5726, 37.34], [-120.57277, 37.33991], [-120.57279, 37.33992]]]} Open Access 1 25987 Unamed Park 26651 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 1.503 Unamed Park 0 Local Park 2 4
13792 13792 13791 {"type": "Polygon", "coordinates": [[[-120.60175, 37.3593], [-120.60132, 37.35982], [-120.60126, 37.35998], [-120.60081, 37.36], [-120.60081, 37.35938], [-120.59996, 37.35936], [-120.60049, 37.35872], [-120.60085, 37.3589], [-120.60101, 37.35891], [-120.60175, 37.3593]]]} Open Access 1 36357 Atwater holding 2 15679 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 2.533 Atwater holding 2 0 Local Other or Unknown 14 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]);