units_with_maps

Table actions

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

4 rows where AGNCY_TYP = 13 and MNG_AGENCY = 491

This data as json, copyable, CSV (advanced)

Suggested facets: COUNTY

DES_TP 4

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Joaquin River Parkway and Conservation Trust · 4 ✖

ACCESS_TYP 1

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
2239 2239 2238 {"type": "Polygon", "coordinates": [[[-119.81102, 36.87326], [-119.80959, 36.87329], [-119.8096, 36.87351], [-119.81007, 36.87379], [-119.81022, 36.87384], [-119.81101, 36.87381], [-119.81092, 36.88017], [-119.80915, 36.88029], [-119.80178, 36.8809], [-119.79911, 36.88089], [-119.80337, 36.87899], [-119.80477, 36.87934], [-119.80542, 36.8792], [-119.8063, 36.87931], [-119.8063, 36.8783], [-119.80622, 36.87802], [-119.80565, 36.87825], [-119.80549, 36.8785], [-119.80516, 36.87785], [-119.79392, 36.8778], [-119.79337, 36.87782], [-119.79334, 36.87681], [-119.79332, 36.8768], [-119.7933, 36.87682], [-119.79325, 36.87549], [-119.79577, 36.8744], [-119.80082, 36.87025], [-119.80215, 36.86845], [-119.80261, 36.86797], [-119.80445, 36.86616], [-119.80599, 36.86497], [-119.80929, 36.86355], [-119.80935, 36.86353], [-119.81041, 36.86422], [-119.81111, 36.86607], [-119.81102, 36.87326]]]} Unknown Access 4 16693 Van Buren Unit 26820 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   Madera 48 433.198 Van Buren Unit   None 186  
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  
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  
12279 12279 12278 {"type": "Polygon", "coordinates": [[[-119.74413, 36.95238], [-119.73643, 36.95242], [-119.73532, 36.95037], [-119.73417, 36.94855], [-119.73385, 36.94778], [-119.73382, 36.94705], [-119.73448, 36.94596], [-119.73557, 36.94502], [-119.73691, 36.94458], [-119.738, 36.94429], [-119.73914, 36.94436], [-119.7401, 36.94453], [-119.74133, 36.94424], [-119.74239, 36.94352], [-119.7435, 36.94216], [-119.74386, 36.94241], [-119.74413, 36.95238]]]} Unknown Access 4 25928 Ledger Island 21130 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   Madera 48 184.827 Ledger Island   None 1072  

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