trees
8,298 rows where qLegalStatus_id = 4 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
508 | 113374 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 88 HOWARD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | ||||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
1232 | 264776 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
1256 | 97187 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
1442 | 103437 | Undocumented 4 | Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 | 50X Bluxome St | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2072 | 259693 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 30 Lafayette St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007347 | 2109367 | 37.7723349336637 | -122.417984438142 | (37.7723349336637, -122.417984438142) | 8 | 2 | 9 | 28853 | 19 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2258 | 264781 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
2261 | 101055 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2436 | 102404 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2733 | 107738 | Undocumented 4 | Tree(s) :: 17 | 155x HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774227 | 6007127.8 | 2111172.9 | 37.7772811641179 | -122.41887077508 | (37.7772811641179, -122.41887077508) | 7 | 9 | 9 | 28852 | 36 | |
2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
3022 | 264768 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
3300 | 113370 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 88 HOWARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | ||||
3301 | 102850 | Undocumented 4 | Tree(s) :: 17 | 25X Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3775 | 262460 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 88 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009992 | 2112469 | 37.7810008079546 | -122.409054015659 | (37.7810008079546, -122.409054015659) | 14 | 2 | 9 | 28853 | 34 | ||||
4013 | 264857 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
4070 | 262551 | Undocumented 4 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1835 Owens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014708 | 2106994 | 37.7662307347547 | -122.392355853292 | (37.7662307347547, -122.392355853292) | 14 | 3 | 9 | 310 | 29 | ||||
4185 | 262568 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4200 | 262567 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
4280 | 264767 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 90x Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
4382 | 264774 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
4689 | 100758 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700X Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012260.07583 | 2110177.24035 | 37.7748349572731 | -122.401046493351 | (37.7748349572731, -122.401046493351) | 14 | 2 | 9 | 28853 | 34 | |||
4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
5012 | 261384 | Undocumented 4 | Potential Site :: Potential Site 48 | 246 Leavenworth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008558 | 2113314 | 37.7832405398106 | -122.41407474629 | (37.7832405398106, -122.41407474629) | 7 | 10 | 9 | 28852 | 36 | |||||
5054 | 102983 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
5372 | 256588 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
5493 | 264903 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
5615 | 200997 | Undocumented 4 | Potential Site :: Potential Site 48 | 150 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | Permit Number 778623 | 6015155.9522 | 2115579.6824 | 37.7898299587744 | -122.391406724 | (37.7898299587744, -122.391406724) | 6 | 2 | 9 | 28855 | 6 | ||
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
6007 | 261051 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
6742 | 264909 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
7099 | 103526 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
7151 | 117089 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 200X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
7269 | 72440 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6012482 | 2109734 | 37.7736302975223 | -122.400247669168 | (37.7736302975223, -122.400247669168) | 14 | 2 | 9 | 28853 | 34 | ||
7613 | 262571 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
7669 | 101056 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
7713 | 264772 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
7931 | 260390 | Undocumented 4 | Tree(s) :: 17 | 501x Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009931 | 2112548 | 37.7812143059327 | -122.409270622322 | (37.7812143059327, -122.409270622322) | 14 | 2 | 9 | 28853 | 34 | ||||
7948 | 259183 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 35 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6007987.0607 | 2111156.01389 | 37.7772831438281 | -122.415897110674 | (37.7772831438281, -122.415897110674) | 8 | 2 | 9 | 28853 | 34 | ||||
7972 | 264777 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
8223 | 262569 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
8245 | 259048 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
8789 | 110821 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1X WELSH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013408 | 2111682 | 37.7790306545162 | -122.397181094632 | (37.7790306545162, -122.397181094632) | 6 | 2 | 9 | 28856 | 34 | |||
9120 | 262556 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
9284 | 259046 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
9425 | 264770 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
9436 | 115038 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 788 HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777510 | 6012725 | 2112521 | 37.7812963087062 | -122.399602805279 | (37.7812963087062, -122.399602805279) | 6 | 2 | 9 | 28856 | 34 | |
9438 | 115058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013762 | 2111312 | 37.7780344196247 | -122.395930522096 | (37.7780344196247, -122.395930522096) | 6 | 2 | 9 | 28856 | 34 | ||||
9840 | 256599 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 2x Stillman St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
9864 | 102975 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
10006 | 200995 | Undocumented 4 | Potential Site :: Potential Site 48 | 150 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | Permit Number 778623 | 6015191.9409 | 2115616.6994 | 37.7899335962877 | -122.391284794105 | (37.7899335962877, -122.391284794105) | 6 | 2 | 9 | 28855 | 6 | ||
10281 | 262560 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
10424 | 259047 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
10663 | 264778 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
10726 | 113513 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 352 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008306 | 2113136 | 37.7827376375446 | -122.414933965724 | (37.7827376375446, -122.414933965724) | 7 | 10 | 9 | 28852 | 36 | ||||
11312 | 110827 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1X WELSH ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013408 | 2111682 | 37.7790306545162 | -122.397181094632 | (37.7790306545162, -122.397181094632) | 6 | 2 | 9 | 28856 | 34 | |||
11559 | 261050 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
11636 | 249410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 698 Polk St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6007114.55441 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | 7 | 9 | 9 | 28852 | 36 | |||
11719 | 264769 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
11738 | 259182 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 35 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6007987.0607 | 2111156.01389 | 37.7772831438281 | -122.415897110674 | (37.7772831438281, -122.415897110674) | 8 | 2 | 9 | 28853 | 34 | ||||
11739 | 264780 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
12000 | 261047 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006673 | 2113065 | 37.7824507928685 | -122.420578423098 | (37.7824507928685, -122.420578423098) | 7 | 9 | 9 | 28852 | 36 | ||||
12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
12099 | 102848 | Undocumented 4 | Tree(s) :: 17 | 31 Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
12634 | 264775 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 90x Guy Pl | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
12672 | 104797 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 342 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014205.7 | 2115535.6 | 37.7896561328511 | -122.394691444468 | (37.7896561328511, -122.394691444468) | 6 | 2 | 9 | 28855 | 6 | ||||
12931 | 264773 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
13440 | 264856 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
13739 | 103425 | Undocumented 4 | Podocarpus henkelii :: Long-Leafed Yellow-Wood 187 | 50X Bluxome St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
13754 | 100722 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1445X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009133 | 2108884.6 | 37.7711107319532 | -122.411772383651 | (37.7711107319532, -122.411772383651) | 8 | 2 | 9 | 28853 | 34 | |||
13756 | 261045 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 750 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006673 | 2113065 | 37.7824507928685 | -122.420578423098 | (37.7824507928685, -122.420578423098) | 7 | 9 | 9 | 28852 | 36 | ||||
14399 | 262550 | Undocumented 4 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1835 Owens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014708 | 2106994 | 37.7662307347547 | -122.392355853292 | (37.7662307347547, -122.392355853292) | 14 | 3 | 9 | 310 | 29 | ||||
14738 | 103343 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
14834 | 263588 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | ||||
14967 | 108631 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 501 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008465.6 | 2113811.6 | 37.7846016393538 | -122.4144296353 | (37.7846016393538, -122.4144296353) | 7 | 10 | 9 | 28852 | 36 | ||||
15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
15238 | 261049 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 770 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2113137 | 37.7826496144307 | -122.420514344125 | (37.7826496144307, -122.420514344125) | 7 | 9 | 9 | 28852 | 36 | ||||
15329 | 264906 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
15440 | 262565 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15616 | 264771 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 90x Guy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014171 | 2114529 | 37.7868903128003 | -122.3947409816 | (37.7868903128003, -122.3947409816) | 6 | 2 | 9 | 28855 | 6 | ||||
15642 | 102891 | Undocumented 4 | Tree(s) :: 17 | 115 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008968 | 2112966 | 37.7823080347026 | -122.412631696322 | (37.7823080347026, -122.412631696322) | 7 | 10 | 9 | 28852 | 36 | ||||
15706 | 110811 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 2X FREELON ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013408 | 2111682 | 37.7790306545162 | -122.397181094632 | (37.7790306545162, -122.397181094632) | 6 | 2 | 9 | 28856 | 34 | ||||
15813 | 262563 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 |
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) );