Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61148 | 61148 | 85309 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 140895 | 140895 | 85310 | Olea europaea :: Olive Tree 41 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.77064078968729 | -122.442827504693 | (37.7706407896873, -122.442827504693) | |
| 113 | 113 | 183695 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.50177309900499 | (37.7612921278024, -122.501773099005) | |||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 1058 | 1058 | 19026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.78836090738071 | -122.44506178917 | (37.7883609073807, -122.44506178917) | |||
| 1301 | 1301 | 245837 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 451 Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 3 | Width 0ft | 6005362.4532 | 2110596.2894 | 37.775598372260106 | -122.424936650191 | (37.7755983722601, -122.424936650191) | ||
| 1374 | 1374 | 97285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2321 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773461 | 6003155.0 | 2116788.0 | 37.7924743139296 | -122.433015230869 | (37.7924743139296, -122.433015230869) | |
| 1539 | 1539 | 167009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3865 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 768818 | 6003858.30002 | 2105358.64848 | 37.7611320042552 | -122.42976622233 | (37.7611320042552, -122.42976622233) | |
| 1571 | 1571 | 19004 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3080X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000063.0 | 2115465.0 | 37.7886658330885 | -122.44361852594999 | (37.7886658330885, -122.44361852595) | |||
| 1711 | 1711 | 233792 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 628 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780007 | 6002673.122880001 | 2108886.30409 | 37.7707509019602 | -122.434117422087 | (37.7707509019602, -122.434117422087) | |
| 1854 | 1854 | 58389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.799846446913705 | -122.42187710853999 | (37.7998464469137, -122.42187710854) | ||
| 1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
| 2001 | 2001 | 141165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 1 | Width 0ft | 6002136.302999999 | 2113271.8343 | 37.7827619879541 | -122.436288194942 | (37.7827619879541, -122.436288194942) | ||
| 2576 | 2576 | 247475 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | 11 | Width 0ft | Permit Number 38697 | 6002266.1755 | 2109683.5253 | 37.7729167694499 | -122.435582100921 | (37.7729167694499, -122.435582100921) | |
| 2601 | 2601 | 8737 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997009.0435 | 2113012.7724 | 37.781758017625705 | -122.454007533534 | (37.7817580176257, -122.454007533534) | |||
| 2706 | 2706 | 233690 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3920 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1987 12:00:00 AM | 7 | Width 3ft | Permit Number 24467 | 6004362.33659 | 2101340.9487400004 | 37.7501288754449 | -122.427736705194 | (37.7501288754449, -122.427736705194) | |
| 2762 | 2762 | 210764 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1499 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1987 12:00:00 AM | 15 | Width 3ft | Permit Number 24541 | 5994579.33292 | 2105376.6403099997 | 37.7606515981079 | -122.46185925530001 | (37.7606515981079, -122.4618592553) | |
| 2792 | 2792 | 17890 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2237 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003209.8546 | 2115154.5824 | 37.7879924771756 | -122.432708698198 | (37.7879924771756, -122.432708698198) | |||
| 2894 | 2894 | 17961 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2501 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001809.5629 | 2114963.9325 | 37.7873894873509 | -122.437539789894 | (37.7873894873509, -122.437539789894) | |||
| 2931 | 2931 | 93638 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1603 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6000053.4052 | 2110559.6245 | 37.7751963877973 | -122.44329925092501 | (37.7751963877973, -122.443299250925) | |||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 3402 | 3402 | 253446 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1339 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 3x3 | 6002186.0 | 2113207.0 | 37.7825867929513 | -122.43611162356399 | (37.7825867929513, -122.436111623564) | |||
| 3422 | 3422 | 17740 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/04/1982 12:00:00 AM | 6 | 3X3 | 6002203.7996 | 2113272.0173 | 37.7827663252153 | -122.436054698673 | (37.7827663252153, -122.436054698673) | ||
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 3589 | 3589 | 11167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.42039071266501 | (37.805442070952, -122.420390712665) | |||
| 3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
| 3887 | 3887 | 233176 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 10 | Width 3ft | Permit Number 14045 | 5999260.53687 | 2106690.2118599997 | 37.7645267156554 | -122.445763615616 | (37.7645267156554, -122.445763615616) | |
| 4877 | 4877 | 55287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1262 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1972 12:00:00 AM | 8 | 3x3 | Permit Number 11213 | 5988342.6659 | 2106727.2678 | 37.76399904444129 | -122.483527825437 | (37.7639990444413, -122.483527825437) | |
| 4996 | 4996 | 7951 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1740 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 12 | 3X3 | 6005752.06301 | 2116078.7697900003 | 37.790673913324795 | -122.42397884754801 | (37.7906739133248, -122.423978847548) | ||
| 5042 | 5042 | 13051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163005 | -122.410595078527 | (37.803179205163, -122.410595078527) | ||
| 5329 | 5329 | 19019 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3150 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 18 | 3X3 | 5999711.09845 | 2115422.68298 | 37.788529565338 | -122.444833006162 | (37.788529565338, -122.444833006162) | |||
| 5357 | 5357 | 18911 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2608 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002198.68531 | 2115767.74163 | 37.7896186569185 | -122.436251055535 | (37.7896186569185, -122.436251055535) | |||
| 5487 | 5487 | 17190 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1804X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4X4 | 6004839.2103 | 2115093.1205 | 37.7879159889562 | -122.427067036821 | (37.7879159889562, -122.427067036821) | |||
| 5572 | 5572 | 19043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3277 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999143.513780001 | 2115295.23483 | 37.788147218565996 | -122.44678758008499 | (37.788147218566, -122.446787580085) | |||
| 5647 | 5647 | 19035 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3227 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999339.77887 | 2115319.94044 | 37.7882262635735 | -122.446110316852 | (37.7882262635735, -122.446110316852) | |||
| 5862 | 5862 | 9730 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 637 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6005783.8123 | 2111973.7899 | 37.779404445065396 | -122.42357702198099 | (37.7794044450654, -122.423577021981) | |||
| 5875 | 5875 | 19016 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3147 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999737.62232 | 2115377.53995 | 37.7884071280271 | -122.444737991858 | (37.7884071280271, -122.444737991858) | |||
| 5990 | 5990 | 17787 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1805 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1997 12:00:00 AM | 8 | 3x3 | 6005226.8193 | 2115439.913 | 37.788890105137604 | -122.425750672593 | (37.7888901051376, -122.425750672593) | ||
| 6083 | 6083 | 108032 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001036.4090599995 | 2120513.75887 | 37.802583868119896 | -122.440612955426 | (37.8025838681199, -122.440612955426) | ||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 6162 | 6162 | 35284 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 6289 | 6289 | 11171 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.805969514352604 | -122.420334179488 | (37.8059695143526, -122.420334179488) | |||
| 6472 | 6472 | 39482 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 6564 | 6564 | 17913 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2329 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002782.7895 | 2115098.9315 | 37.7878154446212 | -122.43418228549801 | (37.7878154446212, -122.434182285498) | |||
| 6602 | 6602 | 19040 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3249 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5999255.64905 | 2115310.27739 | 37.7881949266879 | -122.446400695359 | (37.7881949266879, -122.446400695359) | |||
| 6694 | 6694 | 18851 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2195 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004377.36753 | 2116024.81596 | 37.7904480629835 | -122.428731372449 | (37.7904480629835, -122.428731372449) | |||
| 6830 | 6830 | 112118 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1816 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775883 | 5999532.43444 | 2115241.7678400003 | 37.7880226220009 | -122.445438140154 | (37.7880226220009, -122.445438140154) | |
| 6960 | 6960 | 18834 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2015 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005049.74421 | 2116112.8257400002 | 37.7907277467244 | -122.426411260094 | (37.7907277467244, -122.426411260094) | |||
| 6990 | 6990 | 11166 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006897.54428 | 2121449.5194099997 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | |||
| 7014 | 7014 | 18833 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2011 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005074.81818 | 2116121.47161 | 37.7907529034619 | -122.42632512122499 | (37.7907529034619, -122.426325121225) | |||
| 7031 | 7031 | 26429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1640 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 12 | 3X3 | 6006244.692919999 | 2116200.95926 | 37.7910372151429 | -122.422283057138 | (37.7910372151429, -122.422283057138) | ||
| 7465 | 7465 | 18815 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1800X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006086.60229 | 2116306.71294 | 37.7913186696705 | -122.422837564717 | (37.7913186696705, -122.422837564717) | |||
| 7573 | 7573 | 17799 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1847 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6005086.185 | 2115415.4042 | 37.788814862037796 | -122.42623550271799 | (37.7888148620378, -122.426235502718) | |||
| 7633 | 7633 | 17741 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 6 | 3X3 | 6002204.1761 | 2113255.0755 | 37.7827198287143 | -122.436052183441 | (37.7827198287143, -122.436052183441) | |||
| 7672 | 7672 | 11164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424728999 | (37.8055622446775, -122.42024424729) | |||
| 7719 | 7719 | 19009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3087 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6000046.25088 | 2115421.62879 | 37.788545791795 | -122.44367335825001 | (37.788545791795, -122.44367335825) | |||
| 7807 | 7807 | 11165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006893.18193 | 2121482.83945 | 37.8055764872155 | -122.42041437295 | (37.8055764872155, -122.42041437295) | |||
| 8017 | 8017 | 19018 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3150 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 01/19/2011 12:00:00 AM | 3 | 3X3 | Permit Number 767112 | 5999751.82821 | 2115426.62042 | 37.78854270082589 | -122.444692371063 | (37.7885427008259, -122.444692371063) | |
| 8073 | 8073 | 108033 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001051.57629 | 2120515.71183 | 37.802590094109604 | -122.440560609499 | (37.8025900941096, -122.440560609499) | ||
| 8126 | 8126 | 2647 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1944 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004195.494 | 2115001.3607 | 37.7876276181393 | -122.42928763204901 | (37.7876276181393, -122.429287632049) | |||
| 8161 | 8161 | 18934 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2715 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001626.08114 | 2115640.1055400004 | 37.789235650952 | -122.438223055655 | (37.789235650952, -122.438223055655) | |||
| 8164 | 8164 | 17738 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 9 | 3X3 | 6002216.6 | 2113193.3325 | 37.7825510038819 | -122.43600478260001 | (37.7825510038819, -122.4360047826) | ||
| 8213 | 8213 | 18826 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6005641.1205400005 | 2116203.30526 | 37.791009592476 | -122.42437156440599 | (37.791009592476, -122.424371564406) | |||
| 8344 | 8344 | 8692 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2955 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997893.1705 | 2113031.5548 | 37.781860243466 | -122.450950238487 | (37.781860243466, -122.450950238487) | |||
| 8427 | 8427 | 19039 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3241 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999284.05701 | 2115314.75606 | 37.7882088464099 | -122.44630273130801 | (37.7882088464099, -122.446302731308) | |||
| 8511 | 8511 | 11154 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006919.78752 | 2121256.3248099997 | 37.804956035058495 | -122.420306213261 | (37.8049560350585, -122.420306213261) | |||
| 8735 | 8735 | 35281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 8736 | 8736 | 11158 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2626 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006955.38483 | 2121356.90745 | 37.8052342151411 | -122.42019016746599 | (37.8052342151411, -122.420190167466) | |||
| 8861 | 8861 | 17912 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2324 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1991 12:00:00 AM | 15 | 3X3 | 6002786.0192 | 2115147.8046 | 37.7879498210071 | -122.43417460656 | (37.7879498210071, -122.43417460656) | ||
| 8890 | 8890 | 108034 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001070.0116 | 2120518.4067 | 37.8025985432527 | -122.440497007638 | (37.8025985432527, -122.440497007638) | ||
| 8910 | 8910 | 18818 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1846 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005917.03781 | 2116283.90197 | 37.7912464676084 | -122.423422632158 | (37.7912464676084, -122.423422632158) | |||
| 8964 | 8964 | 115754 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3157 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772142 | 5999354.88302 | 2119687.6663900004 | 37.8002197429071 | -122.446372392773 | (37.8002197429071, -122.446372392773) | ||
| 8994 | 8994 | 19017 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3150 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 01/19/2011 12:00:00 AM | 3 | 3X3 | Permit Number 767112 | 5999786.663369999 | 2115431.4160700003 | 37.7885578562165 | -122.444572191968 | (37.7885578562165, -122.444572191968) | |
| 9009 | 9009 | 11172 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.80615118099271 | -122.42055467348301 | (37.8061511809927, -122.420554673483) | |||
| 9062 | 9062 | 17891 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x9 | 6003186.0915 | 2115153.6856 | 37.7879886670873 | -122.43279085011999 | (37.7879886670873, -122.43279085012) | |||
| 9077 | 9077 | 18066 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999965.0708 | 2114761.4253 | 37.786728414639505 | -122.443906774886 | (37.7867284146395, -122.443906774886) | |||
| 9087 | 9087 | 11163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | |||
| 9132 | 9132 | 11160 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | |||
| 9180 | 9180 | 9916 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1990X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005305.17759 | 2116200.067 | 37.790981725181 | -122.42553368453301 | (37.790981725181, -122.425533684533) | |||
| 9210 | 9210 | 11156 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006962.612869999 | 2121312.5054900004 | 37.80511270594771 | -122.420162000697 | (37.8051127059477, -122.420162000697) | |||
| 9242 | 9242 | 17892 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2249 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003165.9152 | 2115151.8922 | 37.7879825985405 | -122.43286052828002 | (37.7879825985405, -122.43286052828) | |||
| 9243 | 9243 | 17977 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2558 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001719.5728 | 2115004.5111 | 37.7874957889991 | -122.43785404394698 | (37.7874957889991, -122.437854043947) | |||
| 9303 | 9303 | 11157 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | |||
| 9309 | 9309 | 17899 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2279 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003065.4822 | 2115140.6832 | 37.787946124669 | -122.433207206924 | (37.787946124669, -122.433207206924) | |||
| 9323 | 9323 | 18065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999986.084 | 2114760.7686 | 37.786727810113504 | -122.443834027246 | (37.7867278101135, -122.443834027246) | |||
| 9363 | 9363 | 18821 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6005936.5128 | 2116239.67488 | 37.79112613022821 | -122.423352103743 | (37.7911261302282, -122.423352103743) | |||
| 9421 | 9421 | 18820 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1855 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005909.66344 | 2116240.6882700003 | 37.7911273973734 | -122.42344507383899 | (37.7911273973734, -122.423445073839) | |||
| 9447 | 9447 | 17825 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1924 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2000 12:00:00 AM | 3 | 3X3 | 6004489.9176 | 2115389.1759 | 37.7887091248695 | -122.42829663448299 | (37.7887091248695, -122.428296634483) | ||
| 9961 | 9961 | 54316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1324 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1972 12:00:00 AM | 5x5 | Permit Number 10077 | 5994279.15543647 | 2106492.16366383 | 37.7636972500787 | -122.46297836176001 | (37.7636972500787, -122.46297836176) | ||
| 10358 | 10358 | 37108 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981801.156 | 2106110.4328 | 37.761922478322504 | -122.506106840747 | (37.7619224783225, -122.506106840747) |
| 10463 | 10463 | 37110 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1301X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 8 | 3x3 | Permit Number 39705 | 5981797.2694 | 2106191.6975 | 37.762145379104204 | -122.506126308526 | (37.7621453791042, -122.506126308526) |
| 10545 | 10545 | 55314 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.5676900002 | 37.7182526888019 | -122.40305069543301 | (37.7182526888019, -122.403050695433) | |
| 10809 | 10809 | 15867 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5425 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5 | 5999480.671080001 | 2088101.53675 | 37.713499198913105 | -122.443666741949 | (37.7134991989131, -122.443666741949) | |||
| 10913 | 10913 | 54811 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774552 | 6009584.74153 | 2095040.5771599999 | 37.7331234617736 | -122.409232703537 | (37.7331234617736, -122.409232703537) | |
| 11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
| 11312 | 11312 | 35280 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 11618 | 11618 | 15887 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5619 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1992 12:00:00 AM | 6 | 3X3 | 5998592.6313 | 2087274.30395 | 37.71117711610329 | -122.44667662714501 | (37.7111771161033, -122.446676627145) | ||
| 11822 | 11822 | 117429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 418 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 777101 | 6000919.46363 | 2092339.69207 | 37.72521817457061 | -122.43899732339099 | (37.7252181745706, -122.438997323391) | ||
| 12051 | 12051 | 26281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1884 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2011 12:00:00 AM | 12 | 3x4 | 6000209.254369999 | 2093016.37684 | 37.7270357601912 | -122.441500974804 | (37.7270357601912, -122.441500974804) | ||
| 12214 | 12214 | 15831 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5179 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1995 12:00:00 AM | 6 | 3X3 | 6000153.213380001 | 2088921.93918 | 37.715790175057 | -122.441401035832 | (37.715790175057, -122.441401035832) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");