units_with_maps

Table actions

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

1 row where AGNCY_NAME = 862, MNG_AGENCY = 840 and MNG_AG_TYP = 10

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • Fond Land Preservation Foundation · 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
7399 7399 7398 {"type": "MultiPolygon", "coordinates": [[[[-118.32813, 34.25287], [-118.32799, 34.2536], [-118.32811, 34.254], [-118.32728, 34.25449], [-118.32715, 34.25435], [-118.32611, 34.25459], [-118.32583, 34.25429], [-118.32522, 34.25334], [-118.32538, 34.25159], [-118.32516, 34.25134], [-118.32518, 34.25131], [-118.32529, 34.25124], [-118.32592, 34.25118], [-118.32619, 34.25128], [-118.32645, 34.25156], [-118.32659, 34.25202], [-118.32678, 34.25225], [-118.32709, 34.25239], [-118.32776, 34.25256], [-118.32813, 34.25287]]], [[[-118.35035, 34.24485], [-118.34989, 34.24486], [-118.34989, 34.2463], [-118.34866, 34.2463], [-118.3484, 34.24562], [-118.34795, 34.24522], [-118.34716, 34.24544], [-118.346, 34.2464], [-118.34557, 34.24817], [-118.34407, 34.24477], [-118.34085, 34.24487], [-118.34106, 34.24552], [-118.33901, 34.24712], [-118.3387, 34.24719], [-118.33869, 34.25013], [-118.33898, 34.25021], [-118.33904, 34.25075], [-118.34034, 34.25092], [-118.34011, 34.25127], [-118.34019, 34.2513], [-118.34027, 34.2514], [-118.34073, 34.25205], [-118.34066, 34.25204], [-118.34065, 34.25205], [-118.34078, 34.2522], [-118.34112, 34.25233], [-118.34098, 34.25322], [-118.34001, 34.25301], [-118.33978, 34.25305], [-118.33979, 34.25311], [-118.33919, 34.25323], [-118.33871, 34.25314], [-118.3387, 34.25408], [-118.3348, 34.25297], [-118.32787, 34.25114], [-118.32532, 34.24575], [-118.32614, 34.24569], [-118.32564, 34.24438], [-118.32585, 34.24356], [-118.32829, 34.24373], [-118.32941, 34.24303], [-118.33558, 34.24282], [-118.33558, 34.24462], [-118.33559, 34.24463], [-118.33679, 34.24372], [-118.34114, 34.24136], [-118.34166, 34.24142], [-118.34431, 34.24006], [-118.34432, 34.24256], [-118.35034, 34.24236], [-118.35035, 34.24485]]], [[[-118.33422, 34.25811], [-118.33386, 34.25817], [-118.33304, 34.25842], [-118.33287, 34.25845], [-118.33269, 34.25847], [-118.33263, 34.2585], [-118.3325, 34.25862], [-118.33238, 34.25867], [-118.33187, 34.25871], [-118.33175, 34.25879], [-118.33179, 34.25942], [-118.33099, 34.2595], [-118.33094, 34.2595], [-118.33093, 34.25949], [-118.33073, 34.2595], [-118.32881, 34.25776], [-118.32752, 34.25663], [-118.32832, 34.25596], [-118.32851, 34.25262], [-118.32804, 34.25162], [-118.33174, 34.2526], [-118.33131, 34.25461], [-118.33187, 34.2553], [-118.33162, 34.25606], [-118.33175, 34.25642], [-118.33176, 34.25744], [-118.33282, 34.25776], [-118.33402, 34.25796], [-118.33422, 34.25811]]], [[[-118.35418, 34.24275], [-118.35397, 34.24291], [-118.35393, 34.24342], [-118.35417, 34.24362], [-118.35417, 34.24516], [-118.35385, 34.24535], [-118.35372, 34.24537], [-118.35366, 34.24534], [-118.35357, 34.24544], [-118.35354, 34.24541], [-118.35312, 34.24527], [-118.3527, 34.24541], [-118.35272, 34.24228], [-118.35417, 34.24223], [-118.35418, 34.24275]]]]} Open Access 1 6826 Fond Wilderness Preserve 3733 3023 Fond Land Preservation Foundation 862 Non Profit 6 Non Profit - Land Trust 10 http://www.flpf.org/ Non Governmental Organization 10 3023 Fond Land Preservation Foundation 840 Non Profit 6 Non Profit - Land Trust 10 http://flpf.org/index.html Los Angeles 6 498.668 Fond Wilderness Preserve 0 Private Conservation 16 2

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