units_with_maps

Table actions

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

185 rows where MNG_AG_TYP = 17 and YR_EST = 0

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, PARK_URL, COUNTY, GAP_STS

ACCESS_TYP 2

MNG_AG_TYP 1

  • Community Services District · 185 ✖
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
1095 1095 1094 {"type": "Polygon", "coordinates": [[[-121.61579, 37.90931], [-121.61435, 37.90927], [-121.61438, 37.90837], [-121.61578, 37.90838], [-121.61579, 37.90931]]]} Open Access 1 48931 Ravenswood Park 33651 2439 Discovery Bay Community Service District 314 Special District 4 Community Services District 19 https://www.todb.ca.gov/district-services Special District 4 2439 Discovery Bay Community Service District 311 Special District 4 Community Services District 17   Contra Costa 12 3.141 Ravenswood Park 0 Local Park 2 4
1438 1438 1437 {"type": "Polygon", "coordinates": [[[-124.10901, 40.47901], [-124.10855, 40.47903], [-124.10832, 40.47893], [-124.10793, 40.47776], [-124.10611, 40.47501], [-124.10671, 40.47476], [-124.10793, 40.47525], [-124.1085, 40.47611], [-124.10879, 40.47677], [-124.10904, 40.47753], [-124.10909, 40.47838], [-124.10901, 40.47901]]]} Open Access 1 48917 Scotia Fireman's Park 33638 2438 Scotia Community Services District 367 Special District 4 Community Services District 19 http://scotiacsd.com/ Special District 4 2438 Scotia Community Services District 362 Special District 4 Community Services District 17 http://scotiacsd.com/parks-recreation/ Humboldt 45 12.733 Scotia Fireman's Park 0 Local Park 2 4
1498 1498 1497 {"type": "Polygon", "coordinates": [[[-118.07545, 33.79832], [-118.07598, 33.79832], [-118.07615, 33.7983], [-118.07645, 33.79825], [-118.07688, 33.79815], [-118.07702, 33.79839], [-118.07716, 33.79858], [-118.07751, 33.79891], [-118.07806, 33.79937], [-118.07807, 33.79942], [-118.07794, 33.79951], [-118.07761, 33.79971], [-118.07704, 33.79992], [-118.07672, 33.8], [-118.07651, 33.80004], [-118.07608, 33.80008], [-118.07541, 33.80008], [-118.07539, 33.80005], [-118.07539, 33.79836], [-118.07541, 33.79833], [-118.07545, 33.79832]]]} Open Access 1 10499 Rossmoor Park 24679 2126 Rossmore Community Services District 376 Special District 4 Community Services District 19 http://www.rossmoor-csd.org/ Special District 4 2126 Rossmore Community Services District 371 Special District 4 Community Services District 17   Orange 3 9.408 Rossmoor Park 0 Local Park 2 4
1666 1666 1665 {"type": "Polygon", "coordinates": [[[-118.08117, 33.78314], [-118.08254, 33.78315], [-118.08258, 33.78316], [-118.08259, 33.78319], [-118.08259, 33.78367], [-118.08259, 33.78448], [-118.08257, 33.78451], [-118.08253, 33.78453], [-118.08161, 33.78453], [-118.08015, 33.78451], [-118.08013, 33.78449], [-118.08015, 33.78316], [-118.08018, 33.78314], [-118.08117, 33.78314]]]} Open Access 1 12584 Rush Park 24734 2126 Rossmore Community Services District 376 Special District 4 Community Services District 19 http://www.rossmoor-csd.org/ Special District 4 2126 Rossmore Community Services District 371 Special District 4 Community Services District 17   Orange 3 8.579 Rush Park 0 Local Park 2 4
1800 1800 1799 {"type": "Polygon", "coordinates": [[[-123.38583, 39.43566], [-123.38562, 39.43602], [-123.38541, 39.43598], [-123.385, 39.43606], [-123.38426, 39.43631], [-123.38279, 39.43476], [-123.38225, 39.43434], [-123.381, 39.43365], [-123.38365, 39.43389], [-123.38526, 39.43448], [-123.38564, 39.43503], [-123.38564, 39.43541], [-123.38583, 39.43566]]]} Open Access 1 48510 OHL Redwood Grove Park 33222 2208 Brooktrails Community Services District 424 Special District 4 Community Services District 19 http://www.btcsd.org/ Special District 4 2208 Brooktrails Community Services District 418 Special District 4 Community Services District 17   Mendocino 24 13.066 OHL Redwood Grove Park 0 Local Park 2 4
2153 2153 2152 {"type": "Polygon", "coordinates": [[[-118.65798, 35.17081], [-118.6578, 35.1709], [-118.65757, 35.17099], [-118.65739, 35.17104], [-118.6569, 35.17114], [-118.65657, 35.17115], [-118.65646, 35.17117], [-118.65636, 35.17116], [-118.65616, 35.17116], [-118.6558, 35.17111], [-118.65549, 35.17103], [-118.65508, 35.17088], [-118.65347, 35.17007], [-118.65369, 35.16978], [-118.65381, 35.16954], [-118.65384, 35.16946], [-118.65404, 35.16856], [-118.65412, 35.16843], [-118.65421, 35.16832], [-118.65439, 35.16818], [-118.65448, 35.16813], [-118.65466, 35.16806], [-118.65572, 35.16787], [-118.65615, 35.16773], [-118.65652, 35.16844], [-118.65688, 35.16867], [-118.65791, 35.16929], [-118.65732, 35.16993], [-118.65798, 35.17081]]]} Open Access 1 16088 Bear Valley Park 15932 2007 Bear Valley Springs Community Services District 487 Special District 4 Community Services District 19 http://www.bvcsd.com/ Special District 4 2007 Bear Valley Springs Community Services District 478 Special District 4 Community Services District 17   Kern 36 25.291 Bear Valley Park 0 Local Park 2 4
2684 2684 2683 {"type": "Polygon", "coordinates": [[[-116.57315, 34.05039], [-116.57313, 34.05043], [-116.57309, 34.05044], [-116.5722, 34.05045], [-116.57219, 34.04877], [-116.57314, 34.04877], [-116.57315, 34.05039]]]} Open Access 1 18236 Covington Park 17726 2086 Morongo Valley Community Services District 543 Special District 4 Community Services District 19 http://www.92256.net/csd/ Special District 4 2086 Morongo Valley Community Services District 536 Special District 4 Community Services District 17   San Bernardino 22 4.048 Covington Park 0 Local Park 2 4
2988 2988 2987 {"type": "Polygon", "coordinates": [[[-121.43784, 38.40364], [-121.43781, 38.40446], [-121.43684, 38.40452], [-121.43668, 38.40452], [-121.43664, 38.40449], [-121.43665, 38.4038], [-121.43784, 38.40364]]]} Open Access 1 24083 Keema Park 20570 2194 Consumnes Community Services District 567 Special District 4 Community Services District 19 http://www.yourcsd.com/parks/parks_list.asp Special District 4 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17   Sacramento 41 2.195 Keema Park 0 Local Park 2 4
2993 2993 2992 {"type": "Polygon", "coordinates": [[[-121.08061, 38.70247], [-121.08014, 38.70268], [-121.07972, 38.70295], [-121.07911, 38.70345], [-121.07912, 38.70276], [-121.07907, 38.70225], [-121.07913, 38.70177], [-121.07908, 38.70147], [-121.07996, 38.7012], [-121.08061, 38.70247]]]} Open Access 1 24120 Weisberg Park 27333 2197 El Dorado Hills Community Service District 568 Special District 4 Community Services District 19 http://www.edhcsd.org/ Special District 4 2197 El Dorado Hills Community Service District 560 Special District 4 Community Services District 17   El Dorado 34 4.833 Weisberg Park 0 Local Park 2 4
3017 3017 3016 {"type": "MultiPolygon", "coordinates": [[[[-120.23169, 38.03773], [-120.23143, 38.03812], [-120.23136, 38.03818], [-120.23149, 38.03796], [-120.23109, 38.03778], [-120.23122, 38.03757], [-120.23169, 38.03773]]], [[[-120.23299, 38.0363], [-120.23278, 38.03631], [-120.23251, 38.03687], [-120.23232, 38.03733], [-120.23214, 38.03757], [-120.23214, 38.03761], [-120.23229, 38.03799], [-120.23232, 38.038], [-120.23233, 38.03806], [-120.23187, 38.03808], [-120.23164, 38.03828], [-120.23146, 38.03828], [-120.23152, 38.03822], [-120.2318, 38.03776], [-120.2319, 38.03747], [-120.2318, 38.03743], [-120.23183, 38.03737], [-120.23177, 38.03733], [-120.23196, 38.03692], [-120.23148, 38.03676], [-120.23144, 38.03663], [-120.23166, 38.03624], [-120.23174, 38.03615], [-120.23178, 38.03613], [-120.23213, 38.03612], [-120.23242, 38.03623], [-120.23299, 38.03609], [-120.23299, 38.0363]]]]} Open Access 1 24322 Eproson Park 32872 2264 Twain Harte Community Services District 574 Special District 4 Community Services District 19 http://www.twainhartecsd.com/ Special District 4 2264 Twain Harte Community Services District 566 Special District 4 Community Services District 17   Tuolumne 21 3.819 Eproson Park 0 Local Park 2 4
3018 3018 3017 {"type": "Polygon", "coordinates": [[[-120.22896, 37.8407], [-120.22786, 37.84097], [-120.22634, 37.84146], [-120.22619, 37.84109], [-120.22604, 37.84066], [-120.22665, 37.8405], [-120.22662, 37.83992], [-120.22722, 37.83984], [-120.22824, 37.83973], [-120.22836, 37.84012], [-120.22861, 37.84009], [-120.22869, 37.84028], [-120.22896, 37.8407]]]} Open Access 1 24323 Mary Laveroni Community Park 21935 2225 Groveland Community Services District 575 Special District 4 Community Services District 19 http://gcsd.org/ Special District 4 2225 Groveland Community Services District 567 Special District 4 Community Services District 17   Tuolumne 21 6.919 Mary Laveroni Community Park 0 Local Park 2 4
3019 3019 3018 {"type": "Polygon", "coordinates": [[[-120.23769, 38.03201], [-120.23715, 38.03226], [-120.237, 38.03217], [-120.23668, 38.03234], [-120.2365, 38.03222], [-120.23722, 38.03183], [-120.23702, 38.03158], [-120.23769, 38.03201]]]} Open Access 1 24324 Twain Harte Tennis Courts 26608 2264 Twain Harte Community Services District 574 Special District 4 Community Services District 19 http://www.twainhartecsd.com/ Special District 4 2264 Twain Harte Community Services District 566 Special District 4 Community Services District 17   Tuolumne 21 0.715 Twain Harte Tennis Courts 0 Local Recreation Area 3 4
3094 3094 3093 {"type": "Polygon", "coordinates": [[[-121.0891, 38.67807], [-121.08906, 38.67816], [-121.08906, 38.6783], [-121.0891, 38.67836], [-121.08909, 38.67867], [-121.08902, 38.67878], [-121.0889, 38.67884], [-121.08828, 38.67885], [-121.08817, 38.67887], [-121.08799, 38.67895], [-121.08788, 38.67891], [-121.08782, 38.67886], [-121.08764, 38.6788], [-121.08755, 38.6788], [-121.08693, 38.67865], [-121.08692, 38.67807], [-121.0891, 38.67807]]]} Open Access 1 25179 Kalithea Park 20547 2197 El Dorado Hills Community Service District 568 Special District 4 Community Services District 19 http://www.edhcsd.org/ Special District 4 2197 El Dorado Hills Community Service District 560 Special District 4 Community Services District 17   El Dorado 34 3.826 Kalithea Park 0 Local Park 2 4
3095 3095 3094 {"type": "Polygon", "coordinates": [[[-121.08995, 38.67612], [-121.08966, 38.67632], [-121.08929, 38.67632], [-121.08942, 38.67575], [-121.08946, 38.67572], [-121.0895, 38.67571], [-121.08958, 38.67574], [-121.08977, 38.67585], [-121.08987, 38.67597], [-121.08995, 38.67612]]]} Open Access 1 25180 Ridgeview 7 Park 24357 2197 El Dorado Hills Community Service District 568 Special District 4 Community Services District 19 http://www.edhcsd.org/ Special District 4 2197 El Dorado Hills Community Service District 560 Special District 4 Community Services District 17   El Dorado 34 0.632 Ridgeview 7 Park 0 Local Park 2 4
3311 3311 3310 {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.0036, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00353, 38.69419], [-121.00327, 38.69372], [-121.00274, 38.6933], [-121.00269, 38.693], [-121.00275, 38.69254], [-121.00265, 38.6919], [-121.0022, 38.69097], [-121.00192, 38.6906], [-121.0019, 38.69021], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.6901], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.6938], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} Open Access 1 29639 Gateway Park 19240 2212 Cameron Park Community Services District 615 Special District 4 Community Services District 19 http://www.cameronpark.org/parks_and_facilities.html Special District 4 2212 Cameron Park Community Services District 604 Special District 4 Community Services District 17   El Dorado 34 13.424 Gateway Park 0 Local Park 2 4
3319 3319 3318 {"type": "MultiPolygon", "coordinates": [[[[-124.16824, 40.85924], [-124.16709, 40.86133], [-124.16528, 40.86127], [-124.15926, 40.86121], [-124.15927, 40.86055], [-124.16009, 40.8591], [-124.16824, 40.85924]]], [[[-124.17983, 40.83876], [-124.17625, 40.84479], [-124.17547, 40.84606], [-124.17116, 40.85399], [-124.16888, 40.85808], [-124.16438, 40.85809], [-124.16426, 40.85767], [-124.16325, 40.85769], [-124.16253, 40.8578], [-124.16234, 40.85708], [-124.16173, 40.85708], [-124.16171, 40.85701], [-124.16406, 40.857], [-124.164, 40.85397], [-124.16796, 40.85399], [-124.16798, 40.84978], [-124.16822, 40.84977], [-124.16816, 40.84801], [-124.16989, 40.84799], [-124.1699, 40.84788], [-124.17062, 40.84787], [-124.17056, 40.84614], [-124.17287, 40.84609], [-124.17275, 40.84247], [-124.17293, 40.84245], [-124.17281, 40.83882], [-124.17788, 40.83876], [-124.17983, 40.83876]]]]} Open Access 1 29677 Manila Dunes Recreation Area 6209 2319 Manila Community Services District 618 Special District 4 Community Services District 19 http://www.manilacsd.com/ Special District 4 2319 Manila Community Services District 607 Special District 4 Community Services District 17 http://www.friendsofthedunes.org/resources/ Humboldt 45 265.033 Manila Dunes Rec. Area 0 Local Recreation Area 3 4
3321 3321 3320 {"type": "Polygon", "coordinates": [[[-124.16247, 40.85177], [-124.16166, 40.85293], [-124.16151, 40.85317], [-124.15946, 40.85236], [-124.15859, 40.852], [-124.15866, 40.85177], [-124.15859, 40.8514], [-124.15856, 40.85106], [-124.15866, 40.85071], [-124.15889, 40.85049], [-124.15943, 40.85029], [-124.16022, 40.85014], [-124.16032, 40.85011], [-124.16004, 40.85044], [-124.16002, 40.85068], [-124.16191, 40.85144], [-124.162, 40.85158], [-124.16247, 40.85177]]]} Open Access 1 29679 Manila Community Park 21749 2319 Manila Community Services District 618 Special District 4 Community Services District 19 http://www.manilacsd.com/ Special District 4 2319 Manila Community Services District 607 Special District 4 Community Services District 17   Humboldt 45 15.038 Manila Community Park 0 Local Park 2 4
3345 3345 3344 {"type": "Polygon", "coordinates": [[[-121.10145, 38.69128], [-121.10119, 38.69131], [-121.10095, 38.69131], [-121.1009, 38.6913], [-121.10073, 38.69131], [-121.1003, 38.69125], [-121.09981, 38.6911], [-121.0995, 38.69094], [-121.09923, 38.69073], [-121.09909, 38.69062], [-121.09902, 38.69053], [-121.09887, 38.69061], [-121.09794, 38.69096], [-121.09783, 38.69073], [-121.09782, 38.69058], [-121.09788, 38.69043], [-121.09815, 38.69016], [-121.09851, 38.68988], [-121.0986, 38.68968], [-121.10131, 38.68916], [-121.10149, 38.68991], [-121.10145, 38.69128]]]} Open Access 1 24122 Promontory Community Park 24016 2197 El Dorado Hills Community Service District 568 Special District 4 Community Services District 19 http://www.edhcsd.org/ Special District 4 2197 El Dorado Hills Community Service District 560 Special District 4 Community Services District 17   El Dorado 34 12.49 Promontory Community Park 0 Local Park 2 4
3346 3346 3345 {"type": "Polygon", "coordinates": [[[-120.98121, 38.68838], [-120.9796, 38.68963], [-120.97944, 38.6898], [-120.97775, 38.68919], [-120.98018, 38.68729], [-120.98102, 38.6879], [-120.98092, 38.68806], [-120.9809, 38.68811], [-120.98121, 38.68838]]]} Open Access 1 24123 Rasmussen Park 24190 2212 Cameron Park Community Services District 615 Special District 4 Community Services District 19 http://www.cameronpark.org/parks_and_facilities.html Special District 4 2212 Cameron Park Community Services District 604 Special District 4 Community Services District 17   El Dorado 34 9.847 Rasmussen Park 0 Local Park 2 4
3352 3352 3351 {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} Open Access 1 24241 Larissa Park 21027 2238 McKinleyville Community Services District 624 Special District 4 Community Services District 19 http://mckinleyvillecsd.com/ Special District 4 2238 McKinleyville Community Services District 613 Special District 4 Community Services District 17   Humboldt 45 0.324 Larissa 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]);