units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 101 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/SweetwaterSummit.html"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16304 | 16304 | 16303 | {"type": "MultiPolygon", "coordinates": [[[[-117.00001, 32.68021], [-116.9999, 32.6803], [-116.99948, 32.6805], [-116.99933, 32.68048], [-116.99906, 32.67979], [-116.99918, 32.67964], [-116.99933, 32.67951], [-116.99965, 32.6793], [-117.00001, 32.68021]]], [[[-117.00057, 32.68357], [-117.00042, 32.68367], [-117.00034, 32.6837], [-116.9996, 32.68176], [-116.99988, 32.68218], [-117.00023, 32.68292], [-117.00039, 32.68335], [-117.00048, 32.68348], [-117.00057, 32.68357]]], [[[-117.01085, 32.68508], [-117.0108, 32.68502], [-117.00999, 32.68293], [-117.00981, 32.68262], [-117.0097, 32.6823], [-117.00947, 32.68196], [-117.00926, 32.68171], [-117.00885, 32.68185], [-117.00769, 32.68091], [-117.00773, 32.68079], [-117.00764, 32.68046], [-117.00752, 32.68031], [-117.00726, 32.68024], [-117.00687, 32.68024], [-117.00636, 32.68], [-117.00618, 32.68006], [-117.00551, 32.67982], [-117.00531, 32.6795], [-117.00445, 32.67942], [-117.00375, 32.67932], [-117.003, 32.67933], [-117.00257, 32.67941], [-117.00171, 32.67964], [-117.00098, 32.67965], [-117.00067, 32.67979], [-117.00046, 32.67995], [-117.00034, 32.68], [-116.99995, 32.67898], [-117.00084, 32.67873], [-117.00087, 32.67878], [-117.00381, 32.67799], [-117.00411, 32.67874], [-117.00797, 32.67767], [-117.00904, 32.68038], [-117.01085, 32.68508]]], [[[-117.01152, 32.6883], [-117.01149, 32.68841], [-117.01082, 32.68933], [-117.00851, 32.68999], [-117.00587, 32.68883], [-117.00564, 32.68831], [-117.00625, 32.68725], [-117.00289, 32.68583], [-117.00257, 32.68591], [-117.00165, 32.68354], [-117.00123, 32.68236], [-117.00077, 32.68114], [-117.00115, 32.68104], [-117.0019, 32.68068], [-117.00205, 32.68055], [-117.00237, 32.68044], [-117.0029, 32.68057], [-117.00354, 32.68054], [-117.00431, 32.68064], [-117.00479, 32.68061], [-117.00526, 32.68084], [-117.0057, 32.68097], [-117.00583, 32.68115], [-117.00587, 32.68123], [-117.00609, 32.68137], [-117.00632, 32.68144], [-117.0066, 32.6816], [-117.00722, 32.68165], [-117.0081, 32.68225], [-117.0081, 32.68244], [-117.00838, 32.68303], [-117.00883, 32.6835], [-117.00881, 32.68371], [-117.00891, 32.68396], [-117.00926, 32.68435], [-117.00945, 32.68492], [-117.00942, 32.68547], [-117.00989, 32.68585], [-117.01016, 32.68623], [-117.01024, 32.68645], [-117.01031, 32.68713], [-117.01077, 32.68741], [-117.01098, 32.68758], [-117.01111, 32.68772], [-117.01124, 32.68794], [-117.01152, 32.6883]]], [[[-117.0142, 32.69115], [-117.01407, 32.69137], [-117.01404, 32.69148], [-117.01402, 32.69167], [-117.01424, 32.69254], [-117.01424, 32.69264], [-117.01418, 32.69275], [-117.01397, 32.69293], [-117.01382, 32.69309], [-117.01353, 32.6935], [-117.01347, 32.69361], [-117.01345, 32.69372], [-117.01346, 32.69383], [-117.01357, 32.69426], [-117.0116, 32.6948], [-117.01144, 32.69486], [-117.01108, 32.69399], [-117.01103, 32.6939], [-117.01054, 32.69262], [-117.01006, 32.69143], [-117.01173, 32.69096], [-117.01152, 32.69038], [-117.01163, 32.69016], [-117.01202, 32.69013], [-117.01273, 32.68984], [-117.01289, 32.68963], [-117.01287, 32.68945], [-117.01419, 32.6907], [-117.01415, 32.69111], [-117.0142, 32.69115]], [[-117.01373, 32.69043], [-117.01304, 32.69061], [-117.01303, 32.69062], [-117.01307, 32.6907], [-117.01339, 32.69062], [-117.01363, 32.69051], [-117.01373, 32.69044], [-117.01373, 32.69043]]], [[[-117.01537, 32.6897], [-117.01531, 32.68973], [-117.01528, 32.6898], [-117.01496, 32.68971], [-117.01467, 32.68959], [-117.01339, 32.68865], [-117.01289, 32.68825], [-117.0127, 32.68795], [-117.01268, 32.68796], [-117.01269, 32.68799], [-117.01238, 32.68772], [-117.01191, 32.6873], [-117.0118, 32.68716], [-117.01382, 32.6866], [-117.01371, 32.6884], [-117.01529, 32.68944], [-117.01537, 32.6897]]], [[[-117.01431, 32.69121], [-117.01438, 32.69125], [-117.01463, 32.69149], [-117.01479, 32.6917], [-117.01489, 32.6921], [-117.01486, 32.69243], [-117.01477, 32.69283], [-117.01447, 32.69319], [-117.01438, 32.69354], [-117.014, 32.69412], [-117.01369, 32.69421], [-117.01358, 32.6938], [-117.01358, 32.69372], [-117.0136, 32.69362], [-117.01395, 32.69311], [-117.01408, 32.69299], [-117.01429, 32.69281], [-117.01435, 32.69272], [-117.01437, 32.69264], [-117.01436, 32.6925], [-117.01415, 32.69166], [-117.01415, 32.69154], [-117.01418, 32.69142], [-117.01424, 32.6913], [-117.01431, 32.69121]]], [[[-117.02499, 32.66848], [-117.0249, 32.66869], [-117.02484, 32.66908], [-117.02486, 32.67035], [-117.0249, 32.67075], [-117.02518, 32.672], [-117.02521, 32.67236], [-117.0252, 32.67254], [-117.02517, 32.6728], [-117.02509, 32.67314], [-117.02501, 32.67334], [-117.02483, 32.67369], [-117.02457, 32.67403], [-117.02433, 32.67428], [-117.02337, 32.67511], [-117.02256, 32.67565], [-117.02197, 32.676], [-117.02154, 32.67624], [-117.02106, 32.67646], [-117.0207, 32.6766], [-117.01952, 32.67701], [-117.01923, 32.67712], [-117.01787, 32.67774], [-117.01789, 32.67782], [-117.01781, 32.67784], [-117.01766, 32.678], [-117.01762, 32.6779], [-117.01775, 32.67785], [-117.01736, 32.67692], [-117.01733, 32.67677], [-117.01711, 32.67622], [-117.01704, 32.6759], [-117.01703, 32.67576], [-117.01705, 32.67538], [-117.01713, 32.67511], [-117.01724, 32.67483], [-117.01735, 32.67464], [-117.01757, 32.67436], [-117.02207, 32.67065], [-117.02262, 32.67012], [-117.02277, 32.66993], [-117.02291, 32.66967], [-117.023, 32.66939], [-117.02299, 32.66936], [-117.02302, 32.6692], [-117.02307, 32.6691], [-117.02311, 32.66895], [-117.02313, 32.66893], [-117.02314, 32.66871], [-117.02458, 32.66832], [-117.02474, 32.66835], [-117.02499, 32.66848]]], [[[-117.05345, 32.65191], [-117.05284, 32.65255], [-117.05244, 32.65154], [-117.05218, 32.65168], [-117.05264, 32.65295], [-117.05109, 32.65463], [-117.05102, 32.65467], [-117.04909, 32.65552], [-117.04884, 32.65558], [-117.04651, 32.65746], [-117.04652, 32.65747], [-117.04686, 32.65754], [-117.04754, 32.65766], [-117.04741, 32.6583], [-117.04736, 32.65846], [-117.04714, 32.65872], [-117.04718, 32.65876], [-117.04668, 32.65911], [-117.04503, 32.65958], [-117.04446, 32.66024], [-117.04216, 32.65876], [-117.04259, 32.65872], [-117.04367, 32.65864], [-117.04391, 32.65848], [-117.04312, 32.65655], [-117.04477, 32.65528], [-117.04523, 32.65503], [-117.04534, 32.65494], [-117.04555, 32.65484], [-117.04564, 32.65477], [-117.04613, 32.65432], [-117.04639, 32.65415], [-117.0467, 32.654], [-117.04734, 32.65373], [-117.04823, 32.65326], [-117.04852, 32.65307], [-117.04881, 32.65284], [-117.04997, 32.65181], [-117.0504, 32.65152], [-117.0509, 32.65126], [-117.0509, 32.65121], [-117.05132, 32.65099], [-117.05135, 32.65102], [-117.05183, 32.65077], [-117.05281, 32.65012], [-117.05345, 32.65191]]], [[[-117.06397, 32.65135], [-117.06384, 32.65128], [-117.06386, 32.6514], [-117.06342, 32.65122], [-117.06212, 32.65106], [-117.06148, 32.65108], [-117.06147, 32.65099], [-117.06106, 32.65101], [-117.06104, 32.65098], [-117.06065, 32.65109], [-117.06066, 32.65113], [-117.06063, 32.65115], [-117.06075, 32.65146], [-117.06062, 32.65169], [-117.06068, 32.65187], [-117.05917, 32.65229], [-117.05886, 32.65147], [-117.05842, 32.65037], [-117.05739, 32.65065], [-117.05705, 32.6498], [-117.05699, 32.64984], [-117.05601, 32.65004], [-117.05604, 32.65009], [-117.05558, 32.65018], [-117.05554, 32.65013], [-117.05462, 32.65031], [-117.05372, 32.65165], [-117.05349, 32.65188], [-117.05282, 32.65004], [-117.05383, 32.64928], [-117.05387, 32.64932], [-117.05461, 32.64876], [-117.05559, 32.65012], [-117.05593, 32.65006], [-117.05593, 32.65005], [-117.05488, 32.64858], [-117.05556, 32.64829], [-117.05602, 32.64812], [-117.05625, 32.64805], [-117.05671, 32.64793], [-117.05729, 32.64789], [-117.05767, 32.64791], [-117.05772, 32.64792], [-117.05775, 32.64796], [-117.05781, 32.64817], [-117.05787, 32.64827], [-117.05801, 32.64846], [-117.05813, 32.64857], [-117.05832, 32.6487], [-117.05853, 32.64879], [-117.06311, 32.65017], [-117.06331, 32.65027], [-117.06345, 32.65038], [-117.06363, 32.65055], [-117.06382, 32.65088], [-117.06396, 32.65121], [-117.06397, 32.65135]]], [[[-117.05658, 32.6514], [-117.05554, 32.65167], [-117.05525, 32.65089], [-117.05618, 32.6504], [-117.05658, 32.6514]]], [[[-117.06354, 32.65011], [-117.06344, 32.65006], [-117.06344, 32.65004], [-117.06332, 32.64998], [-117.06306, 32.64987], [-117.05855, 32.64852], [-117.0584, 32.64844], [-117.05824, 32.6483], [-117.05816, 32.6482], [-117.05812, 32.64811], [-117.05812, 32.64806], [-117.05815, 32.64801], [-117.05823, 32.64797], [-117.05906, 32.6481], [-117.05896, 32.64821], [-117.05895, 32.6483], [-117.05898, 32.64838], [-117.05902, 32.64844], [-117.05907, 32.6485], [-117.05913, 32.64853], [-117.05926, 32.64857], [-117.05964, 32.64861], [-117.06012, 32.64864], [-117.06347, 32.64994], [-117.06354, 32.65011]]], [[[-117.07154, 32.65622], [-117.07101, 32.65681], [-117.07124, 32.65743], [-117.07094, 32.65739], [-117.07043, 32.6573], [-117.07021, 32.65723], [-117.06993, 32.65713], [-117.06947, 32.65692], [-117.06926, 32.65679], [-117.0687, 32.65639], [-117.06832, 32.65603], [-117.06812, 32.65577], [-117.06793, 32.65544], [-117.06738, 32.65421], [-117.06718, 32.65383], [-117.06698, 32.65356], [-117.06668, 32.65324], [-117.06629, 32.65293], [-117.06481, 32.652], [-117.06455, 32.65181], [-117.06446, 32.65168], [-117.06432, 32.65142], [-117.06414, 32.65087], [-117.06388, 32.65038], [-117.06479, 32.65031], [-117.06506, 32.65042], [-117.06561, 32.65064], [-117.06591, 32.65079], [-117.06628, 32.65099], [-117.06692, 32.65139], [-117.06744, 32.65178], [-117.06745, 32.6518], [-117.06827, 32.65243], [-117.06859, 32.65271], [-117.06917, 32.65327], [-117.06943, 32.65349], [-117.0705, 32.6548], [-117.07059, 32.6551], [-117.07154, 32.65622]]], [[[-117.0657, 32.65289], [-117.06522, 32.65303], [-117.06481, 32.65234], [-117.0657, 32.65289], [-117.0657, 32.65289]]], [[[-117.07212, 32.65465], [-117.07196, 32.65454], [-117.0718, 32.65416], [-117.07175, 32.65411], [-117.07187, 32.65408], [-117.07212, 32.65465]]]]} | Open Access 1 | 537 | Sweetwater Summit Regional Park | 29259 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SweetwaterSummit.html | San Diego 4 | 517.158 | Sweetwater Summit RP | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);