units_with_maps

Table actions

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

9 rows where DES_TP = 14, LAYER = 2 and MNG_AGENCY = 84

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Escondido, City of · 9 ✖

DES_TP 1

  • Local Other or Unknown · 9 ✖

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
208 208 207 {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} No Public Access 3 654 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 16.798 Reidy Canyon Creek 0 Local Other or Unknown 14 4
235 235 234 {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} No Public Access 3 684 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 4.055 Reidy Canyon Creek 0 Local Other or Unknown 14 4
236 236 235 {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} No Public Access 3 687 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 2.732 Reidy Canyon Creek 0 Local Other or Unknown 14 4
251 251 250 {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} No Public Access 3 683 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 0.966 Reidy Canyon Creek 0 Local Other or Unknown 14 4
3891 3891 3890 {"type": "Polygon", "coordinates": [[[-117.09429, 33.13135], [-117.094, 33.13143], [-117.09383, 33.13102], [-117.09403, 33.13085], [-117.09407, 33.13095], [-117.09412, 33.13095], [-117.09429, 33.13135]]]} No Public Access 3 642 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 0.372 Reidy Canyon Creek 0 Local Other or Unknown 14 4
5007 5007 5006 {"type": "Polygon", "coordinates": [[[-117.08308, 33.12563], [-117.083, 33.12566], [-117.08273, 33.12596], [-117.08261, 33.1257], [-117.08295, 33.12535], [-117.08308, 33.12563]]]} No Public Access 3 689 Escondido Creek 18706 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 0.332 Escondido Creek 0 Local Other or Unknown 14 4
5863 5863 5862 {"type": "MultiPolygon", "coordinates": [[[[-117.02636, 33.16692], [-117.02637, 33.16744], [-117.0263, 33.16767], [-117.02627, 33.16768], [-117.02381, 33.1705], [-117.0228, 33.17041], [-117.02244, 33.17066], [-117.02191, 33.17075], [-117.02157, 33.17076], [-117.0211, 33.17036], [-117.02039, 33.17028], [-117.0193, 33.16949], [-117.01888, 33.1689], [-117.01829, 33.16863], [-117.0182, 33.16854], [-117.01809, 33.16833], [-117.01805, 33.16832], [-117.01805, 33.16822], [-117.01821, 33.16823], [-117.01836, 33.16851], [-117.01841, 33.16856], [-117.019, 33.16883], [-117.01907, 33.16893], [-117.01899, 33.16898], [-117.01935, 33.16949], [-117.02041, 33.17025], [-117.02111, 33.17033], [-117.02157, 33.17072], [-117.02186, 33.17071], [-117.02188, 33.17067], [-117.02237, 33.17059], [-117.02276, 33.17032], [-117.02381, 33.17041], [-117.02579, 33.16812], [-117.02611, 33.1677], [-117.02619, 33.16744], [-117.02618, 33.16691], [-117.02636, 33.16692]]], [[[-117.03026, 33.16085], [-117.02978, 33.16201], [-117.02983, 33.16203], [-117.02952, 33.16302], [-117.02949, 33.16333], [-117.02954, 33.16362], [-117.02927, 33.16475], [-117.02785, 33.16432], [-117.02829, 33.16321], [-117.02812, 33.16305], [-117.02818, 33.16299], [-117.02891, 33.16214], [-117.029, 33.16188], [-117.02906, 33.16187], [-117.02931, 33.16168], [-117.02936, 33.16148], [-117.02948, 33.16128], [-117.02963, 33.16113], [-117.02986, 33.16099], [-117.03026, 33.16085]]], [[[-117.047, 33.14542], [-117.0464, 33.14577], [-117.04613, 33.14599], [-117.04568, 33.14639], [-117.04536, 33.1466], [-117.04502, 33.14677], [-117.04494, 33.1468], [-117.04431, 33.14709], [-117.04386, 33.14733], [-117.04316, 33.14765], [-117.04287, 33.14774], [-117.04248, 33.14783], [-117.04224, 33.14786], [-117.04113, 33.1479], [-117.04094, 33.14799], [-117.04089, 33.14791], [-117.04015, 33.14791], [-117.03971, 33.14795], [-117.03949, 33.14801], [-117.03909, 33.14814], [-117.0387, 33.1484], [-117.03852, 33.14855], [-117.03758, 33.14944], [-117.03759, 33.14947], [-117.03744, 33.14963], [-117.03729, 33.14987], [-117.03692, 33.14982], [-117.03731, 33.14903], [-117.03754, 33.14905], [-117.03827, 33.14831], [-117.03842, 33.14818], [-117.03841, 33.14815], [-117.03858, 33.14803], [-117.03896, 33.14783], [-117.03932, 33.14768], [-117.03981, 33.14758], [-117.04015, 33.14756], [-117.04116, 33.14756], [-117.04121, 33.14762], [-117.04189, 33.14763], [-117.04224, 33.1476], [-117.04252, 33.14756], [-117.04277, 33.14749], [-117.043, 33.14741], [-117.04507, 33.14646], [-117.04528, 33.14635], [-117.04539, 33.14627], [-117.04584, 33.14587], [-117.04623, 33.14554], [-117.04685, 33.14517], [-117.047, 33.14542]]], [[[-117.0675, 33.13214], [-117.06677, 33.13264], [-117.06648, 33.13289], [-117.06619, 33.13307], [-117.06584, 33.13324], [-117.06561, 33.13332], [-117.06516, 33.13344], [-117.06488, 33.13347], [-117.06459, 33.13312], [-117.06483, 33.1331], [-117.06485, 33.13313], [-117.06512, 33.13308], [-117.06552, 33.13296], [-117.06601, 33.13276], [-117.06651, 33.13245], [-117.06738, 33.13176], [-117.0675, 33.13214]]], [[[-117.06901, 33.13096], [-117.06874, 33.13109], [-117.06832, 33.13136], [-117.06801, 33.13163], [-117.06802, 33.13165], [-117.06769, 33.13191], [-117.06757, 33.13154], [-117.0683, 33.13093], [-117.0688, 33.13065], [-117.06901, 33.13096]]], [[[-117.0704, 33.13036], [-117.06983, 33.13063], [-117.0698, 33.1306], [-117.06925, 33.13085], [-117.06904, 33.13054], [-117.07019, 33.13002], [-117.0704, 33.13036]]], [[[-117.07179, 33.12972], [-117.07063, 33.13026], [-117.07043, 33.12995], [-117.07073, 33.12981], [-117.07071, 33.12977], [-117.07158, 33.12938], [-117.07179, 33.12972]]], [[[-117.07317, 33.12909], [-117.07202, 33.12961], [-117.07181, 33.12927], [-117.07295, 33.12874], [-117.07317, 33.12909]]], [[[-117.07456, 33.12844], [-117.07339, 33.12896], [-117.07334, 33.1289], [-117.07432, 33.12843], [-117.07448, 33.12836], [-117.07456, 33.12844]]], [[[-117.07591, 33.12782], [-117.07479, 33.12835], [-117.07472, 33.12824], [-117.07586, 33.12772], [-117.07591, 33.12782]]], [[[-117.07746, 33.12743], [-117.07699, 33.12747], [-117.07676, 33.12751], [-117.07641, 33.12762], [-117.07616, 33.12773], [-117.07608, 33.12761], [-117.07724, 33.12709], [-117.07746, 33.12743]]], [[[-117.08144, 33.1271], [-117.08115, 33.12721], [-117.08078, 33.1273], [-117.08026, 33.12738], [-117.07774, 33.12741], [-117.07754, 33.12707], [-117.07901, 33.12707], [-117.08015, 33.12704], [-117.08067, 33.12695], [-117.08102, 33.12686], [-117.08124, 33.12678], [-117.08144, 33.1271]]], [[[-117.08226, 33.12655], [-117.08202, 33.12674], [-117.08199, 33.12672], [-117.08166, 33.12695], [-117.08146, 33.12667], [-117.08176, 33.12645], [-117.08176, 33.12644], [-117.08207, 33.12614], [-117.08226, 33.12655]]], [[[-117.08271, 33.12607], [-117.08237, 33.12643], [-117.0822, 33.12601], [-117.08225, 33.12599], [-117.08254, 33.12569], [-117.08271, 33.12607]]], [[[-117.08966, 33.12061], [-117.08939, 33.12075], [-117.08924, 33.12087], [-117.08838, 33.12158], [-117.08823, 33.12129], [-117.08922, 33.12051], [-117.08949, 33.12035], [-117.08966, 33.12061]]], [[[-117.09276, 33.11986], [-117.09207, 33.11988], [-117.09152, 33.11994], [-117.09127, 33.11998], [-117.09056, 33.12017], [-117.09021, 33.1203], [-117.08986, 33.12046], [-117.0897, 33.12024], [-117.08998, 33.12008], [-117.09025, 33.11996], [-117.09048, 33.11986], [-117.09078, 33.11978], [-117.09107, 33.11977], [-117.09148, 33.11968], [-117.09186, 33.11961], [-117.09222, 33.11958], [-117.09265, 33.11958], [-117.09276, 33.11986]]], [[[-117.09679, 33.11874], [-117.09593, 33.11947], [-117.09577, 33.11965], [-117.09533, 33.11949], [-117.09538, 33.1194], [-117.09539, 33.11936], [-117.09511, 33.11927], [-117.09567, 33.119], [-117.09571, 33.11901], [-117.09634, 33.11858], [-117.09679, 33.11874]]], [[[-117.09969, 33.11766], [-117.09946, 33.1182], [-117.0989, 33.11818], [-117.09888, 33.11815], [-117.09867, 33.11815], [-117.09837, 33.11816], [-117.09803, 33.11822], [-117.09776, 33.11828], [-117.0975, 33.11838], [-117.09728, 33.11849], [-117.09706, 33.11865], [-117.09653, 33.11844], [-117.09691, 33.11816], [-117.09712, 33.11804], [-117.09749, 33.11788], [-117.09798, 33.11774], [-117.09798, 33.11772], [-117.09829, 33.11767], [-117.09893, 33.11765], [-117.09894, 33.11768], [-117.09931, 33.11768], [-117.09969, 33.11766]]], [[[-117.1043, 33.11385], [-117.10384, 33.11409], [-117.10355, 33.11429], [-117.10326, 33.11453], [-117.10283, 33.11502], [-117.10252, 33.11554], [-117.10242, 33.11581], [-117.10218, 33.11658], [-117.10203, 33.11686], [-117.10177, 33.1172], [-117.10174, 33.11727], [-117.10161, 33.11742], [-117.10146, 33.11755], [-117.10118, 33.11774], [-117.10097, 33.11726], [-117.10097, 33.11723], [-117.10128, 33.11699], [-117.1015, 33.11676], [-117.10182, 33.11591], [-117.10195, 33.1155], [-117.10213, 33.11513], [-117.10232, 33.11481], [-117.10255, 33.11452], [-117.10257, 33.11437], [-117.10284, 33.11418], [-117.10307, 33.11393], [-117.10311, 33.11394], [-117.10358, 33.11365], [-117.1043, 33.11385]]], [[[-117.11185, 33.10955], [-117.11069, 33.11042], [-117.11039, 33.11068], [-117.11003, 33.11107], [-117.10985, 33.11132], [-117.10976, 33.11149], [-117.10961, 33.1117], [-117.10939, 33.11195], [-117.10889, 33.11244], [-117.10817, 33.11317], [-117.10811, 33.11314], [-117.10768, 33.11353], [-117.10742, 33.11388], [-117.10735, 33.11405], [-117.10729, 33.11442], [-117.10718, 33.11439], [-117.10723, 33.11402], [-117.10738, 33.11364], [-117.10735, 33.11362], [-117.1076, 33.11327], [-117.10792, 33.11298], [-117.10786, 33.11293], [-117.10723, 33.11311], [-117.10723, 33.11314], [-117.10474, 33.11367], [-117.10402, 33.11348], [-117.10445, 33.11328], [-117.10496, 33.11313], [-117.10644, 33.11287], [-117.10742, 33.11262], [-117.10777, 33.1125], [-117.10831, 33.11222], [-117.10878, 33.11189], [-117.1092, 33.11145], [-117.10968, 33.11079], [-117.10997, 33.11045], [-117.11033, 33.11011], [-117.11091, 33.10963], [-117.11124, 33.1093], [-117.11185, 33.10955]]]]} No Public Access 3 192 Escondido Creek 18706 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 62.151 Escondido Creek 0 Local Other or Unknown 14 4
6015 6015 6014 {"type": "Polygon", "coordinates": [[[-117.09363, 33.12972], [-117.0934, 33.12982], [-117.09332, 33.12983], [-117.09264, 33.12819], [-117.09301, 33.12807], [-117.09327, 33.1289], [-117.09363, 33.12972]]]} No Public Access 3 675 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 1.523 Reidy Canyon Creek 0 Local Other or Unknown 14 4
6250 6250 6249 {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} No Public Access 3 1410 Escondido Creek 18706 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 8.905 Escondido Creek 0 Local Other or Unknown 14 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]);