units_with_maps

Table actions

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

1 row where AGNCY_NAME = 827, DES_TP = 104 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

DES_TP 1

  • State Other or Unknown · 1 ✖

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
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

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