trees
194,517 rows sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1090 | 260553 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 09/21/2019 12:00:00 AM | 3 | ||||||||||||
2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
6898 | 43451 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.13158 | 2091140.97159 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | 9 | 7 | 6 | 28861 | 25 | |
6925 | 43437 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.91122 | 37.7223551630339 | -122.444242104791 | (37.7223551630339, -122.444242104791) | 9 | 7 | 6 | 28861 | 25 | |
8442 | 43966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/24/2000 12:00:00 AM | 9 | Permit Number 43534 | 6006884.39072 | 2112892.55093 | 37.7819892007742 | -122.419834861512 | (37.7819892007742, -122.419834861512) | 7 | 9 | 9 | 28852 | 36 | |
14808 | 43442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.7222544731451 | -122.443973794765 | (37.7222544731451, -122.443973794765) | 9 | 7 | 6 | 28861 | 25 | |
15094 | 43443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.7222365289812 | -122.44393453037 | (37.7222365289812, -122.44393453037) | 9 | 7 | 6 | 28861 | 25 | |
15705 | 260554 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/26/2017 12:00:00 AM | 3 | ||||||||||||
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
23754 | 113821 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 4101x 25TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
24009 | 43438 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | 9 | 7 | 6 | 28861 | 25 | |
24920 | 81846 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) | 13 | 9 | 10 | 28858 | 21 |
26910 | 111776 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
27209 | 43436 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.97046 | 2091192.04874 | 37.7219945825726 | -122.443310340608 | (37.7219945825726, -122.443310340608) | 9 | 7 | 6 | 28861 | 25 | |
27628 | 43446 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.443231082473 | (37.721961717728, -122.443231082473) | 9 | 7 | 6 | 28861 | 25 | |
30190 | 43448 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | 9 | 7 | 6 | 28861 | 25 | |
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
39489 | 111135 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 2 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | ||
40162 | 95366 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.425183031522 | (37.8041229057048, -122.425183031522) | 13 | 9 | 1 | 28858 | 17 | ||
41146 | 43456 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999514.70275 | 2091259.45123 | 37.7221720538917 | -122.443775852197 | (37.7221720538917, -122.443775852197) | 9 | 7 | 6 | 28861 | 25 | |
41337 | 81843 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
45020 | 111128 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | ||
49365 | 43453 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999638.45654 | 2091195.87208 | 37.7220045380552 | -122.443343502225 | (37.7220045380552, -122.443343502225) | 9 | 7 | 6 | 28861 | 25 | |
50286 | 113709 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
51635 | 43454 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 11 | Permit Number 43162 | 5999613.63458 | 2091208.86715 | 37.7220388040182 | -122.443430238238 | (37.7220388040182, -122.443430238238) | 9 | 7 | 6 | 28861 | 25 | |
52169 | 111442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 8 | 5999909.42688 | 2091057.17434 | 37.7216391542992 | -122.44239687581 | (37.7216391542992, -122.44239687581) | 9 | 7 | 6 | 28861 | 25 | |||
52668 | 113708 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
55608 | 43458 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999537.11613 | 2091248.65338 | 37.72214368387 | -122.443697599487 | (37.72214368387, -122.443697599487) | 9 | 7 | 6 | 28861 | 25 | |
62163 | 144 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | 15 | 5 | 5 | 28862 | 3 | ||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
64581 | 99308 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1902X 41st Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
67117 | 105655 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
71335 | 43459 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999660.0285 | 2091185.48027 | 37.7219772346577 | -122.443268187573 | (37.7219772346577, -122.443268187573) | 9 | 7 | 6 | 28861 | 25 | |
72388 | 82383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 | |
73737 | 113813 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
74404 | 111444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.7215516403644 | -122.442184051271 | (37.7215516403644, -122.442184051271) | 9 | 7 | 6 | 28861 | 25 | ||
74558 | 111133 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
74998 | 43439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.7222809168058 | -122.444048388121 | (37.7222809168058, -122.444048388121) | 9 | 7 | 6 | 28861 | 25 | |
79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
82558 | 98222 | DPW Maintained 1 | Eucalyptus macarthuri :: Camden Wollybutt 516 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
82890 | 43444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999490.75065 | 2091271.846 | 37.7222047208672 | -122.443859538611 | (37.7222047208672, -122.443859538611) | 9 | 7 | 6 | 28861 | 25 | |
83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
87336 | 113817 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
87604 | 81841 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
87682 | 113810 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |||
88456 | 113809 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
89407 | 98217 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
90434 | 113818 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
92535 | 107891 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
98832 | 81842 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
99974 | 43441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | 9 | 7 | 6 | 28861 | 25 | |
101614 | 113808 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
102600 | 107890 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
105012 | 43447 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999697.54909 | 2091165.42889 | 37.7219243176433 | -122.443137049362 | (37.7219243176433, -122.443137049362) | 9 | 7 | 6 | 28861 | 25 | |
111923 | 81845 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.7897041006217 | -122.419274608151 | (37.7897041006217, -122.419274608151) | 13 | 9 | 10 | 28858 | 21 |
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
113750 | 43445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999858.82768 | 2091082.35027 | 37.7217053974709 | -122.442573589903 | (37.7217053974709, -122.442573589903) | 9 | 7 | 6 | 28861 | 25 | |
116073 | 111445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 7 | 5999980.84773 | 2091017.84349 | 37.7215352313433 | -122.442147171851 | (37.7215352313433, -122.442147171851) | 9 | 7 | 6 | 28861 | 25 | |||
116839 | 99309 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.499188691375 | (37.7494969779561, -122.499188691375) | 1 | 8 | 3 | 29491 | 35 | ||
120864 | 113819 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
124997 | 113812 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 1 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
126055 | 43435 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.442711119627 | (37.7217631321556, -122.442711119627) | 9 | 7 | 6 | 28861 | 25 | |
128478 | 111134 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
129541 | 111443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | 9 | 7 | 6 | 28861 | 25 | |||
130117 | 113705 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | ||
132280 | 43432 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | 9 | 7 | 6 | 28861 | 25 | |
134473 | 43434 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.83279 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | 9 | 7 | 6 | 28861 | 25 | |
135580 | 111441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5 | 5999897.1183 | 2091063.84845 | 37.7216567783095 | -122.442439902078 | (37.7216567783095, -122.442439902078) | 9 | 7 | 6 | 28861 | 25 | |||
135831 | 81840 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
136434 | 43457 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.7221892471271 | -122.443818239036 | (37.7221892471271, -122.443818239036) | 9 | 7 | 6 | 28861 | 25 | |
139145 | 43449 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | 9 | 7 | 6 | 28861 | 25 | |
143725 | 113706 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
144216 | 111439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6 | 5999870.68262 | 2091075.24274 | 37.7216865575792 | -122.442532100582 | (37.7216865575792, -122.442532100582) | 9 | 7 | 6 | 28861 | 25 | |||
144463 | 43455 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||
146800 | 172952 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.424987312212 | (37.8034425497953, -122.424987312212) | 13 | 9 | 1 | 28858 | 32 | ||
147039 | 98216 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.501501543012 | (37.7576365448231, -122.501501543012) | 1 | 8 | 3 | 56 | 35 | ||
147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
148472 | 113707 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2801x CLEMENT ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4x4 | 5986698 | 2113245 | 37.7817990393362 | -122.4896955071 | (37.7817990393362, -122.4896955071) | 11 | 6 | 2 | 55 | 26 | |||
149820 | 43450 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.7218800449238 | -122.443027412104 | (37.7218800449238, -122.443027412104) | 9 | 7 | 6 | 28861 | 25 | |
152081 | 111131 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
152631 | 98218 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 3 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
153397 | 98220 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1501X 42nd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
154938 | 113811 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
158125 | 229287 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 420 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 2 | 6x6 | 6004863.64618 | 2105856.17124 | 37.7625549619753 | -122.426324583413 | (37.7625549619753, -122.426324583413) | 8 | 4 | 5 | 28859 | 3 | ||
167633 | 81844 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1421 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 09/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007169.78114 | 2115706.72596 | 37.7897323105397 | -122.419047208268 | (37.7897323105397, -122.419047208268) | 13 | 9 | 10 | 28858 | 21 |
171772 | 140269 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 2040 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998144.7463 | 2109987.1343 | 37.7735154534297 | -122.449860434482 | (37.7735154534297, -122.449860434482) | 15 | 5 | 11 | 29492 | 16 | |
172013 | 43433 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | 9 | 7 | 6 | 28861 | 25 | |
175403 | 111129 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
177608 | 113816 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
177877 | 113822 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 4101x 25TH ST | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
178823 | 81839 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.7897129400157 | -122.419194651452 | (37.7897129400157, -122.419194651452) | 13 | 9 | 10 | 28858 | 21 |
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
179503 | 113815 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 4101x 25TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 8 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
184999 | 43452 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.443557397876 | (37.7220903846374, -122.443557397876) | 9 | 7 | 6 | 28861 | 25 | |
185385 | 111132 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 2030x HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5x5.5 | 5998060 | 2109954 | 37.7734196259383 | -122.450151194281 | (37.7734196259383, -122.450151194281) | 15 | 5 | 11 | 29492 | 16 | |||
186111 | 105656 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 05/09/2014 12:00:00 AM | 3 | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||
186295 | 105654 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 05/09/2014 12:00:00 AM | 3 | 3x3 | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 |
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) );