units_with_maps

Table actions

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

160 rows where COUNTY = 37

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS

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
516 516 515 {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} Open Access 1 25989 Pierini Park 23664 1460 Dos Palos, City of 194 City 2 City Agency 2   City 2 1460 Dos Palos, City of 190 City 2 City Agency 2   Merced 37 3.824 Pierini Park 0 Local Park 2 4
527 527 526 {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} Open Access 1 25990 Des Park 18106 1460 Dos Palos, City of 194 City 2 City Agency 2   City 2 1460 Dos Palos, City of 190 City 2 City Agency 2   Merced 37 0.735 Des Park 0 Local Park 2 4
595 595 594 {"type": "Polygon", "coordinates": [[[-120.70774, 37.37509], [-120.70769, 37.37584], [-120.70689, 37.37578], [-120.70694, 37.37503], [-120.70774, 37.37509]]]} Open Access 1 48788 Singh Park 33511 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 1.459 Singh Park 0 Local Park 2 4
1401 1401 1400 {"type": "Polygon", "coordinates": [[[-120.859, 37.04879], [-120.85833, 37.0488], [-120.85834, 37.04941], [-120.8539, 37.04946], [-120.85391, 37.04617], [-120.85899, 37.04611], [-120.859, 37.04879]]]} Open Access 1 16916 Cemetery 17012 2069 Los Banos Cemetery District 358 Special District 4 Cemetery District 11 http://www.co.merced.ca.us/index.aspx?NID=1329 Special District 4 2069 Los Banos Cemetery District 355 Special District 4 Cemetery District 11   Merced 37 39.929 Cemetery 0 Local Historic or Cultural Area 19 4
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
2060 2060 2059 {"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49733, 37.32619], [-120.49733, 37.32628], [-120.49619, 37.32625], [-120.49612, 37.32633], [-120.49608, 37.32681], [-120.49667, 37.32683], [-120.49656, 37.32703], [-120.49646, 37.32775], [-120.49506, 37.32776], [-120.49478, 37.32773], [-120.49448, 37.32767], [-120.49415, 37.32753], [-120.49257, 37.32679], [-120.49224, 37.32671], [-120.49198, 37.32668], [-120.49227, 37.32645], [-120.4925, 37.32639], [-120.4938, 37.32607], [-120.49499, 37.32599], [-120.49551, 37.3258], [-120.4955, 37.32517], [-120.49477, 37.32497], [-120.49422, 37.32489], [-120.49382, 37.32488], [-120.48924, 37.32491], [-120.48822, 37.32573], [-120.48823, 37.32621], [-120.48701, 37.32619], [-120.48707, 37.325], [-120.4871, 37.32472], [-120.5026, 37.32463]]]} Open Access 1 17183 Fahrens Park 18783 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 49.713 Fahrens Park 0 Local Park 2 4
2061 2061 2060 {"type": "Polygon", "coordinates": [[[-120.48346, 37.28095], [-120.48345, 37.28231], [-120.48218, 37.28228], [-120.48217, 37.28092], [-120.48346, 37.28095]]]} Open Access 1 17190 Flanagan Park 18939 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 4.228 Flanagan Park 0 Local Park 2 4
2069 2069 2068 {"type": "Polygon", "coordinates": [[[-120.45486, 37.32488], [-120.45107, 37.32489], [-120.45114, 37.32226], [-120.45128, 37.32237], [-120.45151, 37.32264], [-120.45184, 37.32277], [-120.45213, 37.32281], [-120.4523, 37.32277], [-120.45322, 37.32263], [-120.45421, 37.32265], [-120.4544, 37.32276], [-120.45458, 37.3229], [-120.45448, 37.32309], [-120.45444, 37.32341], [-120.45433, 37.32358], [-120.45409, 37.32381], [-120.45384, 37.32413], [-120.45368, 37.3244], [-120.45359, 37.32461], [-120.45356, 37.32471], [-120.45367, 37.32477], [-120.45419, 37.32473], [-120.45458, 37.32476], [-120.45486, 37.32488]]]} Open Access 1 17208 Rahilly Park 24073 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 16.515 Rahilly Park 0 Local Park 2 4
2076 2076 2075 {"type": "MultiPolygon", "coordinates": [[[[-120.48446, 37.30559], [-120.48421, 37.306], [-120.48402, 37.30604], [-120.48391, 37.30609], [-120.48365, 37.30627], [-120.4836, 37.30627], [-120.48269, 37.30595], [-120.48317, 37.30512], [-120.48446, 37.30559]]], [[[-120.48598, 37.30615], [-120.48564, 37.30673], [-120.48546, 37.30672], [-120.48514, 37.30663], [-120.48487, 37.3065], [-120.48464, 37.30635], [-120.48448, 37.30608], [-120.4847, 37.30568], [-120.48598, 37.30615]]]]} Open Access 1 17232 Courthouse Square 17719 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 5.112 Courthouse Square 0 Local Park 2 4
2080 2080 2079 {"type": "Polygon", "coordinates": [[[-120.77651, 37.43633], [-120.77555, 37.43632], [-120.77574, 37.43492], [-120.77646, 37.43492], [-120.77651, 37.43633]]]} Open Access 1 17257 Shattuck Park 25374 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 2.867 Shattuck Park 0 Local Park 2 4
2081 2081 2080 {"type": "Polygon", "coordinates": [[[-120.61865, 37.39656], [-120.61343, 37.39659], [-120.61347, 37.39483], [-120.61787, 37.39482], [-120.61845, 37.39525], [-120.61865, 37.39656]]]} Open Access 1 17262 Winton Community Park 27658 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 21.353 Winton Community Park 0 Local Park 2 4
2298 2298 2297 {"type": "Polygon", "coordinates": [[[-120.33032, 37.236], [-120.329, 37.236], [-120.32896, 37.23284], [-120.32958, 37.23283], [-120.32959, 37.23288], [-120.33029, 37.23288], [-120.33032, 37.236]]]} Open Access 1 16928 Plainsburg Cemetery 23766 2111 Plainsburg Cemetery District 507 Special District 4 Cemetery District 11 http://www.co.merced.ca.us/index.aspx?NID=1329 Special District 4 2111 Plainsburg Cemetery District 499 Special District 4 Cemetery District 11   Merced 37 10.119 Plainsburg Cemetery 0 Local Historic or Cultural Area 19 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
2359 2359 2358 {"type": "Polygon", "coordinates": [[[-121.00338, 37.25772], [-121.0023, 37.25798], [-121.00217, 37.25766], [-121.00186, 37.25773], [-121.00157, 37.25702], [-121.00298, 37.25667], [-121.00309, 37.25667], [-121.00319, 37.25669], [-121.00333, 37.25679], [-121.00337, 37.25685], [-121.00338, 37.25691], [-121.00338, 37.25772]]]} Open Access 1 17127 Henry Miller Park 19826 1127 Gustine, City of 516 City 2 City Agency 2 http://www.cityofgustine.com/pView.aspx?id=13859&catid=649 City 2 1127 Gustine, City of 509 City 2 City Agency 2   Merced 37 4.094 Henry Miller Park 0 Local Park 2 4

Next page

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