superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where MNG_AGENCY = 629 and MNG_AG_TYP = 15 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Home Owners Association · 25 ✖
MNG_AGENCY 1
- Home Owners Association - Unknown Name · 25 ✖
ACCESS_TYP 1
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13012 | 13012 | 13011 | {"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 | Kensington Road Park | 33346 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.287 | Kensington Road Park | |||
13030 | 13030 | 13029 | {"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 | Terracotta Park | 33352 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.546 | Terracotta Park | |||
13051 | 13051 | 13050 | {"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 | Sienna Park | 33365 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.67 | Sienna Park | |||
14414 | 14414 | 14413 | {"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 | The Breezeway | 33355 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.674 | The Breezeway | |||
13027 | 13027 | 13026 | {"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 | Hillsborough Park | 33348 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.702 | Hillsborough Park | |||
13035 | 13035 | 13034 | {"type": "Polygon", "coordinates": [[[-116.97738, 32.65693], [-116.97721, 32.65698], [-116.9771, 32.65706], [-116.97694, 32.65721], [-116.97668, 32.65643], [-116.97706, 32.65643], [-116.97724, 32.65675], [-116.97738, 32.65693]]]} | Restricted Access 2 | Cobblestone Park | 33360 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.726 | Cobblestone Park | |||
13065 | 13065 | 13064 | {"type": "Polygon", "coordinates": [[[-116.95147, 32.64226], [-116.95151, 32.64236], [-116.95151, 32.64247], [-116.95145, 32.64258], [-116.95133, 32.64266], [-116.95118, 32.64269], [-116.95105, 32.64267], [-116.95093, 32.6426], [-116.95086, 32.6425], [-116.95084, 32.6424], [-116.95087, 32.6423], [-116.95094, 32.64221], [-116.95103, 32.64215], [-116.95116, 32.64212], [-116.95126, 32.64213], [-116.95138, 32.64218], [-116.95147, 32.64226]]]} | Restricted Access 2 | Circle Park | 33367 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.754 | Circle Park | |||
12046 | 12046 | 12045 | {"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 | Orchard Park | 33354 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.846 | Orchard Park | |||
14041 | 14041 | 14040 | {"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 | Magnolia Hill Park | 33356 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.848 | Magnolia Hill Park | |||
13064 | 13064 | 13063 | {"type": "Polygon", "coordinates": [[[-116.99018, 32.63505], [-116.99014, 32.63512], [-116.98962, 32.63527], [-116.98954, 32.63523], [-116.98938, 32.63482], [-116.99002, 32.63464], [-116.99018, 32.63505]]]} | Restricted Access 2 | Alcala Park | 33366 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.849 | Alcala Park | |||
13028 | 13028 | 13027 | {"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 | Wisteria Park | 33350 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.857 | Wisteria Park | |||
13034 | 13034 | 13033 | {"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 | Mulberry Park | 33359 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 0.858 | Mulberry Park | |||
13041 | 13041 | 13040 | {"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 | Jacaranda Park | 33362 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.199 | Jacaranda Park | |||
13032 | 13032 | 13031 | {"type": "Polygon", "coordinates": [[[-116.97617, 32.63948], [-116.97614, 32.6399], [-116.97612, 32.64006], [-116.9761, 32.64008], [-116.97549, 32.64002], [-116.97527, 32.63998], [-116.97525, 32.63995], [-116.97541, 32.63942], [-116.97545, 32.6394], [-116.97578, 32.63945], [-116.97615, 32.63945], [-116.97617, 32.63948]]]} | Restricted Access 2 | Countryside Park | 33357 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.298 | Countryside Park | |||
13013 | 13013 | 13012 | {"type": "Polygon", "coordinates": [[[-117.00158, 32.64883], [-117.00127, 32.64895], [-117.00104, 32.64919], [-117.00075, 32.64957], [-117.00074, 32.64972], [-117.00066, 32.64986], [-117.00056, 32.64962], [-117.00018, 32.64972], [-117.00016, 32.64965], [-117.00053, 32.64954], [-117.00037, 32.64912], [-117.00095, 32.64895], [-117.00084, 32.64865], [-117.00104, 32.6486], [-117.00118, 32.64862], [-117.00145, 32.6487], [-117.00158, 32.64883]]]} | Restricted Access 2 | Bonitas Haciendas Mini-Park | 33347 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.4 | Bonitas Haciendas Mini-Park | |||
13079 | 13079 | 13078 | {"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.08947, 32.59416], [-117.08978, 32.59441], [-117.08985, 32.5944], [-117.08996, 32.59434], [-117.09002, 32.59442], [-117.09011, 32.59473]]]} | Restricted Access 2 | Swiss Park | 33368 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.422 | Swiss Park | |||
13031 | 13031 | 13030 | {"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 | Madison Lane Park | 33353 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 1.505 | Madison Lane Park | |||
13033 | 13033 | 13032 | {"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 | Oak Crest Park | 33358 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 2.168 | Oak Crest Park | |||
13042 | 13042 | 13041 | {"type": "Polygon", "coordinates": [[[-116.95784, 32.6469], [-116.95776, 32.64726], [-116.95776, 32.64742], [-116.95656, 32.64741], [-116.95641, 32.64735], [-116.95632, 32.64703], [-116.95625, 32.64688], [-116.95615, 32.64672], [-116.95619, 32.64666], [-116.95674, 32.64628], [-116.95698, 32.64648], [-116.95726, 32.64666], [-116.95755, 32.64679], [-116.95784, 32.6469]]]} | Restricted Access 2 | Augusta Park | 33363 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 3.216 | Augusta Park | |||
13029 | 13029 | 13028 | {"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 | Dolphin Beach Club | 33351 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 3.296 | Dolphin Beach Club |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);