superunits_with_maps

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

92 rows where MNG_AGENCY = 559

View and edit SQL

MNG_AGENCY

  • Consumnes Community Services District · 92

ACCESS_TYP

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
1231 1230 {"type": "Polygon", "coordinates": [[[-121.36943, 38.44722], [-121.36911, 38.4473], [-121.36882, 38.44745], [-121.36862, 38.44752], [-121.36844, 38.44754], [-121.36794, 38.44755], [-121.36772, 38.44758], [-121.3677, 38.44537], [-121.36942, 38.44537], [-121.36943, 38.44722]]]} Open Access 1 Amundson Park   15463 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 8.563 Amundson Park  
1715 1714 {"type": "Polygon", "coordinates": [[[-121.43142, 38.3814], [-121.43141, 38.38145], [-121.42914, 38.38144], [-121.42914, 38.38117], [-121.42912, 38.38115], [-121.42916, 38.38111], [-121.42917, 38.38105], [-121.42914, 38.38095], [-121.42914, 38.38006], [-121.42917, 38.37995], [-121.42916, 38.3799], [-121.42912, 38.37986], [-121.42914, 38.37984], [-121.42914, 38.37947], [-121.43132, 38.37946], [-121.43138, 38.37948], [-121.4314, 38.37952], [-121.43142, 38.3814]]]} Open Access 1 Backer Park   15752 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 10.773 Backer Park  
1733 1732 {"type": "Polygon", "coordinates": [[[-121.37654, 38.40796], [-121.37501, 38.40797], [-121.37498, 38.40782], [-121.37335, 38.40783], [-121.37335, 38.40729], [-121.37456, 38.40729], [-121.37505, 38.40699], [-121.37572, 38.407], [-121.37574, 38.40698], [-121.37585, 38.40696], [-121.37625, 38.40696], [-121.37626, 38.40752], [-121.37654, 38.40774], [-121.37654, 38.40796]]]} Open Access 1 Baker Park   15767 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 5.456 Baker Park  
1783 1782 {"type": "Polygon", "coordinates": [[[-121.47122, 38.42207], [-121.47055, 38.42258], [-121.4703, 38.42258], [-121.4702, 38.42264], [-121.47006, 38.42265], [-121.46996, 38.42263], [-121.46986, 38.42258], [-121.46961, 38.42257], [-121.46898, 38.42208], [-121.46899, 38.42179], [-121.46917, 38.42176], [-121.46916, 38.42083], [-121.469, 38.42082], [-121.469, 38.42054], [-121.46908, 38.42052], [-121.46914, 38.42049], [-121.47034, 38.42048], [-121.47105, 38.4199], [-121.47111, 38.41993], [-121.47118, 38.41994], [-121.47118, 38.4208], [-121.47102, 38.42082], [-121.47103, 38.42175], [-121.47121, 38.42177], [-121.47122, 38.42207]]]} Open Access 1 Bartholomew Park   15841 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 10.249 Bartholomew Park  
1801 1800 {"type": "Polygon", "coordinates": [[[-121.4245, 38.41885], [-121.42449, 38.41889], [-121.42368, 38.41943], [-121.42327, 38.41898], [-121.42324, 38.41869], [-121.42353, 38.41864], [-121.42368, 38.41859], [-121.42398, 38.41845], [-121.42415, 38.4184], [-121.42426, 38.41839], [-121.4243, 38.41842], [-121.42445, 38.41877], [-121.4245, 38.41885]]]} Open Access 1 Batey Park   15861 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.845 Batey Park  
1898 1897 {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41307], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.41429], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} Open Access 1 Beeman Park   15953 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 3.28 Beeman Park  
1958 1957 {"type": "Polygon", "coordinates": [[[-121.3487, 38.39004], [-121.3487, 38.39008], [-121.34845, 38.39049], [-121.3479, 38.39027], [-121.34783, 38.39028], [-121.34779, 38.39023], [-121.34774, 38.39021], [-121.34763, 38.39021], [-121.3476, 38.39016], [-121.34705, 38.38994], [-121.34715, 38.38984], [-121.34735, 38.38953], [-121.34739, 38.38951], [-121.34747, 38.38951], [-121.34868, 38.39], [-121.3487, 38.39004]]]} Open Access 1 Berens Park   16019 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.922 Berens Park  
1984 1983 {"type": "MultiPolygon", "coordinates": [[[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43667, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43064], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43494, 38.43062], [-121.43971, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]], [[[-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 Betschart Park   16049 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 13.848 Betschart Park  
2200 2199 {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39787], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} Open Access 1 Bradford Park   16325 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.547 Bradford Park  
2681 2680 {"type": "Polygon", "coordinates": [[[-121.43638, 38.42801], [-121.43638, 38.42805], [-121.43624, 38.42824], [-121.43613, 38.42847], [-121.43607, 38.42869], [-121.43432, 38.42814], [-121.43436, 38.42786], [-121.43441, 38.42782], [-121.43443, 38.42776], [-121.43441, 38.42771], [-121.43437, 38.42767], [-121.43431, 38.42739], [-121.4343, 38.42709], [-121.43435, 38.42705], [-121.43437, 38.427], [-121.43435, 38.42695], [-121.43431, 38.42691], [-121.43437, 38.42684], [-121.43486, 38.42685], [-121.4349, 38.42692], [-121.43498, 38.42697], [-121.43509, 38.42698], [-121.43543, 38.42709], [-121.43582, 38.42713], [-121.43586, 38.42715], [-121.43588, 38.42718], [-121.43594, 38.42742], [-121.43602, 38.42757], [-121.43611, 38.4277], [-121.43638, 38.42801]]]} Open Access 1 Case Park   16942 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 6.081 Case Park  
2686 2685 {"type": "Polygon", "coordinates": [[[-121.37703, 38.42161], [-121.377, 38.42169], [-121.37703, 38.42179], [-121.37703, 38.42262], [-121.37624, 38.42262], [-121.37623, 38.42127], [-121.37672, 38.42127], [-121.37673, 38.42145], [-121.37703, 38.42161]]]} Open Access 1 Castello Park   16948 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 2.382 Castello Park  
2705 2704 {"type": "Polygon", "coordinates": [[[-121.45641, 38.41232], [-121.45637, 38.41234], [-121.45607, 38.41261], [-121.45601, 38.41264], [-121.45598, 38.41269], [-121.45598, 38.41275], [-121.45568, 38.41281], [-121.45527, 38.41284], [-121.4552, 38.41222], [-121.45618, 38.41213], [-121.45635, 38.41206], [-121.45638, 38.41206], [-121.45641, 38.41232]]]} Open Access 1 Caterino Park   16972 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.507 Caterino Park  
2800 2799 {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} Open Access 1 Del Meyer Park   18039 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 0.885 Del Meyer Park  
3117 3116 {"type": "Polygon", "coordinates": [[[-121.3967, 38.41621], [-121.3967, 38.4165], [-121.39663, 38.41653], [-121.39659, 38.4166], [-121.3966, 38.41664], [-121.39664, 38.41669], [-121.39661, 38.41672], [-121.3966, 38.41708], [-121.39662, 38.41712], [-121.39653, 38.41715], [-121.39646, 38.41702], [-121.39609, 38.41661], [-121.3958, 38.41635], [-121.39532, 38.41598], [-121.39514, 38.4158], [-121.39498, 38.4156], [-121.39551, 38.41544], [-121.3958, 38.41544], [-121.39586, 38.41553], [-121.39603, 38.4157], [-121.3962, 38.41581], [-121.3962, 38.4162], [-121.3967, 38.41621]]]} Open Access 1 Colton Park   17545 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 2.685 Colton Park  
3343 3342 {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} Open Access 1 Fite Park   18926 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 4.4 Fite Park  
3461 3460 {"type": "Polygon", "coordinates": [[[-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], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453]]]} Open Access 1 Davis Park   17953 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 0.997 Davis Park  
3874 3873 {"type": "Polygon", "coordinates": [[[-121.44981, 38.40281], [-121.44976, 38.40285], [-121.44971, 38.40321], [-121.44966, 38.40335], [-121.44964, 38.40338], [-121.44958, 38.40339], [-121.44926, 38.40328], [-121.44895, 38.40314], [-121.44877, 38.40304], [-121.44846, 38.40281], [-121.44838, 38.40279], [-121.44864, 38.40261], [-121.44859, 38.40249], [-121.44886, 38.40233], [-121.44896, 38.40244], [-121.44915, 38.40258], [-121.44941, 38.40274], [-121.44981, 38.40281]]]} Open Access 1 Ehrhardt Oaks Park   18470 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.749 Ehrhardt Oaks Park  
3939 3938 {"type": "Polygon", "coordinates": [[[-121.38042, 38.39718], [-121.37979, 38.39739], [-121.3716, 38.39746], [-121.37156, 38.38687], [-121.37157, 38.38683], [-121.37159, 38.3868], [-121.37166, 38.38678], [-121.37171, 38.3868], [-121.37191, 38.387], [-121.3731, 38.38823], [-121.37592, 38.39121], [-121.37624, 38.39157], [-121.37632, 38.39172], [-121.37658, 38.39199], [-121.37933, 38.39571], [-121.37925, 38.39598], [-121.37939, 38.39617], [-121.37984, 38.3964], [-121.38042, 38.39718]]]} Open Access 1 Elk Grove Park   18562 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 123.144 Elk Grove Park  
4168 4167 {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} Open Access 1 Fales Park   18830 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 1.212 Fales Park  
4198 4197 {"type": "Polygon", "coordinates": [[[-121.38669, 38.41831], [-121.38668, 38.41952], [-121.38566, 38.41969], [-121.38543, 38.4197], [-121.38524, 38.41969], [-121.3854, 38.41902], [-121.3854, 38.41831], [-121.38669, 38.41831]]]} Open Access 1 Feickert Park   18864 2194 Consumnes Community Services District 559 Special District 4 Community Services District 17 http://www.yourcsd.com/parks/parks_list.asp Special District 4 4.177 Feickert Park  

Next page

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]);
Powered by Datasette · Query took 55.26ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette