7,157 rows where qSpecies_id = 36 sorted by PermitNotes descending

View and edit SQL

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)
108194 21564 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1450 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     9 4X4 dead 6005645.68769 2114853.19648 37.7873027884337 -122.424259698627 (37.7873027884337, -122.424259698627) 13 9 1 28858 41
155070 93151 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 284X Funston Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6   Tree 5 on Funston. 5991864.0342 2113562.75305 37.7829717659308 -122.471846777677 (37.7829717659308, -122.471846777677) 11 6 2 54 11
19747 92977 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1741 Turk St 4 Sidewalk: Curb side : Cutout Tree Private 2     7   Tree 4 on Seymour St. 6001670.119 2112142.3771 37.779634286354 -122.437820070618 (37.779634286354, -122.437820070618) 15 5 11 29490 41
120665 92976 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1741 Turk St 3 Sidewalk: Curb side : Cutout Tree Private 2     8   Tree 3 on Seymour St. 6001673.9808 2112126.93 37.7795920921164 -122.437805604344 (37.7795920921164, -122.437805604344) 15 5 11 29490 41
21699 93149 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 284X Funston Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7   Tree 3 on Funston. 5991868.14141 2113524.63495 37.7828673417723 -122.471829789625 (37.7828673417723, -122.471829789625) 11 6 2 54 11
111634 92975 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1741 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2     7   Tree 2 on Seymour St. 6001675.9117 2112115.8273 37.7795617167054 -122.437798129123 (37.7795617167054, -122.437798129123) 15 5 11 29490 41
89665 93148 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 284X Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x5 Tree 2 on Funston. 5991866.59303 2113502.9352 37.7828076706429 -122.471833564338 (37.7828076706429, -122.471833564338) 11 6 2 54 11
182397 93147 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 284X Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Tree 1 on Funston. 5991866.22681 2113485.5569 37.7827599334256 -122.471833564358 (37.7827599334256, -122.471833564358) 11 6 2 54 11
19664 93051 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1555X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/2010 12:00:00 AM 3 3x3 Planted for DPW by FUF 6015509.3 2098161.9 37.7420241196322 -122.388967590374 (37.7420241196322, -122.388967590374) 10 3 8 58 1
44041 93052 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1555X Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/09/2010 12:00:00 AM 3 3x3 Planted by FUF for BUF 6015509.3 2098161.9 37.7420241196322 -122.388967590374 (37.7420241196322, -122.388967590374) 10 3 8 58 1
172710 54041 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2855 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM 14   Permit Number 9763 6001036.63383 2118177.80488 37.7961699689158 -122.440444544776 (37.7961699689158, -122.440444544776) 13 9 1 57 17
71333 54040 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2815 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM 13   Permit Number 9762 6001043.48682 2118118.78953 37.7960083184722 -122.440416597468 (37.7960083184722, -122.440416597468) 13 9 1 57 17
119562 54039 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2813 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/1972 12:00:00 AM 11   Permit Number 9761 6001046.84176 2118093.62628 37.7959394178222 -122.440403183184 (37.7959394178222, -122.440403183184) 13 9 1 57 17
126174 53881 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2715 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/1972 12:00:00 AM 21   Permit Number 9592 5999588.3128 2113961.1528 37.7845095766598 -122.445152707185 (37.7845095766598, -122.445152707185) 15 6 11 29490 31
69669 53822 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2865 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/1972 12:00:00 AM 11   Permit Number 9519 6000482.39335 2116463.10454 37.7914302782425 -122.442239169804 (37.7914302782425, -122.442239169804) 13 6 1 29490 27
62622 30446 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 357 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 12   Permit Number 95 6011194.45133 2119670.62732 37.8008420431764 -122.405401443236 (37.8008420431764, -122.405401443236) 3 1 10 308 23
191346 30439 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 387 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 15   Permit Number 92 6011071.27916 2119657.83609 37.8008000340602 -122.405826771312 (37.8008000340602, -122.405826771312) 3 1 10 308 23
150937 30438 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 324 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 15   Permit Number 91 6011339.87851 2119740.52253 37.8010420883794 -122.404903125306 (37.8010420883794, -122.404903125306) 3 1 10 308 23
148320 30434 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 312 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 20   Permit Number 87 6011372.10185 2119743.57684 37.8010522759047 -122.404791833276 (37.8010522759047, -122.404791833276) 3 1 10 308 23
19887 30431 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 255 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 9   Permit Number 84 6010587.196 2120972.0532 37.8043814669615 -122.407594621587 (37.8043814669615, -122.407594621587) 3 1 10 308 23
97586 30428 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 434 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 13 7x3 Permit Number 82 6010847.2664 2119670.2518 37.8008215943087 -122.406602828336 (37.8008215943087, -122.406602828336) 3 1 10 308 23
194450 234943 Prune Opt Out 3 Pittosporum undulatum :: Victorian Box 36 4339 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft Permit Number 788007 6001670.90597 2100562.91239 37.7478399578525 -122.436988118323 (37.7478399578525, -122.436988118323) 2 4 5 63 22
194459 248440 Prune Opt Out 3 Pittosporum undulatum :: Victorian Box 36 724 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft Permit Number 788001 5997627.8337 2107978.5557 37.7679708233346 -122.451503597918 (37.7679708233346, -122.451503597918) 15 5 11 29492 9
194262 262537 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 65 Ocean Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
592 211675 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 140 Jules Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2020 12:00:00 AM 3 Width 4ft Permit Number 785250 5994473.3982 2090822.99818 37.7206848225258 -122.461170675896 (37.7206848225258, -122.461170675896) 9 8 6 28861 24
8888 211674 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 134 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2020 12:00:00 AM 3 Width 3ft Permit Number 785249 5994473.26175 2090798.24034 37.7206168355785 -122.46116935389 (37.7206168355785, -122.46116935389) 9 8 6 28861 24
194263 15782 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/06/2015 12:38:00 PM 3 3X3 Permit Number 785142 6001159.6334 2090631.0194 37.7205402088092 -122.438044743528 (37.7205402088092, -122.438044743528) 9 7 6 28861 25
194268 15788 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/29/2020 12:00:00 AM 12 3X3 Permit Number 785142 6001054.6013 2090473.5841 37.7201019532463 -122.438396531841 (37.7201019532463, -122.438396531841) 9 7 6 28861 25
194271 15783 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4840 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 03:01:00 PM 3 3X3 Permit Number 785142 6001146.6106 2090614.741 37.7204947713768 -122.43808859365 (37.7204947713768, -122.43808859365) 9 7 6 28861 25
11127 234129 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 30 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:00:00 AM 3 3x3 Permit Number 784531 6005403.94341 2104612.96948 37.7591719489519 -122.424367461684 (37.7591719489519, -122.424367461684) 2 4 5 28859 19
30656 256908 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 751 25th Ave   : Tree Private 2 FUF 01/04/2019 12:00:00 AM 3 3x3 Permit Number 782750 5988160.57678 2110864.58172 37.7753483638678 -122.484461088261 (37.7753483638678, -122.484461088261) 11 6 2 55 26
48115 256907 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 751 25th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2019 12:00:00 AM 3 3x3 Permit Number 782750 5988160.57678 2110864.58172 37.7753483638678 -122.484461088261 (37.7753483638678, -122.484461088261) 11 6 2 55 26
14774 15553 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2847 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 4X4 Permit Number 781883 6007107.4417 2101776.5099 37.7514797285918 -122.418274826958 (37.7514797285918, -122.418274826958) 2 4 7 28859 19
101666 127182 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2011 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 Width 5ft Permit Number 781749 5999884.37822 2115873.98153 37.7897786004407 -122.444265930542 (37.7897786004407, -122.444265930542) 13 6 1 29490 27
160537 205150 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 250 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2018 12:00:00 AM 3 Width 3ft Permit Number 781736 5994962.18094 2106723.12455 37.764370728241 -122.4606327428 (37.764370728241, -122.4606327428) 15 5 11 56 12
155396 1522 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 422 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2013 12:00:00 AM 3 3X3 Permit Number 781664 5995605.60631 2113581.85062 37.7832399843175 -122.458903950762 (37.7832399843175, -122.458903950762) 11 6 1 54 31
177913 1592 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 690 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3 Permit Number 781663 5995684.42266 2111472.80477 37.7774536354298 -122.458478563446 (37.7774536354298, -122.458478563446) 11 6 2 54 16
49267 2675 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2059 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2018 12:00:00 AM 3 4X4 Permit Number 781507 6003660.5178 2114875.7424 37.7872524011428 -122.431129574605 (37.7872524011428, -122.431129574605) 13 9 11 29490 27
57136 254420 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1232 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2018 12:00:00 AM 3 3x3 Permit Number 781394 5991448.19583 2107029.01028 37.765007814143 -122.472808824857 (37.765007814143, -122.472808824857) 11 8 11 56 12
78022 104755 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 781111 5998481.68854 2116256.67872 37.7907492594091 -122.449146662803 (37.7907492594091, -122.449146662803) 13 6 1 54 31
188866 104754 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/28/2018 12:00:00 AM 3 3x3 Permit Number 781111 5998483.43829 2116249.0389 37.7907283825673 -122.449140058165 (37.7907283825673, -122.449140058165) 13 6 1 54 31
13744 240879 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3659 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2017 12:00:00 AM 3 3x3 Permit Number 780848 6005174.01235 2105435.79092 37.7614182359708 -122.425221224092 (37.7614182359708, -122.425221224092) 2 4 5 28859 19
37766 150676 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 548 Rhode Island St 1 Front Yard : Cutout Tree Private 2   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.98399 2105812.52377 37.7628222449765 -122.402486741392 (37.7628222449765, -122.402486741392) 8 3 8 28856 29
50450 27604 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 988 Fulton St 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/09/2017 12:00:00 AM 3 4X4 Permit Number 780706 6003185.1314 2111389.5656 37.7776532852192 -122.43252520607 (37.7776532852192, -122.43252520607) 15 9 11 29492 41
56063 27606 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 988 Fulton St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/09/2017 12:00:00 AM 3 4X4 Permit Number 780706 6003145.1713 2111385.063 37.7776386560762 -122.432663119808 (37.7776386560762, -122.432663119808) 15 9 11 29492 41
125729 27601 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 988 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2017 12:00:00 AM 3 4X4 Permit Number 780706 6003246.4786 2111399.6963 37.7776845802664 -122.432313709128 (37.7776845802664, -122.432313709128) 15 9 11 29492 41
34077 256492 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
38312 167082 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
4820 253072 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1350 46th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/18/2019 12:00:00 AM 3 6x10 Permit Number 780489 5981849.66657 2105897.22193 37.7613399178539 -122.50592325662 (37.7613399178539, -122.50592325662) 1 8 3 56 35
48746 100153 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 590 08th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 780398 5993481.43699 2111479.23814 37.7773444498569 -122.466099823613 (37.7773444498569, -122.466099823613) 11 6 2 54 11
189637 123240 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 590 08th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft Permit Number 780398 5993479.44876 2111515.72827 37.777444527227 -122.466109353825 (37.777444527227, -122.466109353825) 11 6 2 54 11
104239 251429 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1345 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779991 6003307 2100429 37.7475651236724 -122.431321029201 (37.7475651236724, -122.431321029201) 2 4 5 63 22
4265 129451 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1147 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2018 12:00:00 AM 3 3x3 Permit Number 779607 6007395.89235 2119499.90916 37.8001601781003 -122.418533970572 (37.8001601781003, -122.418533970572) 5 1 1 28858 32
16037 135812 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1147 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 779607 6007418.27175 2119501.50723 37.8001658258642 -122.418456642358 (37.8001658258642, -122.418456642358) 5 1 1 28858 32
179761 160920 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 666 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3 Permit Number 779533 6002104.11317 2090113.36167 37.7191725036747 -122.434742983299 (37.7191725036747, -122.434742983299) 9 7 6 28861 5
77555 232299 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 108 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2018 12:00:00 AM 3 Width 4ft Permit Number 779438 6005119.98151 2099339.98705 37.7446775233394 -122.424974374591 (37.7446775233394, -122.424974374591) 2 7 5 63 22
106854 251131 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 354 05th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 02/14/2014 12:00:00 AM   3x3 Permit Number 779305 6011875 2111882 37.7794943458843 -122.402498458881 (37.7794943458843, -122.402498458881) 14 2 9 28856 34
189387 251132 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 354 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW 02/11/2006 12:00:00 AM   3x3 Permit Number 779305 6011875 2111882 37.7794943458843 -122.402498458881 (37.7794943458843, -122.402498458881) 14 2 9 28856 34
161137 92967 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3022 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2016 12:00:00 AM 3 4x4 Permit Number 779165 6000091.47375 2115801.73595 37.7895920459934 -122.443544210206 (37.7895920459934, -122.443544210206) 13 6 1 29490 27
163376 253126 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 182 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.20381 37.7261633586637 -122.432716365158 (37.7261633586637, -122.432716365158) 9 7 6 28861 5
52723 7976 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2007 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2017 12:00:00 AM 3 4X4 Permit Number 779097 6005561.28008 2117067.6166 37.793378265541 -122.424709321884 (37.793378265541, -122.424709321884) 13 9 1 28858 27
12611 121264 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3053 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778943 5996367 2111408 37.7773149020317 -122.456112630584 (37.7773149020317, -122.456112630584) 11 6 2 54 16
162812 121265 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3053 Turk Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778943 5996367 2111408 37.7773149020317 -122.456112630584 (37.7773149020317, -122.456112630584) 11 6 2 54 16
119324 253343 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
184490 253342 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
148640 57347 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4006 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1976 12:00:00 AM 20   Permit Number 778373 6001804.25600707 2102958.17712895 37.7544243620634 -122.436698432015 (37.7544243620634, -122.436698432015) 2 4 5 28862 22
139856 49914 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2140 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3 4x4 Permit Number 778261 6008088.06345917 2105963.11156728 37.7630303308354 -122.415180031733 (37.7630303308354, -122.415180031733) 8 4 7 28859 19
146339 49915 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2140 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3 4x4 Permit Number 778261 6008088.06345917 2105963.11156728 37.7630303308354 -122.415180031733 (37.7630303308354, -122.415180031733) 8 4 7 28859 19
117732 254359 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 41 Campbell Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 778173 6012132.40915 2088469.86278 37.7152240259545 -122.399963419046 (37.7152240259545, -122.399963419046) 10 7 8 309 39
115980 50493 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 639 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778052 6002442.45455321 2090054.61865068 37.7190304113329 -122.43356927156 (37.7190304113329, -122.43356927156) 9 7 6 28861 5
77889 4254 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4079 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2016 12:00:00 AM 3 3X3 Permit Number 777901 6003404.0668529 2100364.8685588 37.7473945342564 -122.430980801713 (37.7473945342564, -122.430980801713) 2 4 5 63 22
135156 116178 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 94X Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 2x2 Permit Number 777858 6013051.68778 2114735.35229 37.7873946119181 -122.39862805626 (37.7873946119181, -122.39862805626) 12 2 9 28855 6
2804 115921 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 50 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777610 6013791.45387 2116146.74475 37.7913111540478 -122.396167553395 (37.7913111540478, -122.396167553395) 12 2 9 28855 6
81103 156905 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 3201x 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417 2106083 37.7633217807187 -122.417509514421 (37.7633217807187, -122.417509514421) 8 4 7 28859 19
105170 252909 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 3201x 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417 2106083 37.7633217807187 -122.417509514421 (37.7633217807187, -122.417509514421) 8 4 7 28859 19
176471 252908 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19
176658 252906 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 600 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19
178976 252905 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 600 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19
36893 152811 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009988.15821 2101607.87857 37.7511784382559 -122.40830102207 (37.7511784382559, -122.40830102207) 2 4 7 28859 19
46028 152812 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.7511816461268 -122.408251752714 (37.7511816461268, -122.408251752714) 2 4 7 28859 19
134654 152810 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.7511779795992 -122.408352609887 (37.7511779795992, -122.408352609887) 2 4 7 28859 19
109201 56400 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 203 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 12   Permit Number 776836 5992106.73149 2114059.68671 37.7843502487637 -122.471043366703 (37.7843502487637, -122.471043366703) 11 6 2 54 11
164047 15420 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2090 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2015 12:00:00 AM 3 4x4 Permit Number 776475 6006807.3195 2106193.613 37.7635911742402 -122.419626052426 (37.7635911742402, -122.419626052426) 8 4 7 28859 19
135398 117444 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1133 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776191 6004090.20732 2089350.17003 37.7171895030573 -122.427823460996 (37.7171895030573, -122.427823460996) 9 7 6 28861 5
100024 258333 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 2 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
172077 258332 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 1 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
110183 112361 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 561X Folsom St 1 Front Yard : Yard Tree Private 2   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.90646 37.7859605214302 -122.396175324952 (37.7859605214302, -122.396175324952) 6 2 9 28856 6
158786 34676 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2000 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/2015 12:00:00 AM 3   Permit Number 775668 6003314.31901 2118972.51824 37.7984814738846 -122.432620094941 (37.7984814738846, -122.432620094941) 13 9 1 57 17
188396 93150 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 284X Funston Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2015 12:00:00 AM 3   Permit Number 775609 5991864.69021 2113542.09367 37.7829150789203 -122.471843002028 (37.7829150789203, -122.471843002028) 11 6 2 54 11
150250 110301 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3727 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2015 12:00:00 AM 3 3x3 Permit Number 775502 6003051.71719 2121145.37774 37.8044326826855 -122.4336841548 (37.8044326826855, -122.4336841548) 13 9 1 57 17
130412 107618 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 599x CHINA BASIN ST 11 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2015 12:00:00 AM 3 4x4 Permit Number 775477 6015291 2109063 37.7719441112286 -122.390483933976 (37.7719441112286, -122.390483933976) 14 3 9 310 20
131027 107614 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 599x CHINA BASIN ST 3 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2015 12:00:00 AM 3 4x4 Permit Number 775477 6015291 2109063 37.7719441112286 -122.390483933976 (37.7719441112286, -122.390483933976) 14 3 9 310 20
177538 107613 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 599x CHINA BASIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2015 12:00:00 AM 3 4x4 Permit Number 775477 6015291 2109063 37.7719441112286 -122.390483933976 (37.7719441112286, -122.390483933976) 14 3 9 310 20
89570 115232 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 523 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 775420 5985904.5 2112316.6 37.7792035589465 -122.49237222008 (37.7792035589465, -122.49237222008) 11 6 2 55 26
137450 99107 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1766 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 2 3x3 Permit Number 775193 6001658.68735 2121105.16624 37.8042431316708 -122.438501963298 (37.8042431316708, -122.438501963298) 13 9 1 57 17
106027 69186 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2459 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM     Permit Number 775037 6003656.25511506 2116791.97327804 37.7925136429048 -122.431281157687 (37.7925136429048, -122.431281157687) 13 9 1 29490 27
136337 59894 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 912 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM   9x6 Permit Number 775027 6009913.676206 2103880.39060941 37.75741407817 -122.408718893172 (37.75741407817, -122.408718893172) 2 4 7 28859 19
62113 114560 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1513 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM     Permit Number 775026 6000098.8 2114218 37.7852439369624 -122.443405056634 (37.7852439369624, -122.443405056634) 15 6 1 29490 31
119423 114977 Private 9 Pittosporum undulatum :: Victorian Box 36 183 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603) 9 8 6 28861 24
12632 67562 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1165 Kansas St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3   Permit Number 774855 6011714 2102959 37.7549848131441 -122.402427835541 (37.7549848131441, -122.402427835541) 10 3 8 28856 29

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