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
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Home Owners Association · 5 ✖
MNG_AGENCY 1
- Home Owners Association - Unknown Name · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
14787 | 14787 | 14786 | {"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.63101], [-116.94885, 32.63109], [-116.94898, 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.62811], [-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]]], [[[-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.98748, 32.64821], [-116.98746, 32.64827], [-116.98718, 32.64855], [-116.98694, 32.64882], [-116.98664, 32.64925], [-116.98652, 32.64925], [-116.98693, 32.64859], [-116.98705, 32.64846], [-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]]]]} | Restricted Access 2 | HOA Open Space | 31748 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | Private 14 | 8.518 | HOA OS |
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]);