trees
3,709 rows where qSpecies_id = 9 sorted by DBH descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69588 | 10276 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6004948.05546 | 2109498.71961 | 37.7725612966014 | -122.426291992897 | (37.7725612966014, -122.426291992897) | 7 | 9 | 5 | 28852 | 10 | |||
| 580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
| 1196 | 41203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.464723766289 | (37.7881743948276, -122.464723766289) | 11 | 6 | 1 | 54 | 11 | ||
| 1662 | 30844 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.23439 | 37.7894135017764 | -122.447123215185 | (37.7894135017764, -122.447123215185) | 13 | 6 | 1 | 29490 | 31 | |
| 2601 | 71109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004811.8428 | 2113348.9801 | 37.7831254666613 | -122.427037449556 | (37.7831254666613, -122.427037449556) | 7 | 9 | 11 | 28858 | 41 | |||
| 3657 | 78310 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.431766435094 | (37.7202236600817, -122.431766435094) | 9 | 7 | 6 | 28861 | 5 | |||
| 4553 | 74059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015912.53475 | 2105383.55959 | 37.7618756257676 | -122.388077166837 | (37.7618756257676, -122.388077166837) | 10 | 3 | 8 | 28856 | 29 | |||
| 6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
| 6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 | |||
| 6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
| 8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
| 9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
| 13554 | 137982 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002983.8805 | 2115127.6807 | 37.7879057937101 | -122.433488604212 | (37.7879057937101, -122.433488604212) | 13 | 9 | 11 | 29490 | 27 | |||
| 13797 | 120007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5986954.13488 | 2111117.22618 | 37.7759717275571 | -122.488652969333 | (37.7759717275571, -122.488652969333) | 11 | 6 | 2 | 55 | 26 | |||
| 15315 | 137876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2002 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004300.8024 | 2115368.2774 | 37.7886410402481 | -122.428949455049 | (37.7886410402481, -122.428949455049) | 13 | 9 | 11 | 29490 | 27 | |||
| 15376 | 233816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | 8 | 2 | 9 | 28853 | 19 | |||
| 18920 | 47271 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1838 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | Permit Number 45212 | 5988771.9103 | 2105832.039 | 37.7615659640444 | -122.48197762946 | (37.7615659640444, -122.48197762946) | 1 | 8 | 3 | 56 | 35 | |
| 20376 | 55284 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11210 | 5988338.8364 | 2106796.1986 | 37.7641880866728 | -122.483546124231 | (37.7641880866728, -122.483546124231) | 1 | 8 | 3 | 56 | 35 | ||
| 20724 | 112714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008746.75593 | 2121471.08922 | 37.8056485022522 | -122.413998966505 | (37.8056485022522, -122.413998966505) | 3 | 1 | 10 | 308 | 23 | |||
| 21401 | 55292 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1275 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11218 | 5988302.8392 | 2106643.7849 | 37.763767505067 | -122.483659451396 | (37.763767505067, -122.483659451396) | 1 | 8 | 3 | 56 | 35 | ||
| 21629 | 132003 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007044.49031 | 2120339.60529 | 37.8024459822598 | -122.419809576178 | (37.8024459822598, -122.419809576178) | 5 | 1 | 1 | 28858 | 32 | |||
| 22485 | 138680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000528.3311 | 2114726.873 | 37.7866656560633 | -122.441955552688 | (37.7866656560633, -122.441955552688) | 13 | 6 | 1 | 29490 | 27 | |||
| 22556 | 233689 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3924 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003598.10122 | 2102465.60051 | 37.7531736444698 | -122.430459710273 | (37.7531736444698, -122.430459710273) | 2 | 4 | 5 | 28862 | 22 | |||
| 24745 | 141166 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1901 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002151.8704 | 2113272.5112 | 37.7827647310459 | -122.436234386856 | (37.7827647310459, -122.436234386856) | 15 | 5 | 11 | 29490 | 41 | |||
| 25908 | 132007 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2319 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007057.56905 | 2120239.89866 | 37.8021729498859 | -122.419757238308 | (37.8021729498859, -122.419757238308) | 5 | 1 | 1 | 28858 | 32 | |||
| 26288 | 124398 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3920 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5995972.08379 | 2115555.35439 | 37.7886797552779 | -122.457778943801 | (37.7886797552779, -122.457778943801) | 11 | 6 | 1 | 54 | 31 | |||
| 26445 | 138269 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 106 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997877.2646 | 2112995.6821 | 37.7817608358344 | -122.451002677666 | (37.7817608358344, -122.451002677666) | 15 | 6 | 2 | 54 | 16 | |||
| 26938 | 210843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Malta Dr | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999589.7002 | 2096031.76487 | 37.735279994668 | -122.443859307484 | (37.735279994668, -122.443859307484) | 9 | 7 | 4 | 63 | 40 | |||
| 28997 | 232995 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 117 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999304.36377 | 2107674.97359 | 37.7672331264423 | -122.445682853789 | (37.7672331264423, -122.445682853789) | 15 | 5 | 5 | 29492 | 9 | |||
| 30256 | 244184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 420 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998450.8539 | 2109035.7965 | 37.7709208329229 | -122.448733033218 | (37.7709208329229, -122.448733033218) | 15 | 5 | 11 | 29492 | 9 | |||
| 32507 | 194124 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 32965 | 131910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2435 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000745.64312 | 2116710.09379 | 37.7921234459845 | -122.441346062983 | (37.7921234459845, -122.441346062983) | 13 | 6 | 1 | 29490 | 27 | |||
| 34303 | 137821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2260 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003077.7361 | 2115191.2965 | 37.7880857910494 | -122.433168428468 | (37.7880857910494, -122.433168428468) | 13 | 9 | 1 | 29490 | 27 | |||
| 37488 | 55314 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.56769 | 37.7182526888019 | -122.403050695433 | (37.7182526888019, -122.403050695433) | 10 | 7 | 8 | 309 | 39 | |
| 39257 | 249461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 6 | : | Tree | Private 2 | 9 | Width 4ft | 6006433.55883 | 2113714.71473 | 37.7842212533479 | -122.42145294241 | (37.7842212533479, -122.42145294241) | 7 | 9 | 11 | 28858 | 41 | |||
| 40549 | 131815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 149 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 9 | Width 6ft | Permit Number 49255 | 6001582.80517 | 2120278.3225 | 37.8019685213769 | -122.438705274832 | (37.8019685213769, -122.438705274832) | 13 | 9 | 1 | 57 | 17 | |
| 42854 | 143547 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2237 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002257.1503 | 2118430.5182 | 37.796933274228 | -122.436239411972 | (37.796933274228, -122.436239411972) | 13 | 9 | 1 | 57 | 17 | |||
| 43667 | 233037 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 777 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009341.05007 | 2104563.63972 | 37.7592580365599 | -122.410747521583 | (37.7592580365599, -122.410747521583) | 2 | 4 | 7 | 28859 | 19 | |||
| 44085 | 210870 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 212 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999295.84734 | 2094097.25907 | 37.7299515304243 | -122.444736256183 | (37.7299515304243, -122.444736256183) | 9 | 7 | 4 | 28861 | 40 | |||
| 44527 | 55280 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1230 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11206 | 5988336.5387 | 2106915.6786 | 37.7645160123234 | -122.483562831314 | (37.7645160123234, -122.483562831314) | 1 | 8 | 3 | 56 | 35 | ||
| 46001 | 56374 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 276 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1973 12:00:00 AM | 9 | Permit Number 12521 | 5991863.56559 | 2113618.18062 | 37.7831239276563 | -122.471852439759 | (37.7831239276563, -122.471852439759) | 11 | 6 | 2 | 54 | 11 | ||
| 51422 | 56856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 183 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1974 12:00:00 AM | 9 | Permit Number 14091 | 6004494.0708 | 2092341.66065 | 37.7254263199646 | -122.426640399257 | (37.7254263199646, -122.426640399257) | 9 | 7 | 6 | 28861 | 5 | ||
| 54432 | 55288 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11214 | 5988299.0097 | 2106694.3342 | 37.7639060767139 | -122.483676402691 | (37.7639060767139, -122.483676402691) | 1 | 8 | 3 | 56 | 35 | ||
| 54593 | 42838 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 9 | Permit Number 46993 | 6005865.07874 | 2120365.99295 | 37.8024519240748 | -122.423892805814 | (37.8024519240748, -122.423892805814) | 5 | 9 | 1 | 28858 | 32 | |
| 56662 | 55281 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1235 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11207 | 5988295.1802 | 2106895.7653 | 37.7644589284875 | -122.483704417245 | (37.7644589284875, -122.483704417245) | 1 | 8 | 3 | 56 | 35 | ||
| 58714 | 178008 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1138 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008249.79962 | 2092133.89794 | 37.7250674643815 | -122.413642453662 | (37.7250674643815, -122.413642453662) | 9 | 3 | 7 | 309 | 28 | |||
| 59839 | 12445 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2001X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 9 | 3X3 | 6004358.0388014 | 2115316.8218262 | 37.788502995764 | -122.428747755973 | (37.788502995764, -122.428747755973) | 13 | 9 | 11 | 29490 | 27 | ||
| 60781 | 177994 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 207 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004174.28367 | 2092306.43033 | 37.7253115008013 | -122.427743365587 | (37.7253115008013, -122.427743365587) | 9 | 7 | 6 | 28861 | 5 | |||
| 61543 | 66571 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 269 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1991 12:00:00 AM | 9 | Permit Number 29760 | 6002938.60911 | 2091863.04833 | 37.7240240961129 | -122.431983324585 | (37.7240240961129, -122.431983324585) | 9 | 7 | 6 | 28861 | 5 | |
| 63497 | 177892 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010348.87494 | 2088600.69344 | 37.7154836618219 | -122.406137331491 | (37.7154836618219, -122.406137331491) | 9 | 7 | 8 | 309 | 39 | |||
| 65510 | 181755 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1243 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5988296.712 | 2106832.1958 | 37.7642844732055 | -122.483694458087 | (37.7642844732055, -122.483694458087) | 1 | 8 | 3 | 56 | 35 | |||
| 66034 | 138653 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1706 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000601.2331 | 2114539.1356 | 37.7861543317081 | -122.441689851832 | (37.7861543317081, -122.441689851832) | 13 | 6 | 1 | 29490 | 27 | |||
| 66379 | 117843 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620x 39th Ave | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.7769499228703 | -122.499560036853 | (37.7769499228703, -122.499560036853) | 11 | 6 | 2 | 55 | 26 | |||
| 66824 | 137983 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2281 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003005.4018 | 2115130.8192 | 37.7879156322374 | -122.433414368883 | (37.7879156322374, -122.433414368883) | 13 | 9 | 11 | 29490 | 27 | |||
| 67408 | 233046 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 757 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007361.12284 | 2102791.47671 | 37.7542808726837 | -122.417469488925 | (37.7542808726837, -122.417469488925) | 2 | 4 | 7 | 28859 | 19 | |||
| 67638 | 107486 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1306x Montgomery St | 8 | Median : Cutout | Tree | DPW 1 | 9 | 6011455.57226 | 2119886.90358 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | 3 | 1 | 10 | 308 | 23 | ||||
| 70714 | 9169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6037 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1998 12:00:00 AM | 9 | 3X3 | 5988226.75232 | 2112484.22581 | 37.7797993055455 | -122.484350989435 | (37.7797993055455, -122.484350989435) | 11 | 6 | 2 | 55 | 26 | ||
| 72187 | 131878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3342 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003707.99232 | 2120258.0938 | 37.802033648495 | -122.431349682064 | (37.802033648495, -122.431349682064) | 13 | 9 | 1 | 57 | 17 | |||
| 74055 | 232975 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4754 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998394.78855 | 2105689.271 | 37.7617289148913 | -122.448685893351 | (37.7617289148913, -122.448685893351) | 15 | 5 | 11 | 29492 | 9 | |||
| 74208 | 232443 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1379 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010363.00865 | 2101291.1462 | 37.7503297444393 | -122.406982420796 | (37.7503297444393, -122.406982420796) | 10 | 4 | 7 | 28859 | 19 | |||
| 74484 | 131876 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3533 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002622.90791 | 2120765.83314 | 37.8033662126461 | -122.435140921623 | (37.8033662126461, -122.435140921623) | 13 | 9 | 1 | 57 | 17 | |||
| 77369 | 232974 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4706 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998602.45672 | 2105699.18317 | 37.7617680039086 | -122.447968369271 | (37.7617680039086, -122.447968369271) | 15 | 5 | 11 | 29492 | 9 | |||
| 80353 | 39179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1050 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | 9 | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | ||
| 80493 | 117751 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 415 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5983734.82883 | 2113014.83015 | 37.7809936100018 | -122.499929513006 | (37.7809936100018, -122.499929513006) | 11 | 6 | 2 | 55 | 26 | |||
| 83062 | 244185 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 420 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998449.1449 | 2109054.1682 | 37.7709711791941 | -122.44874026813 | (37.7709711791941, -122.44874026813) | 15 | 5 | 11 | 29492 | 9 | |||
| 89198 | 177951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989499.70601 | 2089731.63068 | 37.7174007160611 | -122.478283234789 | (37.7174007160611, -122.478283234789) | 1 | 8 | 4 | 64 | 14 | ||||
| 90439 | 43683 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 675 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 9 | Permit Number 43326 | 5994390.52222 | 2110930.65455 | 37.7758905913229 | -122.462915215949 | (37.7758905913229, -122.462915215949) | 11 | 6 | 2 | 54 | 11 | |
| 91555 | 132001 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2347 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007030.81172 | 2120464.56032 | 37.8027883065064 | -122.419865782891 | (37.8027883065064, -122.419865782891) | 5 | 1 | 1 | 28858 | 32 | |||
| 94721 | 249455 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 251 Olive St | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6006189.18478 | 2113676.83316 | 37.7841034583637 | -122.422295698907 | (37.7841034583637, -122.422295698907) | 7 | 9 | 11 | 28858 | 41 | |||
| 97072 | 233179 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1072 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998990.94366 | 2106256.22808 | 37.7633197085617 | -122.446664834323 | (37.7633197085617, -122.446664834323) | 15 | 5 | 5 | 29492 | 9 | |||
| 97133 | 34572 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3201 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 9 | Permit Number 38280 | 5999335.02954 | 2115649.99979 | 37.7891322487085 | -122.446150499455 | (37.7891322487085, -122.446150499455) | 13 | 6 | 1 | 29490 | 31 | |
| 97395 | 43766 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 509 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 9 | Permit Number 43401 | 5990292.13661 | 2111875.33871 | 37.7782475171318 | -122.477161485772 | (37.7782475171318, -122.477161485772) | 11 | 6 | 2 | 55 | 26 | |
| 98140 | 210845 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Valletta Ct | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999377.40008 | 2096424.41723 | 37.7363460132462 | -122.444621517096 | (37.7363460132462, -122.444621517096) | 9 | 7 | 4 | 63 | 40 | |||
| 98141 | 233754 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 110 Henry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002776.62076 | 2107408.30998 | 37.766698565817 | -122.433653773929 | (37.766698565817, -122.433653773929) | 15 | 5 | 5 | 28862 | 3 | |||
| 99553 | 117905 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 541 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5983767.17374 | 2112125.62524 | 37.7785540103948 | -122.499751875651 | (37.7785540103948, -122.499751875651) | 11 | 6 | 2 | 55 | 26 | |||
| 99851 | 232939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 73 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004724.27638 | 2103277.1719 | 37.7554657600427 | -122.426622955994 | (37.7554657600427, -122.426622955994) | 2 | 4 | 5 | 28862 | 22 | |||
| 102139 | 55290 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1271 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11216 | 5988300.5415 | 2106665.996 | 37.7638283569297 | -122.483669026901 | (37.7638283569297, -122.483669026901) | 1 | 8 | 3 | 56 | 35 | ||
| 103954 | 232878 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2700 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009790.52018 | 2105038.73437 | 37.7605877300581 | -122.409226555764 | (37.7605877300581, -122.409226555764) | 2 | 4 | 8 | 28859 | 19 | |||
| 105594 | 119527 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 870 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5986372.79965 | 2109977.40457 | 37.7728081591982 | -122.49058005324 | (37.7728081591982, -122.49058005324) | 11 | 6 | 2 | 55 | 26 | |||
| 105926 | 233233 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 6 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6010125.25157 | 2099665.50304 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | 2 | 7 | 7 | 28859 | 2 | |||
| 106646 | 182105 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2438 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5987689.5839 | 2098673.5022 | 37.7418475402235 | -122.485195639792 | (37.7418475402235, -122.485195639792) | 1 | 8 | 3 | 29491 | 35 | |||
| 108283 | 139530 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 9 | Width 0ft | 6001148.4033 | 2113139.6515 | 37.7823428677529 | -122.439696423108 | (37.7823428677529, -122.439696423108) | 15 | 5 | 11 | 29490 | 41 | ||
| 108853 | 194125 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 110358 | 140807 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 624 EUCLID AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996369.4263 | 2113851.7201 | 37.7840248500046 | -122.456280974484 | (37.7840248500046, -122.456280974484) | 11 | 6 | 1 | 54 | 31 | |||
| 112151 | 233823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006554.92333 | 2109652.21468 | 37.7730734542033 | -122.420744560833 | (37.7730734542033, -122.420744560833) | 8 | 2 | 9 | 28853 | 19 | |||
| 113057 | 138652 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1706 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000605.718 | 2114521.4425 | 37.786106006561 | -122.441673065091 | (37.786106006561, -122.441673065091) | 13 | 6 | 1 | 29490 | 27 | |||
| 113169 | 233194 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 799 Moultrie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007614.26336 | 2095795.04812 | 37.7350844820538 | -122.416098605579 | (37.7350844820538, -122.416098605579) | 2 | 7 | 7 | 28859 | 2 | |||
| 114428 | 58181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1978 12:00:00 AM | 9 | Permit Number 17168 | 6001356.0678 | 2110442.473 | 37.774948915828 | -122.438784660446 | (37.774948915828, -122.438784660446) | 15 | 5 | 11 | 29492 | 10 | ||
| 114969 | 210848 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 32 Valletta Ct | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999386.30682 | 2096667.25376 | 37.7370132931151 | -122.444608171155 | (37.7370132931151, -122.444608171155) | 9 | 7 | 4 | 63 | 40 | |||
| 121108 | 131898 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3201 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999380.24479 | 2115656.41877 | 37.789152455558 | -122.445994522828 | (37.789152455558, -122.445994522828) | 13 | 6 | 1 | 29490 | 31 | |||
| 122282 | 31100 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 23 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34830 | 6000065.10853 | 2093953.30855 | 37.7296001446305 | -122.442066507168 | (37.7296001446305, -122.442066507168) | 9 | 7 | 4 | 63 | 40 | |
| 123491 | 210688 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 658 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997050.66527 | 2094425.23588 | 37.7307236964431 | -122.452521738406 | (37.7307236964431, -122.452521738406) | 9 | 7 | 4 | 59 | 40 | |||
| 124245 | 233619 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2979 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008989.13692 | 2102723.3885 | 37.7541853853744 | -122.411834574418 | (37.7541853853744, -122.411834574418) | 2 | 4 | 7 | 28859 | 19 | |||
| 125924 | 37619 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 522 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 9 | Permit Number 45363 | 5990650.98195 | 2111800.44887 | 37.7780627029466 | -122.475914650197 | (37.7780627029466, -122.475914650197) | 11 | 6 | 2 | 54 | 26 | |
| 130142 | 251021 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991446.6722 | 2112660.0459 | 37.7804690230051 | -122.473224806894 | (37.7804690230051, -122.473224806894) | 11 | 6 | 2 | 54 | 26 | |||
| 130352 | 140819 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 EUCLID AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996475.0139 | 2113856.7964 | 37.7840448488164 | -122.455916049047 | (37.7840448488164, -122.455916049047) | 11 | 6 | 1 | 54 | 31 | |||
| 132947 | 233815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006685.92768 | 2109625.99474 | 37.7730088433182 | -122.420289538034 | (37.7730088433182, -122.420289538034) | 8 | 2 | 9 | 28853 | 19 | |||
| 134390 | 233605 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 12 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.7458082310637 | -122.407697037414 | (37.7458082310637, -122.407697037414) | 2 | 7 | 7 | 28859 | 2 | |||
| 135208 | 249462 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 201 Olive St | 7 | : | Tree | Private 2 | 9 | Width 4ft | 6006460.85988 | 2113718.34687 | 37.784232765583 | -122.421358748315 | (37.784232765583, -122.421358748315) | 7 | 9 | 11 | 28858 | 41 | |||
| 136024 | 131995 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2428 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007056.74589 | 2120622.73753 | 37.8032240819872 | -122.419787267564 | (37.8032240819872, -122.419787267564) | 5 | 1 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );