units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2, LAYER = 4 and MNG_AGENCY = 494
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Southgate Recreation and Park District · 34 ✖
DES_TP 1
- Local Park · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
4067 | 4067 | 4066 | {"type": "Polygon", "coordinates": [[[-121.45978, 38.51394], [-121.45866, 38.51395], [-121.45865, 38.51401], [-121.45764, 38.51401], [-121.45764, 38.5122], [-121.45977, 38.5122], [-121.45978, 38.51394]]]} | Restricted Access 2 | 44414 | Pacific Park | 23303 | 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 | 9.079 | Pacific 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 | |
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 | |
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 | |
11715 | 11715 | 11714 | {"type": "Polygon", "coordinates": [[[-121.4614, 38.52133], [-121.46141, 38.52418], [-121.4614, 38.52477], [-121.46005, 38.52477], [-121.46005, 38.52331], [-121.45976, 38.52331], [-121.45944, 38.52306], [-121.46004, 38.52256], [-121.46004, 38.52166], [-121.46068, 38.52166], [-121.46069, 38.52133], [-121.4614, 38.52133]]]} | Open Access 1 | 24011 | Fruitridge Park | 19136 | 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 | 11.323 | Fruitridge 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 | |
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 | |
11719 | 11719 | 11718 | {"type": "Polygon", "coordinates": [[[-121.46013, 38.50773], [-121.45932, 38.50773], [-121.45933, 38.50852], [-121.45855, 38.50763], [-121.45817, 38.50721], [-121.45703, 38.50611], [-121.45794, 38.50611], [-121.4579, 38.50626], [-121.45791, 38.50632], [-121.45798, 38.5064], [-121.45808, 38.50643], [-121.45815, 38.50643], [-121.4583, 38.50639], [-121.4593, 38.50638], [-121.45931, 38.5068], [-121.46012, 38.5068], [-121.46013, 38.50773]]]} | Open Access 1 | 24015 | Bowling Green Park | 16311 | 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 | 7.158 | Bowling Green Park | 0 | Local Park 2 | 4 | |
11720 | 11720 | 11719 | {"type": "Polygon", "coordinates": [[[-121.45236, 38.50609], [-121.45235, 38.50799], [-121.45071, 38.50798], [-121.4507, 38.50793], [-121.45045, 38.50745], [-121.45071, 38.50744], [-121.45071, 38.50554], [-121.45232, 38.50554], [-121.45232, 38.50584], [-121.45234, 38.50587], [-121.4523, 38.50591], [-121.45229, 38.50595], [-121.45236, 38.50609]]]} | Open Access 1 | 24016 | Nicholas Park | 22745 | 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 | 9.739 | Nicholas 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 | |
11723 | 11723 | 11722 | {"type": "Polygon", "coordinates": [[[-121.39517, 38.49733], [-121.39516, 38.49734], [-121.39516, 38.498], [-121.39302, 38.498], [-121.39302, 38.49675], [-121.39361, 38.49675], [-121.3946, 38.4968], [-121.39517, 38.49678], [-121.39517, 38.49733]]]} | Open Access 1 | 24018 | Olde Florintown Park | 23113 | 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 | 6.327 | Olde Florintown 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 | |
11725 | 11725 | 11724 | {"type": "Polygon", "coordinates": [[[-121.38267, 38.49379], [-121.38126, 38.49379], [-121.38125, 38.49185], [-121.38133, 38.49184], [-121.38134, 38.49171], [-121.3826, 38.4917], [-121.38261, 38.49269], [-121.38267, 38.49321], [-121.38267, 38.49379]]]} | Open Access 1 | 24020 | Sunrise Florin Park | 26019 | 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 | 6.826 | Sunrise Florin Park | 0 | Local Park 2 | 4 | |
11726 | 11726 | 11725 | {"type": "Polygon", "coordinates": [[[-121.41571, 38.48888], [-121.41487, 38.48888], [-121.41484, 38.4886], [-121.41471, 38.48829], [-121.41454, 38.48805], [-121.41424, 38.48773], [-121.41414, 38.48759], [-121.41407, 38.48744], [-121.41403, 38.48731], [-121.414, 38.48716], [-121.414, 38.48702], [-121.41403, 38.48684], [-121.41569, 38.48685], [-121.41571, 38.48888]]]} | Open Access 1 | 24021 | Rutter Park | 24756 | 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 | 6.323 | Rutter 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 | |
11730 | 11730 | 11729 | {"type": "Polygon", "coordinates": [[[-121.43649, 38.48885], [-121.43648, 38.49039], [-121.43428, 38.49038], [-121.43421, 38.48884], [-121.43649, 38.48885]]]} | Open Access 1 | 24025 | Hampton Park | 19633 | 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 | 8.296 | Hampton Park | 0 | Local Park 2 | 4 | |
11731 | 11731 | 11730 | {"type": "Polygon", "coordinates": [[[-121.436, 38.48702], [-121.43465, 38.48702], [-121.43463, 38.4887], [-121.43237, 38.48869], [-121.43238, 38.487], [-121.43355, 38.487], [-121.43356, 38.48522], [-121.43408, 38.48522], [-121.436, 38.48702]]]} | Open Access 1 | 24026 | Sheldon Park | 25385 | 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 | 15.525 | Sheldon Park | 0 | Local Park 2 | 4 | |
11732 | 11732 | 11731 | {"type": "Polygon", "coordinates": [[[-121.44096, 38.48746], [-121.43882, 38.48746], [-121.43884, 38.48537], [-121.44086, 38.48501], [-121.44096, 38.48746]]]} | Open Access 1 | 24027 | Florin Creek Park | 18964 | 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 | 11.321 | Florin Creek 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]);