units_with_maps

Table actions

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

1 row where AGNCY_LEV = 6, DES_TP = 16 and MNG_AGENCY = 911

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Stanford University · 1 ✖

DES_TP 1

  • Private Conservation · 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
9926 9926 9925 {"type": "MultiPolygon", "coordinates": [[[[-122.24863, 37.40116], [-122.24858, 37.40128], [-122.24857, 37.40138], [-122.2485, 37.40152], [-122.24845, 37.40167], [-122.24843, 37.40184], [-122.24838, 37.40196], [-122.24814, 37.40227], [-122.248, 37.40263], [-122.24802, 37.40288], [-122.24775, 37.40305], [-122.24701, 37.40248], [-122.24627, 37.40217], [-122.24622, 37.40169], [-122.24555, 37.40159], [-122.24558, 37.40139], [-122.24559, 37.40123], [-122.24568, 37.40119], [-122.2457, 37.40102], [-122.24567, 37.40079], [-122.24557, 37.40042], [-122.24546, 37.40022], [-122.24524, 37.39994], [-122.24512, 37.39983], [-122.24499, 37.39966], [-122.24488, 37.39948], [-122.24475, 37.39923], [-122.24472, 37.39914], [-122.24469, 37.39889], [-122.24471, 37.3988], [-122.24475, 37.39874], [-122.24485, 37.39867], [-122.24494, 37.39863], [-122.24508, 37.39861], [-122.24518, 37.39855], [-122.24521, 37.3985], [-122.24532, 37.39847], [-122.24545, 37.39847], [-122.24599, 37.39871], [-122.24622, 37.39874], [-122.24635, 37.39886], [-122.24674, 37.39905], [-122.2469, 37.39916], [-122.24718, 37.39927], [-122.24757, 37.39946], [-122.24777, 37.3996], [-122.24793, 37.39978], [-122.2483, 37.40012], [-122.24839, 37.40026], [-122.24857, 37.40076], [-122.24863, 37.40116]]], [[[-122.24529, 37.40123], [-122.24527, 37.40141], [-122.24523, 37.40157], [-122.24487, 37.40162], [-122.24438, 37.40227], [-122.24487, 37.40246], [-122.24445, 37.40353], [-122.24437, 37.40389], [-122.24434, 37.40427], [-122.24438, 37.40469], [-122.24449, 37.40511], [-122.24525, 37.40675], [-122.24532, 37.40694], [-122.24535, 37.40714], [-122.24536, 37.40739], [-122.24531, 37.40764], [-122.24524, 37.40782], [-122.24516, 37.40798], [-122.24504, 37.40815], [-122.24477, 37.40841], [-122.2445, 37.40859], [-122.24344, 37.40915], [-122.24206, 37.41025], [-122.24059, 37.41156], [-122.23918, 37.41055], [-122.23716, 37.41093], [-122.23668, 37.41129], [-122.23635, 37.41141], [-122.23611, 37.4113], [-122.23599, 37.41092], [-122.2355, 37.41083], [-122.2349, 37.4106], [-122.23481, 37.41057], [-122.23472, 37.41053], [-122.23464, 37.41052], [-122.23463, 37.41051], [-122.23448, 37.41019], [-122.23354, 37.41013], [-122.23311, 37.41], [-122.23218, 37.41013], [-122.23167, 37.41053], [-122.23147, 37.41094], [-122.23116, 37.4112], [-122.2308, 37.41132], [-122.22947, 37.41164], [-122.22907, 37.41168], [-122.22818, 37.41115], [-122.22785, 37.41111], [-122.22753, 37.41117], [-122.22722, 37.41137], [-122.22683, 37.41146], [-122.22633, 37.4118], [-122.22613, 37.41218], [-122.22603, 37.41253], [-122.22307, 37.41289], [-122.22287, 37.41276], [-122.22282, 37.41269], [-122.2228, 37.41261], [-122.2227, 37.41248], [-122.22264, 37.41244], [-122.22259, 37.41233], [-122.22251, 37.41226], [-122.22211, 37.41161], [-122.22178, 37.41133], [-122.2216, 37.41122], [-122.22134, 37.4111], [-122.22116, 37.41105], [-122.22079, 37.411], [-122.22043, 37.41093], [-122.22015, 37.41084], [-122.21996, 37.41075], [-122.21978, 37.41065], [-122.21962, 37.41051], [-122.21952, 37.41038], [-122.21951, 37.41032], [-122.21941, 37.41018], [-122.21936, 37.41002], [-122.2193, 37.40994], [-122.21931, 37.40974], [-122.21917, 37.40951], [-122.21903, 37.40916], [-122.21891, 37.40896], [-122.21881, 37.40888], [-122.21867, 37.40881], [-122.21866, 37.40879], [-122.21854, 37.40855], [-122.21848, 37.40832], [-122.21839, 37.40815], [-122.21836, 37.40809], [-122.21836, 37.40803], [-122.21832, 37.40793], [-122.21811, 37.40767], [-122.21803, 37.40754], [-122.21793, 37.40742], [-122.21785, 37.40734], [-122.21767, 37.40722], [-122.21751, 37.40715], [-122.21734, 37.40711], [-122.21679, 37.40702], [-122.21655, 37.40693], [-122.2165, 37.40689], [-122.21626, 37.4068], [-122.21587, 37.40658], [-122.21592, 37.40631], [-122.21379, 37.40504], [-122.21035, 37.40363], [-122.20976, 37.40446], [-122.20482, 37.40185], [-122.20647, 37.40132], [-122.21002, 37.40039], [-122.21896, 37.39775], [-122.23376, 37.39344], [-122.23394, 37.39365], [-122.23369, 37.3937], [-122.2336, 37.39371], [-122.23356, 37.39391], [-122.2337, 37.39394], [-122.23375, 37.39398], [-122.23374, 37.39409], [-122.23345, 37.39409], [-122.23344, 37.39411], [-122.23353, 37.3943], [-122.23406, 37.39415], [-122.23417, 37.39436], [-122.23403, 37.39459], [-122.23412, 37.39473], [-122.23366, 37.39494], [-122.23376, 37.3951], [-122.23397, 37.39505], [-122.23397, 37.39538], [-122.23421, 37.39545], [-122.23423, 37.39555], [-122.23411, 37.39557], [-122.23405, 37.39576], [-122.23442, 37.39592], [-122.23433, 37.39605], [-122.23414, 37.39596], [-122.23399, 37.39597], [-122.23393, 37.39614], [-122.23425, 37.39626], [-122.23428, 37.39637], [-122.2344, 37.39645], [-122.23427, 37.39658], [-122.23411, 37.39655], [-122.23369, 37.39674], [-122.23354, 37.39662], [-122.23344, 37.39663], [-122.23335, 37.39678], [-122.23345, 37.39688], [-122.23335, 37.39694], [-122.23312, 37.397], [-122.23317, 37.39726], [-122.23339, 37.39724], [-122.2336, 37.3971], [-122.23427, 37.39735], [-122.23451, 37.39735], [-122.235, 37.39731], [-122.23527, 37.39734], [-122.23561, 37.39733], [-122.23578, 37.39712], [-122.23579, 37.39676], [-122.23621, 37.39646], [-122.23653, 37.39604], [-122.23747, 37.39598], [-122.23778, 37.39551], [-122.23809, 37.39599], [-122.23812, 37.396], [-122.238, 37.39605], [-122.23796, 37.39633], [-122.23787, 37.39651], [-122.23766, 37.39678], [-122.23773, 37.39703], [-122.23752, 37.39773], [-122.23775, 37.39814], [-122.23789, 37.39864], [-122.23783, 37.39914], [-122.23828, 37.39983], [-122.23844, 37.39983], [-122.23851, 37.39948], [-122.23892, 37.39915], [-122.23929, 37.39907], [-122.23952, 37.39911], [-122.23977, 37.39905], [-122.24024, 37.3987], [-122.2405, 37.39863], [-122.24071, 37.39855], [-122.24084, 37.39854], [-122.24138, 37.39859], [-122.24144, 37.39866], [-122.24181, 37.39875], [-122.24211, 37.39911], [-122.24239, 37.39914], [-122.2426, 37.3987], [-122.24249, 37.39866], [-122.24231, 37.39851], [-122.24235, 37.39835], [-122.24252, 37.39837], [-122.2441, 37.39833], [-122.24412, 37.39879], [-122.24417, 37.39884], [-122.24421, 37.39911], [-122.2443, 37.39936], [-122.24436, 37.39949], [-122.24443, 37.39955], [-122.2446, 37.40001], [-122.24471, 37.40011], [-122.24511, 37.40077], [-122.24521, 37.40105], [-122.24529, 37.40116], [-122.24529, 37.40123]]]]} Restricted Access 2 17067 Jasper Ridge Reserve 20369 3346 Stanford University 938 Non Profit 6 Non Profit - Education 34 http://jrbp.stanford.edu/ Non Governmental Organization 10 3346 Stanford University 911 Non Profit 6 Non Profit - Education 32   San Mateo 15 1095.659 Jasper Ridge Reserve 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]);