units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where MNG_AGENCY = 494 and MNG_AG_TYP = 4 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 34
- Local Recreation Area 5
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- Recreation/Parks District · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11270 | 11270 | 11269 | {"type": "MultiPolygon", "coordinates": [[[[-121.30369, 38.49136], [-121.29786, 38.49132], [-121.29784, 38.4889], [-121.30251, 38.48891], [-121.30252, 38.48894], [-121.30366, 38.48894], [-121.30369, 38.49136]]], [[[-121.31605, 38.46467], [-121.31569, 38.46467], [-121.31545, 38.46469], [-121.3152, 38.46475], [-121.31494, 38.46485], [-121.31489, 38.46486], [-121.31484, 38.46483], [-121.31425, 38.46426], [-121.31403, 38.46409], [-121.31363, 38.46387], [-121.31323, 38.46373], [-121.31249, 38.46355], [-121.31219, 38.4635], [-121.31084, 38.46343], [-121.31049, 38.46339], [-121.31015, 38.46331], [-121.30949, 38.46309], [-121.30919, 38.46302], [-121.3088, 38.463], [-121.30845, 38.46303], [-121.30718, 38.46329], [-121.30693, 38.46336], [-121.30664, 38.46347], [-121.30619, 38.46369], [-121.30545, 38.46417], [-121.30525, 38.46431], [-121.30504, 38.46452], [-121.30483, 38.46481], [-121.3041, 38.4663], [-121.30334, 38.4671], [-121.30043, 38.4671], [-121.30069, 38.4669], [-121.30202, 38.46628], [-121.30248, 38.466], [-121.30291, 38.46547], [-121.30293, 38.46503], [-121.30287, 38.4641], [-121.30299, 38.46363], [-121.30301, 38.46338], [-121.30352, 38.46257], [-121.30434, 38.46231], [-121.30737, 38.46216], [-121.30796, 38.46155], [-121.30874, 38.46128], [-121.30949, 38.46142], [-121.3106, 38.46198], [-121.31097, 38.46201], [-121.31413, 38.46142], [-121.31529, 38.46197], [-121.31604, 38.46216], [-121.31605, 38.46467]]]]} | Open Access 1 | 21745 | SOUTHGATE RECREATION/PARK DISTRICT | 25690 | 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 | 105.753 | SOUTHGATE RECREATION/PARK DISTRICT | None 985 | |||
11424 | 11424 | 11423 | {"type": "MultiPolygon", "coordinates": [[[[-121.35305, 38.45457], [-121.35307, 38.45492], [-121.35314, 38.45535], [-121.35313, 38.45538], [-121.35308, 38.45542], [-121.35289, 38.45546], [-121.3527, 38.45552], [-121.35247, 38.45564], [-121.35227, 38.45584], [-121.35217, 38.456], [-121.3521, 38.45619], [-121.35209, 38.45635], [-121.35112, 38.45635], [-121.35116, 38.45457], [-121.35305, 38.45457]]], [[[-121.35394, 38.45942], [-121.35394, 38.45908], [-121.35362, 38.45908], [-121.35348, 38.45911], [-121.35334, 38.45912], [-121.35324, 38.45921], [-121.35327, 38.45643], [-121.35348, 38.45643], [-121.35364, 38.45678], [-121.35375, 38.45705], [-121.3539, 38.4576], [-121.35396, 38.45797], [-121.35399, 38.45834], [-121.35398, 38.45938], [-121.35394, 38.45942]]]]} | Open Access 1 | 22264 | SOUTHGATE RECREATION/PARK DISTRICT | 25690 | 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 | 10.514 | SOUTHGATE RECREATION/PARK DISTRICT | None 1013 | |||
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 | |
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 | |
11729 | 11729 | 11728 | {"type": "Polygon", "coordinates": [[[-121.43409, 38.49084], [-121.43187, 38.49083], [-121.4318, 38.48936], [-121.43254, 38.48936], [-121.43253, 38.48901], [-121.43257, 38.48901], [-121.43256, 38.48881], [-121.434, 38.48881], [-121.43409, 38.49084]]]} | Open Access 1 | 24024 | Daylor Sports Field | 17963 | 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.775 | Daylor Sports Field | 0 | Local Recreation Area 3 | 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 | |
11733 | 11733 | 11732 | {"type": "Polygon", "coordinates": [[[-121.31597, 38.47439], [-121.31588, 38.4815], [-121.31585, 38.48155], [-121.31579, 38.48157], [-121.30705, 38.48156], [-121.30699, 38.47674], [-121.30973, 38.47684], [-121.31061, 38.47589], [-121.3108, 38.47422], [-121.31106, 38.47334], [-121.3145, 38.47369], [-121.31597, 38.47439]]]} | Restricted Access 2 | 24028 | Wildhawk Golf Club | 33082 | 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 | 141.725 | Wildhawk Golf Club | 0 | Local Recreation Area 3 | 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]);