trees
39,840 rows where qLegalStatus_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127422 | 86830 | Permitted Site 7 | Araucaria heterophylla :: Norfolk Island Pine 238 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | unpermitted private planting on DPW-maintained street | 6002845 | 2107418 | 37.7667290519071 | -122.43341795454 | (37.7667290519071, -122.43341795454) | 15 | 5 | 5 | 28862 | 3 | ||
31790 | 93029 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5x6 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
121866 | 93030 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | undocumented | 6004830 | 2101620 | 37.7509215289079 | -122.426139360449 | (37.7509215289079, -122.426139360449) | 2 | 4 | 5 | 28862 | 22 | ||
57446 | 94626 | Permitted Site 7 | Alnus rhombifolia :: White Alder 327 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
87020 | 85212 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738 | 2088050 | 37.7130860517587 | -122.460055250763 | (37.7130860517587, -122.460055250763) | 9 | 8 | 6 | 28861 | 24 | |
124970 | 94466 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4128 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
191620 | 94467 | Permitted Site 7 | Liquidambar styraciflua :: American Sweet Gum 37 | 4128 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
127616 | 85251 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1151 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | 3x3 | Under 3yr maintenance agreement. Expires 6/15/2010. | 6001497.16836 | 2088486.70556 | 37.7146715920273 | -122.43672457862 | (37.7146715920273, -122.43672457862) | 9 | 7 | 6 | 28861 | 5 | |
152608 | 13294 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2680X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2001 12:00:00 AM | 8 | 3X3 | Tree located adjacent to 3000 Baker | 5999556.3855 | 2119169.40502 | 37.7988082423603 | -122.445637828136 | (37.7988082423603, -122.445637828136) | 13 | 9 | 1 | 57 | 17 | |
108599 | 93063 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | Tree 5 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
83912 | 93062 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | ||
99129 | 93120 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Tree 4 on Lyon St | 6000421 | 2110261 | 37.774397395284 | -122.442006222093 | (37.774397395284, -122.442006222093) | 15 | 5 | 11 | 29492 | 16 | ||
167547 | 93001 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Tree 4 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
114729 | 94064 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 4 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
87252 | 93061 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x2.5 | Tree 3 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
177669 | 93000 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | Tree 3 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
138913 | 93975 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden gate Ave Roselyn Ter | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 3 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
192464 | 94063 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
114047 | 93863 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree 3 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | |||
187571 | 93020 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | ||
46890 | 93060 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x5 | Tree 2 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
99593 | 92999 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Tree 2 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
173057 | 93974 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
173743 | 94062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
103086 | 93862 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree 2 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | |||
72816 | 93059 | Permitted Site 7 | Tree(s) :: 17 | 145 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x5 | Tree 1 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
186152 | 92965 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3650X Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Tree 1 on Rivera St | 5981790.1 | 2100170.3 | 37.7456119015234 | -122.505704709348 | (37.7456119015234, -122.505704709348) | 1 | 8 | 3 | 29491 | 35 | ||
161927 | 92973 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Market St. | 6001664 | 2105786 | 37.7621809066996 | -122.437385951828 | (37.7621809066996, -122.437385951828) | 15 | 5 | 5 | 28862 | 3 | ||||
191783 | 93021 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.468484819075 | (37.7618848250494, -122.468484819075) | 1 | 8 | 4 | 56 | 12 | ||
104232 | 92998 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 395 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Tree 1 on Harrison St | 6013360.4 | 2113007 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | 6 | 2 | 9 | 28856 | 6 | ||
58625 | 93973 | Permitted Site 7 | Palm (unknown Genus) :: Palm Spp 273 | 59@ Golden gate Ave Roselyn Ter | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Tree 1 on Golden gate Ave | 5998204.2 | 2111419.4 | 37.7774514868833 | -122.449758011487 | (37.7774514868833, -122.449758011487) | 15 | 6 | 2 | 54 | 16 | ||||
166934 | 94061 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Craut. | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
73965 | 94067 | Permitted Site 7 | Tree(s) :: 17 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2010 12:00:00 AM | 3x3 | Tree 1 on 18th St. | 6015474 | 2105663 | 37.7626186026962 | -122.389613415677 | (37.7626186026962, -122.389613415677) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | |
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 | ||||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 |
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) );