calands: units_with_maps: 1 row where COUNTY = 10, DES_TP = 3 and MNG

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

1 row where COUNTY = 10, DES_TP = 3 and MNG_AGENCY = 183

Search:

descending

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
16642	16642	16641	{"type": "MultiPolygon", "coordinates": [[[[-117.31838, 33.64556], [-117.31643, 33.65508], [-117.3159, 33.655], [-117.3175, 33.64716], [-117.31492, 33.6459], [-117.31486, 33.64672], [-117.31481, 33.6469], [-117.31468, 33.64714], [-117.31456, 33.64729], [-117.31434, 33.6475], [-117.31392, 33.64789], [-117.31348, 33.64827], [-117.31301, 33.64862], [-117.31244, 33.649], [-117.31211, 33.64918], [-117.31126, 33.64956], [-117.31073, 33.64984], [-117.31005, 33.65017], [-117.30949, 33.65042], [-117.30927, 33.65053], [-117.30889, 33.65078], [-117.30844, 33.65115], [-117.30823, 33.6513], [-117.30762, 33.65163], [-117.30709, 33.65186], [-117.30583, 33.65264], [-117.30569, 33.65345], [-117.30505, 33.65336], [-117.30502, 33.65344], [-117.30444, 33.65336], [-117.30447, 33.65317], [-117.30504, 33.65325], [-117.30518, 33.65249], [-117.30528, 33.65224], [-117.30537, 33.65207], [-117.30491, 33.65194], [-117.30521, 33.65134], [-117.30553, 33.65084], [-117.30592, 33.65036], [-117.30641, 33.64988], [-117.30713, 33.65063], [-117.30728, 33.65104], [-117.30751, 33.65091], [-117.30759, 33.651], [-117.30797, 33.65077], [-117.30852, 33.65032], [-117.30891, 33.65007], [-117.30917, 33.64994], [-117.30965, 33.64973], [-117.31038, 33.64937], [-117.3109, 33.6491], [-117.31176, 33.64872], [-117.3122, 33.64847], [-117.31291, 33.64796], [-117.31353, 33.64744], [-117.31409, 33.64689], [-117.31416, 33.64678], [-117.31421, 33.64666], [-117.31423, 33.64653], [-117.31428, 33.64483], [-117.30671, 33.63989], [-117.3076, 33.63888], [-117.31838, 33.64556]]], [[[-117.31638, 33.65516], [-117.31558, 33.65869], [-117.30482, 33.65711], [-117.30456, 33.65756], [-117.30361, 33.65993], [-117.30343, 33.66048], [-117.30352, 33.66061], [-117.30255, 33.66048], [-117.30256, 33.66042], [-117.30237, 33.6604], [-117.30301, 33.6588], [-117.303, 33.65878], [-117.30357, 33.65734], [-117.30352, 33.65705], [-117.30395, 33.65598], [-117.3041, 33.65508], [-117.30482, 33.65518], [-117.30511, 33.65354], [-117.30623, 33.6537], [-117.306, 33.6547], [-117.30599, 33.6547], [-117.30586, 33.65527], [-117.30587, 33.65528], [-117.30639, 33.65535], [-117.30675, 33.65377], [-117.31638, 33.65516]]], [[[-117.34304, 33.64146], [-117.34475, 33.64257], [-117.34675, 33.64363], [-117.34852, 33.64439], [-117.34868, 33.64448], [-117.35085, 33.6451], [-117.35263, 33.64613], [-117.35461, 33.64694], [-117.35647, 33.6479], [-117.35792, 33.64931], [-117.35957, 33.6505], [-117.36107, 33.65185], [-117.3646, 33.65373], [-117.36647, 33.65495], [-117.36733, 33.65703], [-117.36906, 33.65812], [-117.37026, 33.65983], [-117.37202, 33.66089], [-117.37359, 33.66204], [-117.37553, 33.6629], [-117.37679, 33.66389], [-117.37635, 33.66441], [-117.37479, 33.66871], [-117.37236, 33.67059], [-117.37202, 33.67079], [-117.37617, 33.67365], [-117.37384, 33.67627], [-117.36872, 33.67273], [-117.36863, 33.67278], [-117.36857, 33.67284], [-117.37373, 33.6764], [-117.37249, 33.6778], [-117.36681, 33.67406], [-117.36503, 33.67526], [-117.36225, 33.67806], [-117.36133, 33.67871], [-117.36045, 33.67891], [-117.35658, 33.67839], [-117.3559, 33.67968], [-117.35515, 33.67939], [-117.35573, 33.67827], [-117.35565, 33.67827], [-117.35507, 33.67936], [-117.35478, 33.67924], [-117.35538, 33.67823], [-117.35513, 33.6781], [-117.35439, 33.67907], [-117.35396, 33.67886], [-117.35469, 33.67785], [-117.3491, 33.67459], [-117.34835, 33.67566], [-117.34819, 33.67558], [-117.34894, 33.67451], [-117.34759, 33.67372], [-117.34675, 33.67485], [-117.34661, 33.67478], [-117.34744, 33.67364], [-117.34656, 33.67312], [-117.34567, 33.67434], [-117.34534, 33.67416], [-117.34583, 33.67342], [-117.34619, 33.67292], [-117.34584, 33.6727], [-117.34546, 33.6732], [-117.34495, 33.67393], [-117.34482, 33.67386], [-117.3457, 33.67262], [-117.34559, 33.67256], [-117.34489, 33.67351], [-117.34476, 33.67343], [-117.34546, 33.6725], [-117.34546, 33.67248], [-117.34508, 33.67226], [-117.34439, 33.67317], [-117.34387, 33.67288], [-117.34457, 33.67198], [-117.34457, 33.67196], [-117.34449, 33.67192], [-117.34374, 33.6728], [-117.34363, 33.67274], [-117.34404, 33.67229], [-117.3444, 33.67186], [-117.34372, 33.67139], [-117.3429, 33.67224], [-117.34264, 33.67207], [-117.34347, 33.67122], [-117.34336, 33.67114], [-117.34252, 33.67199], [-117.34214, 33.67174], [-117.34299, 33.67087], [-117.34074, 33.66929], [-117.33984, 33.67022], [-117.33971, 33.67013], [-117.3406, 33.6692], [-117.33961, 33.6685], [-117.33869, 33.66944], [-117.33844, 33.66927], [-117.33933, 33.66831], [-117.33828, 33.66757], [-117.33734, 33.66852], [-117.33716, 33.6684], [-117.33807, 33.66744], [-117.33796, 33.66734], [-117.33703, 33.66831], [-117.33532, 33.66712], [-117.33505, 33.6674], [-117.33499, 33.66736], [-117.33526, 33.66708], [-117.33425, 33.66637], [-117.33534, 33.6653], [-117.33522, 33.66521], [-117.33412, 33.66629], [-117.3326, 33.66523], [-117.33275, 33.66496], [-117.33233, 33.66478], [-117.33221, 33.66496], [-117.33196, 33.66479], [-117.33329, 33.66339], [-117.3332, 33.66329], [-117.33183, 33.6647], [-117.3313, 33.66434], [-117.33275, 33.66286], [-117.33065, 33.66089], [-117.32217, 33.65965], [-117.32235, 33.65875], [-117.32234, 33.65874], [-117.32024, 33.65844], [-117.32005, 33.65934], [-117.31577, 33.65872], [-117.31658, 33.65519], [-117.33012, 33.65713], [-117.33008, 33.65696], [-117.32641, 33.65643], [-117.32716, 33.65285], [-117.32784, 33.65294], [-117.32777, 33.64959], [-117.3284, 33.64717], [-117.32414, 33.64453], [-117.32152, 33.64745], [-117.31848, 33.64556], [-117.31852, 33.64534], [-117.31119, 33.6408], [-117.31617, 33.63512], [-117.31965, 33.63721], [-117.32318, 33.6394], [-117.32862, 33.64285], [-117.32863, 33.64276], [-117.32867, 33.64269], [-117.3233, 33.63927], [-117.31957, 33.63697], [-117.32073, 33.63564], [-117.31941, 33.63483], [-117.3207, 33.63336], [-117.32925, 33.63859], [-117.33073, 33.63954], [-117.33496, 33.63765], [-117.3357, 33.63726], [-117.33803, 33.63795], [-117.33961, 33.63922], [-117.34128, 33.64038], [-117.34304, 33.64146]]]]}	Open Access 1	3364	Lake Elsinore State Recreation Area	29222	1389	Lake Elsinore, City of 187	City 2	City Agency 2	http://www.lake-elsinore.org/index.aspx?page=202	City 2	1389	Lake Elsinore, City of 183	City 2	City Agency 2	http://en.wikipedia.org/wiki/Lake_Elsinore	Riverside 10	3763.379	Lake Elsinore SRA	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]);