units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

13 rows where AGNCY_NAME = 339, DES_TP = 16 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • Non Profit - Land Trust · 13 ✖

MNG_AGENCY 1

DES_TP 1

  • Private Conservation · 13 ✖
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
1276 1276 1275 {"type": "Polygon", "coordinates": [[[-117.15714, 33.37086], [-117.15594, 33.37098], [-117.15595, 33.37274], [-117.15594, 33.37275], [-117.15292, 33.37263], [-117.15238, 33.37503], [-117.1519, 33.37517], [-117.15148, 33.37559], [-117.15192, 33.37642], [-117.14826, 33.37642], [-117.14851, 33.37245], [-117.14388, 33.37276], [-117.14406, 33.36574], [-117.14184, 33.36576], [-117.142, 33.36267], [-117.13987, 33.36258], [-117.13989, 33.36211], [-117.14228, 33.36219], [-117.14343, 33.36081], [-117.14362, 33.36082], [-117.14372, 33.36086], [-117.14383, 33.36092], [-117.14391, 33.36092], [-117.14397, 33.36089], [-117.14399, 33.36086], [-117.144, 33.36079], [-117.14387, 33.36051], [-117.14387, 33.36046], [-117.14393, 33.36042], [-117.14395, 33.36042], [-117.14418, 33.36063], [-117.14429, 33.36068], [-117.14507, 33.36085], [-117.14543, 33.36098], [-117.14557, 33.36105], [-117.14562, 33.3611], [-117.14568, 33.36117], [-117.1457, 33.36123], [-117.14575, 33.36128], [-117.14586, 33.36132], [-117.14606, 33.36131], [-117.14618, 33.36127], [-117.1463, 33.36119], [-117.14635, 33.36112], [-117.14643, 33.36104], [-117.14678, 33.36089], [-117.14689, 33.36082], [-117.14693, 33.36077], [-117.14715, 33.36066], [-117.14712, 33.3608], [-117.14712, 33.36089], [-117.14702, 33.36109], [-117.14701, 33.36122], [-117.14703, 33.36124], [-117.14804, 33.36138], [-117.14831, 33.36177], [-117.14855, 33.3618], [-117.14855, 33.36571], [-117.15713, 33.36567], [-117.15714, 33.37086]], [[-117.14362, 33.36422], [-117.14363, 33.36407], [-117.1436, 33.364], [-117.14349, 33.3639], [-117.14336, 33.36384], [-117.14323, 33.36383], [-117.14307, 33.36388], [-117.14295, 33.36397], [-117.1429, 33.36408], [-117.1429, 33.36419], [-117.14295, 33.3643], [-117.14304, 33.36438], [-117.14316, 33.36444], [-117.14334, 33.36445], [-117.14345, 33.36441], [-117.1435, 33.36438], [-117.14358, 33.36431], [-117.14362, 33.36422]], [[-117.15178, 33.3673], [-117.15181, 33.36725], [-117.15157, 33.36726], [-117.15158, 33.36751], [-117.1516, 33.3675], [-117.15178, 33.3673]]]} Open Access 1 7246 Monserate Mountain Preserve 3664 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/monserate-mountain.html San Diego 4 343.819 Monserate Mtn. Preserve 0 Private Conservation 16 2
1282 1282 1281 {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} Open Access 1 7247 Palomares House 23367 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/palomares-house-and-park.html San Diego 4 1.248 Palomares House 0 Private Conservation 16 2
4216 4216 4215 {"type": "Polygon", "coordinates": [[[-117.39755, 33.44539], [-117.38308, 33.44537], [-117.36359, 33.44529], [-117.36342, 33.43052], [-117.38823, 33.43027], [-117.389, 33.43025], [-117.38944, 33.43083], [-117.39484, 33.43788], [-117.39755, 33.44539]]]} Restricted Access 2 47758 Margarita Peak Preserve 31564 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 1165.479 Margarita Peak Preserve 0 Private Conservation 16 2
5414 5414 5413 {"type": "Polygon", "coordinates": [[[-117.23382, 33.35463], [-117.23345, 33.3551], [-117.23265, 33.3558], [-117.23252, 33.35594], [-117.23126, 33.35761], [-117.23105, 33.3578], [-117.23083, 33.35794], [-117.23058, 33.35806], [-117.23051, 33.35804], [-117.23049, 33.35801], [-117.23046, 33.35577], [-117.23067, 33.35574], [-117.23087, 33.35566], [-117.23097, 33.35558], [-117.2311, 33.35543], [-117.23121, 33.35539], [-117.23145, 33.35518], [-117.23195, 33.35489], [-117.23227, 33.35462], [-117.23382, 33.35463]]]} Open Access 1 7208 Dinwiddie Preserve 18159 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/dinwiddie.html San Diego 4 12.888 Dinwiddie Preserve 0 Private Conservation 16 2
5416 5416 5415 {"type": "MultiPolygon", "coordinates": [[[[-117.24868, 33.36016], [-117.24498, 33.36016], [-117.24498, 33.35287], [-117.24593, 33.35286], [-117.24633, 33.3535], [-117.24645, 33.3538], [-117.24655, 33.35424], [-117.24702, 33.35711], [-117.24704, 33.35733], [-117.24713, 33.35765], [-117.24725, 33.35793], [-117.24749, 33.35833], [-117.24868, 33.36016]]], [[[-117.24932, 33.35835], [-117.24933, 33.36017], [-117.24931, 33.36082], [-117.24785, 33.35833], [-117.24932, 33.35835]]]]} Open Access 1 7248 Los Jilgueros Preserve 21518 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/los-jilgueros.html San Diego 4 43.934 Los Jilgueros Preserve 0 Private Conservation 16 2
7317 7317 7316 {"type": "Polygon", "coordinates": [[[-117.16715, 33.33888], [-117.16588, 33.3392], [-117.16534, 33.33971], [-117.16475, 33.33998], [-117.16499, 33.33744], [-117.16645, 33.33732], [-117.16704, 33.33813], [-117.16715, 33.33888]]]} Open Access 1 7212 Engel Family Preserve 18674 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/engel-preserve.html San Diego 4 10.291 Engel Family Preserve 0 Private Conservation 16 2
7562 7562 7561 {"type": "Polygon", "coordinates": [[[-117.22732, 33.30013], [-117.2259, 33.30017], [-117.22554, 33.29893], [-117.22542, 33.29857], [-117.22521, 33.29803], [-117.22519, 33.29801], [-117.22511, 33.29784], [-117.2249, 33.2975], [-117.22423, 33.29656], [-117.22415, 33.29638], [-117.22399, 33.29617], [-117.22387, 33.29608], [-117.22344, 33.2955], [-117.22328, 33.29518], [-117.22321, 33.29492], [-117.2232, 33.29481], [-117.22321, 33.29455], [-117.22328, 33.29429], [-117.22336, 33.29408], [-117.22347, 33.29389], [-117.22364, 33.29367], [-117.22359, 33.2936], [-117.22368, 33.29356], [-117.2241, 33.2944], [-117.22506, 33.29509], [-117.2254, 33.29584], [-117.22617, 33.29629], [-117.2269, 33.29677], [-117.22694, 33.29786], [-117.22718, 33.29823], [-117.22729, 33.2987], [-117.22709, 33.29916], [-117.22732, 33.30013]]]} Open Access 1 7249 Bonsall Preserve 16268 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/bonsall.html San Diego 4 27.421 Bonsall Preserve 0 Private Conservation 16 2
8091 8091 8090 {"type": "MultiPolygon", "coordinates": [[[[-117.21879, 33.31769], [-117.21866, 33.31776], [-117.21855, 33.31785], [-117.21834, 33.3181], [-117.21824, 33.31819], [-117.21812, 33.31825], [-117.21799, 33.31829], [-117.21778, 33.3183], [-117.21759, 33.31824], [-117.21743, 33.31813], [-117.21732, 33.31797], [-117.21742, 33.31771], [-117.21753, 33.31752], [-117.21758, 33.31749], [-117.21793, 33.31762], [-117.21815, 33.31767], [-117.21849, 33.3177], [-117.21879, 33.31769]]], [[[-117.2207, 33.30943], [-117.21999, 33.31078], [-117.21983, 33.31124], [-117.2199, 33.31157], [-117.2199, 33.31202], [-117.21961, 33.31249], [-117.2192, 33.31268], [-117.21902, 33.31431], [-117.21924, 33.31485], [-117.21938, 33.31696], [-117.21928, 33.31749], [-117.21902, 33.31748], [-117.21836, 33.31749], [-117.21814, 33.31746], [-117.21793, 33.3174], [-117.21772, 33.31731], [-117.21769, 33.31726], [-117.21811, 33.31657], [-117.21815, 33.31636], [-117.21811, 33.31606], [-117.21813, 33.31587], [-117.21822, 33.31569], [-117.2184, 33.31547], [-117.21847, 33.31536], [-117.21853, 33.31522], [-117.21856, 33.31509], [-117.21856, 33.31494], [-117.21854, 33.3148], [-117.21849, 33.31467], [-117.21835, 33.31442], [-117.21831, 33.3143], [-117.2183, 33.31417], [-117.21831, 33.31403], [-117.21863, 33.31254], [-117.21868, 33.31242], [-117.21876, 33.31231], [-117.21907, 33.31202], [-117.21921, 33.31182], [-117.21966, 33.31055], [-117.21967, 33.31041], [-117.21963, 33.31016], [-117.21965, 33.31], [-117.22028, 33.30895], [-117.22035, 33.3088], [-117.22038, 33.30877], [-117.22061, 33.3088], [-117.22066, 33.30882], [-117.22071, 33.30887], [-117.22072, 33.30892], [-117.22072, 33.30908], [-117.2207, 33.30943]]]]} No Public Access 3 47751 Appleton Preserve 31560 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 19.488 Appleton Preserve 0 Private Conservation 16 2
8092 8092 8091 {"type": "Polygon", "coordinates": [[[-117.2348, 33.31528], [-117.23431, 33.31514], [-117.23407, 33.31513], [-117.23389, 33.31516], [-117.23331, 33.31534], [-117.23319, 33.31536], [-117.23289, 33.31535], [-117.23268, 33.31529], [-117.23247, 33.31519], [-117.23236, 33.31511], [-117.23196, 33.31472], [-117.23419, 33.30918], [-117.2304, 33.30919], [-117.23035, 33.3091], [-117.22993, 33.30919], [-117.22848, 33.30919], [-117.2283, 33.30887], [-117.22864, 33.30886], [-117.22872, 33.30913], [-117.22983, 33.30913], [-117.22995, 33.30909], [-117.23001, 33.30902], [-117.23002, 33.30897], [-117.22988, 33.3086], [-117.2299, 33.30827], [-117.22994, 33.30821], [-117.23003, 33.30815], [-117.2301, 33.30813], [-117.23033, 33.30813], [-117.23041, 33.30757], [-117.23469, 33.30753], [-117.23477, 33.31377], [-117.2348, 33.31528]]]} Open Access 1 47757 Karen Tucker Preserve at Heller’s Bend 31563 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 46.666 Karen Tucker Preserve at Heller’s Bend 0 Private Conservation 16 2
9759 9759 9758 {"type": "Polygon", "coordinates": [[[-117.33309, 33.47838], [-117.32511, 33.4758], [-117.32508, 33.47488], [-117.32412, 33.47486], [-117.32413, 33.47409], [-117.32497, 33.4741], [-117.32544, 33.47311], [-117.32616, 33.47088], [-117.32581, 33.46875], [-117.32987, 33.4687], [-117.3299, 33.46759], [-117.32883, 33.46768], [-117.32931, 33.46611], [-117.33054, 33.46549], [-117.3304, 33.46403], [-117.3287, 33.46412], [-117.32431, 33.46406], [-117.32041, 33.46405], [-117.32059, 33.46391], [-117.32871, 33.4639], [-117.33309, 33.46368], [-117.33301, 33.46731], [-117.33085, 33.46751], [-117.33071, 33.47105], [-117.33073, 33.47106], [-117.33304, 33.47086], [-117.33309, 33.47838]]]} No Public Access 3 47870 Durling Preserve 31815 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 https://www.fallbrooklandconservancy.org/durling.html San Diego 4 186.908 Durling Preserve 2012 Private Conservation 16 2
9760 9760 9759 {"type": "Polygon", "coordinates": [[[-117.19894, 33.34671], [-117.19636, 33.34669], [-117.19513, 33.34547], [-117.19475, 33.3447], [-117.19427, 33.34402], [-117.19365, 33.34432], [-117.19357, 33.34438], [-117.19286, 33.34464], [-117.19254, 33.34481], [-117.19243, 33.34489], [-117.19233, 33.345], [-117.19226, 33.34511], [-117.19222, 33.34523], [-117.19204, 33.34518], [-117.19211, 33.34498], [-117.19224, 33.34481], [-117.19239, 33.34468], [-117.19268, 33.34451], [-117.19255, 33.3444], [-117.19266, 33.34359], [-117.19303, 33.34192], [-117.19759, 33.34189], [-117.19749, 33.34227], [-117.19751, 33.34307], [-117.19757, 33.3434], [-117.19761, 33.34348], [-117.19774, 33.34364], [-117.19779, 33.34376], [-117.1978, 33.34433], [-117.19777, 33.34444], [-117.19761, 33.34476], [-117.19752, 33.34518], [-117.19717, 33.3455], [-117.19859, 33.3455], [-117.19894, 33.34671]]]} Open Access 1 47871 Gird Valley Preserve 31816 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 https://www.fallbrooklandconservancy.org/gird.html San Diego 4 47.794 Gird Valley Preserve 2015 Private Conservation 16 2
9761 9761 9760 {"type": "Polygon", "coordinates": [[[-117.01978, 33.34227], [-117.01951, 33.34216], [-117.01831, 33.34175], [-117.01701, 33.34157], [-117.01718, 33.34144], [-117.01789, 33.34103], [-117.01817, 33.34027], [-117.01511, 33.33929], [-117.01499, 33.3393], [-117.01482, 33.33925], [-117.01477, 33.33931], [-117.01403, 33.33932], [-117.01408, 33.339], [-117.01668, 33.33534], [-117.0194, 33.33715], [-117.01974, 33.33725], [-117.01978, 33.34227]]]} No Public Access 3 47872 Granger Preserve 31817 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10   San Diego 4 53.474 Granger Preserve 2016 Private Conservation 16 2
16908 16908 16907 {"type": "Polygon", "coordinates": [[[-117.24764, 33.43349], [-117.24755, 33.43356], [-117.24749, 33.43379], [-117.24725, 33.43425], [-117.24708, 33.43464], [-117.24704, 33.4348], [-117.24703, 33.43509], [-117.24706, 33.43524], [-117.24711, 33.43543], [-117.24713, 33.43582], [-117.24704, 33.43686], [-117.24703, 33.43761], [-117.24701, 33.43771], [-117.24694, 33.43784], [-117.24682, 33.43797], [-117.24664, 33.43805], [-117.24658, 33.43806], [-117.24611, 33.43833], [-117.246, 33.43843], [-117.24594, 33.43853], [-117.24241, 33.43684], [-117.24264, 33.43527], [-117.2425, 33.43413], [-117.2422, 33.43397], [-117.24202, 33.43414], [-117.24151, 33.43426], [-117.24138, 33.43426], [-117.24136, 33.43193], [-117.2441, 33.43197], [-117.24701, 33.43192], [-117.24726, 33.43248], [-117.24764, 33.43349]]]} Open Access 1 12581 Rock Mountain Preserve 24510 3022 Fallbrook Land Conservancy 339 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/ Non Governmental Organization 10 3022 Fallbrook Land Conservancy 336 Non Profit 6 Non Profit - Land Trust 10 http://www.fallbrooklandconservancy.org/rock-mountain.html San Diego 4 76.127 Rock Mtn. Preserve 0 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);