trees
379 rows where qSpecies_id = 86 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5035 | 103624 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
| 5344 | 102057 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1x1 | Permit Number 18946 | 6001387 | 2105809 | 37.7622283076155 | -122.438345635253 | (37.7622283076155, -122.438345635253) | 15 | 5 | 5 | 28862 | 3 | |||
| 7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
| 13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
| 25989 | 101973 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1695 21st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | Permit Number 769633 | 5989621.7 | 2103844.4 | 37.7561578263999 | -122.478893204843 | (37.7561578263999, -122.478893204843) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||||
| 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 | ||||
| 43129 | 100849 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 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 | ||||
| 67917 | 87249 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||||
| 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 | ||||
| 73562 | 59560 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 5 Eureka St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/03/1981 12:00:00 AM | 1x1 | Permit Number 18946 | 6001393.95326629 | 2105805.98956595 | 37.7622204371899 | -122.438321370904 | (37.7622204371899, -122.438321370904) | 15 | 5 | 5 | 28862 | 3 | ||
| 106864 | 103625 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/04/2013 12:00:00 AM | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | |||
| 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 | ||||
| 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 | |||||
| 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 | ||||
| 132265 | 87248 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||
| 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 | ||||
| 146664 | 87250 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 236323 Larkin St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/19/2008 12:00:00 AM | 3x3 | Permit Number 50274 | 6006714 | 2119291 | 37.7995481543168 | -122.420878746938 | (37.7995481543168, -122.420878746938) | 5 | 9 | 1 | 28858 | 32 | ||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 191808 | 103623 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 333 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/04/2013 12:00:00 AM | 13x2 | Permit Number 770205 | 5987603.5 | 2115303.5 | 37.7875039187234 | -122.486714142272 | (37.7875039187234, -122.486714142272) | 11 | 6 | 1 | 55 | 33 | ||
| 29197 | 136662 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1307 Bay St | 4 | : | Tree | Private 2 | 1 | Width 1ft | 6004522.84241 | 2120815.90939 | 37.8036114118857 | -122.428569697738 | (37.8036114118857, -122.428569697738) | 13 | 9 | 1 | 28858 | 17 | |||
| 135535 | 120845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.85655 | 2113416.78862 | 37.7824580717728 | -122.478575916409 | (37.7824580717728, -122.478575916409) | 11 | 6 | 2 | 55 | 26 | |||
| 175109 | 120844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5989915.94097 | 2113420.78105 | 37.7824690387717 | -122.478575916411 | (37.7824690387717, -122.478575916411) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 5140 | 70173 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 246 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5992471.1879 | 2113801.97828 | 37.7836637247597 | -122.469763717453 | (37.7836637247597, -122.469763717453) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |
| 21045 | 179811 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1367 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 5999338.15399 | 2089837.49101 | 37.7182576053899 | -122.444284002399 | (37.7182576053899, -122.444284002399) | 9 | 7 | 6 | 28861 | 25 | |||
| 26893 | 241069 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 415 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6002146.1874 | 2103426.00537 | 37.7557283324003 | -122.435549412575 | (37.7557283324003, -122.435549412575) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 44958 | 136637 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997659.79036 | 2114483.77284 | 37.7858342881777 | -122.451862419331 | (37.7858342881777, -122.451862419331) | 15 | 6 | 1 | 54 | 31 | |||
| 46609 | 215311 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.93989 | 2088894.46571 | 37.7154733555918 | -122.455989631214 | (37.7154733555918, -122.455989631214) | 9 | 8 | 6 | 28861 | 24 | |||
| 49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 63804 | 179827 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002666.48138 | 2089402.27505 | 37.7172519286027 | -122.432748322975 | (37.7172519286027, -122.432748322975) | 9 | 7 | 6 | 28861 | 5 | |||
| 64521 | 179831 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991499.58423 | 2088662.21507 | 37.7145802532566 | -122.471292774854 | (37.7145802532566, -122.471292774854) | 9 | 8 | 6 | 64 | 24 | |||
| 65645 | 179865 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 279 Moscow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6004627.95191 | 2091486.48414 | 37.7230857614719 | -122.426116731211 | (37.7230857614719, -122.426116731211) | 9 | 7 | 6 | 28861 | 5 | |||
| 65762 | 136699 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008168.57169 | 2119227.42502 | 37.7994554738439 | -122.415840886849 | (37.7994554738439, -122.415840886849) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 85219 | 136636 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 91 Mayfair Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997648.25188 | 2114482.46822 | 37.7858300451643 | -122.451902244894 | (37.7858300451643, -122.451902244894) | 15 | 6 | 1 | 54 | 31 | |||
| 94393 | 68663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 142 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32570 | 5993373.867 | 2114549.20899 | 37.7857675498482 | -122.466695151518 | (37.7857675498482, -122.466695151518) | 11 | 6 | 2 | 54 | 11 | |
| 94688 | 215286 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1642 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5992803.42046 | 2104269.10188 | 37.757508190571 | -122.467920721889 | (37.757508190571, -122.467920721889) | 1 | 8 | 4 | 56 | 12 | |||
| 100575 | 136700 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1955 Jones St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6008170.72961 | 2119215.54579 | 37.7994229777558 | -122.415832578026 | (37.7994229777558, -122.415832578026) | 5 | 1 | 10 | 308 | 32 | |||
| 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 | |||
| 113257 | 215310 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 536 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 5995931.84882 | 2088877.77404 | 37.7154275189482 | -122.455988739984 | (37.7154275189482, -122.455988739984) | 9 | 8 | 6 | 28861 | 24 | |||
| 114841 | 179851 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998773.25514 | 2089930.66617 | 37.718481197523 | -122.44624330948 | (37.718481197523, -122.44624330948) | 9 | 7 | 6 | 28861 | 25 | |||
| 115107 | 123109 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992552.3957 | 2111792.37608 | 37.7781505989958 | -122.469336449069 | (37.7781505989958, -122.469336449069) | 11 | 6 | 2 | 54 | 11 | |||
| 115962 | 136711 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007948.87662 | 2120608.06628 | 37.8032340150017 | -122.416698973183 | (37.8032340150017, -122.416698973183) | 5 | 1 | 1 | 308 | 32 | |||
| 123638 | 179876 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007115.03067 | 2091796.72343 | 37.7240778683719 | -122.41754135197 | (37.7240778683719, -122.41754135197) | 9 | 7 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | ||||
| 127245 | 123108 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 534 11th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992553.53653 | 2111802.27469 | 37.7781778438173 | -122.469333223241 | (37.7781778438173, -122.469333223241) | 11 | 6 | 2 | 54 | 11 | |||
| 133349 | 136697 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007352.71781 | 2120177.3681 | 37.80201787889 | -122.418731441927 | (37.80201787889, -122.418731441927) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 134836 | 99719 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2164 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007186.17673 | 2119740.01598 | 37.8008076423232 | -122.419276711652 | (37.8008076423232, -122.419276711652) | 5 | 1 | 1 | 28858 | 32 | |||
| 140976 | 241054 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 877 Treat Ave | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6008599.28066 | 2103440.07697 | 37.7561313707826 | -122.413233475267 | (37.7561313707826, -122.413233475267) | 2 | 4 | 7 | 28859 | 19 | |||
| 144237 | 241072 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 121 Buena Vista Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001500.23395 | 2107474.74915 | 37.7668084854387 | -122.43807332932 | (37.7668084854387, -122.43807332932) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | ||||
| 155425 | 197901 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 578 San Bruno Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6010946.53736 | 2105641.36513 | 37.7623071159928 | -122.405270835575 | (37.7623071159928, -122.405270835575) | 8 | 3 | 8 | 28856 | 29 | |||
| 158694 | 197907 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012887.44209 | 2106652.03819 | 37.7651905214559 | -122.398628855746 | (37.7651905214559, -122.398628855746) | 14 | 3 | 8 | 28856 | 20 | |||
| 171818 | 179910 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5998425.41243 | 2088873.3917 | 37.7155582929503 | -122.447369596148 | (37.7155582929503, -122.447369596148) | 9 | 7 | 6 | 28861 | 25 | |||
| 175053 | 179875 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007112.5297 | 2091803.34556 | 37.7240959105931 | -122.417550466576 | (37.7240959105931, -122.417550466576) | 9 | 7 | 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 | |||
| 180866 | 179830 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 966 Randolph St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 5991498.1765 | 2088667.95393 | 37.7145959293389 | -122.471298058377 | (37.7145959293389, -122.471298058377) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
| 6275 | 215306 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994798.91109 | 2091839.85894 | 37.7234956059322 | -122.46011911751 | (37.7234956059322, -122.46011911751) | 9 | 8 | 4 | 28861 | 24 | |||
| 27598 | 179854 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | 9 | 7 | 6 | 28861 | 25 | ||||
| 30022 | 215307 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 490 Faxon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994799.16087 | 2091851.78305 | 37.7235283610397 | -122.460119117526 | (37.7235283610397, -122.460119117526) | 9 | 8 | 4 | 28861 | 24 | |||
| 55838 | 179815 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 5998907.25749 | 2087996.54696 | 37.713178199383 | -122.445641109954 | (37.713178199383, -122.445641109954) | 9 | 7 | 6 | 28861 | 25 | |||
| 59411 | 179908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002616.49516 | 2086635.08435 | 37.7096509944651 | -122.432723539456 | (37.7096509944651, -122.432723539456) | 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 | ||||
| 70723 | 179829 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700 France Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002680.04915 | 2089397.80932 | 37.7172404361776 | -122.432701106797 | (37.7172404361776, -122.432701106797) | 9 | 7 | 6 | 28861 | 5 | |||
| 96676 | 215308 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994977.25671 | 2089298.75113 | 37.7165285859022 | -122.459318680413 | (37.7165285859022, -122.459318680413) | 9 | 8 | 6 | 28861 | 24 | |||
| 108553 | 179909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002595.51683 | 2086620.13725 | 37.7096087631907 | -122.432794977119 | (37.7096087631907, -122.432794977119) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 126092 | 215309 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Montana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5994986.28741 | 2089298.56204 | 37.7165285859158 | -122.459287452364 | (37.7165285859158, -122.459287452364) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 157077 | 179866 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 279 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6004629.91456 | 2091490.19984 | 37.7230960748979 | -122.426110211111 | (37.7230960748979, -122.426110211111) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 166310 | 179817 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998649.3213 | 2087861.75891 | 37.712793372299 | -122.446522930295 | (37.712793372299, -122.446522930295) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 175671 | 67619 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.417492763389 | (37.7983521792584, -122.417492763389) | 5 | 1 | 10 | 28858 | 32 | |
| 181460 | 179828 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002676.62468 | 2089397.35699 | 37.7172389999654 | -122.432712911272 | (37.7172389999654, -122.432712911272) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 20054 | 179816 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5998896.47943 | 2087985.98749 | 37.713148590116 | -122.445677603554 | (37.713148590116, -122.445677603554) | 9 | 7 | 6 | 28861 | 25 | |||
| 24490 | 197906 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 75 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012889.3839 | 2106630.87087 | 37.7651325088853 | -122.398620653922 | (37.7651325088853, -122.398620653922) | 14 | 3 | 8 | 28856 | 20 | |||
| 31433 | 136684 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 57 Russell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6007021.76535 | 2118934.77129 | 37.7985873825495 | -122.41978847538 | (37.7985873825495, -122.41978847538) | 5 | 1 | 10 | 28858 | 32 | |||
| 41820 | 68457 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 119 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 12 | Permit Number 32319 | 5991463.79981 | 2114626.05304 | 37.7858681269791 | -122.473308986123 | (37.7858681269791, -122.473308986123) | 11 | 6 | 2 | 54 | 26 | |
| 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 | ||||
| 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 |
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) );