units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_LEV = 7, COUNTY = 6 and MNG_AG_TYP = 15
This data as json, copyable, CSV (advanced)
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 |
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]);