calands: units_with_maps: 1 row where COUNTY = 22 and DES

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

1 row where COUNTY = 22 and DES_TP = 15

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
16543	16543	16542	{"type": "MultiPolygon", "coordinates": [[[[-117.66341, 33.88881], [-117.6633, 33.90309], [-117.65422, 33.90306], [-117.6548, 33.88881], [-117.66341, 33.88881]]], [[[-117.75941, 33.92923], [-117.75932, 33.93043], [-117.75298, 33.9309], [-117.75163, 33.93189], [-117.74607, 33.93083], [-117.74455, 33.92999], [-117.74148, 33.93063], [-117.74147, 33.93011], [-117.73705, 33.93007], [-117.73257, 33.93005], [-117.73253, 33.94625], [-117.72421, 33.94634], [-117.71514, 33.94629], [-117.70867, 33.94646], [-117.70922, 33.94956], [-117.70789, 33.94999], [-117.70755, 33.95017], [-117.70707, 33.95089], [-117.70638, 33.95188], [-117.70632, 33.95249], [-117.70585, 33.95334], [-117.70486, 33.95437], [-117.70462, 33.95479], [-117.7046, 33.95562], [-117.704, 33.95565], [-117.70257, 33.95647], [-117.70294, 33.95484], [-117.70276, 33.95475], [-117.70269, 33.95477], [-117.70124, 33.95414], [-117.70258, 33.95163], [-117.70318, 33.95059], [-117.70425, 33.94837], [-117.70448, 33.94858], [-117.70485, 33.94861], [-117.70503, 33.94835], [-117.7051, 33.94836], [-117.70554, 33.9478], [-117.70615, 33.94763], [-117.70598, 33.94685], [-117.70545, 33.94661], [-117.7051, 33.94661], [-117.70515, 33.9465], [-117.70514, 33.94649], [-117.69765, 33.94634], [-117.69387, 33.94633], [-117.69384, 33.94586], [-117.69168, 33.94527], [-117.68905, 33.94501], [-117.68904, 33.94502], [-117.68903, 33.94627], [-117.68898, 33.94627], [-117.68923, 33.9319], [-117.68956, 33.91749], [-117.69829, 33.91742], [-117.69793, 33.91103], [-117.69787, 33.90358], [-117.68071, 33.90313], [-117.67213, 33.90311], [-117.6722, 33.89594], [-117.67654, 33.89593], [-117.67669, 33.88874], [-117.67276, 33.88671], [-117.67274, 33.88539], [-117.67076, 33.88356], [-117.67122, 33.88364], [-117.67222, 33.88276], [-117.67361, 33.88244], [-117.6759, 33.88248], [-117.67691, 33.88201], [-117.67802, 33.87998], [-117.6774, 33.8797], [-117.67607, 33.87834], [-117.67262, 33.8771], [-117.67271, 33.87667], [-117.67279, 33.8764], [-117.67296, 33.876], [-117.67314, 33.87568], [-117.6734, 33.87531], [-117.67376, 33.87492], [-117.67411, 33.87461], [-117.67456, 33.87429], [-117.67484, 33.87413], [-117.67584, 33.874], [-117.67931, 33.87762], [-117.72079, 33.90312], [-117.72403, 33.90513], [-117.73272, 33.91042], [-117.73811, 33.91376], [-117.74006, 33.91514], [-117.74004, 33.91628], [-117.7435, 33.91907], [-117.74555, 33.9191], [-117.75941, 33.92923]], [[-117.67521, 33.88494], [-117.6752, 33.88488], [-117.67515, 33.88482], [-117.67508, 33.88479], [-117.67499, 33.88478], [-117.67431, 33.88505], [-117.67422, 33.88506], [-117.67414, 33.88504], [-117.67407, 33.88498], [-117.67404, 33.8849], [-117.67419, 33.88441], [-117.67418, 33.88432], [-117.67412, 33.88424], [-117.67406, 33.88419], [-117.67376, 33.88408], [-117.67329, 33.88377], [-117.67321, 33.88374], [-117.6725, 33.88364], [-117.67244, 33.88361], [-117.6724, 33.88355], [-117.67241, 33.8835], [-117.67244, 33.88346], [-117.67258, 33.88334], [-117.67275, 33.88324], [-117.67299, 33.88318], [-117.67313, 33.88317], [-117.67327, 33.88319], [-117.67336, 33.88321], [-117.6732, 33.88359], [-117.67437, 33.88394], [-117.67482, 33.88368], [-117.67441, 33.88317], [-117.67357, 33.88323], [-117.67341, 33.88316], [-117.67328, 33.88313], [-117.67313, 33.88312], [-117.67298, 33.88313], [-117.67278, 33.88317], [-117.67265, 33.88323], [-117.67249, 33.88334], [-117.67235, 33.88348], [-117.67234, 33.88354], [-117.67235, 33.8836], [-117.67239, 33.88365], [-117.67244, 33.88368], [-117.67325, 33.88381], [-117.67373, 33.88413], [-117.67403, 33.88424], [-117.67408, 33.88428], [-117.67412, 33.88435], [-117.67413, 33.88441], [-117.67398, 33.8849], [-117.67401, 33.885], [-117.6741, 33.88508], [-117.67421, 33.88511], [-117.67433, 33.8851], [-117.67499, 33.88483], [-117.67509, 33.88485], [-117.67514, 33.88491], [-117.67514, 33.88498], [-117.67509, 33.88503], [-117.67413, 33.88543], [-117.67382, 33.88567], [-117.67335, 33.88578], [-117.67322, 33.88587], [-117.67325, 33.88591], [-117.6734, 33.88582], [-117.67386, 33.88572], [-117.67417, 33.88548], [-117.67513, 33.88508], [-117.67519, 33.88502], [-117.67521, 33.88494]]], [[[-117.68515, 33.91401], [-117.6808, 33.91394], [-117.68075, 33.90673], [-117.68505, 33.90688], [-117.68515, 33.91401]]], [[[-117.69381, 33.91416], [-117.6895, 33.91409], [-117.68936, 33.90702], [-117.69363, 33.90716], [-117.69368, 33.91086], [-117.69381, 33.91416]]]]}	Open Access 1	5607	Chino Hills State Park	1478	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=648	San Bernardino 22	7305.5	Chino Hills SP	1981	State Park 15	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]);