trees
194,517 rows sorted by PermitNotes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );