trees
1,377 rows where qSpecies_id = 61 sorted by qCaretaker_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45411 | 199928 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.7275881406952 | -122.385255868852 | (37.7275881406952, -122.385255868852) | 10 | 3 | 8 | 58 | 1 | ||
| 92591 | 199927 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | 10 | 3 | 8 | 58 | 1 | ||
| 154274 | 199930 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.7276906682215 | -122.385184171361 | (37.7276906682215, -122.385184171361) | 10 | 3 | 8 | 58 | 1 | ||
| 191358 | 199929 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | 10 | 3 | 8 | 58 | 1 | ||
| 32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 95484 | 98999 | DPW Maintained 1 | Tristania conferta :: 61 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |
| 162433 | 99007 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 76512 | 22419 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | 10 | 3 | 8 | 58 | 1 | ||
| 110034 | 22420 | DPW Maintained 1 | Tristania conferta :: 61 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.7251673144921 | -122.394239832818 | (37.7251673144921, -122.394239832818) | 10 | 3 | 8 | 58 | 1 | ||
| 49136 | 42633 | DPW Maintained 1 | Tristania conferta :: 61 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) | 13 | 9 | 1 | 57 | 17 |
| 209 | 138219 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | 15 | 6 | 2 | 54 | 16 | |||
| 369 | 138522 | Undocumented 4 | Tristania conferta :: 61 | 1602 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001658.1955 | 2114019.9111 | 37.7847888393579 | -122.437995843174 | (37.7847888393579, -122.437995843174) | 13 | 6 | 11 | 29490 | 13 | |||
| 899 | 9520 | DPW Maintained 1 | Tristania conferta :: 61 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.7801483287397 | -122.427928412048 | (37.7801483287397, -122.427928412048) | 7 | 9 | 11 | 29490 | 41 | ||
| 1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
| 1178 | 7095 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.7725188329855 | -122.45023961224 | (37.7725188329855, -122.45023961224) | 15 | 5 | 11 | 29492 | 16 | ||
| 1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
| 1445 | 140697 | DPW Maintained 1 | Tristania conferta :: 61 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.446098386426 | (37.7734481000077, -122.446098386426) | 15 | 5 | 11 | 29492 | 16 | |||
| 1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
| 2490 | 195264 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 771659 | 6011775.98455 | 2114888.82062 | 37.7877448438967 | -122.403052549837 | (37.7877448438967, -122.403052549837) | 12 | 2 | 9 | 28855 | 6 | |
| 3420 | 79436 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004047.0413 | 2110853.2815 | 37.7762296204821 | -122.429505312147 | (37.7762296204821, -122.429505312147) | 7 | 9 | 11 | 28852 | 10 | |||
| 3600 | 23929 | DPW Maintained 1 | Tristania conferta :: 61 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.7866478474124 | -122.431795587112 | (37.7866478474124, -122.431795587112) | 13 | 9 | 11 | 29490 | 27 | ||
| 3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
| 3757 | 29485 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | 10 | 3 | 8 | 58 | 1 | ||
| 4029 | 138227 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | 15 | 6 | 2 | 54 | 16 | |||
| 4086 | 69819 | DPW Maintained 1 | Tristania conferta :: 61 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.498762161048 | (37.7587956653789, -122.498762161048) | 1 | 8 | 3 | 56 | 35 | |||
| 4210 | 29504 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.385374410624 | (37.7276800583286, -122.385374410624) | 10 | 3 | 8 | 58 | 1 | ||
| 4257 | 4614 | DPW Maintained 1 | Tristania conferta :: 61 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | 3 | 1 | 10 | 308 | 4 | ||
| 4598 | 140349 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.428104489199 | (37.7829810622913, -122.428104489199) | 7 | 9 | 11 | 29490 | 41 | |||
| 4786 | 70866 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005878.7494 | 2111261.8484 | 37.7774549853258 | -122.423197973584 | (37.7774549853258, -122.423197973584) | 7 | 9 | 11 | 28852 | 10 | |||
| 4802 | 65984 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | 3 | 1 | 10 | 308 | 23 | |
| 4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
| 5148 | 247454 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003114.7156 | 2110238.7499 | 37.7744894374273 | -122.432686570898 | (37.7744894374273, -122.432686570898) | 15 | 9 | 11 | 29492 | 10 | |||
| 5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
| 5368 | 73913 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.423208392543 | (37.7775067029674, -122.423208392543) | 7 | 9 | 11 | 28852 | 10 | |||
| 5423 | 138217 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998640.9134 | 2112646.2616 | 37.7808451071221 | -122.448335652205 | (37.7808451071221, -122.448335652205) | 15 | 6 | 2 | 54 | 16 | |||
| 5852 | 83783 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004048.7127 | 2110839.5763 | 37.7761920840099 | -122.429498552699 | (37.7761920840099, -122.429498552699) | 7 | 9 | 11 | 28852 | 10 | |||
| 5979 | 137873 | DPW Maintained 1 | Tristania conferta :: 61 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | 13 | 9 | 11 | 28858 | 27 | |||
| 6244 | 138902 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004070.6412 | 2110683.9615 | 37.7757660455959 | -122.42941159626 | (37.7757660455959, -122.42941159626) | 7 | 9 | 11 | 28852 | 10 | |||
| 6338 | 141477 | DPW Maintained 1 | Tristania conferta :: 61 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | 15 | 6 | 2 | 54 | 16 | |||
| 6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
| 6717 | 138911 | DPW Maintained 1 | Tristania conferta :: 61 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | 7 | 9 | 11 | 28852 | 10 | |||
| 6940 | 140679 | DPW Maintained 1 | Tristania conferta :: 61 | 1303 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004187.9883 | 2112981.79 | 37.7820819575387 | -122.429169542785 | (37.7820819575387, -122.429169542785) | 7 | 9 | 11 | 29490 | 41 | |||
| 7492 | 138882 | DPW Maintained 1 | Tristania conferta :: 61 | 510 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004088.2198 | 2110564.2595 | 37.7754383685459 | -122.429342249625 | (37.7754383685459, -122.429342249625) | 7 | 9 | 11 | 28852 | 10 | |||
| 7542 | 247487 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002757.5424 | 2109611.6714 | 37.772747372498 | -122.433877269198 | (37.772747372498, -122.433877269198) | 15 | 5 | 11 | 29492 | 9 | |||
| 7868 | 140649 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | 15 | 5 | 2 | 29492 | 16 | |||
| 8686 | 199711 | DPW Maintained 1 | Tristania conferta :: 61 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | 10 | 3 | 8 | 58 | 1 | |||
| 8843 | 57906 | DPW Maintained 1 | Tristania conferta :: 61 | 643 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20197 | 6000071.8454 | 2111132.0779 | 37.7767692506982 | -122.443276587526 | (37.7767692506982, -122.443276587526) | 15 | 5 | 11 | 29492 | 16 | |
| 8845 | 21605 | DPW Maintained 1 | Tristania conferta :: 61 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | 13 | 9 | 11 | 28858 | 13 | |||
| 8910 | 74145 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005875.6011 | 2111298.5777 | 37.7775556573861 | -122.423211476089 | (37.7775556573861, -122.423211476089) | 7 | 9 | 11 | 28852 | 10 | |||
| 10009 | 141171 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002115.9977 | 2112972.331 | 37.7819384740439 | -122.436337000836 | (37.7819384740439, -122.436337000836) | 15 | 5 | 11 | 29490 | 41 | |||
| 10761 | 60596 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 18 | Permit Number 20216 | 6000702.1439 | 2111336.8084 | 37.7773673101232 | -122.441110894469 | (37.7773673101232, -122.441110894469) | 15 | 5 | 11 | 29492 | 41 | |
| 10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
| 10938 | 28832 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | 10 | 3 | 8 | 58 | 1 | ||
| 11172 | 82387 | DPW Maintained 1 | Tristania conferta :: 61 | 615 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010004.402 | 2119511.4587 | 37.8003383958996 | -122.409508291437 | (37.8003383958996, -122.409508291437) | 3 | 1 | 10 | 308 | 23 | |||
| 11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
| 11870 | 245936 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.452930870305 | (37.76739400269, -122.452930870305) | 15 | 5 | 11 | 29492 | 9 | |||
| 12548 | 142282 | DPW Maintained 1 | Tristania conferta :: 61 | 1670 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999823.8892 | 2110575.119 | 37.7752258412107 | -122.444094309435 | (37.7752258412107, -122.444094309435) | 15 | 5 | 11 | 29492 | 16 | |||
| 12950 | 138781 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003611.2673 | 2114261.243 | 37.785562349837 | -122.431256090862 | (37.785562349837, -122.431256090862) | 13 | 9 | 11 | 29490 | 13 | |||
| 13390 | 200988 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015383.195 | 2115715.4111 | 37.7902152482092 | -122.390629967009 | (37.7902152482092, -122.390629967009) | 6 | 2 | 9 | 28855 | 6 | |||
| 13435 | 71273 | DPW Maintained 1 | Tristania conferta :: 61 | 2480 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6000737.6791 | 2114169.5665 | 37.7851473635462 | -122.441191260636 | (37.7851473635462, -122.441191260636) | 15 | 6 | 1 | 29490 | 27 | |||
| 13783 | 244951 | DPW Maintained 1 | Tristania conferta :: 61 | 251 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005979.0205 | 2110582.4222 | 37.7755951037998 | -122.422802804782 | (37.7755951037998, -122.422802804782) | 7 | 9 | 11 | 28852 | 10 | |||
| 13880 | 141551 | DPW Maintained 1 | Tristania conferta :: 61 | 54 Kittredge Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998011.3045 | 2111395.4264 | 37.7773746235344 | -122.450423568924 | (37.7773746235344, -122.450423568924) | 15 | 6 | 2 | 54 | 16 | |||
| 14129 | 71258 | DPW Maintained 1 | Tristania conferta :: 61 | 923 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 6001950.0126 | 2111666.817 | 37.778344429762 | -122.436817746544 | (37.778344429762, -122.436817746544) | 15 | 5 | 11 | 29490 | 41 | ||
| 14541 | 65945 | DPW Maintained 1 | Tristania conferta :: 61 | 528 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28966 | 6007615.5081 | 2113146.6876 | 37.7827281591619 | -122.417323539063 | (37.7827281591619, -122.417323539063) | 7 | 9 | 9 | 28852 | 36 | |
| 15026 | 60579 | DPW Maintained 1 | Tristania conferta :: 61 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | 15 | 5 | 11 | 29492 | 16 | |
| 15729 | 247461 | DPW Maintained 1 | Tristania conferta :: 61 | 756 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002953.7505 | 2109617.4268 | 37.7727743077426 | -122.433198975484 | (37.7727743077426, -122.433198975484) | 15 | 5 | 11 | 29492 | 9 | |||
| 15889 | 245992 | DPW Maintained 1 | Tristania conferta :: 61 | 1250 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999690.8568 | 2108469.5931 | 37.7694370106113 | -122.444403147816 | (37.7694370106113, -122.444403147816) | 15 | 5 | 11 | 29492 | 9 | |||
| 16548 | 143139 | DPW Maintained 1 | Tristania conferta :: 61 | 2520 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000358 | 2119336 | 37.7993114011756 | -122.442875959315 | (37.7993114011756, -122.442875959315) | 13 | 9 | 1 | 57 | 17 | |||
| 16713 | 137874 | DPW Maintained 1 | Tristania conferta :: 61 | 1635 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005298.8871 | 2115425.6162 | 37.7888549218974 | -122.425500309796 | (37.7888549218974, -122.425500309796) | 13 | 9 | 11 | 28858 | 27 | |||
| 16954 | 259600 | DPW Maintained 1 | Tristania conferta :: 61 | 1595 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6015285.2988 | 2095613.9245 | 37.7350154810982 | -122.389564212737 | (37.7350154810982, -122.389564212737) | 10 | 3 | 8 | 58 | 1 | ||||
| 17145 | 139804 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005645.4415 | 2112973.1088 | 37.7821405184571 | -122.424126793395 | (37.7821405184571, -122.424126793395) | 7 | 9 | 11 | 28852 | 41 | |||
| 17166 | 140743 | DPW Maintained 1 | Tristania conferta :: 61 | 2075 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001328.1518 | 2113161.5088 | 37.7824131116074 | -122.439076141092 | (37.7824131116074, -122.439076141092) | 15 | 5 | 11 | 29490 | 41 | |||
| 17209 | 13251 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000984.849 | 2119261.9127 | 37.7991436944439 | -122.440701531677 | (37.7991436944439, -122.440701531677) | 13 | 9 | 1 | 57 | 17 | |||
| 17245 | 245465 | DPW Maintained 1 | Tristania conferta :: 61 | 2601 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008856.7977 | 2106814.5159 | 37.7654112631592 | -122.412581421905 | (37.7654112631592, -122.412581421905) | 8 | 4 | 7 | 28859 | 19 | |||
| 17387 | 216652 | DPW Maintained 1 | Tristania conferta :: 61 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.70947 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | 9 | 8 | 6 | 28861 | 24 | ||
| 17454 | 55475 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1972 12:00:00 AM | 9 | Permit Number 11427 | 6001668.0931 | 2110827.7285 | 37.7760244773884 | -122.437732898122 | (37.7760244773884, -122.437732898122) | 15 | 5 | 11 | 29492 | 10 | |
| 18356 | 22489 | DPW Maintained 1 | Tristania conferta :: 61 | 6283 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 6 | 3x3 | 6013301.3486 | 2090589.3102 | 37.7211087088425 | -122.396071470667 | (37.7211087088425, -122.396071470667) | 10 | 3 | 8 | 58 | 1 | ||
| 18491 | 141846 | DPW Maintained 1 | Tristania conferta :: 61 | 1273 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004395.0795 | 2112899.1361 | 37.781866731536 | -122.428447208044 | (37.781866731536, -122.428447208044) | 7 | 9 | 11 | 29490 | 41 | |||
| 18493 | 199818 | DPW Maintained 1 | Tristania conferta :: 61 | 2226 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015709.0498 | 2091939.7667 | 37.7249504642567 | -122.387842856465 | (37.7249504642567, -122.387842856465) | 10 | 3 | 8 | 58 | 1 | |||
| 18547 | 41551 | DPW Maintained 1 | Tristania conferta :: 61 | 627 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 11 | Permit Number 42073 | 6000076.2449 | 2111080.2993 | 37.7766273307268 | -122.443257648559 | (37.7766273307268, -122.443257648559) | 15 | 5 | 11 | 29492 | 16 | |
| 19251 | 142786 | DPW Maintained 1 | Tristania conferta :: 61 | 730 POLK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6007071.7839 | 2113562.2092 | 37.7838384745362 | -122.419234083256 | (37.7838384745362, -122.419234083256) | 7 | 9 | 9 | 28858 | 36 | |||
| 19333 | 244143 | DPW Maintained 1 | Tristania conferta :: 61 | 423 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004418.4707 | 2109613.03 | 37.7728452161751 | -122.428132029093 | (37.7728452161751, -122.428132029093) | 7 | 9 | 11 | 28852 | 10 | |||
| 19450 | 200924 | DPW Maintained 1 | Tristania conferta :: 61 | 4100 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015492.5641 | 2097476.9144 | 37.7401423621251 | -122.38897764491 | (37.7401423621251, -122.38897764491) | 10 | 3 | 8 | 58 | 1 | |||
| 19570 | 7045 | DPW Maintained 1 | Tristania conferta :: 61 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.439727109686 | (37.7738682146278, -122.439727109686) | 15 | 5 | 11 | 29492 | 10 | ||
| 19744 | 138921 | DPW Maintained 1 | Tristania conferta :: 61 | 631 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004505.2517 | 2110712.757 | 37.7758697074358 | -122.427910221054 | (37.7758697074358, -122.427910221054) | 7 | 9 | 11 | 28852 | 10 | |||
| 19778 | 137930 | DPW Maintained 1 | Tristania conferta :: 61 | 1977 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004477.3196 | 2115333.9095 | 37.7885566643943 | -122.428336281189 | (37.7885566643943, -122.428336281189) | 13 | 9 | 11 | 28858 | 27 | |||
| 19889 | 248530 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.451165239168 | (37.7674964457612, -122.451165239168) | 15 | 5 | 11 | 29492 | 9 | |||
| 19972 | 200895 | DPW Maintained 1 | Tristania conferta :: 61 | 4247 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015445.3265 | 2097019.6548 | 37.7388842023405 | -122.389109055705 | (37.7388842023405, -122.389109055705) | 10 | 3 | 8 | 58 | 1 | |||
| 20396 | 246241 | DPW Maintained 1 | Tristania conferta :: 61 | 1395 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999547.9215 | 2107815.4823 | 37.7676328306769 | -122.444850527256 | (37.7676328306769, -122.444850527256) | 15 | 5 | 11 | 29492 | 9 | |||
| 20401 | 140131 | Permitted Site 7 | Tristania conferta :: 61 | 501 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 5 | Width 0ft | 6005847.0047 | 2111508.1975 | 37.7781296085056 | -122.423325305774 | (37.7781296085056, -122.423325305774) | 7 | 9 | 11 | 28852 | 10 | ||
| 20510 | 142108 | DPW Maintained 1 | Tristania conferta :: 61 | 758 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001607.3106 | 2111115.6492 | 37.7768115789366 | -122.437963788403 | (37.7768115789366, -122.437963788403) | 15 | 5 | 11 | 29492 | 10 | |||
| 20544 | 200187 | DPW Maintained 1 | Tristania conferta :: 61 | 2999 Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6014602.6431 | 2090373.0881 | 37.720587322073 | -122.391558129174 | (37.720587322073, -122.391558129174) | 10 | 3 | 8 | 58 | 1 | |||
| 20668 | 142244 | DPW Maintained 1 | Tristania conferta :: 61 | 419 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005364 | 2110769 | 37.7760726809274 | -122.424943590033 | (37.7760726809274, -122.424943590033) | 7 | 9 | 11 | 28852 | 10 | |||
| 20708 | 200514 | DPW Maintained 1 | Tristania conferta :: 61 | 5701 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6013926.9791 | 2092225.4991 | 37.7256361452498 | -122.39402331403 | (37.7256361452498, -122.39402331403) | 10 | 3 | 8 | 58 | 1 | |||
| 21270 | 139936 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005717.7716 | 2112456.4224 | 37.7807259079437 | -122.423839812492 | (37.7807259079437, -122.423839812492) | 7 | 9 | 11 | 28852 | 41 | |||
| 21423 | 143427 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.7932130339503 | -122.407090272453 | (37.7932130339503, -122.407090272453) | 3 | 1 | 10 | 28857 | 4 | |||
| 21708 | 30437 | DPW Maintained 1 | Tristania conferta :: 61 | 567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046 | (37.8004413456091, -122.40871589046) | 3 | 1 | 10 | 308 | 23 | ||
| 22022 | 30026 | DPW Maintained 1 | Tristania conferta :: 61 | 6190X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6013442.0581 | 2091191.4573 | 37.7227699118645 | -122.395627242562 | (37.7227699118645, -122.395627242562) | 10 | 3 | 8 | 58 | 1 | ||
| 22324 | 141816 | DPW Maintained 1 | Tristania conferta :: 61 | 1218 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004565.725 | 2112968.4018 | 37.7820665729689 | -122.427861790691 | (37.7820665729689, -122.427861790691) | 7 | 9 | 11 | 29490 | 41 | |||
| 22349 | 29469 | DPW Maintained 1 | Tristania conferta :: 61 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.384094597711 | (37.7288867261126, -122.384094597711) | 10 | 3 | 8 | 58 | 1 |
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) );