units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, AGNCY_NAME = 142 and DES_TP = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12699 | 12699 | 12698 | {"type": "MultiPolygon", "coordinates": [[[[-117.70985, 33.67857], [-117.7089, 33.67965], [-117.70712, 33.67964], [-117.70551, 33.68029], [-117.70462, 33.67998], [-117.70337, 33.67949], [-117.70257, 33.67965], [-117.70248, 33.6802], [-117.70115, 33.68143], [-117.70088, 33.68206], [-117.70139, 33.68338], [-117.69594, 33.68515], [-117.6951, 33.68578], [-117.69508, 33.68911], [-117.69505, 33.68948], [-117.69478, 33.68978], [-117.69023, 33.69323], [-117.68884, 33.69254], [-117.68876, 33.69247], [-117.68787, 33.69196], [-117.68749, 33.69171], [-117.68755, 33.69165], [-117.68754, 33.69164], [-117.68635, 33.69082], [-117.67818, 33.68513], [-117.68319, 33.67915], [-117.69036, 33.67056], [-117.69217, 33.67013], [-117.69313, 33.66987], [-117.69507, 33.66931], [-117.69685, 33.66873], [-117.69785, 33.66839], [-117.69877, 33.66805], [-117.69997, 33.66759], [-117.70039, 33.66788], [-117.70076, 33.66776], [-117.70424, 33.67016], [-117.70603, 33.66837], [-117.7061, 33.66899], [-117.70616, 33.66928], [-117.70626, 33.66967], [-117.70637, 33.66995], [-117.70653, 33.67033], [-117.70677, 33.67078], [-117.70713, 33.67129], [-117.70755, 33.67177], [-117.70803, 33.67222], [-117.70864, 33.67267], [-117.70621, 33.67513], [-117.70531, 33.67585], [-117.70522, 33.67578], [-117.70465, 33.67629], [-117.70484, 33.67656], [-117.706, 33.67671], [-117.70725, 33.677], [-117.70869, 33.67813], [-117.70985, 33.67857]]], [[[-117.73183, 33.66114], [-117.73182, 33.66147], [-117.73178, 33.66176], [-117.73168, 33.66208], [-117.73155, 33.66234], [-117.73132, 33.66266], [-117.73069, 33.66332], [-117.73045, 33.66361], [-117.73021, 33.66398], [-117.73005, 33.66431], [-117.72991, 33.66472], [-117.72984, 33.66507], [-117.72982, 33.66542], [-117.72982, 33.66638], [-117.72965, 33.66641], [-117.72953, 33.66647], [-117.72942, 33.66655], [-117.72935, 33.66665], [-117.7293, 33.66681], [-117.7293, 33.66736], [-117.72826, 33.66736], [-117.72818, 33.66621], [-117.72815, 33.66598], [-117.72806, 33.66564], [-117.72791, 33.66526], [-117.72777, 33.665], [-117.72763, 33.6648], [-117.72744, 33.66455], [-117.72727, 33.66437], [-117.72691, 33.66406], [-117.72669, 33.66392], [-117.7265, 33.66381], [-117.72621, 33.66369], [-117.72591, 33.6636], [-117.7256, 33.66354], [-117.72529, 33.66352], [-117.72501, 33.66352], [-117.72478, 33.66354], [-117.72425, 33.66364], [-117.72389, 33.66369], [-117.7236, 33.6637], [-117.72321, 33.66368], [-117.72275, 33.66361], [-117.72128, 33.66328], [-117.72102, 33.66324], [-117.72079, 33.66324], [-117.72051, 33.66328], [-117.72024, 33.66336], [-117.71925, 33.6638], [-117.719, 33.66392], [-117.71877, 33.66407], [-117.71826, 33.66446], [-117.71784, 33.66474], [-117.71728, 33.66506], [-117.71693, 33.66523], [-117.71645, 33.66544], [-117.71569, 33.66569], [-117.71518, 33.66582], [-117.7148, 33.6659], [-117.71398, 33.66601], [-117.71344, 33.66604], [-117.71303, 33.66604], [-117.71177, 33.66597], [-117.71149, 33.66597], [-117.71122, 33.666], [-117.711, 33.66603], [-117.71073, 33.6661], [-117.71048, 33.66619], [-117.71024, 33.6663], [-117.71001, 33.66643], [-117.70968, 33.66669], [-117.70846, 33.66803], [-117.70827, 33.66822], [-117.70802, 33.66841], [-117.70767, 33.66861], [-117.70727, 33.66876], [-117.70696, 33.66884], [-117.70651, 33.6689], [-117.70647, 33.66847], [-117.70646, 33.6681], [-117.70657, 33.66521], [-117.7067, 33.66503], [-117.70692, 33.6648], [-117.70758, 33.66415], [-117.70779, 33.66398], [-117.70812, 33.66374], [-117.70853, 33.66351], [-117.70885, 33.66336], [-117.70925, 33.66323], [-117.70973, 33.66311], [-117.71016, 33.66305], [-117.71052, 33.66303], [-117.71095, 33.66304], [-117.71408, 33.6599], [-117.72201, 33.6571], [-117.72501, 33.6541], [-117.72501, 33.65408], [-117.72416, 33.65347], [-117.72391, 33.65326], [-117.72364, 33.65297], [-117.72343, 33.6527], [-117.72324, 33.6524], [-117.72263, 33.65125], [-117.72328, 33.6506], [-117.72775, 33.65373], [-117.72755, 33.65396], [-117.72729, 33.65429], [-117.72711, 33.65457], [-117.72692, 33.65494], [-117.72677, 33.65531], [-117.72666, 33.6557], [-117.7266, 33.65602], [-117.72656, 33.65641], [-117.72656, 33.65681], [-117.72659, 33.65705], [-117.72664, 33.65737], [-117.72674, 33.65775], [-117.72688, 33.65813], [-117.72703, 33.65843], [-117.72719, 33.65872], [-117.72743, 33.65906], [-117.72783, 33.65951], [-117.72829, 33.65991], [-117.7288, 33.66027], [-117.72936, 33.66056], [-117.72988, 33.66078], [-117.7305, 33.66096], [-117.73116, 33.66108], [-117.73183, 33.66114]], [[-117.72422, 33.65519], [-117.72417, 33.65518], [-117.72416, 33.65519], [-117.72428, 33.65528], [-117.72422, 33.65519]]], [[[-117.72377, 33.67404], [-117.7199, 33.67417], [-117.71945, 33.67421], [-117.71903, 33.67427], [-117.71852, 33.67439], [-117.71805, 33.67454], [-117.71759, 33.67474], [-117.71723, 33.67494], [-117.7169, 33.67516], [-117.71659, 33.67539], [-117.71643, 33.67559], [-117.71636, 33.67574], [-117.71632, 33.67589], [-117.71633, 33.67682], [-117.7163, 33.67704], [-117.71624, 33.67726], [-117.71611, 33.67753], [-117.71594, 33.67776], [-117.7157, 33.67799], [-117.71546, 33.67816], [-117.71532, 33.67781], [-117.71514, 33.67745], [-117.71492, 33.6771], [-117.71468, 33.67676], [-117.71441, 33.67643], [-117.71411, 33.67612], [-117.71379, 33.67584], [-117.71344, 33.67556], [-117.71371, 33.67532], [-117.71406, 33.6751], [-117.71696, 33.67361], [-117.71746, 33.67339], [-117.71798, 33.67322], [-117.71852, 33.67309], [-117.71896, 33.67301], [-117.71974, 33.67293], [-117.722, 33.67285], [-117.72204, 33.67298], [-117.72212, 33.6731], [-117.72225, 33.6732], [-117.72238, 33.67325], [-117.72256, 33.67327], [-117.72346, 33.67324], [-117.72359, 33.67361], [-117.72377, 33.67404]]], [[[-117.73088, 33.68231], [-117.73091, 33.68384], [-117.73089, 33.68419], [-117.73084, 33.68452], [-117.73077, 33.68484], [-117.73062, 33.68527], [-117.7304, 33.68574], [-117.73019, 33.68608], [-117.72999, 33.68637], [-117.7298, 33.68659], [-117.72954, 33.68686], [-117.72924, 33.68713], [-117.72874, 33.68749], [-117.72788, 33.688], [-117.72715, 33.68849], [-117.72661, 33.68893], [-117.72583, 33.68972], [-117.72141, 33.68664], [-117.72176, 33.68629], [-117.72207, 33.68603], [-117.72237, 33.68584], [-117.72375, 33.68505], [-117.72411, 33.68478], [-117.72438, 33.68452], [-117.72464, 33.68418], [-117.72478, 33.68396], [-117.72487, 33.68377], [-117.72499, 33.68343], [-117.7251, 33.68291], [-117.72523, 33.68256], [-117.72535, 33.68237], [-117.72549, 33.68219], [-117.72574, 33.68194], [-117.72585, 33.68201], [-117.726, 33.68207], [-117.72612, 33.68208], [-117.72628, 33.68206], [-117.72644, 33.682], [-117.72708, 33.68162], [-117.72733, 33.68178], [-117.7277, 33.68195], [-117.728, 33.68206], [-117.72836, 33.68215], [-117.72857, 33.68218], [-117.73088, 33.68231]]], [[[-117.73948, 33.67501], [-117.73851, 33.67434], [-117.73608, 33.67677], [-117.7371, 33.6775], [-117.73543, 33.6792], [-117.73438, 33.67847], [-117.73088, 33.68196], [-117.73088, 33.68214], [-117.72868, 33.68203], [-117.72824, 33.68195], [-117.72787, 33.68184], [-117.72743, 33.68163], [-117.72719, 33.68148], [-117.72701, 33.68134], [-117.72681, 33.68115], [-117.72666, 33.68099], [-117.72648, 33.68073], [-117.7264, 33.68058], [-117.72626, 33.68022], [-117.72619, 33.6799], [-117.72618, 33.67969], [-117.72614, 33.67728], [-117.7261, 33.67696], [-117.72601, 33.67665], [-117.72587, 33.67636], [-117.72565, 33.67604], [-117.72547, 33.67586], [-117.72508, 33.6755], [-117.72486, 33.67528], [-117.72459, 33.67497], [-117.72441, 33.67473], [-117.72424, 33.67449], [-117.72404, 33.67415], [-117.72387, 33.6738], [-117.72373, 33.67344], [-117.72358, 33.67289], [-117.72318, 33.67077], [-117.72316, 33.67056], [-117.72318, 33.66952], [-117.72321, 33.66926], [-117.72329, 33.66901], [-117.72339, 33.66877], [-117.72356, 33.66851], [-117.7238, 33.66824], [-117.72408, 33.66801], [-117.72437, 33.66784], [-117.72464, 33.66772], [-117.72497, 33.66761], [-117.72536, 33.66754], [-117.72567, 33.66752], [-117.7336, 33.66754], [-117.7339, 33.66756], [-117.7342, 33.66761], [-117.73444, 33.66767], [-117.73471, 33.66776], [-117.73498, 33.66788], [-117.73522, 33.66802], [-117.73545, 33.66818], [-117.73566, 33.66836], [-117.73582, 33.66852], [-117.73596, 33.6687], [-117.73694, 33.67017], [-117.7372, 33.6705], [-117.73756, 33.67083], [-117.73873, 33.67164], [-117.73897, 33.67182], [-117.73927, 33.67211], [-117.73953, 33.67246], [-117.73969, 33.67276], [-117.7398, 33.67307], [-117.73988, 33.67344], [-117.73989, 33.67371], [-117.73987, 33.67404], [-117.73978, 33.6744], [-117.73968, 33.67467], [-117.73948, 33.67501]]], [[[-117.7433, 33.66791], [-117.74314, 33.66806], [-117.74298, 33.66816], [-117.74278, 33.66826], [-117.74263, 33.66832], [-117.74238, 33.66838], [-117.74168, 33.66847], [-117.7414, 33.66852], [-117.74099, 33.66865], [-117.74065, 33.66881], [-117.74038, 33.66898], [-117.7401, 33.6692], [-117.73903, 33.67029], [-117.73889, 33.67022], [-117.73874, 33.6702], [-117.73859, 33.67021], [-117.73844, 33.67025], [-117.73829, 33.67036], [-117.73784, 33.67082], [-117.73765, 33.67067], [-117.73746, 33.67051], [-117.73719, 33.67021], [-117.73615, 33.66865], [-117.73591, 33.66835], [-117.73574, 33.66819], [-117.73551, 33.668], [-117.7353, 33.66786], [-117.73503, 33.66771], [-117.7347, 33.66758], [-117.73445, 33.6675], [-117.73414, 33.66743], [-117.73382, 33.66739], [-117.73351, 33.66737], [-117.73063, 33.66737], [-117.73063, 33.66681], [-117.73059, 33.66666], [-117.7305, 33.66654], [-117.7304, 33.66647], [-117.73027, 33.66641], [-117.73012, 33.66639], [-117.73012, 33.66532], [-117.73015, 33.66504], [-117.73019, 33.66482], [-117.73025, 33.66461], [-117.73037, 33.66429], [-117.73047, 33.66409], [-117.73063, 33.66384], [-117.73084, 33.66356], [-117.7316, 33.66276], [-117.73176, 33.66253], [-117.73188, 33.66233], [-117.73199, 33.66207], [-117.73207, 33.66181], [-117.73212, 33.66145], [-117.73213, 33.66112], [-117.73366, 33.66113], [-117.73391, 33.66115], [-117.73421, 33.66121], [-117.73457, 33.66132], [-117.7349, 33.66148], [-117.73664, 33.66265], [-117.73692, 33.66287], [-117.73718, 33.66311], [-117.73741, 33.66337], [-117.73806, 33.66418], [-117.73833, 33.66445], [-117.73856, 33.66465], [-117.73883, 33.66485], [-117.7433, 33.66791]]], [[[-117.75103, 33.67316], [-117.74524, 33.67896], [-117.73964, 33.67512], [-117.73979, 33.67487], [-117.7399, 33.67464], [-117.73999, 33.6744], [-117.74005, 33.67416], [-117.74008, 33.67391], [-117.74009, 33.67371], [-117.74008, 33.67347], [-117.74004, 33.67322], [-117.73991, 33.67279], [-117.73978, 33.67252], [-117.73962, 33.67226], [-117.73946, 33.67205], [-117.73928, 33.67185], [-117.73912, 33.67171], [-117.73888, 33.67152], [-117.73932, 33.67107], [-117.73942, 33.67093], [-117.73944, 33.67079], [-117.73942, 33.67067], [-117.73936, 33.67054], [-117.73926, 33.67044], [-117.74029, 33.6694], [-117.74053, 33.66919], [-117.74089, 33.66898], [-117.74131, 33.66881], [-117.74173, 33.66871], [-117.74247, 33.66862], [-117.74283, 33.66852], [-117.74318, 33.66835], [-117.74339, 33.6682], [-117.74353, 33.66807], [-117.74388, 33.66833], [-117.74409, 33.66852], [-117.74429, 33.66872], [-117.7447, 33.66922], [-117.74461, 33.6693], [-117.74505, 33.66975], [-117.7455, 33.67017], [-117.74597, 33.67052], [-117.74646, 33.67085], [-117.74684, 33.67107], [-117.74743, 33.67147], [-117.74778, 33.67167], [-117.74807, 33.67181], [-117.74837, 33.67193], [-117.74955, 33.67232], [-117.74996, 33.67249], [-117.75041, 33.67274], [-117.75103, 33.67316]]]]} | Restricted Access 2 | 29675 | Orange County Great Park | 23151 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2326.795 | Orange County Great Park | 0 | Local Park 2 | 4 | |
| 16360 | 16360 | 16359 | {"type": "Polygon", "coordinates": [[[-117.74864, 33.87571], [-117.74833, 33.87649], [-117.74581, 33.87766], [-117.74581, 33.87811], [-117.74358, 33.87871], [-117.74216, 33.88027], [-117.74233, 33.88141], [-117.74118, 33.88201], [-117.73899, 33.88209], [-117.73627, 33.88067], [-117.7323, 33.87754], [-117.73193, 33.87659], [-117.73167, 33.87505], [-117.73056, 33.87331], [-117.73041, 33.87237], [-117.72834, 33.87079], [-117.727, 33.86982], [-117.72625, 33.86965], [-117.72455, 33.86988], [-117.72208, 33.86913], [-117.72067, 33.8693], [-117.7196, 33.8694], [-117.71702, 33.8695], [-117.71599, 33.86972], [-117.71554, 33.86991], [-117.71527, 33.87045], [-117.71495, 33.87083], [-117.71448, 33.8712], [-117.71377, 33.87163], [-117.71287, 33.87208], [-117.71221, 33.8722], [-117.71038, 33.87221], [-117.70881, 33.87159], [-117.70732, 33.87139], [-117.7064, 33.87147], [-117.6895, 33.87691], [-117.68844, 33.87684], [-117.688, 33.87679], [-117.68756, 33.87671], [-117.68756, 33.87658], [-117.68758, 33.87657], [-117.68757, 33.87656], [-117.68564, 33.87601], [-117.68504, 33.87568], [-117.6856, 33.87486], [-117.68658, 33.87523], [-117.68798, 33.8757], [-117.68969, 33.87532], [-117.69094, 33.87471], [-117.69165, 33.87447], [-117.69301, 33.87466], [-117.69434, 33.87459], [-117.69607, 33.87434], [-117.69767, 33.87375], [-117.70002, 33.87268], [-117.70059, 33.87257], [-117.70644, 33.86987], [-117.70699, 33.86957], [-117.70855, 33.86899], [-117.70877, 33.86892], [-117.70901, 33.86886], [-117.7094, 33.86881], [-117.71077, 33.86886], [-117.71114, 33.86883], [-117.71151, 33.86874], [-117.71228, 33.86844], [-117.71232, 33.86849], [-117.71254, 33.8684], [-117.71259, 33.86768], [-117.7126, 33.86759], [-117.71268, 33.86748], [-117.71276, 33.86742], [-117.71285, 33.86738], [-117.71371, 33.8671], [-117.71521, 33.86689], [-117.71614, 33.86688], [-117.71728, 33.86695], [-117.71908, 33.86711], [-117.72365, 33.86757], [-117.72412, 33.86763], [-117.72459, 33.8677], [-117.7255, 33.86792], [-117.72667, 33.86835], [-117.73229, 33.87054], [-117.73248, 33.87063], [-117.73272, 33.8708], [-117.73285, 33.87094], [-117.73296, 33.87109], [-117.73307, 33.87134], [-117.7331, 33.87152], [-117.7331, 33.87169], [-117.7333, 33.87171], [-117.73322, 33.87226], [-117.73287, 33.87241], [-117.73313, 33.87284], [-117.73353, 33.87415], [-117.73406, 33.87576], [-117.7342, 33.87573], [-117.73566, 33.8767], [-117.73599, 33.87697], [-117.73655, 33.87754], [-117.73692, 33.87782], [-117.7372, 33.87798], [-117.73749, 33.87813], [-117.73779, 33.87824], [-117.73811, 33.87834], [-117.73844, 33.87841], [-117.73877, 33.87845], [-117.73911, 33.87847], [-117.73944, 33.87846], [-117.74077, 33.87836], [-117.74125, 33.87826], [-117.74156, 33.87816], [-117.74186, 33.87804], [-117.74214, 33.8779], [-117.74804, 33.87463], [-117.74864, 33.87571]]]} | Restricted Access 2 | 47965 | Featherly Regional Park | 32177 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/featherly | Orange 3 | 361.019 | Featherly RP | 0 | Local Park 2 | 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]);