trees

4,014 rows where qSpecies_id = 40 sorted by qAddress

✎ View and edit SQL

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)
78840 136001 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1043 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009476.76834 2116835.36375 37.7929609171614 -122.411144983273 (37.7929609171614, -122.411144983273) 3 1 10 28857 21
100186 135999 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1043 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009475.36486 2116853.62807 37.7930109878303 -122.411151130141 (37.7930109878303, -122.411151130141) 3 1 10 28857 21
130066 136003 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1043 Mason St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009481.94772 2116801.23595 37.7928675009884 -122.411124650506 (37.7928675009884, -122.411124650506) 3 1 10 28857 21
1895 73501 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
45395 239378 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001967.26718 2100937.20425 37.7488845150303 -122.435990095661 (37.7488845150303, -122.435990095661) 2 4 5 28862 22
48542 239379 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001966.9971 2100951.66639 37.7489242092946 -122.435992064299 (37.7489242092946, -122.435992064299) 2 4 5 28862 22
94372 71983 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
125693 239381 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001965.34817 2100982.03085 37.7490074892259 -122.43599993875 (37.7490074892259, -122.43599993875) 2 4 5 28862 22
132287 239380 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001965.88505 2100966.71291 37.7489654602953 -122.435996986282 (37.7489654602953, -122.435996986282) 2 4 5 28862 22
180579 70987 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1045 Diamond St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.7492053706113 -122.436016109621 (37.7492053706113, -122.436016109621) 2 4 5 28862 22
44685 121562 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1046 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003754 2102204 37.7524641810183 -122.429901922615 (37.7524641810183, -122.429901922615) 2 4 5 28862 22
139963 237123 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1049 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6008643.89723 2102440.90127 37.7533903648753 -122.413008530528 (37.7533903648753, -122.413008530528) 2 4 7 28859 19
99889 107954 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999967.5 2105076.1 37.7601351040878 -122.443202492583 (37.7601351040878, -122.443202492583) 2 4 5 28862 3
151241 107953 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999967.5 2105076.1 37.7601351040878 -122.443202492583 (37.7601351040878, -122.443202492583) 2 4 5 28862 3
157509 81336 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999938.45094538 2105136.44437451 37.760299138392 -122.443307293466 (37.760299138392, -122.443307293466) 2 4 5 28862 3
194451 238323 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194455 238321 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
194458 238322 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5999967 2105076 37.7601348010019 -122.443204214657 (37.7601348010019, -122.443204214657) 2 4 5 28862 3
51869 179090 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004283.33861 2092987.68869 37.7271882537103 -122.427414882796 (37.7271882537103, -122.427414882796) 9 7 6 28861 5
116834 179091 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6004289.65055 2092997.26304 37.7272148997398 -122.42739374423 (37.7272148997398, -122.42739374423) 9 7 6 28861 5
14257 238498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003477.34326 2097803.5179 37.7403658101453 -122.430544682709 (37.7403658101453, -122.430544682709) 2 7 5 63 7
36583 47700 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45497 6003509.82655426 2097791.42406059 37.7403344433628 -122.430431505695 (37.7403344433628, -122.430431505695) 2 7 5 63 7
81439 47701 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45497 6003509.82655426 2097791.42406059 37.7403344433628 -122.430431505695 (37.7403344433628, -122.430431505695) 2 7 5 63 7
142684 238499 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6003467.41472 2097812.46812 37.7403898229362 -122.430579650144 (37.7403898229362, -122.430579650144) 2 7 5 63 7
137202 237129 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1050 York St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009970.37435 2102983.71181 37.7549551744519 -122.408459559056 (37.7549551744519, -122.408459559056) 2 4 7 28859 19
19149 65479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1051 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/13/1989 12:00:00 AM 10 3x3 Permit Number 28361 6008468.49788 2115537.43749 37.7893405334878 -122.414541776599 (37.7893405334878, -122.414541776599) 5 1 10 28858 21
42949 53899 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1057 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2009 12:00:00 AM     Permit Number 52970 6011224.04910165 2089865.72837227 37.7190061040508 -122.403201256455 (37.7190061040508, -122.403201256455) 10 7 8 309 28
70689 94959 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1059 Evans Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/09/2010 12:00:00 AM       6018613.9 2096078.3 37.7364745658864 -122.378088153142 (37.7364745658864, -122.378088153142) 10 3 8 58 1
153849 214715 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Aptos Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993029.00008 2094275.40431 37.7300810552916 -122.466414259408 (37.7300810552916, -122.466414259408) 9 8 4 59 40
154046 214714 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Aptos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5993036.39091 2094292.88561 37.7301294810876 -122.466389978617 (37.7301294810876, -122.466389978617) 9 8 4 59 40
23510 237298 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008651.85996 2097990.76516 37.7411717277045 -122.412666422143 (37.7411717277045, -122.412666422143) 10 7 7 28859 2
190291 213522 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995639.49669 2093392.93286 37.7278082877035 -122.457325684754 (37.7278082877035, -122.457325684754) 9 7 4 28861 40
62401 239532 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106 Wool St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007362.80754 2097682.06201 37.7402516645702 -122.417101646438 (37.7402516645702, -122.417101646438) 2 7 7 28859 2
102083 237376 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1065 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009202.55158 2102951.75524 37.7548243995487 -122.411112660742 (37.7548243995487, -122.411112660742) 2 4 7 28859 19
162470 109069 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1065 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772763 6002105.57012 2087176.80573 37.7111094529054 -122.434528092094 (37.7111094529054, -122.434528092094) 9 7 6 28861 5
94442 103875 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106X Austin St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006702.4202 2115509.69435 37.7891649813311 -122.42065024171 (37.7891649813311, -122.42065024171) 13 9 10 28858 21
113233 103761 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106X Austin St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2009 12:00:00 AM 3 3x3   6006685.57502 2115508.13748 37.7891597571573 -122.420708413481 (37.7891597571573, -122.420708413481) 13 9 10 28858 21
124856 103876 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 106X Austin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2009 12:00:00 AM 3 3x3   6006716.01893 2115511.31786 37.7891702054911 -122.420603306998 (37.7891702054911, -122.420603306998) 13 9 10 28858 21
38903 238286 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 107 Collingwood St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002042.41083 2105231.1567 37.7606789473897 -122.436037470178 (37.7606789473897, -122.436037470178) 2 4 5 28862 3
48785 238285 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 107 Collingwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002043.60824 2105208.24435 37.7606161036621 -122.43603168931 (37.7606161036621, -122.43603168931) 2 4 5 28862 3
92174 238284 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 107 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002049.03443 2105187.74161 37.7605601163763 -122.43601145548 (37.7605601163763, -122.43601145548) 2 4 5 28862 3
117391 214752 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 107 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5995609.08348 2093408.98072 37.7278506044138 -122.457431983704 (37.7278506044138, -122.457431983704) 9 7 4 28861 40
126218 214753 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 107 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5995611.1547 2093431.54917 37.7279126909161 -122.457426455583 (37.7279126909161, -122.457426455583) 9 7 4 28861 40
148622 238104 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1070 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007407.26502 2101103.92406 37.7496498326723 -122.417190343875 (37.7496498326723, -122.417190343875) 2 4 7 28859 19
171978 238103 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1070 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007408.1692 2101126.19654 37.7497110387337 -122.417188795221 (37.7497110387337, -122.417188795221) 2 4 7 28859 19
95382 237375 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1071 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009203.81222 2102937.13478 37.7547843257492 -122.411107268413 (37.7547843257492, -122.411107268413) 2 4 7 28859 19
42220 23053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1074 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/16/1992 12:00:00 AM 18 3X3   6006318.63458 2103360.59062 37.7557848161263 -122.421115089604 (37.7557848161263, -122.421115089604) 2 4 5 28859 19
153903 69395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1075 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 4   Permit Number 33499 6002066.46838 2087158.9447 37.7110581906667 -122.434661960708 (37.7110581906667, -122.434661960708) 9 7 6 28861 5
156328 59606 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1077 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/1981 12:00:00 AM 1 3x3 Permit Number 19007 6015566.4484 2104073.99726 37.7582606677124 -122.389182708811 (37.7582606677124, -122.389182708811) 10 3 8 28856 29
42441 40646 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 108 Congdon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1999 12:00:00 AM 9   Permit Number 41644 6004664.10426 2094195.33475 37.7305257097718 -122.426184517611 (37.7305257097718, -122.426184517611) 9 7 6 28861 5
19599 237076 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 108 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6005382.34798 2103034.44526 37.7548364711386 -122.424329877219 (37.7548364711386, -122.424329877219) 2 4 5 28859 19
33059 213468 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 108 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992714.16407 2098359.03254 37.7412755040554 -122.467799567899 (37.7412755040554, -122.467799567899) 1 8 4 59 40
117597 50098 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 108 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2009 12:00:00 AM   3x3 Permit Number 52733 5992719.49980491 2098392.60521716 37.7413679942307 -122.467783560141 (37.7413679942307, -122.467783560141) 1 8 4 59 40
63322 238105 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007413.86858 2101032.90286 37.7494551960109 -122.41716247657 (37.7494551960109, -122.41716247657) 2 4 7 28859 19
2388 237117 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6005704.96367 2102692.93709 37.7539169809013 -122.423189907394 (37.7539169809013, -122.423189907394) 2 4 5 28859 19
61092 10178 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/29/2001 12:00:00 AM 16 2X2   6005705.19862 2102704.3683 37.7539483816144 -122.423189907382 (37.7539483816144, -122.423189907382) 2 4 5 28859 19
62451 91030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1086 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6009941.213427 2111462.810786 37.7782352043229 -122.409158690819 (37.7782352043229, -122.409158690819) 14 2 9 28853 34
88087 237229 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5998076.18756 2106198.82247 37.7631097915092 -122.449824524095 (37.7631097915092, -122.449824524095) 15 5 11 29492 9
28169 213311 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 1 : Tree Private 2     4 Width 3ft   5997282.73831 2089151.44786 37.7162564078821 -122.451339215357 (37.7162564078821, -122.451339215357) 9 8 6 28861 24
104247 213314 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 4 : Tree Private 2     5 Width 3ft   5997314.23204 2089197.70588 37.7163852249758 -122.451233692506 (37.7163852249758, -122.451233692506) 9 8 6 28861 24
171186 213312 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 2 : Tree Private 2     4 Width 3ft   5997293.25449 2089167.74263 37.7163017516982 -122.451304041065 (37.7163017516982, -122.451304041065) 9 8 6 28861 24
175641 213313 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 109 Caine Ave 3 : Tree Private 2     5 Width 3ft   5997305.30098 2089185.13122 37.7163501865023 -122.451263656101 (37.7163501865023, -122.451263656101) 9 8 6 28861 24
51918 84222 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
84241 84211 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
171735 84223 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
132782 239537 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007207.94911 2097619.73987 37.7400718289571 -122.417632670008 (37.7400718289571, -122.417632670008) 2 7 7 28859 2
148491 136019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Greenwich St 2 Sidewalk: Curb side : Yard Tree Private 2     10     6012283.42018 2120515.08235 37.8032215378072 -122.401692519489 (37.8032215378072, -122.401692519489) 3 1 10 28860 6
173420 136018 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     11     6012250.39299 2120519.5939 37.8032320823636 -122.401807129095 (37.8032320823636, -122.401807129095) 3 1 10 28860 6
145098 238413 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Hattie St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000620.6168 2105576.07492 37.7615451321313 -122.440979546976 (37.7615451321313, -122.440979546976) 15 5 5 28862 3
161515 238412 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Hattie St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000623.25448 2105558.02265 37.7614957152709 -122.440969129245 (37.7614957152709, -122.440969129245) 15 5 5 28862 3
90720 179056 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Santa Ysabel Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6000936.56308 2093078.77727 37.7272485065017 -122.438991155826 (37.7272485065017, -122.438991155826) 9 7 6 28861 25
93061 179054 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Santa Ysabel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000895.42593 2093107.17468 37.7273241385819 -122.439135400803 (37.7273241385819, -122.439135400803) 9 7 6 28861 25
129137 179053 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Santa Ysabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6000877.24807 2093119.84523 37.7273578946334 -122.439199149238 (37.7273578946334, -122.439199149238) 9 7 6 28861 25
142646 179055 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Santa Ysabel Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6000916.39944 2093093.66767 37.7272882448407 -122.439061927974 (37.7272882448407, -122.439061927974) 9 7 6 28861 25
140346 237234 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 110 Carmel St 4 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   5998175.72217 2105385.27781 37.7608816968555 -122.449421648503 (37.7608816968555, -122.449421648503) 15 5 11 29492 12
190559 237233 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 110 Carmel St 2 Sidewalk: Curb side : Pot Tree Private 2     7 Width 3ft   5998197.90052 2105385.612 37.7608838831125 -122.449344967798 (37.7608838831125, -122.449344967798) 15 5 11 29492 12
31187 27731 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015524.1696 2101161.19501 37.7502603851148 -122.38912554882 (37.7502603851148, -122.38912554882) 10 3 8 28856 1
52392 27729 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015622.7491 2101166.85438 37.7502813887778 -122.3887850466 (37.7502813887778, -122.3887850466) 10 3 8 28856 1
4116 262380 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008843.96123 2117672.51917 37.7952240323069 -122.413393767718 (37.7952240323069, -122.413393767718) 5 1 10 308 21
14535 119254 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008843.96123 2117672.51917 37.7952240323069 -122.413393767718 (37.7952240323069, -122.413393767718) 5 1 10 308 21
29561 88415 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 3 3x3 Permit Number 51386 6009399.28346 2116763.19844 37.7927584231235 -122.411407985496 (37.7927584231235, -122.411407985496) 3 1 10 28857 21
35235 88414 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 3 3x3 Permit Number 51386 6009411.74152 2116765.8223 37.7927663263429 -122.41136506535 (37.7927663263429, -122.41136506535) 3 1 10 28857 21
50563 88416 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
91852 88421 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 10 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
103353 88413 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 4 3x3 Permit Number 51386 6009439.10659 2116768.27237 37.7927745884158 -122.411270553799 (37.7927745884158, -122.411270553799) 3 1 10 28857 21
105885 88412 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 3 3x3 Permit Number 51386 6009452.7788 2116769.6537 37.7927791479928 -122.411223344786 (37.7927791479928, -122.411223344786) 3 1 10 28857 21
137212 88418 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
153077 88417 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
156455 88419 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
191235 88420 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Sacramento St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51386 6009510 2116776 37.7927997823299 -122.411025804578 (37.7927997823299, -122.411025804578) 3 1 10 28857 21
130475 237374 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Alabama St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009217.6012 2102696.19703 37.7541235380848 -122.411042564856 (37.7541235380848, -122.411042564856) 2 4 7 28859 19
177159 237372 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6009220.63177 2102661.35643 37.7540280435643 -122.411029623632 (37.7540280435643, -122.411029623632) 2 4 7 28859 19
192533 237373 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009218.81749 2102679.40367 37.7540774954946 -122.41103717252 (37.7540774954946, -122.41103717252) 2 4 7 28859 19
63494 196467 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 8 : Tree Private 2     4 Width 3ft   6015482.81101 2101057.86709 37.7499743755266 -122.389261356351 (37.7499743755266, -122.389261356351) 10 3 8 58 1
124323 196466 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 7 : Tree Private 2     6 Width 3ft   6015450.2681 2101056.0343 37.7499675388841 -122.389373764399 (37.7499675388841, -122.389373764399) 10 3 8 58 1
160146 196468 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 12 : Tree Private 2     8 Width 3ft   6015629.24905 2101065.86664 37.7500044578413 -122.388755520048 (37.7500044578413, -122.388755520048) 10 3 8 58 1
160198 196465 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 3 : Tree Private 2     3 Width 3ft   6015262.99985 2101056.82815 37.7499593343528 -122.390021408488 (37.7499593343528, -122.390021408488) 10 3 8 58 1
51412 214519 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992317.04824 2106570.78616 37.763799911465 -122.469770344939 (37.763799911465, -122.469770344939) 1 8 11 56 12
25676 237114 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 San Jose Ave 18 Front Yard : Yard Tree Private 2     2     6004844.31996 2096418.97753 37.7366415196845 -122.425719694004 (37.7366415196845, -122.425719694004) 2 7 5 28859 2
50542 237113 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 San Jose Ave 17 Front Yard : Yard Tree Private 2     2     6004838.14282 2096415.36394 37.7366312485184 -122.425740793928 (37.7366312485184, -122.425740793928) 2 7 5 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);