units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where GAP_STS = 4 and MNG_AGENCY = 200
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
551 | 551 | 550 | {"type": "Polygon", "coordinates": [[[-118.37726, 34.06288], [-118.37726, 34.06288], [-118.37301, 34.06176], [-118.37628, 34.05985], [-118.37637, 34.05955], [-118.37717, 34.05951], [-118.37726, 34.06288]]]} | Open Access 1 | 3065 | La Cienega Park | 20747 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 19.044 | La Cienega Park | 0 | Local Park 2 | 4 | |
1503 | 1503 | 1502 | {"type": "Polygon", "coordinates": [[[-118.40833, 34.05957], [-118.4058, 34.05957], [-118.4058, 34.0571], [-118.40592, 34.0571], [-118.40626, 34.05675], [-118.40718, 34.0574], [-118.40806, 34.0581], [-118.40822, 34.0583], [-118.40828, 34.05842], [-118.40832, 34.05855], [-118.40833, 34.0587], [-118.40833, 34.05957]]]} | Open Access 1 | 10534 | Roxbury Park | 24708 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 13.744 | Roxbury Park | 0 | Local Park 2 | 4 | |
2011 | 2011 | 2010 | {"type": "Polygon", "coordinates": [[[-118.41373, 34.08014], [-118.4129, 34.0807], [-118.41211, 34.08128], [-118.41203, 34.08064], [-118.41189, 34.08], [-118.41198, 34.07994], [-118.41204, 34.07987], [-118.41279, 34.08003], [-118.41373, 34.08014]]]} | Open Access 1 | 15378 | Will Rogers Memorial Park | 27528 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 3.097 | Will Rogers Memorial Park | 0 | Local Park 2 | 4 | |
4427 | 4427 | 4426 | {"type": "Polygon", "coordinates": [[[-118.40996, 34.08304], [-118.40903, 34.08392], [-118.4087, 34.08342], [-118.40954, 34.08258], [-118.40982, 34.08287], [-118.40996, 34.08304]]]} | Open Access 1 | 46314 | Rexford Reservoir | 29603 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 1.916 | Rexford Reservoir | 0 | Local Recreation Area 3 | 4 | |
5309 | 5309 | 5308 | {"type": "Polygon", "coordinates": [[[-118.4146, 34.06717], [-118.41459, 34.06739], [-118.41341, 34.06736], [-118.41217, 34.06729], [-118.41035, 34.06755], [-118.39058, 34.0811], [-118.38983, 34.08056], [-118.40966, 34.06717], [-118.4146, 34.06717]]]} | Open Access 1 | 4585 | Beverly Gardens Park | 16052 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 50.415 | Beverly Gardens Park | 0 | Local Park 2 | 4 | |
6181 | 6181 | 6180 | {"type": "Polygon", "coordinates": [[[-118.40263, 34.09299], [-118.40258, 34.09309], [-118.40246, 34.09325], [-118.40249, 34.09327], [-118.40229, 34.09354], [-118.40241, 34.09366], [-118.40234, 34.09366], [-118.4023, 34.09371], [-118.40217, 34.09374], [-118.40206, 34.0938], [-118.40194, 34.09391], [-118.4018, 34.09413], [-118.40169, 34.0942], [-118.40162, 34.09421], [-118.40155, 34.09416], [-118.40144, 34.09388], [-118.40139, 34.09384], [-118.40133, 34.09384], [-118.40127, 34.09389], [-118.40122, 34.09388], [-118.40089, 34.094], [-118.40078, 34.094], [-118.4006, 34.09364], [-118.40062, 34.09323], [-118.40038, 34.09322], [-118.39996, 34.09275], [-118.3996, 34.0926], [-118.39999, 34.09208], [-118.40011, 34.09186], [-118.40015, 34.09172], [-118.40017, 34.09157], [-118.40015, 34.09123], [-118.40037, 34.09108], [-118.40059, 34.09089], [-118.40152, 34.08988], [-118.40166, 34.08977], [-118.40216, 34.0911], [-118.40243, 34.09143], [-118.40232, 34.09147], [-118.40225, 34.09191], [-118.4023, 34.09215], [-118.40241, 34.09241], [-118.4025, 34.09249], [-118.40257, 34.09259], [-118.40263, 34.09299]]]} | Open Access 1 | 1230 | Greystone Park | 19506 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 18.878 | Greystone Park | 0 | Local Park 2 | 4 | |
8006 | 8006 | 8005 | {"type": "Polygon", "coordinates": [[[-118.39874, 34.07197], [-118.39801, 34.07197], [-118.398, 34.07189], [-118.39839, 34.07162], [-118.39874, 34.07197]]]} | Open Access 1 | 20663 | Rexford Rest Mini Park | 29602 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.363 | Rexford Rest MP | 0 | Local Park 2 | 4 | |
8148 | 8148 | 8147 | {"type": "Polygon", "coordinates": [[[-118.39065, 34.0663], [-118.39065, 34.06644], [-118.39025, 34.06644], [-118.39025, 34.0663], [-118.39065, 34.0663]]]} | Open Access 1 | 46321 | Oakhurst Mini Park | 29609 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.139 | Oakhurst MP | 0 | Local Park 2 | 4 | |
8149 | 8149 | 8148 | {"type": "Polygon", "coordinates": [[[-118.39632, 34.06788], [-118.39593, 34.06815], [-118.39578, 34.06799], [-118.39616, 34.06773], [-118.39632, 34.06788]]]} | Open Access 1 | 46325 | Crescent Mini Park | 29612 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.255 | Crescent MP | 0 | Local Park 2 | 4 | |
10238 | 10238 | 10237 | {"type": "MultiPolygon", "coordinates": [[[[-118.41259, 34.08958], [-118.41262, 34.08979], [-118.4126, 34.08996], [-118.41253, 34.09013], [-118.41239, 34.09029], [-118.41229, 34.09035], [-118.41214, 34.09042], [-118.41201, 34.09045], [-118.41187, 34.09047], [-118.41181, 34.09052], [-118.41163, 34.09064], [-118.41141, 34.09087], [-118.41118, 34.0912], [-118.41107, 34.09131], [-118.41093, 34.0914], [-118.41078, 34.09148], [-118.41039, 34.09163], [-118.41008, 34.09182], [-118.41, 34.09179], [-118.40995, 34.09173], [-118.4099, 34.09165], [-118.41006, 34.09155], [-118.41039, 34.09129], [-118.41082, 34.09105], [-118.41104, 34.09098], [-118.41115, 34.09093], [-118.41125, 34.09086], [-118.41135, 34.09076], [-118.41139, 34.09067], [-118.41142, 34.09057], [-118.41144, 34.09027], [-118.41158, 34.09], [-118.41164, 34.08982], [-118.41164, 34.08967], [-118.41159, 34.08944], [-118.4116, 34.08929], [-118.41259, 34.08958]]], [[[-118.41199, 34.09068], [-118.41197, 34.09119], [-118.41198, 34.09155], [-118.41196, 34.09164], [-118.41179, 34.09162], [-118.41171, 34.09159], [-118.41164, 34.09159], [-118.41154, 34.09166], [-118.41154, 34.09173], [-118.41123, 34.09177], [-118.41118, 34.09152], [-118.4112, 34.09145], [-118.4114, 34.09124], [-118.41159, 34.09096], [-118.41176, 34.09079], [-118.41195, 34.09066], [-118.41199, 34.09068]]]]} | Open Access 1 | 17918 | Coldwater Canyon Park | 17486 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 5.192 | Coldwater Canyon Park | 0 | Local Park 2 | 4 | |
10865 | 10865 | 10864 | {"type": "Polygon", "coordinates": [[[-118.42063, 34.07687], [-118.42007, 34.07706], [-118.4199, 34.07701], [-118.4196, 34.07656], [-118.42038, 34.07628], [-118.42063, 34.07687]]]} | Open Access 1 | 20664 | Maltz Park | 21714 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 1.216 | Maltz Park | 0 | Local Park 2 | 4 | |
14916 | 14916 | 14915 | {"type": "Polygon", "coordinates": [[[-118.38318, 34.0682], [-118.38275, 34.06821], [-118.38274, 34.06808], [-118.38317, 34.06807], [-118.38318, 34.0682]]]} | Open Access 1 | 45486 | Arnaz Park | 28316 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/pg/places/?PLACEID=67 | Los Angeles 6 | 0.149 | Arnaz Park | 0 | Local Park 2 | 4 |
15257 | 15257 | 15256 | {"type": "Polygon", "coordinates": [[[-118.39439, 34.08904], [-118.39439, 34.08904], [-118.39388, 34.08937], [-118.39391, 34.08929], [-118.39389, 34.08915], [-118.39396, 34.08911], [-118.39396, 34.08907], [-118.394, 34.08902], [-118.39408, 34.08905], [-118.39417, 34.08907], [-118.39428, 34.08906], [-118.39437, 34.08902], [-118.39439, 34.08904]]]} | Open Access 1 | 46315 | Sierra Park | 29604 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.176 | Sierra Park | 0 | Local Park 2 | 4 | |
15259 | 15259 | 15258 | {"type": "Polygon", "coordinates": [[[-118.39973, 34.0679], [-118.39891, 34.06846], [-118.3987, 34.06824], [-118.39952, 34.06768], [-118.39973, 34.0679]]]} | Open Access 1 | 46324 | Beverly Canon Gardens Park | 29610 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.735 | Beverly Canon Gardens Park | 0 | Local Park 2 | 4 | |
15260 | 15260 | 15259 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06053], [-118.41139, 34.0606], [-118.41083, 34.06087], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06003], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06053]]], [[[-118.41243, 34.06254], [-118.41205, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41232, 34.06203], [-118.41217, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | 46326 | Beverly Hills High School Park | 31849 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 10.447 | Beverly Hills High School Park | 0 | Local Park 2 | 4 | |
15261 | 15261 | 15260 | {"type": "Polygon", "coordinates": [[[-118.39847, 34.06603], [-118.39847, 34.06645], [-118.39807, 34.06645], [-118.39807, 34.06603], [-118.39847, 34.06603]]]} | Open Access 1 | 46318 | Reeves Mini Park | 29607 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.418 | Reeves MP | 0 | Local Park 2 | 4 | |
15262 | 15262 | 15261 | {"type": "Polygon", "coordinates": [[[-118.38135, 34.06394], [-118.38092, 34.06395], [-118.38092, 34.06382], [-118.38135, 34.06381], [-118.38135, 34.06394]]]} | Open Access 1 | 46320 | Hamel Mini Park | 29608 | 1029 | Beverly Hills, City of 204 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 0.149 | Hamel MP | 0 | Local Park 2 | 4 | |
15263 | 15263 | 15262 | {"type": "Polygon", "coordinates": [[[-118.38356, 34.06628], [-118.38312, 34.0663], [-118.3831, 34.06602], [-118.38268, 34.06603], [-118.38267, 34.06594], [-118.38262, 34.06594], [-118.3826, 34.06506], [-118.38346, 34.06506], [-118.38351, 34.06508], [-118.38356, 34.06628]]]} | Restricted Access 2 | 46327 | Horace Mann Elementary School Park | 31881 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.532 | Horace Mann Elementary School Park | 0 | Local Park 2 | 4 | |
15264 | 15264 | 15263 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | 46328 | Beverly Vista Elementary School Park | 31882 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.838 | Beverly Vista Elementary School Park | 0 | Local Park 2 | 4 | |
15265 | 15265 | 15264 | {"type": "MultiPolygon", "coordinates": [[[[-118.40382, 34.07823], [-118.40328, 34.0785], [-118.40298, 34.07798], [-118.40351, 34.07775], [-118.40382, 34.07823]]], [[[-118.40519, 34.07988], [-118.404, 34.08055], [-118.40365, 34.08016], [-118.40422, 34.07986], [-118.40483, 34.07951], [-118.40519, 34.07988]]]]} | Restricted Access 2 | 46329 | Hawthorne Elementary School Park | 31883 | 2366 | Beverly Hills Unified School District 1146 | Special District 4 | School District 14 | http://www.bhusd.org/ | Special District 4 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | Los Angeles 6 | 2.583 | Hawthorne Elementary School 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]);