units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
84 rows where MNG_AGENCY = 253 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11579 | 11579 | 11578 | {"type": "Polygon", "coordinates": [[[-122.09273, 37.63614], [-122.09226, 37.63664], [-122.09216, 37.63438], [-122.09246, 37.63438], [-122.0925, 37.6344], [-122.09251, 37.63442], [-122.09256, 37.63586], [-122.09261, 37.63602], [-122.09273, 37.63614]]]} | Open Access 1 | 23674 | Martin Luther King Field | 21906 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.77 | Martin Luther King Field | 0 | Local Recreation Area 3 | 4 | |
9307 | 9307 | 9306 | {"type": "Polygon", "coordinates": [[[-122.12224, 37.67045], [-122.12184, 37.67061], [-122.12193, 37.67077], [-122.12152, 37.67079], [-122.12086, 37.66972], [-122.12161, 37.66942], [-122.12205, 37.67013], [-122.1221, 37.67012], [-122.12222, 37.67031], [-122.12217, 37.67034], [-122.12224, 37.67045]]]} | Open Access 1 | 15513 | Mc Conaghy Park | 21985 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.46 | Mc Conaghy Park | 0 | Local Park 2 | 4 | |
8989 | 8989 | 8988 | {"type": "Polygon", "coordinates": [[[-122.1144, 37.68599], [-122.11396, 37.68623], [-122.11369, 37.68633], [-122.11347, 37.68631], [-122.11314, 37.6862], [-122.1129, 37.68607], [-122.11285, 37.685], [-122.11298, 37.68492], [-122.11301, 37.68483], [-122.11289, 37.68469], [-122.11285, 37.68395], [-122.11419, 37.68388], [-122.1144, 37.68599]]]} | Open Access 1 | 14840 | Meek Park | 22104 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 7.907 | Meek Park | 0 | Local Park 2 | 4 | |
2256 | 2256 | 2255 | {"type": "Polygon", "coordinates": [[[-122.10116, 37.6315], [-122.09735, 37.63159], [-122.09693, 37.63095], [-122.10101, 37.62939], [-122.10116, 37.6315]]]} | Open Access 1 | 18099 | Mt. Eden Park | 22577 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.739 | Mt. Eden Park | 0 | Local Park 2 | 4 | |
9358 | 9358 | 9357 | {"type": "Polygon", "coordinates": [[[-122.06246, 37.64119], [-122.06232, 37.64127], [-122.05822, 37.63602], [-122.05832, 37.63597], [-122.05832, 37.63595], [-122.05833, 37.63595], [-122.06246, 37.64119]]]} | Open Access 1 | 15634 | Nuestro Parquecito | 22935 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.343 | Nuestro Parquecito | None 768 | |||
8980 | 8980 | 8979 | {"type": "Polygon", "coordinates": [[[-122.04961, 37.66126], [-122.04912, 37.66152], [-122.04848, 37.66153], [-122.04851, 37.66049], [-122.04931, 37.66038], [-122.04961, 37.66126]]]} | Open Access 1 | 14822 | Old Highlands Park | 23086 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.498 | Old Highlands Park | 0 | Local Park 2 | 4 | |
2719 | 2719 | 2718 | {"type": "Polygon", "coordinates": [[[-122.15145, 37.62482], [-122.1508, 37.62499], [-122.14973, 37.62515], [-122.14837, 37.62508], [-122.14707, 37.62481], [-122.14004, 37.62225], [-122.13959, 37.62203], [-122.13915, 37.62174], [-122.14433, 37.62003], [-122.14478, 37.62002], [-122.14935, 37.61837], [-122.15103, 37.61782], [-122.15106, 37.61893], [-122.15087, 37.61931], [-122.15075, 37.62021], [-122.15092, 37.62129], [-122.15132, 37.6246], [-122.15145, 37.62482]]]} | Restricted Access 2 | 18348 | Oliver Property | 23136 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 118.291 | Oliver Property | 1977 | Local Other or Unknown 14 | 4 | |
8967 | 8967 | 8966 | {"type": "Polygon", "coordinates": [[[-122.08803, 37.62809], [-122.08797, 37.62953], [-122.08792, 37.62957], [-122.08779, 37.62954], [-122.08761, 37.62946], [-122.08716, 37.62916], [-122.0867, 37.62889], [-122.0861, 37.62865], [-122.0856, 37.62851], [-122.08557, 37.62847], [-122.08561, 37.62834], [-122.08803, 37.62809]]]} | Open Access 1 | 14794 | Palma Ceia Park | 23349 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 4.554 | Palma Ceia Park | 0 | Local Park 2 | 4 | |
12100 | 12100 | 12099 | {"type": "Polygon", "coordinates": [[[-122.02692, 37.71714], [-122.02691, 37.71717], [-122.02654, 37.71755], [-122.02638, 37.71747], [-122.02451, 37.71785], [-122.02432, 37.71778], [-122.02444, 37.71756], [-122.02439, 37.71745], [-122.02463, 37.71737], [-122.02484, 37.71728], [-122.02503, 37.71717], [-122.02482, 37.71695], [-122.02504, 37.7168], [-122.02517, 37.71668], [-122.02554, 37.7163], [-122.0258, 37.71608], [-122.02603, 37.71595], [-122.02615, 37.71591], [-122.02674, 37.71691], [-122.02692, 37.71714]]]} | Open Access 1 | 24934 | Palomares Hills Park | 23366 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 6.072 | Palomares Hills Park | 0 | Local Park 2 | 4 | |
9140 | 9140 | 9139 | {"type": "Polygon", "coordinates": [[[-122.08616, 37.71826], [-122.08524, 37.71962], [-122.0845, 37.71944], [-122.0848, 37.71885], [-122.08526, 37.71821], [-122.08533, 37.718], [-122.08568, 37.71799], [-122.08581, 37.71803], [-122.08595, 37.7181], [-122.08616, 37.71826]]]} | Open Access 1 | 15168 | Parsons Park | 23483 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.279 | Parsons Park | 0 | Local Park 2 | 4 | |
1911 | 1911 | 1910 | {"type": "Polygon", "coordinates": [[[-122.11063, 37.64003], [-122.10917, 37.64003], [-122.10914, 37.63892], [-122.1106, 37.63889], [-122.11063, 37.64003]]]} | Open Access 1 | 14788 | Rancho Arroyo Park | 24128 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.995 | Rancho Arroyo Park | 0 | Local Park 2 | 4 | |
5221 | 5221 | 5220 | {"type": "Polygon", "coordinates": [[[-121.98774, 37.69927], [-121.987, 37.69915], [-121.98436, 37.69881], [-121.98245, 37.69859], [-121.98161, 37.69845], [-121.98091, 37.69828], [-121.98042, 37.69813], [-121.97989, 37.69799], [-121.97915, 37.69786], [-121.97787, 37.69781], [-121.97662, 37.69763], [-121.97536, 37.69737], [-121.97291, 37.69698], [-121.97296, 37.6967], [-121.97308, 37.69667], [-121.97325, 37.69658], [-121.97334, 37.69638], [-121.97349, 37.69634], [-121.97353, 37.69606], [-121.97363, 37.69594], [-121.97374, 37.69576], [-121.97373, 37.69571], [-121.97376, 37.69562], [-121.97371, 37.69553], [-121.97377, 37.69509], [-121.97355, 37.69429], [-121.97839, 37.69432], [-121.97841, 37.69486], [-121.98072, 37.69488], [-121.98068, 37.69509], [-121.98129, 37.6962], [-121.98162, 37.69661], [-121.98198, 37.697], [-121.98199, 37.69713], [-121.98773, 37.69755], [-121.98774, 37.69927]]]} | Open Access 1 | 289 | Rowell Ranch Rodeo Park | 24705 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 83.074 | Rowell Ranch Rodeo Park | 0 | Local Park 2 | 4 | |
8986 | 8986 | 8985 | {"type": "Polygon", "coordinates": [[[-122.07515, 37.62535], [-122.07338, 37.62536], [-122.07346, 37.62481], [-122.07338, 37.62446], [-122.07398, 37.62436], [-122.07422, 37.62446], [-122.07438, 37.6245], [-122.07509, 37.62453], [-122.07515, 37.62535]]]} | Open Access 1 | 14863 | Ruus Park | 24757 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.683 | Ruus Park | 0 | Local Park 2 | 4 | |
6743 | 6743 | 6742 | {"type": "Polygon", "coordinates": [[[-122.06367, 37.67916], [-122.06302, 37.67937], [-122.06319, 37.67989], [-122.06191, 37.6806], [-122.06121, 37.68082], [-122.06083, 37.68007], [-122.06126, 37.67992], [-122.06086, 37.67911], [-122.0635, 37.67828], [-122.06367, 37.67916]]]} | Open Access 1 | 5083 | San Felipe Park | 24884 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.766 | San Felipe Park | 1965 | Local Park 2 | 4 | |
3610 | 3610 | 3609 | {"type": "Polygon", "coordinates": [[[-122.14555, 37.66548], [-122.14449, 37.66584], [-122.14439, 37.66644], [-122.14233, 37.66724], [-122.14201, 37.66706], [-122.14184, 37.66295], [-122.14345, 37.66316], [-122.14555, 37.66548]]]} | Open Access 1 | 441 | San Lorenzo Community Park | 24925 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 23.787 | San Lorenzo Community Park | 0 | Local Park 2 | 4 | |
8992 | 8992 | 8991 | {"type": "Polygon", "coordinates": [[[-122.0868, 37.64365], [-122.0862, 37.64443], [-122.08561, 37.64443], [-122.0856, 37.64372], [-122.08598, 37.64371], [-122.08609, 37.64358], [-122.08652, 37.64359], [-122.08664, 37.64357], [-122.0868, 37.64365]]]} | Open Access 1 | 14846 | Schafer Park | 25179 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.748 | Schafer Park | 0 | Local Park 2 | 4 | |
8973 | 8973 | 8972 | {"type": "Polygon", "coordinates": [[[-122.07395, 37.64394], [-122.07177, 37.64429], [-122.07183, 37.64455], [-122.07079, 37.64457], [-122.07077, 37.64395], [-122.0707, 37.64384], [-122.0703, 37.64384], [-122.07028, 37.6426], [-122.07241, 37.64248], [-122.07395, 37.64394]]]} | Open Access 1 | 14803 | Sorensdale Park | 25624 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.217 | Sorensdale Park | 0 | Local Park 2 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
8991 | 8991 | 8990 | {"type": "Polygon", "coordinates": [[[-122.06921, 37.65745], [-122.06885, 37.6576], [-122.06789, 37.65718], [-122.06765, 37.65698], [-122.06747, 37.65668], [-122.06699, 37.65618], [-122.06735, 37.65594], [-122.06776, 37.65649], [-122.06823, 37.65633], [-122.06921, 37.65745]]]} | Open Access 1 | 14843 | Spring Grove Park | 25738 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.192 | Spring Grove Park | 0 | Local Park 2 | 4 | |
8976 | 8976 | 8975 | {"type": "Polygon", "coordinates": [[[-122.04463, 37.6307], [-122.04385, 37.63103], [-122.04302, 37.63043], [-122.04412, 37.62993], [-122.04463, 37.6307]]]} | Open Access 1 | 14808 | Stonybrook Park | 25900 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.245 | Stonybrook 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]);