units_with_maps

Table actions

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

11 rows where AGNCY_NAME = 123, DES_TP = 3 and MNG_AGENCY = 120

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Carlsbad, City of · 11 ✖

DES_TP 1

  • Local Recreation Area · 11 ✖
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
5072 5072 5071 {"type": "Polygon", "coordinates": [[[-117.29151, 33.13914], [-117.29094, 33.13994], [-117.29087, 33.14012], [-117.29095, 33.14017], [-117.29055, 33.14137], [-117.28899, 33.14036], [-117.28835, 33.14107], [-117.28758, 33.14058], [-117.28903, 33.13896], [-117.28987, 33.13949], [-117.29102, 33.13866], [-117.2913, 33.13893], [-117.29151, 33.13909], [-117.29151, 33.13914]]]} Open Access 1 822 Business Park Recreation Facility (Zone 5) 30004 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 12.987 Business Park Rec. Facility (Zone 5) 0 Local Recreation Area 3 4
5215 5215 5214 {"type": "Polygon", "coordinates": [[[-117.34113, 33.15608], [-117.34183, 33.15694], [-117.34184, 33.15698], [-117.34182, 33.15701], [-117.34113, 33.15742], [-117.34108, 33.15742], [-117.34104, 33.1574], [-117.34033, 33.15654], [-117.34113, 33.15608]]]} Open Access 1 816 Chase Field 17153 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 2.723 Chase Field 0 Local Recreation Area 3 4
6024 6024 6023 {"type": "Polygon", "coordinates": [[[-117.29374, 33.13929], [-117.29267, 33.1393], [-117.29229, 33.13926], [-117.29214, 33.13922], [-117.29185, 33.13912], [-117.29165, 33.139], [-117.29149, 33.13887], [-117.29129, 33.13865], [-117.2935, 33.13738], [-117.29374, 33.13929]]]} Open Access 1 828 Business Park Recreation Facility 16541 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 7.167 Business Park Rec. Facility 0 Local Recreation Area 3 4
6087 6087 6086 {"type": "Polygon", "coordinates": [[[-117.30606, 33.10595], [-117.30582, 33.10598], [-117.30555, 33.10596], [-117.30562, 33.10551], [-117.30557, 33.10548], [-117.30521, 33.10539], [-117.30525, 33.105], [-117.30526, 33.10463], [-117.30605, 33.10448], [-117.30606, 33.10595]]]} Open Access 1 1113 Batiquitos Drive Open Space 15863 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 2.468 Batiquitos Drive OS 0 Local Recreation Area 3 4
6129 6129 6128 {"type": "Polygon", "coordinates": [[[-117.30647, 33.10234], [-117.30617, 33.10247], [-117.30636, 33.10281], [-117.30617, 33.10282], [-117.30617, 33.10266], [-117.30508, 33.10086], [-117.30526, 33.1008], [-117.30538, 33.10115], [-117.3057, 33.10108], [-117.30542, 33.10119], [-117.30544, 33.10127], [-117.3055, 33.10135], [-117.30588, 33.10197], [-117.30617, 33.10185], [-117.30619, 33.10187], [-117.30588, 33.10201], [-117.30614, 33.10245], [-117.30645, 33.10232], [-117.30647, 33.10234]]]} Open Access 1 1114 Batiquitos Drive Open Space 15863 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 0.715 Batiquitos Drive OS 0 Local Recreation Area 3 4
6130 6130 6129 {"type": "Polygon", "coordinates": [[[-117.30489, 33.1026], [-117.30484, 33.10263], [-117.30464, 33.10265], [-117.30424, 33.1026], [-117.30451, 33.10256], [-117.30459, 33.10251], [-117.30466, 33.10246], [-117.3047, 33.1024], [-117.30471, 33.1023], [-117.30467, 33.10201], [-117.30452, 33.10151], [-117.30442, 33.10129], [-117.30412, 33.10081], [-117.3039, 33.10085], [-117.30378, 33.10059], [-117.30402, 33.10049], [-117.30403, 33.10047], [-117.30422, 33.1004], [-117.30466, 33.10131], [-117.30467, 33.10135], [-117.30481, 33.10171], [-117.30487, 33.10193], [-117.30489, 33.10221], [-117.3049, 33.10257], [-117.30489, 33.1026]]]} Open Access 1 1115 Batiquitos Drive Open Space 15863 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 1.598 Batiquitos Drive OS 0 Local Recreation Area 3 4
15421 15421 15420 {"type": "Polygon", "coordinates": [[[-117.33023, 33.15686], [-117.33022, 33.157], [-117.33015, 33.15709], [-117.33003, 33.1572], [-117.32987, 33.15728], [-117.32972, 33.1573], [-117.3295, 33.15728], [-117.3294, 33.15725], [-117.32929, 33.15717], [-117.32917, 33.15701], [-117.32785, 33.15762], [-117.32731, 33.15675], [-117.32718, 33.15651], [-117.32716, 33.15642], [-117.32727, 33.15627], [-117.3275, 33.15625], [-117.32782, 33.1562], [-117.32795, 33.15615], [-117.32929, 33.15552], [-117.33023, 33.15686]]]} Restricted Access 2 46659 Magnolia Athletic Field 31624 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 9.19 Magnolia Athletic Field 0 Local Recreation Area 3 4
15656 15656 15655 {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.3009, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29047, 33.12797], [-117.29037, 33.12753], [-117.29114, 33.12727], [-117.29117, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30085, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13008], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13664], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30039, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29622, 33.13071], [-117.29622, 33.13069], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29635, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30639, 33.12491], [-117.30643, 33.12505], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} Restricted Access 2 804 The Crossings Golf Course 30002 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 391.552 The Crossings GC 0 Local Recreation Area 3 4
15816 15816 15815 {"type": "Polygon", "coordinates": [[[-117.30512, 33.09899], [-117.30508, 33.10086], [-117.30508, 33.10146], [-117.30497, 33.10125], [-117.30494, 33.10114], [-117.30486, 33.10098], [-117.30445, 33.1], [-117.30439, 33.09991], [-117.30399, 33.09898], [-117.30512, 33.09899]]]} Open Access 1 1116 Batiquitos Drive Open Space 15863 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 3.566 Batiquitos Drive OS 0 Local Recreation Area 3 4
15820 15820 15819 {"type": "Polygon", "coordinates": [[[-117.30392, 33.09963], [-117.30353, 33.09976], [-117.30314, 33.09969], [-117.30324, 33.09954], [-117.30324, 33.09935], [-117.30314, 33.09914], [-117.30301, 33.09907], [-117.30276, 33.099], [-117.30287, 33.09898], [-117.30372, 33.09898], [-117.30392, 33.09963]]]} Open Access 1 1117 Batiquitos Drive Open Space 15863 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 1.277 Batiquitos Drive OS 0 Local Recreation Area 3 4
16020 16020 16019 {"type": "Polygon", "coordinates": [[[-117.24719, 33.08498], [-117.24511, 33.08569], [-117.24483, 33.08511], [-117.24479, 33.08506], [-117.24465, 33.08473], [-117.24408, 33.08356], [-117.24396, 33.08316], [-117.24407, 33.08242], [-117.24407, 33.08146], [-117.24415, 33.08123], [-117.24416, 33.08092], [-117.24457, 33.08092], [-117.24442, 33.08125], [-117.24448, 33.08142], [-117.24468, 33.08178], [-117.24468, 33.08182], [-117.24491, 33.08223], [-117.24513, 33.0833], [-117.24532, 33.08363], [-117.24561, 33.08401], [-117.24598, 33.0844], [-117.24602, 33.08441], [-117.24619, 33.08461], [-117.24651, 33.08479], [-117.24719, 33.08498]]]} Open Access 1 5079 La Costa Canyon Open Space 20752 1045 Carlsbad, City of 123 City 2 City Agency 2 http://www.carlsbadca.gov/services/depts/parks/default.asp City 2 1045 Carlsbad, City of 120 City 2 City Agency 2   San Diego 4 12.952 La Costa Canyon OS 0 Local Recreation Area 3 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]);