units_with_maps

Table actions

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

2 rows where DES_TP = 16 and MNG_AG_TYP = 18

This data as json, copyable, CSV (advanced)

MNG_AGENCY 2

MNG_AG_TYP 1

  • Commercial · 2 ✖

DES_TP 1

  • Private Conservation · 2 ✖
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
13011 13011 13010 {"type": "Polygon", "coordinates": [[[-122.07488, 37.0773], [-122.07365, 37.07969], [-122.07177, 37.07868], [-122.07123, 37.07859], [-122.07087, 37.07867], [-122.0706, 37.07841], [-122.06987, 37.07846], [-122.06831, 37.0799], [-122.0676, 37.08081], [-122.06757, 37.08181], [-122.0674, 37.08181], [-122.06645, 37.0818], [-122.06648, 37.08068], [-122.06562, 37.08034], [-122.06429, 37.07964], [-122.06405, 37.07935], [-122.06361, 37.07897], [-122.06273, 37.07861], [-122.0623, 37.07823], [-122.06184, 37.07801], [-122.06163, 37.07749], [-122.06148, 37.07742], [-122.06095, 37.07731], [-122.05935, 37.07846], [-122.05927, 37.07841], [-122.0585, 37.07752], [-122.05958, 37.07597], [-122.06208, 37.07574], [-122.06383, 37.07431], [-122.06382, 37.07429], [-122.06238, 37.07428], [-122.06239, 37.07328], [-122.06498, 37.0733], [-122.06525, 37.07244], [-122.06613, 37.07145], [-122.06767, 37.07161], [-122.06781, 37.07262], [-122.06938, 37.0739], [-122.06959, 37.07377], [-122.07205, 37.07535], [-122.07488, 37.0773]], [[-122.07175, 37.07565], [-122.07196, 37.07546], [-122.07196, 37.07544], [-122.07076, 37.07466], [-122.06983, 37.07409], [-122.06966, 37.07396], [-122.06957, 37.07398], [-122.06941, 37.07409], [-122.06767, 37.07267], [-122.06754, 37.07171], [-122.06622, 37.07159], [-122.06542, 37.07248], [-122.0654, 37.07262], [-122.0654, 37.07274], [-122.0655, 37.07307], [-122.06558, 37.07324], [-122.06551, 37.07326], [-122.06538, 37.07326], [-122.065, 37.07346], [-122.06466, 37.07354], [-122.06425, 37.07376], [-122.0641, 37.07391], [-122.06408, 37.07403], [-122.06408, 37.07414], [-122.06414, 37.0743], [-122.06426, 37.07443], [-122.06437, 37.07444], [-122.06424, 37.07451], [-122.06414, 37.07462], [-122.0641, 37.07475], [-122.06411, 37.07484], [-122.06413, 37.07487], [-122.06413, 37.0749], [-122.06418, 37.07496], [-122.06431, 37.0756], [-122.06435, 37.07652], [-122.06423, 37.0768], [-122.06416, 37.07684], [-122.06373, 37.07682], [-122.0631, 37.07681], [-122.06288, 37.07708], [-122.06288, 37.07712], [-122.0633, 37.07744], [-122.06373, 37.07753], [-122.06428, 37.07738], [-122.06452, 37.07761], [-122.06488, 37.07782], [-122.06482, 37.07791], [-122.06394, 37.07796], [-122.0639, 37.07807], [-122.06391, 37.07813], [-122.06406, 37.07823], [-122.0641, 37.07828], [-122.0642, 37.07834], [-122.06421, 37.07836], [-122.06441, 37.0785], [-122.06449, 37.07865], [-122.06453, 37.0787], [-122.06462, 37.07888], [-122.06467, 37.07895], [-122.06468, 37.07898], [-122.06482, 37.07902], [-122.06465, 37.07911], [-122.06461, 37.07923], [-122.06478, 37.07936], [-122.06479, 37.07938], [-122.06513, 37.07944], [-122.06538, 37.07958], [-122.06558, 37.07958], [-122.06565, 37.07954], [-122.06571, 37.07948], [-122.06577, 37.07937], [-122.06582, 37.07923], [-122.0676, 37.07962], [-122.06784, 37.07963], [-122.068, 37.07957], [-122.06809, 37.07951], [-122.06927, 37.07843], [-122.06939, 37.07834], [-122.06957, 37.07824], [-122.06984, 37.07814], [-122.07012, 37.07808], [-122.07071, 37.07806], [-122.07104, 37.07807], [-122.07155, 37.07793], [-122.07159, 37.0778], [-122.07169, 37.07759], [-122.07176, 37.07741], [-122.07216, 37.07659], [-122.07221, 37.07631], [-122.07213, 37.07592], [-122.07175, 37.07565]]]} Restricted Access 2 31201 Quail Hollow Quarry Conservation Areas 24045 6066 GraniteRock 1036 Private 7 Commercial 20 http://www.graniterock.com/locations/santa_cruz.html Private 14 6066 GraniteRock 998 Private 7 Commercial 18   Santa Cruz 5 78.891 Quail Hollow Quarry Conservation Areas 0 Private Conservation 16 2
15293 15293 15292 {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} No Public Access 3 46424 El Segundo Blue Butterfly Preserve 29696 6107 Chevron Corporation 1149 Private 7 Commercial 20 http://www.chevron.com/ Private 14 6107 Chevron Corporation 1096 Private 7 Commercial 18   Los Angeles 6 1.358 El Segundo Blue Butterfly 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]);