units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where COUNTY = 6 and MNG_AG_LEV = 7
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, GAP_STS
MNG_AGENCY 8
DES_TP 7
- Private Conservation 4
- Private Recreation or Education 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 3
ACCESS_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9407 | 9407 | 9406 | {"type": "Polygon", "coordinates": [[[-118.16539, 33.79771], [-118.1653, 33.79772], [-118.16505, 33.79788], [-118.16487, 33.79797], [-118.16459, 33.798], [-118.16457, 33.79798], [-118.16441, 33.79797], [-118.16422, 33.7979], [-118.16416, 33.79788], [-118.16391, 33.79769], [-118.16355, 33.79759], [-118.16322, 33.79759], [-118.16321, 33.79783], [-118.16279, 33.79783], [-118.16261, 33.79778], [-118.16232, 33.79779], [-118.16225, 33.79773], [-118.16219, 33.79756], [-118.1622, 33.79711], [-118.16329, 33.79711], [-118.16329, 33.79644], [-118.16342, 33.7965], [-118.16357, 33.7966], [-118.16389, 33.7969], [-118.1642, 33.79714], [-118.16423, 33.79718], [-118.16426, 33.79728], [-118.16431, 33.79732], [-118.1644, 33.79733], [-118.16449, 33.79729], [-118.16457, 33.79731], [-118.1647, 33.79731], [-118.16493, 33.79707], [-118.16499, 33.79711], [-118.16539, 33.79771]]]} | Restricted Access 2 | 47821 | Comstock South LLC HOA | 31763 | 6120 | Comstock South LLC 910 | Private 7 | Home Owners Association 16 | Private 14 | 6120 | Comstock South LLC 883 | Private 7 | Home Owners Association 15 | Los Angeles 6 | 5.79 | Comstock South LLC HOA | 0 | Private Conservation 16 | 2 | ||
9411 | 9411 | 9410 | {"type": "Polygon", "coordinates": [[[-118.16745, 33.79841], [-118.16748, 33.79966], [-118.16742, 33.8003], [-118.16741, 33.80064], [-118.16736, 33.80067], [-118.16679, 33.80067], [-118.16673, 33.80063], [-118.16673, 33.80057], [-118.16695, 33.80057], [-118.16704, 33.80055], [-118.16711, 33.80046], [-118.1671, 33.80042], [-118.16718, 33.80035], [-118.16723, 33.80024], [-118.16723, 33.80016], [-118.16733, 33.79982], [-118.16737, 33.79925], [-118.16735, 33.79924], [-118.16733, 33.79912], [-118.1673, 33.79905], [-118.16718, 33.79893], [-118.16714, 33.7987], [-118.16712, 33.79868], [-118.16709, 33.79851], [-118.16704, 33.79848], [-118.1668, 33.79846], [-118.16701, 33.79867], [-118.16704, 33.79875], [-118.16705, 33.79882], [-118.167, 33.799], [-118.16691, 33.79902], [-118.16686, 33.79908], [-118.16691, 33.79933], [-118.16688, 33.79966], [-118.16666, 33.7996], [-118.16659, 33.79955], [-118.16656, 33.79946], [-118.16654, 33.79945], [-118.16657, 33.79932], [-118.16658, 33.79922], [-118.16655, 33.79911], [-118.16649, 33.79901], [-118.1667, 33.79881], [-118.16669, 33.79878], [-118.16652, 33.79864], [-118.16648, 33.79864], [-118.1663, 33.79847], [-118.16627, 33.79847], [-118.16603, 33.7983], [-118.16602, 33.79825], [-118.16593, 33.79816], [-118.16577, 33.79795], [-118.16548, 33.79774], [-118.16539, 33.79771], [-118.165, 33.79711], [-118.16494, 33.79707], [-118.1651, 33.79693], [-118.16509, 33.79689], [-118.16519, 33.79674], [-118.16548, 33.79688], [-118.16549, 33.79687], [-118.16597, 33.79717], [-118.1664, 33.79749], [-118.16649, 33.7975], [-118.16656, 33.79781], [-118.16672, 33.79795], [-118.16673, 33.79805], [-118.16686, 33.79805], [-118.16685, 33.79812], [-118.16689, 33.79819], [-118.1672, 33.79828], [-118.16745, 33.79841]]]} | Restricted Access 2 | 47822 | Hilltop LLC HOA | 31764 | 6119 | Hilltop LLC 911 | Private 7 | Home Owners Association 16 | Private 14 | 6119 | Hilltop LLC 884 | Private 7 | Home Owners Association 15 | Los Angeles 6 | 6.573 | Hilltop LLC HOA | 0 | Private Conservation 16 | 2 | ||
9413 | 9413 | 9412 | {"type": "MultiPolygon", "coordinates": [[[[-118.15724, 33.79865], [-118.15735, 33.79866], [-118.15738, 33.79868], [-118.15739, 33.79872], [-118.15737, 33.79875], [-118.1572, 33.79889], [-118.15711, 33.79894], [-118.15658, 33.79909], [-118.15638, 33.7992], [-118.15631, 33.79919], [-118.15629, 33.79916], [-118.1564, 33.79915], [-118.15648, 33.79906], [-118.15653, 33.79896], [-118.15652, 33.79884], [-118.15649, 33.79877], [-118.15635, 33.79858], [-118.15611, 33.79832], [-118.15608, 33.79826], [-118.15607, 33.79818], [-118.15607, 33.79814], [-118.15612, 33.79806], [-118.15601, 33.79791], [-118.15601, 33.79786], [-118.15599, 33.79782], [-118.15594, 33.79778], [-118.15587, 33.79776], [-118.15602, 33.7973], [-118.15576, 33.79724], [-118.15574, 33.79726], [-118.15563, 33.79759], [-118.15553, 33.79771], [-118.1555, 33.79782], [-118.1555, 33.79789], [-118.15554, 33.79798], [-118.15552, 33.79809], [-118.15572, 33.79811], [-118.15572, 33.79814], [-118.15552, 33.79813], [-118.15551, 33.79827], [-118.15556, 33.79851], [-118.15559, 33.79858], [-118.15564, 33.79865], [-118.15582, 33.79878], [-118.15601, 33.79901], [-118.15599, 33.79903], [-118.15588, 33.7989], [-118.15556, 33.79866], [-118.15549, 33.79856], [-118.15541, 33.79835], [-118.15541, 33.79811], [-118.1552, 33.7981], [-118.1552, 33.79807], [-118.15541, 33.79807], [-118.15543, 33.79796], [-118.15543, 33.79771], [-118.15554, 33.79754], [-118.15555, 33.79747], [-118.15556, 33.79734], [-118.1555, 33.79733], [-118.1555, 33.79719], [-118.15646, 33.7972], [-118.15658, 33.79735], [-118.1566, 33.79741], [-118.1566, 33.79748], [-118.1565, 33.79736], [-118.15636, 33.79743], [-118.15628, 33.79748], [-118.15622, 33.79755], [-118.15619, 33.79763], [-118.15618, 33.79771], [-118.15622, 33.79787], [-118.15624, 33.79802], [-118.1563, 33.7982], [-118.15651, 33.79866], [-118.15673, 33.79859], [-118.15675, 33.79862], [-118.15655, 33.79871], [-118.15654, 33.79872], [-118.15671, 33.79892], [-118.15676, 33.79895], [-118.15681, 33.79895], [-118.15695, 33.79889], [-118.15713, 33.79888], [-118.15725, 33.79884], [-118.15727, 33.79879], [-118.15724, 33.79865]]], [[[-118.15759, 33.79826], [-118.15756, 33.79831], [-118.15739, 33.7983], [-118.15724, 33.79832], [-118.1572, 33.79827], [-118.15697, 33.79783], [-118.15686, 33.79786], [-118.15664, 33.79786], [-118.15672, 33.79769], [-118.1567, 33.79763], [-118.15665, 33.79759], [-118.15667, 33.79747], [-118.15666, 33.79738], [-118.1567, 33.79738], [-118.15689, 33.79765], [-118.15697, 33.79771], [-118.15719, 33.79806], [-118.15727, 33.79812], [-118.15759, 33.79826]]], [[[-118.1581, 33.80028], [-118.15797, 33.8005], [-118.15798, 33.80071], [-118.15784, 33.80071], [-118.15786, 33.80049], [-118.15794, 33.80023], [-118.15793, 33.80019], [-118.1579, 33.80017], [-118.15768, 33.80011], [-118.15732, 33.79992], [-118.15718, 33.7998], [-118.15704, 33.79967], [-118.15687, 33.79976], [-118.15685, 33.79973], [-118.15703, 33.79963], [-118.1569, 33.79936], [-118.15693, 33.79934], [-118.15687, 33.79914], [-118.15716, 33.79906], [-118.15722, 33.79908], [-118.15703, 33.79913], [-118.15699, 33.79919], [-118.15709, 33.79938], [-118.15712, 33.79951], [-118.15723, 33.79966], [-118.15733, 33.79977], [-118.1575, 33.79964], [-118.15754, 33.79967], [-118.15737, 33.7998], [-118.15737, 33.79981], [-118.15744, 33.79987], [-118.15769, 33.8], [-118.15802, 33.80006], [-118.1581, 33.80028]]]]} | Restricted Access 2 | 47823 | Bixby Village HOA | 31766 | 6118 | Bixby Village Home Owner Association 913 | Private 7 | Home Owners Association 16 | http://www.bixbyvillagehoa.com/page/28905~504318/Management-Contacts | Private 14 | 6118 | Bixby Village Home Owner Association 886 | Private 7 | Home Owners Association 15 | Los Angeles 6 | 3.135 | Bixby Village HOA | 0 | Private Conservation 16 | 2 | |
11514 | 11514 | 11513 | {"type": "MultiPolygon", "coordinates": [[[[-118.125, 33.83134], [-118.12499, 33.83168], [-118.12426, 33.83168], [-118.12426, 33.83134], [-118.125, 33.83134]]], [[[-118.12601, 33.83154], [-118.12534, 33.83154], [-118.12534, 33.83085], [-118.12601, 33.83085], [-118.12601, 33.83154]]]]} | No Public Access 3 | 48218 | Heartwell Park | 32767 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 1.82 | Heartwell Park | None 1023 | |||
11516 | 11516 | 11515 | {"type": "Polygon", "coordinates": [[[-118.18686, 33.84556], [-118.18686, 33.84557], [-118.18512, 33.84616], [-118.18512, 33.84532], [-118.18565, 33.8453], [-118.18613, 33.84533], [-118.18647, 33.84542], [-118.18686, 33.84556]]]} | Restricted Access 2 | 48222 | Scherer Park | 32775 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.201 | Scherer Park | None 1024 | |||
14017 | 14017 | 14016 | {"type": "Polygon", "coordinates": [[[-118.47347, 34.03122], [-118.47281, 34.03175], [-118.47275, 34.03178], [-118.47267, 34.03175], [-118.47203, 34.03124], [-118.47296, 34.03049], [-118.4734, 34.03086], [-118.47336, 34.03089], [-118.47335, 34.03112], [-118.47347, 34.03122]]]} | Open Access 1 | 46587 | Colorado Center Park | 29890 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | Los Angeles 6 | 2.516 | Colorado Ctr. Park | 0 | Private Recreation or Education 65 | 4 | ||
14688 | 14688 | 14687 | {"type": "Polygon", "coordinates": [[[-117.93807, 34.01787], [-117.9369, 34.02264], [-117.93682, 34.02264], [-117.9367, 34.02287], [-117.93573, 34.02327], [-117.93478, 34.02326], [-117.93448, 34.02322], [-117.93398, 34.02336], [-117.93332, 34.02341], [-117.93268, 34.02377], [-117.93232, 34.02429], [-117.93221, 34.02464], [-117.93236, 34.02535], [-117.93261, 34.02577], [-117.9329, 34.02604], [-117.93359, 34.02641], [-117.93493, 34.02691], [-117.93511, 34.02717], [-117.93532, 34.02753], [-117.93534, 34.02768], [-117.93528, 34.02789], [-117.93341, 34.02785], [-117.93283, 34.02778], [-117.93226, 34.02768], [-117.92284, 34.02511], [-117.92244, 34.02505], [-117.91796, 34.02461], [-117.91792, 34.02459], [-117.9179, 34.02456], [-117.9179, 34.02452], [-117.92008, 34.01904], [-117.92158, 34.01919], [-117.92157, 34.01914], [-117.9201, 34.01899], [-117.92078, 34.01727], [-117.92095, 34.0169], [-117.92116, 34.01651], [-117.92171, 34.01558], [-117.9217, 34.01556], [-117.9221, 34.01491], [-117.93046, 34.01574], [-117.9371, 34.0177], [-117.93807, 34.01787]]]} | Restricted Access 2 | 45010 | Industry Hills Golf Club | 29719 | 1146 | Industry, City of 1119 | City 2 | City Agency 2 | http://www.cityofindustry.org/ | City 2 | 6108 | Los Angeles Golf Club 1073 | Private 7 | Commercial 18 | http://www.ihgolfclub.com/ | Los Angeles 6 | 430.082 | Industry Hills Golf Club | None 1257 | ||
15293 | 15293 | 15292 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | 46424 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1149 | Private 7 | Commercial 20 | http://www.chevron.com/ | Private 14 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | Los Angeles 6 | 1.358 | El Segundo Blue Butterfly Preserve | 0 | Private Conservation 16 | 2 | |
15379 | 15379 | 15378 | {"type": "Polygon", "coordinates": [[[-117.91257, 34.03967], [-117.91245, 34.03993], [-117.91203, 34.04013], [-117.91193, 34.04047], [-117.91214, 34.04078], [-117.912, 34.04119], [-117.91145, 34.0417], [-117.91066, 34.04186], [-117.91045, 34.04181], [-117.90909, 34.04119], [-117.90866, 34.0401], [-117.90908, 34.03917], [-117.90923, 34.03897], [-117.90946, 34.03861], [-117.90968, 34.03813], [-117.90979, 34.03808], [-117.91005, 34.03812], [-117.91031, 34.03814], [-117.91058, 34.03814], [-117.91129, 34.03809], [-117.91192, 34.03815], [-117.91189, 34.03836], [-117.91225, 34.0388], [-117.91242, 34.03907], [-117.91257, 34.03967]]]} | Restricted Access 2 | 46592 | Big League Dreams Sportsplex | 29897 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 6109 | Big League Dreams 803 | Private 7 | Commercial 18 | Los Angeles 6 | 27.328 | Big League Dreams Sportsplex | None 1357 | |||
17053 | 17053 | 17052 | {"type": "Polygon", "coordinates": [[[-118.20385, 34.15912], [-118.20364, 34.15913], [-118.20283, 34.15904], [-118.20265, 34.15903], [-118.20242, 34.15906], [-118.20215, 34.15918], [-118.20198, 34.15931], [-118.20187, 34.15946], [-118.20181, 34.15961], [-118.20163, 34.16029], [-118.20152, 34.16049], [-118.20134, 34.16069], [-118.20113, 34.16084], [-118.20035, 34.16128], [-118.19998, 34.16144], [-118.19952, 34.16158], [-118.19932, 34.16163], [-118.19902, 34.16167], [-118.19849, 34.16169], [-118.19592, 34.16158], [-118.19553, 34.16156], [-118.19518, 34.16157], [-118.19473, 34.16163], [-118.19442, 34.1617], [-118.19389, 34.16188], [-118.19365, 34.16167], [-118.19365, 34.16163], [-118.19384, 34.16147], [-118.19386, 34.16142], [-118.19384, 34.16133], [-118.19377, 34.1612], [-118.19376, 34.16113], [-118.19382, 34.16092], [-118.19381, 34.16077], [-118.19383, 34.16072], [-118.19397, 34.16063], [-118.19415, 34.16047], [-118.1942, 34.16046], [-118.19428, 34.16047], [-118.19437, 34.16057], [-118.19449, 34.16065], [-118.19459, 34.16067], [-118.19469, 34.16066], [-118.19481, 34.16059], [-118.19508, 34.16038], [-118.1952, 34.16036], [-118.19532, 34.16032], [-118.19559, 34.16013], [-118.19567, 34.16001], [-118.19576, 34.15995], [-118.19586, 34.15985], [-118.19589, 34.15979], [-118.1959, 34.1593], [-118.19593, 34.15921], [-118.19598, 34.15913], [-118.19606, 34.15906], [-118.19614, 34.15902], [-118.19629, 34.15897], [-118.1965, 34.15894], [-118.19678, 34.15894], [-118.19707, 34.15878], [-118.19761, 34.15832], [-118.19787, 34.15792], [-118.19805, 34.15789], [-118.1985, 34.1582], [-118.19855, 34.15817], [-118.19866, 34.15816], [-118.199, 34.15799], [-118.1992, 34.15792], [-118.19932, 34.15784], [-118.19949, 34.15777], [-118.19957, 34.1577], [-118.19971, 34.15763], [-118.19978, 34.1576], [-118.19992, 34.15761], [-118.20004, 34.15771], [-118.2004, 34.15772], [-118.20115, 34.15799], [-118.20281, 34.15819], [-118.20278, 34.1576], [-118.20345, 34.15779], [-118.20361, 34.15821], [-118.20366, 34.15888], [-118.20384, 34.15885], [-118.20385, 34.15912]]]} | Restricted Access 2 | 6955 | Scholl Canyon Golf Course & Tennis Center | 29385 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | http://www.schollcanyongc.com/ | Los Angeles 6 | 60.199 | Scholl Canyon GC & Tennis Ctr. | None 1427 |
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]);