units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 32
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 1
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12116 | 12116 | 12115 | {"type": "Polygon", "coordinates": [[[-118.12784, 34.13519], [-118.12781, 34.13533], [-118.1278, 34.13577], [-118.12776, 34.13581], [-118.12451, 34.13581], [-118.12429, 34.13529], [-118.12521, 34.13501], [-118.12521, 34.13476], [-118.12477, 34.13488], [-118.1247, 34.13468], [-118.12461, 34.13465], [-118.12407, 34.13481], [-118.12406, 34.13478], [-118.12475, 34.13457], [-118.12476, 34.13456], [-118.12458, 34.13415], [-118.12453, 34.13412], [-118.12386, 34.13432], [-118.12384, 34.13426], [-118.12487, 34.13395], [-118.12482, 34.13381], [-118.12471, 34.13363], [-118.12471, 34.13354], [-118.1248, 34.13354], [-118.12482, 34.13311], [-118.12511, 34.13311], [-118.12516, 34.13297], [-118.12521, 34.13297], [-118.12524, 34.1328], [-118.1253, 34.13269], [-118.12541, 34.13258], [-118.12556, 34.13249], [-118.12567, 34.13245], [-118.12583, 34.13242], [-118.12783, 34.13242], [-118.12784, 34.13519]]]} | Open Access 1 | 25053 | Tournament Park | 29146 | 3362 | California Institute of Technology 1005 | Non Profit 6 | Non Profit - Education 34 | http://www.caltech.edu/ | Non Governmental Organization 10 | 3362 | California Institute of Technology 968 | Non Profit 6 | Non Profit - Education 32 | Los Angeles 6 | 25.881 | Tournament Park | 0 | Private Recreation or Education 65 | 4 | |
16271 | 16271 | 16270 | {"type": "MultiPolygon", "coordinates": [[[[-118.7196, 34.04372], [-118.71953, 34.04551], [-118.71958, 34.04915], [-118.71638, 34.0492], [-118.71638, 34.04989], [-118.7163, 34.04988], [-118.71595, 34.04962], [-118.71587, 34.04959], [-118.71578, 34.04961], [-118.71562, 34.04972], [-118.71557, 34.04971], [-118.71541, 34.0496], [-118.71532, 34.0496], [-118.71497, 34.0498], [-118.71484, 34.04985], [-118.71471, 34.04987], [-118.71447, 34.04987], [-118.7144, 34.04979], [-118.71416, 34.04981], [-118.71418, 34.04992], [-118.71406, 34.04998], [-118.71424, 34.05015], [-118.71452, 34.05017], [-118.71463, 34.05015], [-118.71433, 34.05032], [-118.71451, 34.05037], [-118.71442, 34.05047], [-118.71442, 34.05074], [-118.71436, 34.05085], [-118.71437, 34.051], [-118.71429, 34.05115], [-118.71428, 34.05131], [-118.71413, 34.05131], [-118.71376, 34.05162], [-118.71351, 34.05157], [-118.71325, 34.05171], [-118.71325, 34.05173], [-118.71341, 34.05174], [-118.71327, 34.05184], [-118.71327, 34.05186], [-118.71343, 34.05188], [-118.71318, 34.0523], [-118.71309, 34.05228], [-118.71296, 34.05242], [-118.71278, 34.05243], [-118.71262, 34.05239], [-118.7126, 34.05226], [-118.71251, 34.0522], [-118.71227, 34.05186], [-118.71225, 34.05221], [-118.71176, 34.05228], [-118.71166, 34.05233], [-118.71163, 34.05237], [-118.71162, 34.05243], [-118.7117, 34.05269], [-118.71146, 34.05282], [-118.71144, 34.05301], [-118.71134, 34.05302], [-118.71116, 34.05283], [-118.71107, 34.05283], [-118.71086, 34.05248], [-118.71061, 34.05232], [-118.71054, 34.05236], [-118.71039, 34.05229], [-118.71021, 34.05203], [-118.70981, 34.05186], [-118.70972, 34.05179], [-118.70965, 34.0517], [-118.70955, 34.05148], [-118.7095, 34.05142], [-118.70943, 34.05139], [-118.70918, 34.05138], [-118.70907, 34.05134], [-118.70893, 34.05125], [-118.7087, 34.05103], [-118.7084, 34.05106], [-118.70791, 34.05021], [-118.70522, 34.04897], [-118.70517, 34.04899], [-118.70481, 34.04888], [-118.70429, 34.04858], [-118.70417, 34.04856], [-118.70385, 34.0486], [-118.70374, 34.04857], [-118.70369, 34.04853], [-118.70361, 34.0484], [-118.70353, 34.04833], [-118.70316, 34.04821], [-118.70305, 34.04816], [-118.70291, 34.04807], [-118.70263, 34.04783], [-118.70231, 34.0477], [-118.70208, 34.04747], [-118.70188, 34.04739], [-118.70167, 34.04699], [-118.70157, 34.04686], [-118.70148, 34.0468], [-118.70111, 34.0466], [-118.70099, 34.04648], [-118.70078, 34.04619], [-118.7011, 34.04639], [-118.70129, 34.04648], [-118.70149, 34.04653], [-118.70181, 34.04656], [-118.70151, 34.04637], [-118.70133, 34.04629], [-118.70125, 34.04623], [-118.701, 34.0459], [-118.70074, 34.04563], [-118.70067, 34.0456], [-118.70034, 34.04557], [-118.70007, 34.04549], [-118.69954, 34.04514], [-118.69939, 34.04499], [-118.6993, 34.04495], [-118.69906, 34.04496], [-118.69879, 34.04507], [-118.69873, 34.0451], [-118.6987, 34.04515], [-118.69869, 34.04521], [-118.6987, 34.04527], [-118.69884, 34.04544], [-118.69889, 34.04555], [-118.6989, 34.04564], [-118.69888, 34.04582], [-118.69895, 34.04602], [-118.69893, 34.04616], [-118.69807, 34.04554], [-118.69849, 34.04479], [-118.69899, 34.04471], [-118.69928, 34.04363], [-118.69905, 34.04238], [-118.70187, 34.04238], [-118.70296, 34.04405], [-118.70363, 34.04411], [-118.70391, 34.04409], [-118.70409, 34.04405], [-118.70426, 34.04399], [-118.70443, 34.04391], [-118.70457, 34.04381], [-118.70532, 34.0444], [-118.70446, 34.04496], [-118.70494, 34.04547], [-118.70561, 34.04503], [-118.70571, 34.0449], [-118.70629, 34.04452], [-118.70648, 34.04451], [-118.70665, 34.04471], [-118.70673, 34.04484], [-118.70675, 34.04494], [-118.70674, 34.04504], [-118.70673, 34.04508], [-118.70667, 34.04508], [-118.70664, 34.04515], [-118.7067, 34.04517], [-118.70667, 34.04522], [-118.70655, 34.04534], [-118.7064, 34.04542], [-118.70622, 34.04546], [-118.70609, 34.04546], [-118.70597, 34.04544], [-118.70599, 34.04539], [-118.7059, 34.04536], [-118.70581, 34.0455], [-118.70611, 34.04616], [-118.7067, 34.04621], [-118.70764, 34.04598], [-118.70778, 34.04637], [-118.70875, 34.04646], [-118.70972, 34.04542], [-118.70988, 34.04546], [-118.70994, 34.0454], [-118.71112, 34.04528], [-118.71112, 34.0462], [-118.7135, 34.04619], [-118.71353, 34.04627], [-118.7141, 34.04713], [-118.71424, 34.04725], [-118.71442, 34.04734], [-118.71446, 34.0474], [-118.71452, 34.04744], [-118.71458, 34.04744], [-118.71468, 34.0474], [-118.71513, 34.0474], [-118.71538, 34.04737], [-118.71562, 34.0473], [-118.71583, 34.04718], [-118.716, 34.04703], [-118.71613, 34.04684], [-118.71618, 34.04671], [-118.71621, 34.04646], [-118.71623, 34.04643], [-118.71638, 34.04639], [-118.71645, 34.0465], [-118.71644, 34.04652], [-118.71653, 34.04659], [-118.71679, 34.04647], [-118.71704, 34.04629], [-118.71708, 34.0462], [-118.71709, 34.04611], [-118.71689, 34.04596], [-118.71698, 34.04581], [-118.71714, 34.04592], [-118.71736, 34.04551], [-118.71739, 34.04527], [-118.71724, 34.04492], [-118.7172, 34.04486], [-118.71713, 34.04482], [-118.71704, 34.04479], [-118.71665, 34.04478], [-118.71618, 34.04479], [-118.71593, 34.04483], [-118.71589, 34.04481], [-118.71558, 34.04463], [-118.7159, 34.04412], [-118.71593, 34.04403], [-118.71594, 34.04394], [-118.71591, 34.0438], [-118.71583, 34.04368], [-118.7157, 34.04358], [-118.71551, 34.04351], [-118.71547, 34.04347], [-118.7156, 34.04283], [-118.71557, 34.04264], [-118.71548, 34.04247], [-118.71538, 34.04237], [-118.71527, 34.04228], [-118.71514, 34.04222], [-118.715, 34.04217], [-118.71485, 34.04215], [-118.71469, 34.04215], [-118.71455, 34.04217], [-118.71442, 34.04221], [-118.71424, 34.04231], [-118.7141, 34.04244], [-118.71348, 34.04342], [-118.71339, 34.04352], [-118.71325, 34.04359], [-118.7131, 34.04361], [-118.71296, 34.04359], [-118.71287, 34.04356], [-118.71283, 34.04352], [-118.71332, 34.04277], [-118.71343, 34.04255], [-118.71335, 34.04251], [-118.71346, 34.04218], [-118.71351, 34.04183], [-118.71344, 34.04162], [-118.71333, 34.04141], [-118.7127, 34.04065], [-118.71262, 34.04053], [-118.71254, 34.04033], [-118.71253, 34.04011], [-118.71259, 34.04023], [-118.7129, 34.04012], [-118.71317, 34.04044], [-118.71395, 34.04065], [-118.71445, 34.04019], [-118.71445, 34.04017], [-118.71435, 34.0401], [-118.7144, 34.04002], [-118.71438, 34.03994], [-118.71455, 34.03986], [-118.7149, 34.03942], [-118.7148, 34.03936], [-118.71442, 34.03922], [-118.71444, 34.03919], [-118.71494, 34.03937], [-118.71526, 34.03895], [-118.71505, 34.03775], [-118.71571, 34.03694], [-118.71512, 34.03605], [-118.71358, 34.03503], [-118.71483, 34.03493], [-118.71809, 34.03679], [-118.7184, 34.03923], [-118.71835, 34.04035], [-118.71933, 34.04219], [-118.7196, 34.04372]]], [[[-118.70509, 34.04902], [-118.70418, 34.04939], [-118.70319, 34.0494], [-118.70134, 34.04835], [-118.70124, 34.04784], [-118.69899, 34.0462], [-118.69901, 34.04602], [-118.69894, 34.04582], [-118.69896, 34.04564], [-118.69895, 34.04555], [-118.6989, 34.04542], [-118.69877, 34.04525], [-118.69876, 34.04519], [-118.69877, 34.04516], [-118.69883, 34.04511], [-118.69911, 34.045], [-118.69918, 34.04499], [-118.69928, 34.045], [-118.69934, 34.04503], [-118.69949, 34.04518], [-118.70005, 34.04554], [-118.7003, 34.04562], [-118.7007, 34.04567], [-118.70094, 34.04593], [-118.7012, 34.04626], [-118.70129, 34.04633], [-118.70144, 34.0464], [-118.7016, 34.04649], [-118.7014, 34.04646], [-118.70113, 34.04635], [-118.70088, 34.04619], [-118.7006, 34.04597], [-118.70059, 34.04597], [-118.70076, 34.04628], [-118.701, 34.04658], [-118.70108, 34.04664], [-118.70144, 34.04684], [-118.70155, 34.04693], [-118.70164, 34.04705], [-118.7018, 34.04738], [-118.70186, 34.04744], [-118.70204, 34.04751], [-118.70222, 34.04769], [-118.70231, 34.04776], [-118.70259, 34.04787], [-118.70297, 34.04818], [-118.70313, 34.04826], [-118.7035, 34.04838], [-118.70356, 34.04844], [-118.70363, 34.04856], [-118.70369, 34.04861], [-118.70377, 34.04864], [-118.70385, 34.04865], [-118.70416, 34.04861], [-118.70423, 34.04862], [-118.70478, 34.04892], [-118.70509, 34.04902]]], [[[-118.7164, 34.05288], [-118.71536, 34.05292], [-118.71535, 34.0565], [-118.71496, 34.05681], [-118.71433, 34.05616], [-118.71375, 34.056], [-118.71369, 34.05587], [-118.7137, 34.05546], [-118.71346, 34.05539], [-118.71325, 34.05559], [-118.71294, 34.05564], [-118.7119, 34.05521], [-118.7114, 34.05467], [-118.71125, 34.05431], [-118.71113, 34.05418], [-118.71111, 34.05419], [-118.71111, 34.0544], [-118.71125, 34.05473], [-118.71179, 34.05532], [-118.71291, 34.05578], [-118.71333, 34.05572], [-118.71351, 34.05555], [-118.71353, 34.05556], [-118.71353, 34.05589], [-118.71362, 34.05611], [-118.71423, 34.05628], [-118.71499, 34.05705], [-118.7152, 34.05749], [-118.71503, 34.05836], [-118.71515, 34.05874], [-118.71533, 34.05896], [-118.71533, 34.0673], [-118.7111, 34.06737], [-118.71111, 34.05477], [-118.7092, 34.05244], [-118.70843, 34.05111], [-118.70867, 34.05109], [-118.70889, 34.05129], [-118.70903, 34.05139], [-118.70917, 34.05143], [-118.70941, 34.05144], [-118.70946, 34.05146], [-118.70948, 34.05149], [-118.70959, 34.05172], [-118.7097, 34.05185], [-118.70982, 34.05192], [-118.71016, 34.05207], [-118.71034, 34.05233], [-118.71055, 34.05242], [-118.71061, 34.05238], [-118.71081, 34.05252], [-118.71103, 34.05288], [-118.71113, 34.05288], [-118.7113, 34.05308], [-118.71149, 34.05306], [-118.71152, 34.05286], [-118.71178, 34.05271], [-118.71169, 34.05243], [-118.7117, 34.05239], [-118.71172, 34.05235], [-118.71231, 34.05225], [-118.71233, 34.05204], [-118.71246, 34.05224], [-118.71254, 34.05229], [-118.71256, 34.05243], [-118.71277, 34.05249], [-118.71299, 34.05247], [-118.71311, 34.05234], [-118.71322, 34.05236], [-118.71353, 34.05185], [-118.71352, 34.05184], [-118.7134, 34.05182], [-118.71356, 34.05169], [-118.71343, 34.05168], [-118.71352, 34.05163], [-118.71378, 34.05168], [-118.71416, 34.05136], [-118.71434, 34.05136], [-118.71435, 34.05116], [-118.71443, 34.05102], [-118.71443, 34.05086], [-118.71448, 34.05075], [-118.71448, 34.05049], [-118.71455, 34.05041], [-118.71493, 34.05025], [-118.71492, 34.05024], [-118.71451, 34.05032], [-118.71447, 34.0503], [-118.71469, 34.05018], [-118.71479, 34.05008], [-118.71451, 34.05011], [-118.71428, 34.0501], [-118.71416, 34.04999], [-118.71425, 34.04995], [-118.71423, 34.04986], [-118.71437, 34.04985], [-118.71443, 34.04992], [-118.71472, 34.04992], [-118.71486, 34.0499], [-118.715, 34.04985], [-118.71534, 34.04965], [-118.71539, 34.04966], [-118.71554, 34.04976], [-118.7156, 34.04978], [-118.71568, 34.04976], [-118.71582, 34.04965], [-118.71587, 34.04964], [-118.71626, 34.04993], [-118.71638, 34.04995], [-118.71638, 34.05005], [-118.71605, 34.04994], [-118.71599, 34.04996], [-118.71596, 34.05001], [-118.716, 34.05007], [-118.71638, 34.05027], [-118.7164, 34.05288]]], [[[-118.71534, 34.05761], [-118.71533, 34.05871], [-118.71533, 34.05872], [-118.7153, 34.05868], [-118.7152, 34.05836], [-118.71534, 34.05761]]], [[[-118.71534, 34.05717], [-118.71534, 34.05717], [-118.71534, 34.05742], [-118.71522, 34.05717], [-118.71534, 34.05717]]], [[[-118.71638, 34.05021], [-118.71603, 34.05002], [-118.71603, 34.05], [-118.71605, 34.05], [-118.71638, 34.05011], [-118.71638, 34.05021]]]]} | Open Access 1 | 48999 | Pepperdine University Open Space | 33698 | 3399 | Pepperdine University 1169 | Non Profit 6 | Non Profit - Education 34 | https://www.pepperdine.edu/ | Non Governmental Organization 10 | 3399 | Pepperdine University 1108 | Non Profit 6 | Non Profit - Education 32 | Los Angeles 6 | 517.886 | Pepperdine University OS | 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]);