units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 494 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
DES_TP 4
- Local Park 34
- Local Recreation Area 5
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Southgate Recreation and Park District · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11714 | 11714 | 11713 | {"type": "Polygon", "coordinates": [[[-121.45645, 38.53704], [-121.45645, 38.53736], [-121.45555, 38.53735], [-121.45555, 38.53704], [-121.45645, 38.53704]]]} | Open Access 1 | 24010 | Jack W. Davis Park | 20312 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.684 | Jack W. Davis Park | 0 | Local Park 2 | 4 | |
11718 | 11718 | 11717 | {"type": "Polygon", "coordinates": [[[-121.44673, 38.5137], [-121.44636, 38.5137], [-121.44636, 38.51283], [-121.44672, 38.51283], [-121.44673, 38.5137]]]} | Open Access 1 | 24014 | Fountain Plaza Park | 19022 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.772 | Fountain Plaza Park | 0 | Local Park 2 | 4 | |
4029 | 4029 | 4028 | {"type": "Polygon", "coordinates": [[[-121.36424, 38.46455], [-121.36352, 38.46455], [-121.36364, 38.46426], [-121.36351, 38.46422], [-121.36365, 38.46387], [-121.36365, 38.46358], [-121.36401, 38.46357], [-121.36406, 38.46361], [-121.36408, 38.46382], [-121.36413, 38.46403], [-121.3643, 38.46449], [-121.36429, 38.46453], [-121.36424, 38.46455]]]} | Open Access 1 | 44161 | Caymus Park | 16983 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.303 | Caymus Park | 0 | Local Park 2 | 4 | |
11739 | 11739 | 11738 | {"type": "Polygon", "coordinates": [[[-121.40509, 38.47026], [-121.40506, 38.4703], [-121.40501, 38.47032], [-121.4039, 38.47032], [-121.40385, 38.47031], [-121.40383, 38.47028], [-121.40382, 38.47003], [-121.40418, 38.47002], [-121.40418, 38.46973], [-121.40509, 38.46972], [-121.40509, 38.47026]]]} | Open Access 1 | 24031 | Willowood Park | 27593 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.53 | Willowood Park | 0 | Local Park 2 | 4 | |
11741 | 11741 | 11740 | {"type": "Polygon", "coordinates": [[[-121.38663, 38.46532], [-121.38661, 38.46533], [-121.38661, 38.46559], [-121.38657, 38.46562], [-121.38653, 38.46568], [-121.38654, 38.46574], [-121.38658, 38.46578], [-121.38641, 38.46592], [-121.38585, 38.46606], [-121.38558, 38.46532], [-121.3859, 38.46532], [-121.38648, 38.46505], [-121.38654, 38.46507], [-121.38662, 38.46507], [-121.38663, 38.46532]]]} | Open Access 1 | 24033 | Cottonwood Park | 17692 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.648 | Cottonwood Park | 0 | Local Park 2 | 4 | |
11749 | 11749 | 11748 | {"type": "Polygon", "coordinates": [[[-121.36203, 38.45362], [-121.36203, 38.45434], [-121.362, 38.45438], [-121.36174, 38.45448], [-121.36168, 38.45444], [-121.36088, 38.45376], [-121.36073, 38.4536], [-121.36203, 38.45362]]]} | Open Access 1 | 24042 | Vineyard Park | 27139 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.66 | Vineyard Park | 0 | Local Park 2 | 4 | |
11740 | 11740 | 11739 | {"type": "Polygon", "coordinates": [[[-121.36573, 38.47003], [-121.36487, 38.47003], [-121.36487, 38.46908], [-121.36488, 38.46905], [-121.36492, 38.46903], [-121.36572, 38.46903], [-121.36573, 38.47003]]]} | Open Access 1 | 24032 | Carlisle Woods Park | 16857 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.053 | Carlisle Woods Park | 0 | Local Park 2 | 4 | |
9785 | 9785 | 9784 | {"type": "Polygon", "coordinates": [[[-121.31037, 38.47068], [-121.31044, 38.47071], [-121.3105, 38.4709], [-121.31049, 38.47177], [-121.31046, 38.47182], [-121.31031, 38.47181], [-121.3101, 38.47176], [-121.30978, 38.47163], [-121.3095, 38.47145], [-121.30927, 38.47122], [-121.30927, 38.47117], [-121.3093, 38.47115], [-121.31037, 38.47068]]]} | Open Access 1 | 47907 | Little Hawke Park | 32000 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.12 | Little Hawke Park | 0 | Local Park 2 | 4 | |
11724 | 11724 | 11723 | {"type": "Polygon", "coordinates": [[[-121.44822, 38.49495], [-121.4482, 38.49517], [-121.44786, 38.49499], [-121.44687, 38.49483], [-121.44598, 38.49481], [-121.44504, 38.49472], [-121.44491, 38.49465], [-121.44535, 38.49428], [-121.44562, 38.49428], [-121.44583, 38.4941], [-121.44645, 38.49453], [-121.44665, 38.49463], [-121.44686, 38.49472], [-121.44727, 38.49483], [-121.44822, 38.49495]]]} | Open Access 1 | 24019 | Crowfoot Park | 17834 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.127 | Crowfoot Park | 0 | Local Park 2 | 4 | |
11717 | 11717 | 11716 | {"type": "Polygon", "coordinates": [[[-121.4637, 38.51495], [-121.46371, 38.51497], [-121.4644, 38.51497], [-121.46446, 38.515], [-121.46447, 38.51503], [-121.46448, 38.51563], [-121.46446, 38.51568], [-121.4644, 38.5157], [-121.4637, 38.51571], [-121.46369, 38.51573], [-121.4633, 38.51573], [-121.46309, 38.51534], [-121.46327, 38.51533], [-121.46327, 38.51495], [-121.4637, 38.51495]]]} | Open Access 1 | 24013 | Rainbow Park | 24091 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.229 | Rainbow Park | 0 | Local Park 2 | 4 | |
11727 | 11727 | 11726 | {"type": "Polygon", "coordinates": [[[-121.45147, 38.49244], [-121.45145, 38.49257], [-121.4512, 38.49261], [-121.45027, 38.49262], [-121.44975, 38.49267], [-121.44968, 38.49264], [-121.44966, 38.49254], [-121.44967, 38.49243], [-121.4497, 38.49232], [-121.44982, 38.49217], [-121.44993, 38.49209], [-121.45069, 38.49164], [-121.45147, 38.49244]]]} | Open Access 1 | 24022 | Royal Park | 24717 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.719 | Royal Park | 0 | Local Park 2 | 4 | |
11734 | 11734 | 11733 | {"type": "Polygon", "coordinates": [[[-121.38473, 38.47813], [-121.38438, 38.47832], [-121.38416, 38.47851], [-121.38395, 38.47878], [-121.38388, 38.47893], [-121.38382, 38.47911], [-121.3834, 38.47904], [-121.3834, 38.4783], [-121.38308, 38.47836], [-121.38305, 38.47832], [-121.38301, 38.47828], [-121.38288, 38.47826], [-121.38288, 38.47802], [-121.38233, 38.47802], [-121.38227, 38.47773], [-121.38243, 38.47769], [-121.38257, 38.47764], [-121.38282, 38.47751], [-121.38303, 38.47758], [-121.38289, 38.47787], [-121.38289, 38.47789], [-121.38339, 38.47794], [-121.3834, 38.4779], [-121.38455, 38.47791], [-121.38473, 38.47813]]]} | Open Access 1 | 24029 | Southwoods Park | 25705 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.493 | Southwoods Park | 0 | Local Park 2 | 4 | |
11721 | 11721 | 11720 | {"type": "Polygon", "coordinates": [[[-121.41738, 38.50033], [-121.41737, 38.5009], [-121.41656, 38.50089], [-121.41623, 38.50091], [-121.41596, 38.50113], [-121.41545, 38.50113], [-121.41544, 38.50076], [-121.41547, 38.50068], [-121.41544, 38.50058], [-121.41543, 38.49992], [-121.41595, 38.49992], [-121.41596, 38.5003], [-121.41738, 38.50033]]]} | Open Access 1 | 24017 | Kennedy Park | 20603 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.562 | Kennedy Park | 0 | Local Park 2 | 4 | |
3502 | 3502 | 3501 | {"type": "MultiPolygon", "coordinates": [[[[-121.38155, 38.45546], [-121.38133, 38.45552], [-121.38115, 38.45563], [-121.38102, 38.45578], [-121.38096, 38.45595], [-121.38097, 38.45515], [-121.38053, 38.45511], [-121.38059, 38.45505], [-121.3806, 38.45497], [-121.38057, 38.45493], [-121.38053, 38.45491], [-121.38047, 38.4549], [-121.38041, 38.4549], [-121.38041, 38.45474], [-121.38085, 38.45497], [-121.38115, 38.45506], [-121.3814, 38.45506], [-121.38155, 38.45546]]], [[[-121.38319, 38.45988], [-121.38277, 38.45988], [-121.38264, 38.4596], [-121.38272, 38.45954], [-121.38274, 38.45948], [-121.3827, 38.45937], [-121.3827, 38.45913], [-121.38268, 38.45901], [-121.38261, 38.45886], [-121.38245, 38.45861], [-121.38238, 38.45845], [-121.38224, 38.45784], [-121.38214, 38.45762], [-121.38195, 38.4573], [-121.38188, 38.45714], [-121.38182, 38.45694], [-121.38176, 38.45661], [-121.38171, 38.45649], [-121.38156, 38.45622], [-121.38155, 38.45617], [-121.38155, 38.4561], [-121.38154, 38.45606], [-121.38149, 38.45601], [-121.3814, 38.456], [-121.38131, 38.45603], [-121.38128, 38.45611], [-121.38109, 38.45611], [-121.38109, 38.45594], [-121.38113, 38.45583], [-121.38123, 38.4557], [-121.38135, 38.45562], [-121.38148, 38.45558], [-121.38159, 38.45557], [-121.38319, 38.45988]]]]} | Open Access 1 | 36025 | Danbury Parkway | 17917 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.905 | Danbury Parkway | 0 | Local Recreation Area 3 | 4 | |
11728 | 11728 | 11727 | {"type": "Polygon", "coordinates": [[[-121.43545, 38.49234], [-121.43446, 38.49233], [-121.43438, 38.4923], [-121.4343, 38.49084], [-121.43543, 38.49084], [-121.43545, 38.49234]]]} | Open Access 1 | 24023 | Jose P Rizal Comm. Center | 20492 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.915 | Jose P Rizal Comm. Ctr. | 0 | Local Recreation Area 3 | 4 | |
9801 | 9801 | 9800 | {"type": "Polygon", "coordinates": [[[-121.37598, 38.47607], [-121.37594, 38.47623], [-121.37594, 38.47651], [-121.37591, 38.47673], [-121.3759, 38.47727], [-121.37588, 38.47732], [-121.37583, 38.47733], [-121.3749, 38.47733], [-121.37466, 38.47735], [-121.37462, 38.47733], [-121.37451, 38.47719], [-121.37432, 38.47701], [-121.37433, 38.47696], [-121.37449, 38.47679], [-121.37468, 38.47651], [-121.37478, 38.47621], [-121.3748, 38.4761], [-121.37479, 38.47602], [-121.37516, 38.47603], [-121.37546, 38.47606], [-121.37598, 38.47607]]]} | Open Access 1 | 47908 | Tamarindo Park | 32001 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.11 | Tamarindo Park | 0 | Local Park 2 | 4 | |
2246 | 2246 | 2245 | {"type": "Polygon", "coordinates": [[[-121.33204, 38.46376], [-121.33196, 38.46381], [-121.33192, 38.46388], [-121.33192, 38.46393], [-121.33195, 38.46402], [-121.33195, 38.46443], [-121.33194, 38.46446], [-121.3319, 38.46448], [-121.33169, 38.46449], [-121.33126, 38.46455], [-121.33095, 38.46455], [-121.33077, 38.46453], [-121.33071, 38.46454], [-121.33064, 38.46459], [-121.33061, 38.46464], [-121.3306, 38.46469], [-121.33028, 38.46469], [-121.33027, 38.46527], [-121.33022, 38.46521], [-121.33022, 38.46349], [-121.33204, 38.46348], [-121.33204, 38.46376]]]} | Open Access 1 | 47905 | Bradshaw Vineyards Park | 31991 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/parks-a-facilities/parks-information.html | Sacramento 41 | 4.59 | Bradshaw Vineyards Park | 0 | Local Park 2 | 4 |
11745 | 11745 | 11744 | {"type": "Polygon", "coordinates": [[[-121.3844, 38.45687], [-121.38428, 38.45693], [-121.38383, 38.45695], [-121.38348, 38.45707], [-121.38347, 38.45965], [-121.38194, 38.45553], [-121.38217, 38.45547], [-121.38219, 38.45568], [-121.38225, 38.4559], [-121.38258, 38.45677], [-121.38259, 38.45689], [-121.38265, 38.45695], [-121.38275, 38.45697], [-121.38285, 38.45694], [-121.38287, 38.45694], [-121.38291, 38.45691], [-121.38313, 38.45685], [-121.384, 38.45652], [-121.38405, 38.45651], [-121.38409, 38.45653], [-121.3844, 38.45687]]]} | Open Access 1 | 24038 | Hardester Park | 19674 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.804 | Hardester Park | 0 | Local Park 2 | 4 | |
11738 | 11738 | 11737 | {"type": "Polygon", "coordinates": [[[-121.3995, 38.47407], [-121.39941, 38.47407], [-121.39939, 38.47307], [-121.39876, 38.47307], [-121.39876, 38.47407], [-121.39739, 38.47408], [-121.39733, 38.47406], [-121.3973, 38.47402], [-121.39729, 38.47356], [-121.39727, 38.47329], [-121.39726, 38.47286], [-121.39727, 38.47283], [-121.39733, 38.4728], [-121.3981, 38.47278], [-121.39887, 38.47267], [-121.39902, 38.47268], [-121.39912, 38.47263], [-121.39916, 38.47256], [-121.39949, 38.47256], [-121.3995, 38.47407]]]} | Open Access 1 | 24030 | Norman Waters Park | 22799 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.661 | Norman Waters Park | 0 | Local Park 2 | 4 | |
11743 | 11743 | 11742 | {"type": "Polygon", "coordinates": [[[-121.39967, 38.46301], [-121.39954, 38.46311], [-121.39947, 38.46347], [-121.39762, 38.46348], [-121.39765, 38.46193], [-121.39833, 38.46206], [-121.39877, 38.46208], [-121.39889, 38.46224], [-121.39911, 38.46246], [-121.39936, 38.46276], [-121.39967, 38.46301]]]} | Open Access 1 | 24035 | Toby Johnson Park | 26382 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.704 | Toby Johnson Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);