trees
614 rows where qSpecies_id = 29 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
76954 | 214036 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 262 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992219.26388 | 2089623.39625 | 37.7172610279406 | -122.46887519663 | (37.7172610279406, -122.46887519663) | 9 | 8 | 6 | 64 | 24 | |||
132582 | 240413 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 2 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.7569141478938 | -122.442632304847 | (37.7569141478938, -122.442632304847) | 2 | 4 | 5 | 28862 | 3 | ||
147638 | 197338 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 501 Amador St | 9 | : | Tree | Private 2 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.7459188288093 | -122.381878129198 | (37.7459188288093, -122.381878129198) | 10 | 3 | 8 | 58 | 1 | |||
150531 | 247182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Buena Vista Ave East | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6001135.9574 | 2108807.3946 | 37.7704468753543 | -122.439428836098 | (37.7704468753543, -122.439428836098) | 15 | 5 | 11 | 29492 | 9 | |||
157185 | 197337 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 501 Amador St | 8 | : | Tree | Private 2 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | 10 | 3 | 8 | 58 | 1 | |||
8833 | 240424 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 6 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.433987315365 | (37.7363966594644, -122.433987315365) | 2 | 7 | 5 | 63 | 7 | |||
31447 | 240421 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002440.89213 | 2096392.57557 | 37.7364329192297 | -122.434027483591 | (37.7364329192297, -122.434027483591) | 2 | 7 | 5 | 63 | 7 | |||
58215 | 240423 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002449.92079 | 2096381.92143 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | 2 | 7 | 5 | 63 | 7 | |||
60862 | 240422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 4 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.434020937432 | (37.7364241292793, -122.434020937432) | 2 | 7 | 5 | 63 | 7 | |||
168828 | 240425 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 7 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002456.87513 | 2096374.31689 | 37.7363836921523 | -122.433970918943 | (37.7363836921523, -122.433970918943) | 2 | 7 | 5 | 63 | 7 | |||
123102 | 87075 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 6 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
141663 | 87074 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 395 Byxbee St | 5 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
58114 | 197341 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | 10 | 3 | 8 | 58 | 1 | ||||
68958 | 246759 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | 2 | 7 | 7 | 28859 | 2 | ||||
80550 | 246767 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6009322.26711 | 2098890.11567 | 37.7436787515713 | -122.410411873024 | (37.7436787515713, -122.410411873024) | 2 | 7 | 7 | 28859 | 2 | ||||
101615 | 240382 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200 Kingston St | 14 | Front Yard : Yard | Tree | Private 2 | 2 | 6006224.51109 | 2098080.7337 | 37.7412822264814 | -122.4210657258 | (37.7412822264814, -122.4210657258) | 2 | 7 | 7 | 28859 | 2 | ||||
105507 | 197339 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6016827.1128 | 2099574.92506 | 37.7459769564893 | -122.384509368331 | (37.7459769564893, -122.384509368331) | 10 | 3 | 8 | 58 | 1 | ||||
145642 | 246638 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3320 Harrison St | 9 | Front Yard : Yard | Tree | Private 2 | 20 | 6009023.34848 | 2099240.78509 | 37.7446248509555 | -122.411470234758 | (37.7446248509555, -122.411470234758) | 2 | 7 | 7 | 28859 | 2 | ||||
156224 | 197340 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6016813.36643 | 2099575.53369 | 37.7459778674902 | -122.384556944272 | (37.7459778674902, -122.384556944272) | 10 | 3 | 8 | 58 | 1 | ||||
190698 | 136321 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | 3 | 1 | 10 | 308 | 23 | ||||
193221 | 246761 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 5 | Front Yard : Yard | Tree | Private 2 | 16 | 6009235.42267 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | 2 | 7 | 7 | 28859 | 2 | ||||
89675 | 23598 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200X Vasquez Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
142099 | 23599 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200X Vasquez Ave | 9 | Median : Cutout | Tree | DPW 1 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
163298 | 117837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 660x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5983820.01458 | 2111273.23439 | 37.7762166927907 | -122.499506071449 | (37.7762166927907, -122.499506071449) | 11 | 6 | 2 | 55 | 26 | |||
181144 | 13408 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 364 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.7389906787724 | -122.443712833155 | (37.7389906787724, -122.443712833155) | 9 | 7 | 4 | 59 | 40 | |||
33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
77469 | 248239 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 298 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | 2 | 7 | 7 | 28859 | 2 | ||||
78352 | 247984 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009751.76686 | 2099644.86409 | 37.7457751935767 | -122.408980002136 | (37.7457751935767, -122.408980002136) | 2 | 7 | 7 | 28859 | 2 | ||||
120646 | 247983 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 8 | 6009757.51939 | 2099637.18115 | 37.7457544201473 | -122.408959568646 | (37.7457544201473, -122.408959568646) | 2 | 7 | 7 | 28859 | 2 | ||||
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
799 | 72078 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | 11 | 6 | 2 | 55 | 26 | ||
1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
2407 | 38882 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | 11 | 6 | 1 | 54 | 31 | ||
2638 | 32596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1474 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.7596132973579 | -122.492881221287 | (37.7596132973579, -122.492881221287) | 1 | 8 | 3 | 56 | 35 | |
2740 | 74867 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | 11 | 6 | 1 | 54 | 31 | |||
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
3428 | 37647 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | 11 | 6 | 2 | 54 | 11 | ||
3822 | 74719 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997437.82689 | 2116041.06971 | 37.7900974955643 | -122.452742784551 | (37.7900974955643, -122.452742784551) | 11 | 6 | 1 | 54 | 31 | |||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
6569 | 82802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | 11 | 6 | 2 | 55 | 26 | ||
7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
10754 | 41218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431 | (37.8011293999489, -122.43745640431) | 13 | 9 | 1 | 57 | 17 | |
11342 | 141053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.7818900483272 | -122.45414629098 | (37.7818900483272, -122.45414629098) | 11 | 6 | 1 | 54 | 31 | ||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
12126 | 184960 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1990 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | 1 | 8 | 3 | 29491 | 35 | |||
12169 | 70387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003118.96111 | 2094567.61018 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | 9 | 7 | 5 | 28861 | 25 | |||
12537 | 54837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.7743590132093 | -122.447906287477 | (37.7743590132093, -122.447906287477) | 15 | 5 | 11 | 29492 | 16 | |
12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
13360 | 75003 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997399.30482 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | 11 | 6 | 1 | 54 | 31 | |||
13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
13949 | 70219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999766.96115 | 2119470.28489 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | 13 | 9 | 1 | 57 | 17 | |||
13999 | 73403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003121.92331 | 2094558.5911 | 37.7314358416937 | -122.43154198317 | (37.7314358416937, -122.43154198317) | 9 | 7 | 5 | 28861 | 25 | |||
14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
15577 | 61446 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2020 12:00:00 AM | 3 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | 11 | 6 | 2 | 55 | 26 | |
15621 | 68830 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32781 | 6000000.33338592 | 2094041.19205625 | 37.7298377607142 | -122.442296747396 | (37.7298377607142, -122.442296747396) | 9 | 7 | 4 | 63 | 40 | ||
15733 | 64781 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | 4 | Permit Number 25773 | 5983728.64713 | 2111021.26009 | 37.7755194830569 | -122.499803502734 | (37.7755194830569, -122.499803502734) | 11 | 6 | 2 | 55 | 26 | |
16030 | 72309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3555 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997281.41005 | 2116017.68654 | 37.7900243276015 | -122.453282282457 | (37.7900243276015, -122.453282282457) | 11 | 6 | 1 | 54 | 31 | |||
16441 | 32611 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | 1 | 8 | 3 | 56 | 35 | |
16645 | 74566 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | 11 | 6 | 1 | 54 | 31 | |||
16909 | 38635 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
18659 | 68867 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 32831 | 5999260.75597787 | 2093758.61799029 | 37.7290196985316 | -122.444833238065 | (37.7290196985316, -122.444833238065) | 9 | 7 | 4 | 28861 | 40 | ||
18662 | 72377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | 11 | 6 | 2 | 55 | 26 | |||
19085 | 70121 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988662.20068 | 2110577.24438 | 37.7745886129839 | -122.482704814222 | (37.7745886129839, -122.482704814222) | 11 | 6 | 2 | 55 | 26 | |||
20030 | 81327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | 13 | 9 | 1 | 57 | 17 | |
20270 | 41769 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
20719 | 32859 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
20853 | 33056 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
21474 | 183295 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.7629688694519 | -122.506035915679 | (37.7629688694519, -122.506035915679) | 1 | 8 | 3 | 56 | 35 | |||
21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
21743 | 9330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.5022559 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | 2 | 7 | 5 | 63 | 7 | ||
21889 | 240418 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001776.14511 | 2096508.83113 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | 2 | 7 | 5 | 63 | 7 | |||
22308 | 33551 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.7400478987016 | -122.418202822848 | (37.7400478987016, -122.418202822848) | 2 | 7 | 7 | 28859 | 2 | |||
22588 | 44207 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 701 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2000 12:00:00 AM | Permit Number 43655 | 6009221.06713893 | 2115299.96241651 | 37.7887307349007 | -122.411921176175 | (37.7887307349007, -122.411921176175) | 5 | 1 | 10 | 28852 | 21 | ||
23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
24081 | 118563 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.505243048821 | (37.7792296683273, -122.505243048821) | 11 | 6 | 2 | 55 | 26 | |||
24228 | 48907 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
24465 | 48904 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
25363 | 32597 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | 1 | 8 | 3 | 56 | 35 | |
25866 | 32518 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | 2 | 7 | 7 | 28859 | 2 | |
26259 | 217579 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.7143464128453 | -122.468610110073 | (37.7143464128453, -122.468610110073) | 9 | 8 | 6 | 64 | 24 | |||
26389 | 87804 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841 | 2117073 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | 13 | 9 | 1 | 28858 | 27 |
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) );