units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, GAP_STS = 4 and MNG_AGENCY = 42
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
| 15652 | 15652 | 15651 | {"type": "Polygon", "coordinates": [[[-117.28127, 33.07733], [-117.28113, 33.07742], [-117.2812, 33.07751], [-117.28126, 33.0776], [-117.28122, 33.07759], [-117.28117, 33.07759], [-117.28101, 33.07767], [-117.28079, 33.07775], [-117.28049, 33.0778], [-117.27999, 33.07785], [-117.27981, 33.07785], [-117.27954, 33.07782], [-117.27921, 33.07775], [-117.27907, 33.0777], [-117.27887, 33.07762], [-117.27868, 33.07752], [-117.27847, 33.07738], [-117.27806, 33.07706], [-117.27777, 33.07676], [-117.27755, 33.07699], [-117.27683, 33.0771], [-117.27543, 33.07714], [-117.27537, 33.0771], [-117.27536, 33.07715], [-117.27528, 33.07707], [-117.27512, 33.07701], [-117.275, 33.07701], [-117.27489, 33.07697], [-117.27485, 33.07693], [-117.27477, 33.07693], [-117.27462, 33.0771], [-117.27461, 33.07716], [-117.27447, 33.07719], [-117.2744, 33.07717], [-117.27431, 33.07721], [-117.27412, 33.07735], [-117.27414, 33.07739], [-117.27395, 33.07748], [-117.27383, 33.07751], [-117.27377, 33.07755], [-117.27375, 33.0777], [-117.27369, 33.07779], [-117.27362, 33.07787], [-117.27344, 33.07789], [-117.27327, 33.07787], [-117.27318, 33.07782], [-117.27313, 33.07775], [-117.2731, 33.07766], [-117.27303, 33.07755], [-117.27303, 33.07747], [-117.27307, 33.07736], [-117.27316, 33.07726], [-117.27309, 33.07701], [-117.27312, 33.07693], [-117.27317, 33.07689], [-117.27332, 33.07686], [-117.2734, 33.07692], [-117.27353, 33.07688], [-117.27355, 33.07684], [-117.27362, 33.0769], [-117.27375, 33.07696], [-117.27389, 33.077], [-117.27397, 33.077], [-117.274, 33.07698], [-117.27402, 33.07691], [-117.27412, 33.07687], [-117.27424, 33.07686], [-117.27428, 33.07683], [-117.27429, 33.07673], [-117.27424, 33.07661], [-117.27445, 33.07661], [-117.27465, 33.07655], [-117.27476, 33.07648], [-117.27478, 33.07651], [-117.27484, 33.07652], [-117.27492, 33.07647], [-117.27493, 33.07644], [-117.27505, 33.07639], [-117.27511, 33.07639], [-117.27527, 33.07631], [-117.27529, 33.07623], [-117.27536, 33.07621], [-117.27538, 33.07616], [-117.27546, 33.07608], [-117.27545, 33.07606], [-117.27539, 33.07607], [-117.2753, 33.07601], [-117.27528, 33.07584], [-117.27515, 33.07582], [-117.27493, 33.07572], [-117.27478, 33.07577], [-117.27469, 33.07578], [-117.27468, 33.0758], [-117.27471, 33.07582], [-117.27465, 33.07588], [-117.2745, 33.07596], [-117.27442, 33.07597], [-117.27433, 33.07603], [-117.27427, 33.07603], [-117.27425, 33.07612], [-117.27402, 33.07611], [-117.27399, 33.07628], [-117.2742, 33.07632], [-117.27418, 33.07636], [-117.27409, 33.0764], [-117.27402, 33.07647], [-117.27397, 33.07647], [-117.274, 33.07643], [-117.27398, 33.07637], [-117.27392, 33.07632], [-117.27392, 33.07615], [-117.274, 33.076], [-117.27409, 33.07593], [-117.27422, 33.07595], [-117.27444, 33.07577], [-117.27444, 33.07564], [-117.27436, 33.07557], [-117.27437, 33.07548], [-117.27448, 33.07527], [-117.27447, 33.07511], [-117.2745, 33.07508], [-117.27448, 33.07501], [-117.27451, 33.07484], [-117.27449, 33.07474], [-117.2745, 33.07469], [-117.27446, 33.07459], [-117.27448, 33.07455], [-117.27446, 33.07441], [-117.2745, 33.07435], [-117.27451, 33.07417], [-117.27455, 33.07407], [-117.27457, 33.07379], [-117.27455, 33.07375], [-117.27472, 33.07359], [-117.27471, 33.07358], [-117.2743, 33.07358], [-117.27436, 33.07356], [-117.27453, 33.07355], [-117.27471, 33.0735], [-117.27492, 33.07356], [-117.27502, 33.07356], [-117.27568, 33.07363], [-117.27583, 33.07362], [-117.27616, 33.07369], [-117.27626, 33.07344], [-117.27611, 33.07339], [-117.27601, 33.07345], [-117.27564, 33.07349], [-117.27554, 33.07346], [-117.2752, 33.07345], [-117.27511, 33.07345], [-117.27505, 33.07348], [-117.27498, 33.07347], [-117.27497, 33.07344], [-117.275, 33.07336], [-117.27484, 33.07331], [-117.27414, 33.07327], [-117.27415, 33.07233], [-117.27332, 33.07232], [-117.27348, 33.07201], [-117.2734, 33.07184], [-117.27328, 33.07169], [-117.27311, 33.07142], [-117.27301, 33.07114], [-117.27299, 33.07086], [-117.27299, 33.07059], [-117.27311, 33.07004], [-117.27328, 33.069], [-117.27336, 33.06887], [-117.27371, 33.06865], [-117.27414, 33.06833], [-117.27425, 33.06821], [-117.27403, 33.06799], [-117.27387, 33.06809], [-117.27353, 33.06828], [-117.27318, 33.06843], [-117.27299, 33.06807], [-117.27241, 33.06761], [-117.27232, 33.06729], [-117.27239, 33.067], [-117.27251, 33.06679], [-117.27376, 33.06567], [-117.27404, 33.06528], [-117.27431, 33.06509], [-117.27505, 33.06466], [-117.27495, 33.06452], [-117.27434, 33.06226], [-117.27434, 33.06213], [-117.27451, 33.06091], [-117.2738, 33.06058], [-117.27372, 33.05965], [-117.2742, 33.0583], [-117.27433, 33.0579], [-117.27468, 33.05752], [-117.27469, 33.05732], [-117.27476, 33.05729], [-117.27506, 33.05724], [-117.27538, 33.05724], [-117.27618, 33.05732], [-117.27658, 33.05731], [-117.27636, 33.06206], [-117.27807, 33.06204], [-117.27864, 33.06209], [-117.27938, 33.06239], [-117.28001, 33.06237], [-117.2801, 33.06245], [-117.28037, 33.06257], [-117.28027, 33.06273], [-117.28011, 33.06289], [-117.2801, 33.06292], [-117.27902, 33.06371], [-117.27885, 33.06386], [-117.27866, 33.0641], [-117.2785, 33.06445], [-117.27845, 33.06463], [-117.27836, 33.06567], [-117.27833, 33.06584], [-117.27826, 33.06603], [-117.27824, 33.06606], [-117.27813, 33.06605], [-117.27812, 33.06607], [-117.27785, 33.06654], [-117.27785, 33.06677], [-117.27672, 33.06872], [-117.27656, 33.06872], [-117.27682, 33.07143], [-117.27661, 33.07143], [-117.27664, 33.07259], [-117.27661, 33.07278], [-117.27657, 33.07293], [-117.27628, 33.07368], [-117.27619, 33.07408], [-117.27619, 33.07442], [-117.27626, 33.07508], [-117.27629, 33.07526], [-117.27718, 33.07519], [-117.27737, 33.07523], [-117.27791, 33.07524], [-117.27891, 33.07545], [-117.2797, 33.07532], [-117.28044, 33.07595], [-117.28045, 33.07622], [-117.28065, 33.0762], [-117.28077, 33.07631], [-117.28072, 33.0766], [-117.28055, 33.07686], [-117.28029, 33.07696], [-117.28049, 33.07732], [-117.28104, 33.07718], [-117.28127, 33.07733]]]} | Restricted Access 2 | 292 | Encinitas Ranch Golf Course | 32986 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.jcgolf.com/courses-encinitas.php | San Diego 4 | 184.589 | Encinitas Ranch GC | 0 | Local Recreation Area 3 | 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]);