194,517 rows 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)
191057 100769 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3701 21st St   Front Yard : Yard Tree Private 2     55   Street tree w/in RoW 6003717 2103606 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
123690 98250 DPW Maintained 1 Tree(s) :: 17 650 Eddy St   Sidewalk: Curb side : Cutout Landscaping Private 2         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554) 7 9 9 28858 36
180035 4148 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3631 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/17/1999 12:00:00 AM 3 3X3 She would like to be kept in the loop on what happens with this. 6006082.4281665 2100506.5376626 37.7479349243864 -122.421729258843 (37.7479349243864, -122.421729258843) 2 4 7 28859 22
169352 103020 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 40X Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3 See 61 Fair Ave property permits 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
170842 103021 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 40X Coleridge St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3 See 61 Fair Ave for old permit records 6006901 2099544.2 37.7453386886112 -122.418830426928 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
175524 103085 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 99 Colton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.420335581823 (37.7728452155106, -122.420335581823) 8 2 9 28853 19
177248 103086 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 99 Colton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.420335581823 (37.7728452155106, -122.420335581823) 8 2 9 28853 19
15015 127892 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 623 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 20 Width 4ft Resulted descion 9/7/16 -DE 6010045.66816 2119169.32215 37.7994012851886 -122.40934133535 (37.7994012851886, -122.40934133535) 3 1 10 308 4
90288 9941 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 5x6 Resulted descion 9/7/16 -DE 6010050.95997 2119172.47111 37.7994102279433 -122.409323246083 (37.7994102279433, -122.409323246083) 3 1 10 308 4
87616 86601 DPW Maintained 1 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 1728 Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/10/2011 12:00:00 AM 3 3x3 Replant with Acer rubrum 'Red Sunset' 6009458 2106735 37.7652266534479 -122.410496377801 (37.7652266534479, -122.410496377801) 8 4 7 28859 19
26373 18941 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2782 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3 Replace with P. Undulatum 6001522.42549 2115673.82967 37.7893223527794 -122.438584108286 (37.7893223527794, -122.438584108286) 13 6 1 29490 27
109345 56538 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1601 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2         Removed on Permit No. 49327 5990034.81385638 2101735.08104673 37.7503901747188 -122.477310384437 (37.7503901747188, -122.477310384437) 1 8 3 29491 35
89921 84820 Permitted Site 7 Tree(s) :: 17 772 HARRISON St 2 Sidewalk: Curb side : Cutout Tree Private 2         Removed on Permit No. 49314 6012829 2112467 37.7811538337362 -122.399239222173 (37.7811538337362, -122.399239222173) 6 2 9 28856 34
139114 84738 Permitted Site 7 Tree(s) :: 17 97 Banks St 3 Sidewalk: Curb side : Cutout Tree Private 2         Removed on Permit No. 49268 6008713.1 2098156.5 37.7416302361339 -122.412466387589 (37.7416302361339, -122.412466387589) 10 7 7 28859 2
166560 84818 Permitted Site 7 Tree(s) :: 17 760 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2         Removed on Permit No. 49223 6012704 2103964 37.7577995404784 -122.399074649862 (37.7577995404784, -122.399074649862) 10 3 8 28856 29
45162 100793 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 2979 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2         Recently planted by FUF. 6008363 2103862 37.7572766073656 -122.414080464335 (37.7572766073656, -122.414080464335) 2 4 7 28859 19
1215 253279 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 201X Laguna Honda Blvd 1 Sidewalk: Property side : Yard Tree DPW 1       10x10 ROW IS 10' tree is street tree                    
157369 17376 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1600 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Property owner contact Achmed 821-1594. 6014810.60512 2095342.40421 37.7342436096391 -122.391186437905 (37.7342436096391, -122.391186437905) 10 3 8 58 1
83914 99756 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 517 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Probably planted at same time/permitted with tree no. 1 6001837 2100870 37.7486925868246 -122.436435749617 (37.7486925868246, -122.436435749617) 2 4 5 28862 22
8683 99744 Undocumented 4 Maytenus boaria :: Mayten 58 431 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Probably planted at same time as tree no. 1 w/same permit. CB 6002387 2100900 37.7488061968535 -122.43453600134 (37.7488061968535, -122.43453600134) 2 4 5 28862 22
34602 97033 Property Tree 8 Afrocarpus gracilior :: Fern Pine 89 61 Vicksburg St   Back Yard : Yard Tree Private 2         Possible significant tree; Nellie RoW; rear yard 6004120 2102703 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406) 2 4 5 28862 22
70430 142788 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 733 POLK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft Polk St Scape will replant 6007029.0497 2113497.6534 37.7836588132661 -122.419377346786 (37.7836588132661, -122.419377346786) 7 9 9 28858 36
78904 98227 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 207 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Planted without permit; 2' away from sewer line. 6007132 2097003 37.7383741239705 -122.417851565085 (37.7383741239705, -122.417851565085) 2 7 7 28859 2
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
168861 95412 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 2815 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW   1 3x3 Planted by Glen Park Public Library; will become DPW maintained after it is established. 6002467 2095594 37.734241695714 -122.433880155045 (37.734241695714, -122.433880155045) 2 7 5 63 7
105406 95411 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 2815 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467 2095594 37.734241695714 -122.433880155045 (37.734241695714, -122.433880155045) 2 7 5 63 7
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
41375 96477 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 777 Florida St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2011 12:00:00 AM   3x3 Permit number 52657 6009359.6 2104624.3 37.7594256359904 -122.410687650563 (37.7594256359904, -122.410687650563) 2 4 7 28859 19
178575 96914 Undocumented 4 Magnolia spp :: Magnolia 224 4396X 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM   3x3 Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. 6000641.3 2102303.1 37.7525595190983 -122.440673239158 (37.7525595190983, -122.440673239158) 2 4 5 28862 22
140857 54249 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1274 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/1972 12:00:00 AM 20   Permit Number 9991 5988659.40013717 2106655.34316867 37.7638199891792 -122.482427078169 (37.7638199891792, -122.482427078169) 1 8 3 56 35
145534 54248 Permitted Site 7 Tree(s) :: 17 1270 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/1972 12:00:00 AM     Permit Number 9990 5988658.49378017 2106681.68861971 37.7638922738793 -122.482432143443 (37.7638922738793, -122.482432143443) 1 8 3 56 35
124166 54246 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1234 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/1972 12:00:00 AM 12   Permit Number 9988 5988645.1955 2106901.8925 37.764496120049 -122.482494273902 (37.764496120049, -122.482494273902) 1 8 3 56 35
38184 54244 Permitted Site 7 Schinus terebinthifolius :: Brazilian Pepper 93 10 Sharon St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1972 12:00:00 AM 24   Permit Number 9985 6003826.70188878 2107089.19403693 37.7658818771202 -122.429998956827 (37.7658818771202, -122.429998956827) 8 4 5 28862 3
169326 240582 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 8 Sharon St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1972 12:00:00 AM 15 Width 3ft Permit Number 9985 6003834.4345 2107034.98465 37.7657334691548 -122.429968344076 (37.7657334691548, -122.429968344076) 8 4 5 28862 3
44329 54243 DPW Maintained 1 Tristania conferta :: 61 35 Kittredge Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1972 12:00:00 AM 26   Permit Number 9984 5997958.8776 2111479.5979 37.7776027359423 -122.450610999735 (37.7776027359423, -122.450610999735) 15 6 2 54 16
80051 54242 Permitted Site 7 Tree(s) :: 17 1201 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/1972 12:00:00 AM     Permit Number 9982 5998165.20998344 2106218.14593623 37.7631679419226 -122.449518019404 (37.7631679419226, -122.449518019404) 15 5 11 29492 9
76590 54241 Permitted Site 7 Tree(s) :: 17 1289 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9981 5995148.59563824 2106773.34474969 37.7645193430248 -122.459991629084 (37.7645193430248, -122.459991629084) 15 5 11 56 12
69136 54239 Permitted Site 7 Tree(s) :: 17 1283 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9979 5995147.26905248 2106811.90515359 37.7646251436038 -122.459999010975 (37.7646251436038, -122.459999010975) 15 5 11 56 12
158320 54236 Permitted Site 7 Tree(s) :: 17 1278 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9976 5995197.96939939 2106850.57690326 37.7647342420492 -122.459826454653 (37.7647342420492, -122.459826454653) 15 5 11 56 12
41941 54235 Permitted Site 7 Tree(s) :: 17 1275 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9975 5995145.50027148 2106863.31902546 37.7647662110387 -122.460008853529 (37.7647662110387, -122.460008853529) 15 5 11 56 12
151285 54234 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1270 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/2010 12:00:00 AM     Permit Number 9974 5995196.04681137 2106906.46154553 37.7648875762272 -122.459837152742 (37.7648875762272, -122.459837152742) 15 5 11 56 12
186189 54233 Permitted Site 7 Tree(s) :: 17 1269 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9973 5995144.17368572 2106901.87942936 37.7648720116121 -122.460016235469 (37.7648720116121, -122.460016235469) 15 5 11 56 12
26232 54232 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 1265 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 9972 5995143.28929522 2106927.58636529 37.7649425453263 -122.460021156774 (37.7649425453263, -122.460021156774) 15 5 11 56 12
89573 54230 Permitted Site 7 Tree(s) :: 17 1263 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9970 5995142.84709997 2106940.43983326 37.764977812183 -122.46002361743 (37.764977812183, -122.46002361743) 15 5 11 56 12
139392 54228 Permitted Site 7 Tree(s) :: 17 1236 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9967 5995188.02638703 2107139.59434987 37.7655272371859 -122.45988178223 (37.7655272371859, -122.45988178223) 15 5 11 56 12
53753 54227 Permitted Site 7 Tree(s) :: 17 1218 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9966 5995184.16942835 2107251.70599926 37.7658348448517 -122.459903244465 (37.7658348448517, -122.459903244465) 15 5 11 56 12
27611 54226 Permitted Site 7 Tree(s) :: 17 1214 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9964 5995183.31232643 2107276.61969912 37.765903202108 -122.459908013875 (37.765903202108, -122.459908013875) 15 5 11 56 12
63278 54225 Permitted Site 7 Tree(s) :: 17 1200 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9963 5995180.31246968 2107363.81764864 37.7661424524971 -122.459924706879 (37.7661424524971, -122.459924706879) 15 5 11 29492 12
90778 54224 Permitted Site 7 Tree(s) :: 17 1275 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9962 5995455.80388001 2106874.03814043 37.76481348491 -122.458936377414 (37.76481348491, -122.458936377414) 15 5 11 56 12
146108 54223 Permitted Site 7 Tree(s) :: 17 1272 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9961 5995507.09104626 2106895.652617 37.7648757806637 -122.458760554457 (37.7648757806637, -122.458760554457) 15 5 11 56 12
103828 54222 Permitted Site 7 Tree(s) :: 17 1265 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/1972 12:00:00 AM     Permit Number 9960 5995453.59170055 2106938.34058964 37.7649899156402 -122.458948684825 (37.7649899156402, -122.458948684825) 15 5 11 56 12
33977 54221 Permitted Site 7 Tree(s) :: 17 1261 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/1972 12:00:00 AM     Permit Number 9959 5995452.70682877 2106964.06156933 37.7650604879304 -122.458953607806 (37.7650604879304, -122.458953607806) 15 5 11 56 12
111187 54220 Permitted Site 7 Tree(s) :: 17 1257 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/1972 12:00:00 AM     Permit Number 9958 5995451.82195698 2106989.78254901 37.7651310602195 -122.458958530796 (37.7651310602195, -122.458958530796) 15 5 11 56 12
123425 54218 Permitted Site 7 Tree(s) :: 17 1219 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9956 5995442.51666838 2107260.2641065 37.7658731976209 -122.459010301428 (37.7658731976209, -122.459010301428) 15 5 11 56 12
29763 54216 Permitted Site 7 Tree(s) :: 17 650 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/1972 12:00:00 AM     Permit Number 9954 5995030.20332455 2106164.63187071 37.7628411652133 -122.460357005 (37.7628411652133, -122.460357005) 15 5 11 56 12
174081 101247 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 725 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 9951 5993550 2106615 37.7639924992069 -122.465509188009 (37.7639924992069, -122.465509188009) 1 8 11 56 12
186659 54213 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 725 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9951 5993547.73398631 2106617.88649247 37.7640002940645 -122.465517235123 (37.7640002940645, -122.465517235123) 1 8 11 56 12
33758 101245 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1301X 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9950 5993577.2 2106568.3 37.7638658419872 -122.465411719392 (37.7638658419872, -122.465411719392) 1 8 11 56 12
51381 101246 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1301X 08th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9950 5993577.2 2106568.3 37.7638658419872 -122.465411719392 (37.7638658419872, -122.465411719392) 1 8 11 56 12
142314 54212 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1301X 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9950 5993618.71802201 2106620.31797794 37.7640110640874 -122.465271900961 (37.7640110640874, -122.465271900961) 1 8 11 56 12
155295 54211 Permitted Site 7 Tree(s) :: 17 700 Lincoln St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9949 5993605.60395035 2107361.64964194 37.7660458098349 -122.465371113084 (37.7660458098349, -122.465371113084) 11 8 11 29492 8
29205 54207 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 525 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9945 5994167.427381 2106639.11364061 37.7640943000648 -122.463375455955 (37.7640943000648, -122.463375455955) 1 5 11 56 12
164223 54206 Permitted Site 7 Tree(s) :: 17 526 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9944 5994147.95293559 2107032.11537111 37.7651722581206 -122.463471334315 (37.7651722581206, -122.463471334315) 11 5 11 56 12
133105 54205 Permitted Site 7 Tree(s) :: 17 139 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9943 5995354.17926051 2107022.12845835 37.7652142604002 -122.45929859343 (37.7652142604002, -122.45929859343) 15 5 11 56 12
50457 54204 Permitted Site 7 Tree(s) :: 17 131 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1972 12:00:00 AM     Permit Number 9942 5995377.99005235 2107022.95842059 37.7652179081932 -122.459216298261 (37.7652179081932, -122.459216298261) 15 5 11 56 12
30071 54203 Permitted Site 7 Tree(s) :: 17 129 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9941 5995383.94275448 2107023.1659113 37.7652188201332 -122.459195724453 (37.7652188201332, -122.459195724453) 15 5 11 56 12
18590 210743 Permitted Site 7 Olea europaea :: Olive Tree 9 45 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM 14 Width 4ft Permit Number 9938 5995615.49185 2107032.26685 37.7652571180555 -122.458395515563 (37.7652571180555, -122.458395515563) 15 5 11 56 12
126916 54200 Permitted Site 7 Tree(s) :: 17 45 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9938 5995654.85488521 2107032.60892369 37.7652603192898 -122.458259393816 (37.7652603192898, -122.458259393816) 15 5 11 56 12
15190 210598 Permitted Site 7 Olea europaea :: Olive Tree 9 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM 16 Width 4ft Permit Number 9937 5995535.69173 2107072.5304 37.7653630851686 -122.458674438482 (37.7653630851686, -122.458674438482) 15 5 11 56 12
155542 54199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
149250 54198 Permitted Site 7 Tree(s) :: 17 30 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9936 5995701.15076447 2107086.25420453 37.7654102755527 -122.458103151162 (37.7654102755527, -122.458103151162) 15 5 11 56 12
144722 54197 Permitted Site 7 Tree(s) :: 17 7 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM     Permit Number 9935 5995773.43287988 2107036.74210984 37.7652784810606 -122.457849562414 (37.7652784810606, -122.457849562414) 15 5 11 56 12
118856 54196 Permitted Site 7 Tree(s) :: 17 2400 Washington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1972 12:00:00 AM     Permit Number 9933 6003211.73035165 2116564.51715591 37.7918639049586 -122.432802970044 (37.7918639049586, -122.432802970044) 13 9 1 29490 27
19193 54195 Permitted Site 7 Tree(s) :: 17 863 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1972 12:00:00 AM     Permit Number 9932 5983223.98924122 2109926.2761241 37.7724833470275 -122.501468187751 (37.7724833470275, -122.501468187751) 11 6 2 55 26
56272 54194 Permitted Site 7 Tree(s) :: 17 4507 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/1972 12:00:00 AM     Permit Number 9931 6001090.41996526 2104621.18240143 37.7589499775483 -122.439286247947 (37.7589499775483, -122.439286247947) 2 4 5 28862 38
54223 54193 Permitted Site 7 Tree(s) :: 17 226 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/1972 12:00:00 AM     Permit Number 9929 6004425.95705553 2099300.95070846 37.7445311111316 -122.427371396194 (37.7445311111316, -122.427371396194) 2 7 5 63 22
60718 54192 Permitted Site 7 Tree(s) :: 17 1800 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1972 12:00:00 AM     Permit Number 9928 6003970.0714174 2114620.22643789 37.7865683551319 -122.430040351032 (37.7865683551319, -122.430040351032) 13 9 11 29490 27
151934 54191 Permitted Site 7 Tree(s) :: 17 177 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1972 12:00:00 AM     Permit Number 9927 6005446.49280939 2102690.15694653 37.7538947573464 -122.424083563557 (37.7538947573464, -122.424083563557) 2 4 5 28859 19
129517 54190 Permitted Site 7 Tree(s) :: 17 81 Pearl St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9926 6005661.0124984 2108583.32813962 37.7700881256225 -122.423760699167 (37.7700881256225, -122.423760699167) 8 2 5 28853 19
43009 54186 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1536 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM 20 3x3 Permit Number 9921 6015571.57326 2096517.43556 37.7375122082315 -122.388637501128 (37.7375122082315, -122.388637501128) 10 3 8 58 1
177677 54185 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1526 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM 30 4x4 Permit Number 9920 6015598.37895 2096494.31778 37.7374502170542 -122.388543207207 (37.7374502170542, -122.388543207207) 10 3 8 58 1
30586 54184 Permitted Site 7 Tree(s) :: 17 1523 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1972 12:00:00 AM     Permit Number 9919 6015575.83102515 2096446.47115556 37.7373175903777 -122.388617827683 (37.7373175903777, -122.388617827683) 10 3 8 58 1
23464 54183 Permitted Site 7 Tree(s) :: 17 1963 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9918 5992252.86810384 2102050.91586578 37.7513858215434 -122.469663255825 (37.7513858215434, -122.469663255825) 1 8 4 29491 12
122576 54182 Permitted Site 7 Tree(s) :: 17 1959 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9917 5992242.56777336 2102077.94043422 37.7514594286723 -122.469700842466 (37.7514594286723, -122.469700842466) 1 8 4 29491 12
173980 54181 Permitted Site 7 Tree(s) :: 17 1954 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9916 5992280.85765043 2102123.48503857 37.7515866953923 -122.469571747805 (37.7515866953923, -122.469571747805) 1 8 4 29491 12
45025 54180 Permitted Site 7 Tree(s) :: 17 1950 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9915 5992281.85082546 2102137.9648812 37.7516265106914 -122.469569367285 (37.7516265106914, -122.469569367285) 1 8 4 29491 12
162281 54179 Permitted Site 7 Tree(s) :: 17 1946 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9914 5992286.60814003 2102166.49194956 37.7517051135809 -122.469554992473 (37.7517051135809, -122.469554992473) 1 8 4 29491 12
148993 54178 Permitted Site 7 Tree(s) :: 17 1940 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9913 5992293.74410745 2102209.28252543 37.7518230178364 -122.469533430211 (37.7518230178364, -122.469533430211) 1 8 4 29491 12
45978 54177 Permitted Site 7 Tree(s) :: 17 1926 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9912 5992278.63670938 2102318.40263055 37.7521217602474 -122.469593616061 (37.7521217602474, -122.469593616061) 1 8 4 29491 12
64226 54175 Permitted Site 7 Tree(s) :: 17 1906 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9910 5992259.24604597 2102456.89958784 37.7525009162667 -122.469670752945 (37.7525009162667, -122.469670752945) 1 8 4 29491 12
178257 54173 Permitted Site 7 Tree(s) :: 17 881 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9908 6009258.20888465 2090119.45963122 37.7195928134325 -122.410014331585 (37.7195928134325, -122.410014331585) 9 3 7 309 28
80809 54172 Permitted Site 7 Tree(s) :: 17 875 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9907 6009250.66071403 2090144.34753997 37.7196607273878 -122.410042179052 (37.7196607273878, -122.410042179052) 9 3 7 309 28
58130 54171 Permitted Site 7 Tree(s) :: 17 863 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9906 6009235.5643822 2090194.12332646 37.7197965551917 -122.410097874104 (37.7197965551917, -122.410097874104) 9 3 7 309 28
172839 54170 Permitted Site 7 Tree(s) :: 17 851 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9905 6009220.46805037 2090243.89911296 37.7199323829664 -122.41015356936 (37.7199323829664, -122.41015356936) 9 3 7 309 28
56363 54168 Permitted Site 7 Tree(s) :: 17 845 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9903 6009212.91988445 2090268.7870062 37.7200002968427 -122.410181417064 (37.7200002968427, -122.410181417064) 9 3 7 309 28
52906 54166 Permitted Site 7 Tree(s) :: 17 838 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM     Permit Number 9901 6009155.60998668 2090278.58284714 37.7200239816424 -122.410380209835 (37.7200239816424, -122.410380209835) 9 3 7 309 28
66585 54165 DPW Maintained 1 Olea europaea :: Olive Tree 9 833 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM 17   Permit Number 9900 6009194.94472 2090308.57597 37.7201085414697 -122.41024635908 (37.7201085414697, -122.41024635908) 9 3 7 309 28
16760 30450 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 3030 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 9   Permit Number 99 5999622.18885 2116719.4943 37.7920851942278 -122.44523389245 (37.7920851942278, -122.44523389245) 13 6 1 29490 27
40619 54163 DPW Maintained 1 Olea europaea :: Olive Tree 9 809 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM 14   Permit Number 9898 6009163.7285 2090404.08715 37.7203690453816 -122.410361003783 (37.7203690453816, -122.410361003783) 9 3 7 309 28
66005 54162 DPW Maintained 1 Olea europaea :: Olive Tree 9 801 Colby St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM 13   Permit Number 9897 6009157.09852 2090431.14887 37.7204429795508 -122.410385831368 (37.7204429795508, -122.410385831368) 9 3 7 309 28

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