units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 629 and MNG_AG_TYP = 15 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, ACRES, LABEL_NAME, GAP_STS
DES_TP 2
MNG_AG_TYP 1
- Home Owners Association · 27 ✖
MNG_AGENCY 1
- Home Owners Association - Unknown Name · 27 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14788 | 14788 | 14787 | {"type": "Polygon", "coordinates": [[[-116.99842, 32.62091], [-116.9984, 32.62094], [-116.99795, 32.62104], [-116.99791, 32.62102], [-116.99774, 32.62046], [-116.99776, 32.62042], [-116.99821, 32.62033], [-116.99825, 32.62035], [-116.99842, 32.62091]]]} | Restricted Access 2 | 45176 | Wisteria Park | 33350 | 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.858 | Wisteria Park | 0 | Private Recreation or Education 65 | 4 | ||
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 | ||
14797 | 14797 | 14796 | {"type": "Polygon", "coordinates": [[[-116.97573, 32.61392], [-116.97559, 32.61421], [-116.97545, 32.61416], [-116.97534, 32.61417], [-116.97525, 32.61422], [-116.9752, 32.6143], [-116.97465, 32.61411], [-116.97466, 32.61409], [-116.97479, 32.61409], [-116.97496, 32.61406], [-116.97549, 32.61389], [-116.97561, 32.61388], [-116.97573, 32.6139], [-116.97573, 32.61392]]]} | Restricted Access 2 | 45183 | Terracotta Park | 33352 | 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.546 | Terracotta Park | 0 | Private Recreation or Education 65 | 4 | ||
14795 | 14795 | 14794 | {"type": "Polygon", "coordinates": [[[-117.09011, 32.59473], [-117.08972, 32.59469], [-117.08918, 32.59467], [-117.08903, 32.5938], [-117.08962, 32.59389], [-117.08963, 32.59399], [-117.08946, 32.59415], [-117.08978, 32.59442], [-117.08985, 32.5944], [-117.08996, 32.59434], [-117.09002, 32.59442], [-117.09011, 32.59473]]]} | Restricted Access 2 | 45181 | Swiss Park | 33368 | 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 | 1.419 | Swiss Park | 0 | Private Recreation or Education 65 | 4 | ||
14782 | 14782 | 14781 | {"type": "Polygon", "coordinates": [[[-116.98239, 32.62449], [-116.98165, 32.62469], [-116.98153, 32.62438], [-116.98226, 32.62417], [-116.98239, 32.62449]]]} | Restricted Access 2 | 45169 | Sienna Park | 33365 | 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.67 | Sienna Park | 0 | Private Recreation or Education 65 | 4 | ||
14787 | 14787 | 14786 | {"type": "Polygon", "coordinates": [[[-117.0031, 32.62517], [-117.00301, 32.62553], [-117.00297, 32.62555], [-117.00229, 32.62541], [-117.00226, 32.62538], [-117.00235, 32.62501], [-117.00239, 32.62499], [-117.00308, 32.62513], [-117.0031, 32.62517]]]} | Restricted Access 2 | 45174 | Orchard Park | 33354 | 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.846 | Orchard Park | 0 | Private Recreation or Education 65 | 4 | ||
3813 | 3813 | 3812 | {"type": "Polygon", "coordinates": [[[-116.99456, 32.62803], [-116.99407, 32.62875], [-116.99394, 32.62888], [-116.99368, 32.62907], [-116.99364, 32.62907], [-116.99332, 32.62882], [-116.9933, 32.62871], [-116.99399, 32.62774], [-116.99403, 32.62773], [-116.99455, 32.62799], [-116.99456, 32.62803]]]} | Restricted Access 2 | 45186 | Oak Crest Park | 33358 | 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 | 2.168 | Oak Crest Park | 0 | Private Recreation or Education 65 | 4 | ||
14785 | 14785 | 14784 | {"type": "Polygon", "coordinates": [[[-116.98144, 32.61519], [-116.98142, 32.61521], [-116.9809, 32.61533], [-116.98087, 32.61531], [-116.98071, 32.6148], [-116.98073, 32.61478], [-116.98126, 32.61466], [-116.98128, 32.61468], [-116.98144, 32.61519]]]} | Restricted Access 2 | 45172 | Mulberry Park | 33359 | 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.858 | Mulberry Park | 0 | Private Recreation or Education 65 | 4 | ||
4265 | 4265 | 4264 | {"type": "Polygon", "coordinates": [[[-116.9567, 32.66503], [-116.95654, 32.66512], [-116.95638, 32.66517], [-116.95606, 32.66524], [-116.95601, 32.66487], [-116.95602, 32.66467], [-116.95616, 32.66437], [-116.95618, 32.66437], [-116.95629, 32.66455], [-116.95631, 32.66456], [-116.95642, 32.66473], [-116.95646, 32.66474], [-116.9567, 32.66503]]]} | Restricted Access 2 | 45205 | Magnolia Hill Park | 33356 | 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.848 | Magnolia Hill Park | 0 | Private Recreation or Education 65 | 4 | ||
3814 | 3814 | 3813 | {"type": "Polygon", "coordinates": [[[-116.96275, 32.65963], [-116.96272, 32.6598], [-116.96273, 32.65988], [-116.96252, 32.65994], [-116.96249, 32.65993], [-116.96238, 32.65998], [-116.96235, 32.65997], [-116.96224, 32.66002], [-116.96221, 32.66001], [-116.96195, 32.6601], [-116.96175, 32.66013], [-116.96165, 32.65965], [-116.96164, 32.6595], [-116.96167, 32.65933], [-116.96188, 32.65935], [-116.962, 32.6594], [-116.96203, 32.65939], [-116.96215, 32.65944], [-116.96218, 32.65943], [-116.96245, 32.65955], [-116.96275, 32.65963]]]} | Restricted Access 2 | 45187 | Madison Lane Park | 33353 | 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 | 1.505 | Madison Lane Park | 0 | Private Recreation or Education 65 | 4 | ||
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 | ||
14794 | 14794 | 14793 | {"type": "Polygon", "coordinates": [[[-116.95852, 32.65971], [-116.95848, 32.65998], [-116.95841, 32.66002], [-116.95813, 32.66], [-116.95816, 32.65968], [-116.95852, 32.65971]]]} | Restricted Access 2 | 45180 | Kensington Road Park | 33346 | 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.287 | Kensington Road Park | 0 | Private Recreation or Education 65 | 4 | ||
14786 | 14786 | 14785 | {"type": "Polygon", "coordinates": [[[-116.99738, 32.61585], [-116.99737, 32.61587], [-116.99645, 32.61622], [-116.99642, 32.61621], [-116.99622, 32.61584], [-116.99623, 32.61582], [-116.99716, 32.61547], [-116.99719, 32.61548], [-116.99738, 32.61585]]]} | Restricted Access 2 | 45173 | Jacaranda Park | 33362 | 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 | 1.199 | Jacaranda Park | 0 | Private Recreation or Education 65 | 4 | ||
4259 | 4259 | 4258 | {"type": "Polygon", "coordinates": [[[-116.98256, 32.62142], [-116.98251, 32.62145], [-116.98215, 32.62155], [-116.98208, 32.62155], [-116.98189, 32.62107], [-116.98195, 32.62104], [-116.98229, 32.62094], [-116.98237, 32.62094], [-116.98256, 32.62142]]]} | Restricted Access 2 | 45185 | Hillsborough Park | 33348 | 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.702 | Hillsborough Park | 0 | Private Recreation or Education 65 | 4 | ||
4258 | 4258 | 4257 | {"type": "Polygon", "coordinates": [[[-116.95997, 32.62142], [-116.9593, 32.62156], [-116.95916, 32.62104], [-116.95966, 32.62083], [-116.95972, 32.62084], [-116.95987, 32.6211], [-116.95997, 32.62142]]]} | Restricted Access 2 | 45184 | HOA Park | 31749 | 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 | 1.008 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
5619 | 5619 | 5618 | {"type": "Polygon", "coordinates": [[[-116.95083, 32.62528], [-116.95098, 32.62537], [-116.95112, 32.62549], [-116.95124, 32.62562], [-116.95133, 32.62575], [-116.95141, 32.6259], [-116.95146, 32.62607], [-116.95149, 32.62623], [-116.95148, 32.6264], [-116.95145, 32.62659], [-116.95139, 32.62673], [-116.95131, 32.62689], [-116.9512, 32.62703], [-116.95105, 32.62717], [-116.95092, 32.62727], [-116.95054, 32.62745], [-116.95053, 32.62744], [-116.95055, 32.62738], [-116.9505, 32.62727], [-116.95048, 32.62711], [-116.95051, 32.62704], [-116.95063, 32.62686], [-116.95069, 32.62661], [-116.95065, 32.62654], [-116.95065, 32.62647], [-116.95074, 32.62641], [-116.95075, 32.62617], [-116.95072, 32.62598], [-116.95077, 32.62571], [-116.95079, 32.62547], [-116.95085, 32.62535], [-116.95082, 32.6253], [-116.95083, 32.62528]]]} | Restricted Access 2 | 45188 | HOA Park | 31749 | 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 | 3.222 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
4960 | 4960 | 4959 | {"type": "MultiPolygon", "coordinates": [[[[-116.95389, 32.62879], [-116.95386, 32.62885], [-116.95334, 32.62907], [-116.95288, 32.6293], [-116.94886, 32.63154], [-116.94878, 32.63152], [-116.94777, 32.63021], [-116.94712, 32.62933], [-116.94715, 32.62927], [-116.9473, 32.6292], [-116.94749, 32.62947], [-116.94866, 32.63102], [-116.94885, 32.63109], [-116.94899, 32.63111], [-116.94912, 32.6311], [-116.94923, 32.63107], [-116.95003, 32.63059], [-116.95025, 32.6302], [-116.95064, 32.63024], [-116.95164, 32.62962], [-116.95191, 32.62941], [-116.95206, 32.62932], [-116.95252, 32.62929], [-116.95344, 32.62876], [-116.95358, 32.62861], [-116.95357, 32.62844], [-116.95371, 32.62841], [-116.95389, 32.62879]]], [[[-116.95778, 32.62794], [-116.95704, 32.6281], [-116.95487, 32.62855], [-116.95422, 32.62873], [-116.95415, 32.6287], [-116.954, 32.6284], [-116.95407, 32.62837], [-116.95416, 32.62846], [-116.95443, 32.62854], [-116.95604, 32.62813], [-116.95694, 32.62793], [-116.95724, 32.62792], [-116.95741, 32.62789], [-116.95759, 32.62775], [-116.95778, 32.62794]]]]} | Restricted Access 2 | 45161 | HOA Open Space | 31748 | 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 | 7.416 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
4962 | 4962 | 4961 | {"type": "MultiPolygon", "coordinates": [[[[-116.98594, 32.6469], [-116.98591, 32.64692], [-116.98584, 32.64693], [-116.98545, 32.64674], [-116.98558, 32.64668], [-116.98578, 32.64682], [-116.98594, 32.6469]]], [[[-116.98664, 32.64925], [-116.98652, 32.64925], [-116.98693, 32.64859], [-116.98705, 32.64845], [-116.98707, 32.64834], [-116.98707, 32.64814], [-116.98696, 32.64797], [-116.98662, 32.64767], [-116.98618, 32.64741], [-116.98595, 32.64725], [-116.98675, 32.64765], [-116.98695, 32.64777], [-116.98717, 32.64793], [-116.98748, 32.64821], [-116.98747, 32.64827], [-116.98717, 32.64855], [-116.98694, 32.64882], [-116.98664, 32.64925]]]]} | Restricted Access 2 | 45162 | HOA Open Space | 31748 | 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 | 1.099 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
14793 | 14793 | 14792 | {"type": "Polygon", "coordinates": [[[-116.97964, 32.65322], [-116.97946, 32.65338], [-116.97929, 32.65355], [-116.97916, 32.65372], [-116.97904, 32.65392], [-116.97898, 32.65372], [-116.97898, 32.65359], [-116.979, 32.65344], [-116.97897, 32.65339], [-116.97893, 32.65338], [-116.97888, 32.65338], [-116.97879, 32.65349], [-116.97871, 32.65353], [-116.97847, 32.65357], [-116.97835, 32.65366], [-116.97829, 32.65369], [-116.9782, 32.65371], [-116.97813, 32.65369], [-116.97806, 32.65365], [-116.97801, 32.65358], [-116.97795, 32.6532], [-116.97789, 32.65307], [-116.97778, 32.65298], [-116.97745, 32.65283], [-116.97781, 32.65226], [-116.97964, 32.65319], [-116.97964, 32.65322]]]} | Restricted Access 2 | 45164 | East Lake Beach Club | 33361 | 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 | 4.065 | East Lake Beach Club | 0 | Private Recreation or Education 65 | 4 | ||
14771 | 14771 | 14770 | {"type": "Polygon", "coordinates": [[[-116.9516, 32.63377], [-116.9514, 32.63414], [-116.95109, 32.63446], [-116.95092, 32.63457], [-116.95086, 32.63458], [-116.95074, 32.63445], [-116.95043, 32.63406], [-116.95014, 32.63366], [-116.94988, 32.63325], [-116.95034, 32.63301], [-116.9505, 32.63319], [-116.95068, 32.63332], [-116.95108, 32.63351], [-116.95155, 32.63368], [-116.9516, 32.63377]]]} | Restricted Access 2 | 45165 | Dolphin Beach Club | 33351 | 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 | 3.296 | Dolphin Beach Club | 0 | Private Recreation or Education 65 | 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]);