calands: units_with_maps: 5 rows where COUNTY = 9, MNG_AGENCY = 491 and MNG_AG

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

5 rows where COUNTY = 9, MNG_AGENCY = 491 and MNG_AG_TYP = 10

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
5401	5401	5400	{"type": "Polygon", "coordinates": [[[-119.74951, 36.9313], [-119.74932, 36.93147], [-119.74916, 36.93178], [-119.74919, 36.93511], [-119.74673, 36.93673], [-119.74638, 36.93737], [-119.74579, 36.93773], [-119.7458, 36.93775], [-119.74595, 36.93775], [-119.74382, 36.93938], [-119.74241, 36.93959], [-119.7427, 36.94065], [-119.7421, 36.94133], [-119.74083, 36.9424], [-119.73049, 36.94256], [-119.7304, 36.93778], [-119.73048, 36.93776], [-119.73056, 36.93313], [-119.73336, 36.93373], [-119.73427, 36.93358], [-119.73634, 36.93306], [-119.73781, 36.93219], [-119.73788, 36.93198], [-119.74177, 36.93195], [-119.74307, 36.93144], [-119.74333, 36.93159], [-119.74447, 36.93198], [-119.74684, 36.93201], [-119.74686, 36.93149], [-119.7472, 36.93076], [-119.7478, 36.93035], [-119.74793, 36.93041], [-119.74862, 36.93047], [-119.74911, 36.93064], [-119.74939, 36.93079], [-119.74951, 36.9313]], [[-119.74347, 36.93774], [-119.74353, 36.93754], [-119.74352, 36.93753], [-119.74346, 36.93772], [-119.74347, 36.93774]]]}	Unknown Access 4	9875	Ball Ranch	15786	2345	Tehachapi-Cummings County Water District 499	Special District 4	Water District 13	http://tccwd.com/	Special District 4	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10	Fresno 9	384.401	Ball Ranch	0	None 438
6138	6138	6137	{"type": "MultiPolygon", "coordinates": [[[[-119.81139, 36.85174], [-119.80965, 36.85279], [-119.80958, 36.85524], [-119.80919, 36.85524], [-119.80918, 36.85525], [-119.80934, 36.85555], [-119.80965, 36.85584], [-119.8098, 36.85603], [-119.81001, 36.8564], [-119.81053, 36.85718], [-119.81052, 36.85757], [-119.81058, 36.85775], [-119.81056, 36.85798], [-119.81032, 36.8589], [-119.81027, 36.85962], [-119.8101, 36.86002], [-119.80955, 36.8605], [-119.80919, 36.86204], [-119.80844, 36.86293], [-119.80636, 36.86382], [-119.80577, 36.8641], [-119.8056, 36.86425], [-119.80474, 36.86484], [-119.80363, 36.8651], [-119.80253, 36.86561], [-119.80219, 36.86584], [-119.80205, 36.86614], [-119.80199, 36.86632], [-119.80175, 36.86632], [-119.80176, 36.86678], [-119.80174, 36.86702], [-119.80158, 36.86727], [-119.80115, 36.86778], [-119.80104, 36.86782], [-119.8008, 36.86795], [-119.80046, 36.86824], [-119.8003, 36.86851], [-119.80023, 36.86891], [-119.8002, 36.86931], [-119.80015, 36.86954], [-119.79995, 36.86991], [-119.79971, 36.87027], [-119.79948, 36.87058], [-119.79916, 36.87082], [-119.79884, 36.87118], [-119.7985, 36.87152], [-119.79837, 36.87158], [-119.79807, 36.8718], [-119.79783, 36.87189], [-119.79749, 36.87211], [-119.79717, 36.87237], [-119.79685, 36.8726], [-119.79671, 36.87276], [-119.7966, 36.87282], [-119.7962, 36.87288], [-119.79596, 36.87301], [-119.79588, 36.87324], [-119.79577, 36.87342], [-119.79537, 36.87362], [-119.79509, 36.87385], [-119.79479, 36.87406], [-119.79409, 36.87471], [-119.79402, 36.8741], [-119.79381, 36.86984], [-119.79435, 36.86947], [-119.79484, 36.86895], [-119.79528, 36.86836], [-119.79634, 36.86631], [-119.79728, 36.86631], [-119.79729, 36.86374], [-119.79741, 36.86334], [-119.79812, 36.86223], [-119.79822, 36.86156], [-119.79828, 36.86147], [-119.79838, 36.86148], [-119.79846, 36.86137], [-119.79916, 36.86075], [-119.79957, 36.86022], [-119.79979, 36.85985], [-119.80008, 36.85919], [-119.80056, 36.85848], [-119.80065, 36.85813], [-119.80064, 36.85809], [-119.80081, 36.85745], [-119.8008, 36.85741], [-119.80117, 36.85692], [-119.80182, 36.85633], [-119.80242, 36.85586], [-119.80241, 36.85583], [-119.80253, 36.85578], [-119.8026, 36.85572], [-119.80321, 36.85532], [-119.80371, 36.85506], [-119.80397, 36.85494], [-119.80419, 36.85478], [-119.80453, 36.85434], [-119.80485, 36.85465], [-119.80484, 36.85469], [-119.80507, 36.85479], [-119.80512, 36.8547], [-119.80511, 36.85464], [-119.80503, 36.85452], [-119.80472, 36.85422], [-119.80545, 36.85374], [-119.80631, 36.85323], [-119.80719, 36.85267], [-119.80743, 36.85307], [-119.80951, 36.85256], [-119.81014, 36.85204], [-119.81072, 36.85175], [-119.81139, 36.85174]]], [[[-119.81549, 36.85967], [-119.81481, 36.86091], [-119.81419, 36.8616], [-119.8121, 36.86351], [-119.81095, 36.86565], [-119.81041, 36.86422], [-119.80935, 36.86353], [-119.81125, 36.85939], [-119.81234, 36.85837], [-119.81252, 36.85743], [-119.81541, 36.8596], [-119.81545, 36.85967], [-119.81549, 36.85967]]]]}	No Public Access 3	1129	Spano River Ranch	25715	233	San Joaquin River Conservancy 827	State 5	State Agency 5	http://sjrc.ca.gov/	Other State 5	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10	Fresno 9	412.564	Spano River Ranch	0	State Other or Unknown 104	4
12276	12276	12275	{"type": "Polygon", "coordinates": [[[-119.90876, 36.84585], [-119.90533, 36.84896], [-119.90287, 36.84725], [-119.9036, 36.84715], [-119.90433, 36.84704], [-119.90505, 36.8469], [-119.90576, 36.84675], [-119.90647, 36.84658], [-119.90717, 36.84638], [-119.90786, 36.84617], [-119.90876, 36.84585]]]}	Unknown Access 4	25926	Riverside Restoration Area	24459	3069	San Joaquin River Parkway and Conservation Trust 649	Non Profit 6	Non Profit - Land Trust 10	http://www.riverparkway.org	Non Governmental Organization 10	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10	Fresno 9	14.792	Riverside Restoration Area	0	Private Conservation 16	2
12278	12278	12277	{"type": "Polygon", "coordinates": [[[-119.78962, 36.87116], [-119.78961, 36.87514], [-119.7888, 36.87513], [-119.78692, 36.87644], [-119.78681, 36.87677], [-119.78705, 36.8769], [-119.78541, 36.87809], [-119.78512, 36.87927], [-119.78487, 36.87971], [-119.78457, 36.881], [-119.78394, 36.88274], [-119.78388, 36.88428], [-119.78173, 36.88414], [-119.78184, 36.88337], [-119.78096, 36.88318], [-119.78133, 36.88304], [-119.78185, 36.88225], [-119.78144, 36.88101], [-119.78012, 36.88101], [-119.77975, 36.88045], [-119.77959, 36.88014], [-119.77944, 36.87982], [-119.77925, 36.87928], [-119.77903, 36.87851], [-119.77897, 36.87821], [-119.7789, 36.87772], [-119.77889, 36.87732], [-119.77926, 36.87568], [-119.77982, 36.87412], [-119.77986, 36.87363], [-119.78108, 36.87363], [-119.78149, 36.87337], [-119.78262, 36.87323], [-119.78317, 36.87293], [-119.78336, 36.8725], [-119.78321, 36.87199], [-119.78472, 36.87079], [-119.78507, 36.87095], [-119.78655, 36.87182], [-119.78764, 36.8717], [-119.78948, 36.87117], [-119.78962, 36.87116]]]}	Unknown Access 4	25927	Jenson River Ranch	20397	2345	Tehachapi-Cummings County Water District 499	Special District 4	Water District 13	http://tccwd.com/	Special District 4	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10	Fresno 9	189.23	Jenson River Ranch		None 1071
16411	16411	16410	{"type": "Polygon", "coordinates": [[[-119.75792, 36.91239], [-119.75661, 36.91246], [-119.75643, 36.91024], [-119.75775, 36.91023], [-119.75792, 36.91239]]]}	Open Access 1	25932	River Center	24407	3069	San Joaquin River Parkway and Conservation Trust 649	Non Profit 6	Non Profit - Land Trust 10	http://www.riverparkway.org	Non Governmental Organization 10	3069	San Joaquin River Parkway and Conservation Trust 491	Non Profit 6	Non Profit - Land Trust 10	Fresno 9	7.035	River Ctr.	0	Private Conservation 16	2

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