superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 494 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8474 | 8474 | 8473 | {"type": "Polygon", "coordinates": [[[-121.46446, 38.51568], [-121.4644, 38.5157], [-121.46371, 38.51571], [-121.46369, 38.51573], [-121.4633, 38.51573], [-121.46309, 38.51534], [-121.46327, 38.51532], [-121.46327, 38.51495], [-121.46369, 38.51495], [-121.46371, 38.51497], [-121.4644, 38.51497], [-121.46446, 38.515], [-121.46448, 38.51503], [-121.46448, 38.51563], [-121.46446, 38.51568]]]} | Open Access 1 | Rainbow Park | 24091 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2.231 | Rainbow Park | ||
4443 | 4443 | 4442 | {"type": "Polygon", "coordinates": [[[-121.4614, 38.52133], [-121.46141, 38.52418], [-121.4614, 38.52477], [-121.46005, 38.52477], [-121.46004, 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 | Fruitridge Park | 19136 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 11.33 | Fruitridge Park | ||
2182 | 2182 | 2181 | {"type": "Polygon", "coordinates": [[[-121.46013, 38.50773], [-121.45932, 38.50774], [-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.45932, 38.50679], [-121.46012, 38.5068], [-121.46013, 38.50773]]]} | Open Access 1 | Bowling Green Park | 16311 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 7.166 | Bowling Green Park | ||
7849 | 7849 | 7848 | {"type": "Polygon", "coordinates": [[[-121.45978, 38.51394], [-121.45867, 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 | Pacific Park | 23303 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 9.079 | Pacific Park | ||
5445 | 5445 | 5444 | {"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 | Jack W. Davis Park | 20312 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 0.683 | Jack W. Davis Park | ||
6289 | 6289 | 6288 | {"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.50743], [-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 | Nicholas Park | 22745 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 9.741 | Nicholas Park | ||
9043 | 9043 | 9042 | {"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.49216], [-121.44993, 38.49209], [-121.45069, 38.49164], [-121.45147, 38.49244]]]} | Open Access 1 | Royal Park | 24717 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2.719 | Royal Park | ||
3357 | 3357 | 3356 | {"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 | Crowfoot Park | 17834 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2.128 | Crowfoot Park | ||
4342 | 4342 | 4341 | {"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 | Fountain Plaza Park | 19022 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 0.771 | Fountain Plaza Park | ||
4277 | 4277 | 4276 | {"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 | Florin Creek Park | 18964 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 11.319 | Florin Creek Park | ||
4865 | 4865 | 4864 | {"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 | Hampton Park | 19633 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 8.295 | Hampton Park | ||
9582 | 9582 | 9581 | {"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 | Sheldon Park | 25385 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 15.545 | Sheldon Park | ||
5612 | 5612 | 5611 | {"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 | Jose P Rizal Comm. Center | 20492 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 3.914 | Jose P Rizal Comm. Ctr. | ||
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-121.43409, 38.49084], [-121.43187, 38.49083], [-121.4318, 38.48936], [-121.43254, 38.48936], [-121.43253, 38.48902], [-121.43257, 38.489], [-121.43256, 38.48881], [-121.434, 38.48881], [-121.43409, 38.49084]]]} | Open Access 1 | Daylor Sports Field | 17963 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 9.777 | Daylor Sports Field | ||
4585 | 4585 | 4584 | {"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.41597, 38.5003], [-121.41738, 38.50033]]]} | Open Access 1 | Kennedy Park | 20603 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 3.566 | Kennedy Park | ||
9084 | 9084 | 9083 | {"type": "Polygon", "coordinates": [[[-121.41571, 38.48888], [-121.41487, 38.48888], [-121.41484, 38.48859], [-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 | Rutter Park | 24756 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 6.322 | Rutter Park | ||
3242 | 3242 | 3241 | {"type": "Polygon", "coordinates": [[[-121.40565, 38.45943], [-121.40393, 38.45988], [-121.4039, 38.45984], [-121.40385, 38.45943], [-121.40346, 38.45942], [-121.40343, 38.45854], [-121.40239, 38.45852], [-121.40238, 38.4582], [-121.40236, 38.45803], [-121.40231, 38.45783], [-121.40222, 38.45762], [-121.40223, 38.45758], [-121.40227, 38.45755], [-121.40258, 38.45749], [-121.40278, 38.45747], [-121.40306, 38.45748], [-121.40345, 38.45755], [-121.40409, 38.45774], [-121.40427, 38.45778], [-121.40452, 38.45781], [-121.40499, 38.45781], [-121.40503, 38.45783], [-121.40507, 38.45787], [-121.40515, 38.45827], [-121.4053, 38.45873], [-121.40543, 38.45904], [-121.40565, 38.45943]]]} | Open Access 1 | Countryside Comm. Park | 17707 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 11.172 | Countryside Comm. Park | ||
11291 | 11291 | 11290 | {"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 | Willowood Park | 27593 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 1.532 | Willowood Park | ||
10376 | 10376 | 10375 | {"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 | Toby Johnson Park | 26382 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 5.705 | Toby Johnson Park | ||
7422 | 7422 | 7421 | {"type": "Polygon", "coordinates": [[[-121.3995, 38.47407], [-121.39941, 38.47407], [-121.39938, 38.47307], [-121.39876, 38.47308], [-121.39876, 38.47407], [-121.39739, 38.47408], [-121.39733, 38.47406], [-121.3973, 38.47402], [-121.39729, 38.47356], [-121.39726, 38.47329], [-121.39726, 38.47286], [-121.39727, 38.47283], [-121.39733, 38.4728], [-121.3981, 38.47278], [-121.39886, 38.47267], [-121.39902, 38.47268], [-121.39912, 38.47264], [-121.39916, 38.47256], [-121.39949, 38.47256], [-121.3995, 38.47407]]]} | Open Access 1 | Norman Waters Park | 22799 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 5.678 | Norman Waters Park |
Advanced export
JSON shape: default, array, newline-delimited
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]);