units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where DES_TP = 16, GAP_STS = 2 and MNG_AG_TYP = 15
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 10
- Home Owners Association - Unknown Name 2
- Woodbridge Village Association 1
- Quail Hill Community Association 1
- Rancho Santa Margarita Landscape and Recreation Corporation 1
- Portola Valley Ranch Home Owners Association 1
- Comstock South LLC 1
- Hilltop LLC 1
- Bixby Village Home Owner Association 1
- Park Paseo Homeowners Association 1
- Lake Forest Drive Association 1
MNG_AG_TYP 1
- Home Owners Association · 11 ✖
DES_TP 1
- Private Conservation · 11 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8283 | 8283 | 8282 | {"type": "Polygon", "coordinates": [[[-117.78053, 33.65114], [-117.78053, 33.65118], [-117.78037, 33.6515], [-117.78018, 33.65183], [-117.78015, 33.65185], [-117.77904, 33.65142], [-117.77904, 33.65138], [-117.77909, 33.6513], [-117.77941, 33.65074], [-117.77943, 33.65072], [-117.78053, 33.65114]]]} | Restricted Access 2 | 12675 | The Commons | 26279 | 6019 | Quail Hill Community Association 408 | Private 7 | Home Owners Association 16 | http://www.quailhillhoa.org/ | Private 14 | 6019 | Quail Hill Community Association 402 | Private 7 | Home Owners Association 15 | Orange 3 | 2.466 | The Commons | 0 | Private Conservation 16 | 2 | |
8497 | 8497 | 8496 | {"type": "Polygon", "coordinates": [[[-122.22153, 37.36198], [-122.22095, 37.36343], [-122.22116, 37.36353], [-122.22107, 37.36357], [-122.22091, 37.36383], [-122.22031, 37.36425], [-122.21982, 37.36432], [-122.21905, 37.36479], [-122.21859, 37.36468], [-122.21792, 37.36468], [-122.21681, 37.36444], [-122.21663, 37.36458], [-122.21652, 37.36457], [-122.21625, 37.36444], [-122.21573, 37.36435], [-122.21511, 37.36387], [-122.21468, 37.36376], [-122.21411, 37.36345], [-122.21396, 37.36339], [-122.21379, 37.36335], [-122.21362, 37.36334], [-122.21345, 37.36335], [-122.21329, 37.36339], [-122.21312, 37.36346], [-122.21298, 37.36354], [-122.21287, 37.36365], [-122.21278, 37.36376], [-122.21271, 37.36391], [-122.21252, 37.36381], [-122.21233, 37.36377], [-122.21212, 37.36376], [-122.21185, 37.3638], [-122.21156, 37.36357], [-122.21116, 37.36334], [-122.21102, 37.36323], [-122.21199, 37.3621], [-122.21094, 37.36096], [-122.20955, 37.35979], [-122.20929, 37.35959], [-122.20817, 37.3594], [-122.20651, 37.35691], [-122.21042, 37.352], [-122.21243, 37.35403], [-122.21338, 37.35413], [-122.21598, 37.35557], [-122.21904, 37.35912], [-122.22061, 37.36021], [-122.22153, 37.36198]]]} | Restricted Access 2 | 13289 | Coal Mine Ridge | 33341 | 6127 | Portola Valley Ranch Home Owners Association 895 | Private 7 | Home Owners Association 16 | Private 14 | 6127 | Portola Valley Ranch Home Owners Association 869 | Private 7 | Home Owners Association 15 | San Mateo 15 | 244.051 | Coal Mine Ridge | 1964 | Private Conservation 16 | 2 | ||
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 | |
12834 | 12834 | 12833 | {"type": "Polygon", "coordinates": [[[-117.57006, 33.63818], [-117.56954, 33.63885], [-117.56851, 33.63819], [-117.56793, 33.63796], [-117.56772, 33.63797], [-117.56754, 33.638], [-117.56734, 33.63809], [-117.56714, 33.63821], [-117.56675, 33.6382], [-117.56672, 33.63751], [-117.56682, 33.63751], [-117.56741, 33.63745], [-117.56825, 33.63745], [-117.56912, 33.63771], [-117.57006, 33.63818]]]} | Restricted Access 2 | 30293 | Swim & Racquet Complex | 31709 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 622 | Private 7 | Home Owners Association 16 | http://www.samlarc.org/ | Private 14 | 6061 | Rancho Santa Margarita Landscape and Recreation Corporation 611 | Private 7 | Home Owners Association 15 | Orange 3 | 5.564 | Swim & Racquet Complex | 0 | Private Conservation 16 | 2 | |
13445 | 13445 | 13444 | {"type": "Polygon", "coordinates": [[[-117.76081, 33.71748], [-117.7606, 33.71768], [-117.76047, 33.71785], [-117.76035, 33.71811], [-117.76026, 33.71821], [-117.76014, 33.71826], [-117.76006, 33.71834], [-117.76005, 33.71839], [-117.76007, 33.71842], [-117.76016, 33.71849], [-117.76013, 33.71857], [-117.76036, 33.71873], [-117.76026, 33.7188], [-117.76022, 33.71885], [-117.75996, 33.71872], [-117.75988, 33.71874], [-117.75984, 33.7187], [-117.75976, 33.71867], [-117.75892, 33.71777], [-117.75913, 33.71768], [-117.75975, 33.71737], [-117.76028, 33.71704], [-117.76057, 33.71725], [-117.76055, 33.71728], [-117.76081, 33.71748]]]} | Restricted Access 2 | 35619 | Park Paseo Recreation Center | 32332 | 6016 | Park Paseo Homeowners Association 1056 | Private 7 | Home Owners Association 16 | http://parkpaseoirvine.com/ | Private 14 | 6016 | Park Paseo Homeowners Association 1015 | Private 7 | Home Owners Association 15 | Orange 3 | 4.013 | Park Paseo Rec. Ctr. | 0 | Private Conservation 16 | 2 | |
13959 | 13959 | 13958 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | 36667 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.596 | Woodspring Pool | 0 | Private Conservation 16 | 2 | |
14157 | 14157 | 14156 | {"type": "Polygon", "coordinates": [[[-117.67909, 33.649], [-117.67893, 33.64913], [-117.67899, 33.64929], [-117.67864, 33.64938], [-117.67843, 33.64889], [-117.67844, 33.64887], [-117.67849, 33.64885], [-117.67865, 33.6488], [-117.67888, 33.64875], [-117.67905, 33.64874], [-117.67909, 33.64874], [-117.67911, 33.64877], [-117.67904, 33.64889], [-117.67905, 33.64895], [-117.67909, 33.649]]]} | Restricted Access 2 | 43052 | Sterling Heights park | 32391 | 6044 | Lake Forest Drive Association 1088 | Private 7 | Home Owners Association 16 | http://lakeforestdrivehoa.org/ | Private 14 | 6044 | Lake Forest Drive Association 1044 | Private 7 | Home Owners Association 15 | Orange 3 | 0.718 | Sterling Heights park | 0 | Private Conservation 16 | 2 | |
14781 | 14781 | 14780 | {"type": "Polygon", "coordinates": [[[-116.94846, 32.64539], [-116.94839, 32.64551], [-116.94804, 32.64538], [-116.94761, 32.64525], [-116.94727, 32.64516], [-116.94683, 32.64507], [-116.94696, 32.64451], [-116.9465, 32.64443], [-116.94654, 32.64432], [-116.94654, 32.64418], [-116.94627, 32.64341], [-116.94628, 32.6433], [-116.94633, 32.64314], [-116.94659, 32.64328], [-116.94692, 32.6434], [-116.94793, 32.64356], [-116.9478, 32.64414], [-116.9478, 32.64431], [-116.94783, 32.64446], [-116.94788, 32.64461], [-116.94795, 32.64473], [-116.94839, 32.64535], [-116.94846, 32.64539]]]} | Restricted Access 2 | 45168 | Little League Ballfields | 33364 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 6.308 | Little League Ballfields | 0 | Private Conservation 16 | 2 | ||
14783 | 14783 | 14782 | {"type": "Polygon", "coordinates": [[[-116.98285, 32.63543], [-116.98278, 32.63553], [-116.98274, 32.63564], [-116.98277, 32.63571], [-116.98272, 32.63579], [-116.98265, 32.63578], [-116.98257, 32.63579], [-116.9824, 32.63586], [-116.98222, 32.63538], [-116.98267, 32.63521], [-116.98278, 32.63525], [-116.98285, 32.63543]]]} | Restricted Access 2 | 45170 | The Breezeway | 33355 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.674 | The Breezeway | 0 | Private Conservation 16 | 2 |
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]);