units_with_maps

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

94 rows where MNG_AGENCY = 559

View and edit SQL

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER

MNG_AGENCY

  • Consumnes Community Services District · 94

ACCESS_TYP

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
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
3559 3558 {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41306], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.4143], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} Open Access 1 28336 Beeman Park 15953 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 3.279 Beeman Park 0 Local Park 2 4
3573 3572 {"type": "Polygon", "coordinates": [[[-121.47927, 38.41104], [-121.47989, 38.41113], [-121.48031, 38.41123], [-121.48033, 38.41127], [-121.48024, 38.4115], [-121.48019, 38.41184], [-121.48013, 38.41186], [-121.47927, 38.41181], [-121.4793, 38.41153], [-121.47923, 38.41133], [-121.47927, 38.41104]]]} Open Access 1 29068 Perez Park 23609 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 1.695 Perez Park 0 Local Park 2 4
4113 4112 {"type": "Polygon", "coordinates": [[[-121.35944, 38.41534], [-121.35944, 38.41627], [-121.35395, 38.4163], [-121.35405, 38.41543], [-121.35476, 38.41527], [-121.35481, 38.41533], [-121.35488, 38.41536], [-121.35506, 38.41534], [-121.35521, 38.41534], [-121.35561, 38.41539], [-121.35677, 38.41575], [-121.35699, 38.4158], [-121.35723, 38.41581], [-121.35761, 38.41578], [-121.35793, 38.41569], [-121.35821, 38.41554], [-121.35845, 38.41534], [-121.35944, 38.41534]]]} Open Access 1 47113 Hill Park 30784 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 10.163 Hill Park 0 Local Park 2 4
4119 4118 {"type": "Polygon", "coordinates": [[[-121.44987, 38.38318], [-121.44957, 38.38321], [-121.44957, 38.38325], [-121.44874, 38.38344], [-121.44865, 38.38316], [-121.44852, 38.38313], [-121.44851, 38.38306], [-121.44844, 38.38301], [-121.44847, 38.38295], [-121.44837, 38.38269], [-121.44834, 38.38265], [-121.44897, 38.38231], [-121.44906, 38.38231], [-121.44938, 38.38266], [-121.44936, 38.38267], [-121.44938, 38.3827], [-121.44941, 38.38269], [-121.44987, 38.38318]]]} Open Access 1 47127 Buscher Park 30804 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 http://www.yourcsd.com/566/Buscher-Park Sacramento 41 2.298 Buscher Park 0 Local Park 2 4
4120 4119 {"type": "Polygon", "coordinates": [[[-121.34852, 38.45076], [-121.34777, 38.45075], [-121.34771, 38.45079], [-121.34766, 38.45076], [-121.34759, 38.45076], [-121.3475, 38.4508], [-121.34748, 38.45083], [-121.34747, 38.45088], [-121.34728, 38.45088], [-121.34721, 38.45087], [-121.3474, 38.45018], [-121.34742, 38.45018], [-121.34742, 38.45023], [-121.34746, 38.45028], [-121.34757, 38.45031], [-121.34765, 38.45028], [-121.34774, 38.4502], [-121.34787, 38.45017], [-121.34809, 38.45015], [-121.34854, 38.45016], [-121.34857, 38.4502], [-121.34854, 38.45042], [-121.34852, 38.45076]]]} Open Access 1 47128 Jordan Family Park 30805 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 http://www.yourcsd.com/604/Jordan-Family-Park Sacramento 41 1.741 Jordan Family Park 0 Local Park 2 4
4121 4120 {"type": "Polygon", "coordinates": [[[-121.41262, 38.4028], [-121.41282, 38.40283], [-121.41295, 38.40288], [-121.41306, 38.40295], [-121.41315, 38.40303], [-121.41321, 38.40313], [-121.41324, 38.4033], [-121.41322, 38.40341], [-121.41318, 38.40351], [-121.41305, 38.40365], [-121.41294, 38.40371], [-121.41282, 38.40376], [-121.41261, 38.40379], [-121.4124, 38.40376], [-121.41228, 38.40371], [-121.41217, 38.40364], [-121.41208, 38.40355], [-121.41202, 38.40345], [-121.41199, 38.40329], [-121.412, 38.40318], [-121.41205, 38.40308], [-121.41217, 38.40294], [-121.41228, 38.40287], [-121.41241, 38.40283], [-121.41262, 38.4028]]]} Open Access 1 47129 Constellation Park 30806 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 http://www.yourcsd.com/586/Constellation-Park Sacramento 41 2.307 Constellation Park 0 Local Park 2 4
4122 4121 {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} Open Access 1 47130 Harris Ranch Park 30807 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 0.311 Harris Ranch Park 0 Local Park 2 4
11737 11736 {"type": "Polygon", "coordinates": [[[-121.3624, 38.41993], [-121.3624, 38.42089], [-121.36205, 38.4209], [-121.36201, 38.42086], [-121.36188, 38.42039], [-121.36186, 38.4202], [-121.36186, 38.41995], [-121.3624, 38.41993]]]} Open Access 1 24063 Van Doren Park 26826 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 1.115 Van Doren Park 0 Local Park 2 4
11750 11749 {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44858], [-121.37318, 38.44904], [-121.37268, 38.44903], [-121.37246, 38.44899], [-121.37241, 38.44896], [-121.37244, 38.44875], [-121.37243, 38.44837], [-121.37309, 38.44836], [-121.37309, 38.44841], [-121.37312, 38.44846], [-121.3732, 38.44851]]]} Open Access 1 24043 Gage Park 19170 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 1.148 Gage Park 0 Local Park 2 4
11751 11750 {"type": "Polygon", "coordinates": [[[-121.35789, 38.44863], [-121.35783, 38.44864], [-121.35668, 38.44864], [-121.35664, 38.4486], [-121.35664, 38.44812], [-121.35783, 38.44803], [-121.35789, 38.44863]]]} Open Access 1 24044 Perry Park 23615 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 1.657 Perry Park 0 Local Park 2 4
11752 11751 {"type": "Polygon", "coordinates": [[[-121.37676, 38.44496], [-121.37635, 38.44544], [-121.37599, 38.44529], [-121.37572, 38.44522], [-121.37544, 38.44519], [-121.37541, 38.44517], [-121.37539, 38.44514], [-121.3754, 38.44476], [-121.376, 38.44477], [-121.37675, 38.4449], [-121.37676, 38.44496]]]} Open Access 1 24045 Hrepich Park 20128 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 1.488 Hrepich Park 0 Local Park 2 4
11753 11752 {"type": "Polygon", "coordinates": [[[-121.37143, 38.44052], [-121.36803, 38.44054], [-121.36802, 38.43895], [-121.36868, 38.43893], [-121.36868, 38.4382], [-121.37135, 38.43818], [-121.3714, 38.43819], [-121.37143, 38.43822], [-121.37144, 38.43825], [-121.37142, 38.43839], [-121.37143, 38.44052]]]} Open Access 1 24046 Rau Park 24197 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 17.845 Rau Park 0 Local Park 2 4
11754 11753 {"type": "Polygon", "coordinates": [[[-121.43863, 38.43772], [-121.43838, 38.43792], [-121.43823, 38.43809], [-121.43811, 38.43825], [-121.43804, 38.43825], [-121.43772, 38.43819], [-121.43758, 38.43818], [-121.43758, 38.43792], [-121.4376, 38.43791], [-121.4376, 38.43763], [-121.43807, 38.43763], [-121.43828, 38.43757], [-121.43842, 38.4375], [-121.43863, 38.43772]]]} Open Access 1 24047 Rose Park 24615 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 1.188 Rose Park 0 Local Park 2 4
11755 11754 {"type": "Polygon", "coordinates": [[[-121.3936, 38.43618], [-121.39359, 38.43719], [-121.39325, 38.4371], [-121.39304, 38.4371], [-121.39283, 38.43713], [-121.39241, 38.43713], [-121.39262, 38.43683], [-121.39273, 38.43665], [-121.3928, 38.43643], [-121.39284, 38.43623], [-121.39287, 38.43619], [-121.3936, 38.43618]]]} Open Access 1 24048 Lombardi Park 21412 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.047 Lombardi Park 0 Local Park 2 4
11756 11755 {"type": "Polygon", "coordinates": [[[-121.37829, 38.43358], [-121.37803, 38.43438], [-121.37725, 38.4342], [-121.37708, 38.43413], [-121.37698, 38.43406], [-121.3769, 38.43397], [-121.37684, 38.43389], [-121.37674, 38.43366], [-121.37659, 38.4335], [-121.37687, 38.43332], [-121.37689, 38.43317], [-121.37718, 38.43323], [-121.37788, 38.43349], [-121.37829, 38.43358]]]} Open Access 1 24049 Mix Park 22333 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.924 Mix Park 0 Local Park 2 4
11757 11756 {"type": "Polygon", "coordinates": [[[-121.42936, 38.43427], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453], [-121.42935, 38.43456], [-121.42833, 38.43455], [-121.42829, 38.43454], [-121.42826, 38.43451], [-121.42826, 38.43426], [-121.42828, 38.43405], [-121.42867, 38.43409], [-121.42881, 38.43413], [-121.42894, 38.43423], [-121.42903, 38.43435], [-121.42936, 38.43427]]]} Open Access 1 24050 Davis Park 17953 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 0.996 Davis Park 0 Local Park 2 4
11758 11757 {"type": "Polygon", "coordinates": [[[-121.42469, 38.4338], [-121.42405, 38.4338], [-121.42403, 38.43382], [-121.42397, 38.43381], [-121.42389, 38.43382], [-121.42386, 38.4338], [-121.42355, 38.4338], [-121.42354, 38.43312], [-121.42461, 38.43311], [-121.42466, 38.43313], [-121.42468, 38.43315], [-121.42469, 38.4338]]]} Open Access 1 24051 Herburger Park 19831 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 1.877 Herburger Park 0 Local Park 2 4
11759 11758 {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} Open Access 1 24052 Betschart Park 16049 316 Sacramento, County of 550 County 3 County Agency 3 http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx County 3 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17   Sacramento 41 0.634 Betschart Park 0 Local Park 2 4
11760 11759 {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40818, 38.42942], [-121.40814, 38.42949], [-121.40814, 38.42959], [-121.40833, 38.42983], [-121.40831, 38.43019], [-121.408, 38.43026], [-121.40767, 38.4304], [-121.40752, 38.4305], [-121.40738, 38.43061], [-121.40717, 38.43085], [-121.40692, 38.43073], [-121.40672, 38.43065], [-121.40651, 38.43059], [-121.40622, 38.43053], [-121.40622, 38.43039], [-121.40629, 38.43032], [-121.40632, 38.43021], [-121.40647, 38.43004], [-121.40665, 38.42992], [-121.40813, 38.42927], [-121.40824, 38.42925], [-121.40832, 38.42921], [-121.40841, 38.42928]]]} Open Access 1 24053 Guttridge Park 19575 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 4.174 Guttridge 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]);
Powered by Datasette · Query took 84.765ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette