trees
379 rows where qSpecies_id = 86 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 163744 | 179847 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 231 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6000051.92108 | 2092264.11906 | 37.7249612688295 | -122.441990900256 | (37.7249612688295, -122.441990900256) | 9 | 7 | 6 | 28861 | 25 | |||
| 79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
| 161950 | 179870 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 743 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6005435.63394 | 2092350.08273 | 37.7255026319158 | -122.423386095411 | (37.7255026319158, -122.423386095411) | 9 | 7 | 7 | 309 | 5 | |||
| 4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
| 179861 | 179869 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6005754.24665 | 2092349.7952 | 37.725519819773 | -122.422284657027 | (37.725519819773, -122.422284657027) | 9 | 7 | 7 | 309 | 5 | |||
| 126756 | 179845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 85 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000550.17873 | 2092849.30944 | 37.7265964485477 | -122.44031043159 | (37.7265964485477, -122.44031043159) | 9 | 7 | 6 | 28861 | 25 | ||||
| 14728 | 62484 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.98588 | 37.7266678079605 | -122.440260189157 | (37.7266678079605, -122.440260189157) | 9 | 7 | 6 | 28861 | 25 | |
| 39108 | 179880 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6007526.36673 | 2092824.84352 | 37.7269240023301 | -122.416192203412 | (37.7269240023301, -122.416192203412) | 9 | 3 | 7 | 309 | 28 | |||
| 39011 | 179881 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1151 Felton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007539.25103 | 2092829.10153 | 37.7269364183715 | -122.416147963965 | (37.7269364183715, -122.416147963965) | 9 | 3 | 7 | 309 | 28 | |||
| 145353 | 179859 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 71 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004926.25969 | 2092979.13729 | 37.7272011149393 | -122.425191700232 | (37.7272011149393, -122.425191700232) | 9 | 7 | 6 | 28861 | 5 | ||||
| 125001 | 179872 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 66 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005421.70819 | 2093230.42134 | 37.7279190626089 | -122.423496793843 | (37.7279190626089, -122.423496793843) | 9 | 7 | 6 | 28861 | 5 | |||
| 70182 | 179871 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Athens St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005395.25697 | 2093256.97645 | 37.7279904840704 | -122.423590123686 | (37.7279904840704, -122.423590123686) | 9 | 7 | 6 | 28861 | 5 | ||||
| 133906 | 179882 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005924.81091 | 2093297.57145 | 37.7281318260086 | -122.421762319978 | (37.7281318260086, -122.421762319978) | 9 | 7 | 7 | 309 | 5 | |||
| 144877 | 179883 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 39 Amherst St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007323.05766 | 2093363.44581 | 37.7283914539998 | -122.416933184515 | (37.7283914539998, -122.416933184515) | 9 | 3 | 7 | 309 | 5 | |||
| 133462 | 179834 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001971.52486 | 2093519.43437 | 37.7285172835473 | -122.435444813332 | (37.7285172835473, -122.435444813332) | 9 | 7 | 6 | 28861 | 25 | |||
| 80235 | 179835 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001963.44434 | 2093526.42722 | 37.7285360253961 | -122.435473248114 | (37.7285360253961, -122.435473248114) | 9 | 7 | 6 | 28861 | 25 | |||
| 40385 | 215342 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999549.56796 | 2093580.96212 | 37.7285483748934 | -122.443822037778 | (37.7285483748934, -122.443822037778) | 9 | 7 | 4 | 63 | 40 | |||
| 46050 | 215344 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | 9 | 7 | 4 | 63 | 40 | |||
| 27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
| 87437 | 179846 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.7286106583386 | -122.440994678056 | (37.7286106583386, -122.440994678056) | 9 | 7 | 6 | 28861 | 25 | |||
| 104877 | 179837 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Santa Rosa Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6000743.66321 | 2093585.989 | 37.728630215899 | -122.439694355537 | (37.728630215899, -122.439694355537) | 9 | 7 | 6 | 28861 | 25 | |||
| 38090 | 949 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/1990 12:00:00 AM | 6 | 3X6 | 6002168.03285 | 2093561.19975 | 37.7286431202677 | -122.434768461095 | (37.7286431202677, -122.434768461095) | 9 | 7 | 6 | 28861 | 25 | ||
| 124331 | 215343 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999604.29165 | 2093616.12751 | 37.7286480521422 | -122.443635380789 | (37.7286480521422, -122.443635380789) | 9 | 7 | 4 | 63 | 40 | |||
| 123804 | 179868 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 345 Congdon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6004732.69466 | 2093569.91681 | 37.7288123277178 | -122.425902888604 | (37.7288123277178, -122.425902888604) | 9 | 7 | 6 | 28861 | 5 | |||
| 81457 | 179891 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008528.33324 | 2093531.3526 | 37.7289202139869 | -122.41277834095 | (37.7289202139869, -122.41277834095) | 9 | 3 | 7 | 309 | 28 | |||
| 126177 | 179892 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008521.95318 | 2093544.04536 | 37.728954707483 | -122.412801294348 | (37.728954707483, -122.412801294348) | 9 | 3 | 7 | 309 | 28 | |||
| 44005 | 179893 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 101 Dartmouth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008518.11565 | 2093559.33094 | 37.7289964630154 | -122.412815641254 | (37.7289964630154, -122.412815641254) | 9 | 3 | 7 | 309 | 28 | |||
| 190275 | 215305 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Gennessee St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5997468.9434 | 2093863.63233 | 37.7292056228286 | -122.451035210326 | (37.7292056228286, -122.451035210326) | 9 | 7 | 4 | 28861 | 40 | |||
| 169145 | 179841 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002653.07168 | 2093883.32374 | 37.7295551254715 | -122.433114660921 | (37.7295551254715, -122.433114660921) | 9 | 7 | 6 | 28861 | 25 | |||
| 35581 | 179842 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002649.41519 | 2093884.99893 | 37.7295595177473 | -122.433127421409 | (37.7295595177473, -122.433127421409) | 9 | 7 | 6 | 28861 | 25 | |||
| 141539 | 179840 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6002632.59127 | 2093895.12097 | 37.7295863562117 | -122.433186306304 | (37.7295863562117, -122.433186306304) | 9 | 7 | 6 | 28861 | 25 | |||
| 122170 | 179839 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002619.90718 | 2093903.00137 | 37.7296072744596 | -122.433230719323 | (37.7296072744596, -122.433230719323) | 9 | 7 | 6 | 28861 | 25 | |||
| 56948 | 179838 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002614.6695 | 2093907.99697 | 37.7296206941164 | -122.433249183323 | (37.7296206941164, -122.433249183323) | 9 | 7 | 6 | 28861 | 25 | |||
| 173813 | 179843 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6003264.53226 | 2094054.72637 | 37.7300604248468 | -122.431013009142 | (37.7300604248468, -122.431013009142) | 9 | 7 | 6 | 28861 | 25 | |||
| 46559 | 179844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003286.16791 | 2094080.48748 | 37.7301323849801 | -122.430940049855 | (37.7301323849801, -122.430940049855) | 9 | 7 | 6 | 28861 | 25 | |||
| 4119 | 179884 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007440.99847 | 2094010.17739 | 37.7301738725104 | -122.416571250581 | (37.7301738725104, -122.416571250581) | 9 | 3 | 7 | 309 | 28 | |||
| 105096 | 179885 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6007447.44417 | 2094010.42268 | 37.7301749085276 | -122.416548984266 | (37.7301749085276, -122.416548984266) | 9 | 3 | 7 | 309 | 28 | |||
| 54391 | 179886 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6007455.79909 | 2094011.3835 | 37.7301780166028 | -122.416520168176 | (37.7301780166028, -122.416520168176) | 9 | 3 | 7 | 309 | 28 | |||
| 12690 | 179887 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 675 Sweeny St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007462.62751 | 2094011.80961 | 37.7301795706263 | -122.416496591546 | (37.7301795706263, -122.416496591546) | 9 | 3 | 7 | 309 | 28 | |||
| 106736 | 179905 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1216 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 6008780.07198 | 2094033.26413 | 37.7303124823168 | -122.411943512893 | (37.7303124823168, -122.411943512893) | 9 | 3 | 7 | 309 | 28 | |||
| 37296 | 179836 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002646.43295 | 2094204.87454 | 37.7304376544756 | -122.433160577611 | (37.7304376544756, -122.433160577611) | 9 | 7 | 5 | 28861 | 25 | |||
| 47539 | 31120 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34839 | 5998792.22814 | 2094324.02861 | 37.7305454337211 | -122.446493629496 | (37.7305454337211, -122.446493629496) | 9 | 7 | 4 | 28861 | 40 | |
| 34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
| 149391 | 215296 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5997379.68023 | 2094370.54244 | 37.7305923666319 | -122.451380344931 | (37.7305923666319, -122.451380344931) | 9 | 7 | 4 | 28861 | 40 | |||
| 51255 | 215297 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5997404.12695 | 2094370.52949 | 37.7305937308948 | -122.45129582845 | (37.7305937308948, -122.45129582845) | 9 | 7 | 4 | 28861 | 40 | |||
| 34915 | 215298 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000134.87473 | 2094332.54938 | 37.7306454275316 | -122.441852526992 | (37.7306454275316, -122.441852526992) | 9 | 7 | 4 | 63 | 40 | |||
| 87428 | 215300 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000205.65358 | 2094331.35281 | 37.730646174877 | -122.441607748599 | (37.730646174877, -122.441607748599) | 9 | 7 | 4 | 63 | 40 | |||
| 134958 | 215299 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6000184.62411 | 2094332.33386 | 37.730647670445 | -122.441680520847 | (37.730647670445, -122.441680520847) | 9 | 7 | 4 | 63 | 40 | |||
| 29990 | 215341 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6000114.95424 | 2094335.27384 | 37.7306517731413 | -122.441921590428 | (37.7306517731413, -122.441921590428) | 9 | 7 | 4 | 63 | 40 | |||
| 167373 | 215302 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 698 Hearst Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5996836.53539 | 2094438.39167 | 37.7307475482438 | -122.453262964135 | (37.7307475482438, -122.453262964135) | 9 | 7 | 4 | 59 | 40 | |||
| 71787 | 256414 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 110991 | 256413 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 163182 | 256443 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 3001 Sunset Blvd | 27 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 173401 | 179888 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6008315.20524 | 2094307.45797 | 37.7310392676412 | -122.413570011448 | (37.7310392676412, -122.413570011448) | 9 | 3 | 7 | 309 | 28 | |||
| 70544 | 179889 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008314.8677 | 2094310.92324 | 37.7310487635727 | -122.41357142338 | (37.7310487635727, -122.41357142338) | 9 | 3 | 7 | 309 | 28 | |||
| 175071 | 179890 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Dartmouth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6008311.43296 | 2094322.79302 | 37.7310811625636 | -122.413584137105 | (37.7310811625636, -122.413584137105) | 9 | 3 | 7 | 309 | 28 | |||
| 54533 | 215301 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001252.93679 | 2094603.03258 | 37.7314517578791 | -122.438006591549 | (37.7314517578791, -122.438006591549) | 9 | 7 | 4 | 63 | 40 | |||
| 12934 | 16022 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001242.37794 | 2094603.69246 | 37.7314529692816 | -122.438043142671 | (37.7314529692816, -122.438043142671) | 9 | 7 | 4 | 63 | 40 | |||
| 145014 | 256324 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3000X Sunset Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
| 125099 | 215304 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5997552.24164 | 2094964.50066 | 37.7322331140486 | -122.450826587399 | (37.7322331140486, -122.450826587399) | 9 | 7 | 4 | 59 | 40 | ||||
| 20747 | 215303 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.450847264584 | (37.7322337966419, -122.450847264584) | 9 | 7 | 4 | 59 | 40 | ||||
| 54331 | 215340 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999417.92849 | 2095175.79644 | 37.7329199074284 | -122.444391688153 | (37.7329199074284, -122.444391688153) | 9 | 7 | 4 | 59 | 40 | |||
| 8931 | 215339 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999420.83111 | 2095184.41503 | 37.7329437376643 | -122.444382272244 | (37.7329437376643, -122.444382272244) | 9 | 7 | 4 | 59 | 40 | |||
| 33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
| 35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 56720 | 116300 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 112452 | 116298 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 175531 | 116299 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
| 42725 | 215295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001248.26665 | 2095899.59415 | 37.7350115506281 | -122.43811558039 | (37.7350115506281, -122.43811558039) | 2 | 7 | 5 | 63 | 7 | |||
| 126944 | 241063 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005947.85615 | 2095824.2566 | 37.73507084564 | -122.421862055716 | (37.73507084564, -122.421862055716) | 2 | 7 | 7 | 28859 | 2 | |||
| 68300 | 241061 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 6005940.184 | 2095824.54912 | 37.7350712161596 | -122.421888601897 | (37.7350712161596, -122.421888601897) | 2 | 7 | 7 | 28859 | 2 | |||
| 128394 | 241062 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005944.68012 | 2095825.54843 | 37.7350742136048 | -122.421873128139 | (37.7350742136048, -122.421873128139) | 2 | 7 | 7 | 28859 | 2 | |||
| 63554 | 241060 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.7350755589952 | -122.421928139697 | (37.7350755589952, -122.421928139697) | 2 | 7 | 7 | 28859 | 2 | |||
| 188876 | 241058 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005911.64547 | 2095827.03332 | 37.7350764277212 | -122.421987446374 | (37.7350764277212, -122.421987446374) | 2 | 7 | 7 | 28859 | 2 | |||
| 65143 | 241059 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005916.72603 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | 2 | 7 | 7 | 28859 | 2 | |||
| 753 | 197913 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Conkling St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6011758.24884 | 2095732.01029 | 37.7351435225424 | -122.40176684758 | (37.7351435225424, -122.40176684758) | 10 | 3 | 8 | 58 | 1 | |||
| 24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
| 37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
| 92456 | 215336 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998234.84844 | 2096392.28962 | 37.7361925349403 | -122.448569464424 | (37.7361925349403, -122.448569464424) | 9 | 7 | 4 | 59 | 40 | |||
| 88955 | 215335 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998237.40059 | 2096398.28008 | 37.7362091292407 | -122.448561071933 | (37.7362091292407, -122.448561071933) | 9 | 7 | 4 | 59 | 40 | |||
| 142955 | 215334 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998241.14099 | 2096403.03655 | 37.7362224032408 | -122.448548482343 | (37.7362224032408, -122.448548482343) | 9 | 7 | 4 | 59 | 40 | |||
| 152327 | 17449 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012949.37731 | 2096657.76915 | 37.7377518631542 | -122.39771357075 | (37.7377518631542, -122.39771357075) | 10 | 3 | 8 | 58 | 1 | |||
| 146312 | 17448 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012936.47341 | 2096667.45251 | 37.7377777330535 | -122.397758865084 | (37.7377777330535, -122.397758865084) | 10 | 3 | 8 | 58 | 1 | |||
| 105769 | 17447 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1967 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 3X3 | 6012920.44639 | 2096678.64853 | 37.7378075824587 | -122.397815063738 | (37.7378075824587, -122.397815063738) | 10 | 3 | 8 | 58 | 1 | |||
| 112263 | 97298 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 151400 | 97300 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
| 183619 | 215325 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992027.65667 | 2098311.13553 | 37.7411043262013 | -122.470169759048 | (37.7411043262013, -122.470169759048) | 1 | 8 | 4 | 59 | 40 | |||
| 157310 | 215326 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992028.53266 | 2098327.51469 | 37.7411493498502 | -122.470167922636 | (37.7411493498502, -122.470167922636) | 1 | 8 | 4 | 59 | 40 | |||
| 192763 | 215327 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992028.3413 | 2098343.65136 | 37.7411936459769 | -122.470169759049 | (37.7411936459769, -122.470169759049) | 1 | 8 | 4 | 59 | 40 | |||
| 138676 | 215328 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992029.37698 | 2098355.00215 | 37.7412248722329 | -122.470167004418 | (37.7412248722329, -122.470167004418) | 1 | 8 | 4 | 59 | 40 | |||
| 157108 | 114608 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 2398X 15TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5991654 | 2099150 | 37.7433860243849 | -122.471522828523 | (37.7433860243849, -122.471522828523) | 1 | 8 | 4 | 29491 | 40 | ||||
| 69762 | 11201 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 100 Idora Ave | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | 1 | 8 | 4 | 59 | 40 | |||
| 5600 | 241053 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Coso Ave | 3 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6007672.87316 | 2099533.13544 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | 2 | 7 | 7 | 28859 | 2 | |||
| 27037 | 106347 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 415 DEWEY BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | |||||
| 129526 | 215329 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995144.12297 | 2100352.21108 | 37.7468882889814 | -122.459542009073 | (37.7468882889814, -122.459542009073) | 1 | 8 | 4 | 59 | 40 | |||
| 148964 | 241064 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002651.6707 | 2100291.95945 | 37.7471516815152 | -122.433577323454 | (37.7471516815152, -122.433577323454) | 2 | 7 | 5 | 63 | 22 | ||||
| 48837 | 241065 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002656.66446 | 2100292.18739 | 37.7471525907236 | -122.433560071737 | (37.7471525907236, -122.433560071737) | 2 | 7 | 5 | 63 | 22 | ||||
| 156304 | 241066 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002659.6635 | 2100292.45655 | 37.7471534999337 | -122.43354972054 | (37.7471534999337, -122.43354972054) | 2 | 7 | 5 | 63 | 22 | ||||
| 166505 | 215294 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 275 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5994441.43842 | 2100548.35757 | 37.7473864279531 | -122.461986030947 | (37.7473864279531, -122.461986030947) | 1 | 8 | 4 | 29491 | 40 |
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) );