trees
320 rows where qSpecies_id = 145 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10946 | 200359 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 5ft | 6014213.14362 | 2096595.32013 | 37.7376506849368 | -122.393339717964 | (37.7376506849368, -122.393339717964) | 10 | 3 | 8 | 58 | 1 | |||
| 12984 | 38495 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.24733 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) | 13 | 9 | 10 | 28858 | 32 |
| 32545 | 200348 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 10 | : | Tree | Private 2 | 9 | Width 4ft | 6014546.28219 | 2097041.88556 | 37.738895364638 | -122.392219112326 | (37.738895364638, -122.392219112326) | 10 | 3 | 8 | 58 | 1 | |||
| 37605 | 228842 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999127.09441 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | 15 | 5 | 5 | 29492 | 9 | |||
| 39645 | 140287 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998483.9171 | 2110037.6666 | 37.7736736024147 | -122.448690838206 | (37.7736736024147, -122.448690838206) | 15 | 5 | 11 | 29492 | 16 | |||
| 47457 | 129798 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011911.92184 | 2120288.00736 | 37.8025773075571 | -122.402962127524 | (37.8025773075571, -122.402962127524) | 3 | 1 | 10 | 28860 | 6 | |||
| 47873 | 129815 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 433 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012587.02488 | 2117167.29458 | 37.7940462531923 | -122.400406589716 | (37.7940462531923, -122.400406589716) | 3 | 1 | 10 | 28860 | 6 | |||
| 55858 | 200333 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841 | (37.7593020107061, -122.39025440841) | 10 | 3 | 8 | 28856 | 29 | |||
| 73344 | 208167 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991441.56701 | 2097783.56953 | 37.7396218639513 | -122.472157779682 | (37.7396218639513, -122.472157779682) | 1 | 8 | 4 | 29491 | 40 | |||
| 73571 | 129849 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012584.80341 | 2118810.70115 | 37.7985585314168 | -122.400529771657 | (37.7985585314168, -122.400529771657) | 3 | 1 | 10 | 28860 | 6 | |||
| 75159 | 86806 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 81266 | 129784 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1600 Montgomery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6011334.32807 | 2120989.68408 | 37.8044716700829 | -122.405010336152 | (37.8044716700829, -122.405010336152) | 3 | 1 | 10 | 28860 | 6 | |||
| 82047 | 129761 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006380.65068 | 2118525.27839 | 37.7974268811919 | -122.421977832627 | (37.7974268811919, -122.421977832627) | 13 | 9 | 10 | 28858 | 32 | |||
| 100102 | 129752 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2407 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003040.06059 | 2116163.94493 | 37.7907542983172 | -122.433368310202 | (37.7907542983172, -122.433368310202) | 13 | 9 | 1 | 29490 | 27 | |||
| 123480 | 129760 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006381.91218 | 2118496.72963 | 37.7973485646419 | -122.421971438426 | (37.7973485646419, -122.421971438426) | 13 | 9 | 10 | 28858 | 32 | |||
| 125463 | 129830 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012498.4118 | 2117199.54922 | 37.7941298748476 | -122.400715469043 | (37.7941298748476, -122.400715469043) | 3 | 1 | 10 | 28860 | 4 | |||
| 129427 | 142487 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1527 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010095.4595 | 2119399.2703 | 37.8000354558626 | -122.409185274056 | (37.8000354558626, -122.409185274056) | 3 | 1 | 10 | 308 | 23 | |||
| 133100 | 208169 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991440.6028 | 2097828.13237 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | 1 | 8 | 4 | 29491 | 40 | |||
| 136315 | 39385 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.73959 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | 13 | 9 | 1 | 57 | 27 | ||
| 141508 | 200338 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 21 | : | Tree | Private 2 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | 10 | 3 | 8 | 58 | 1 | |||
| 145087 | 106001 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.7593574521144 | -122.390262422266 | (37.7593574521144, -122.390262422266) | 10 | 3 | 8 | 28856 | 29 | |||
| 149057 | 39386 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | 13 | 9 | 1 | 57 | 27 | ||
| 150690 | 129823 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012601.68821 | 2117444.33686 | 37.7948077631249 | -122.400375321165 | (37.7948077631249, -122.400375321165) | 3 | 1 | 10 | 28860 | 4 | |||
| 160674 | 200336 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511 | (37.7424425848476, -122.38903282511) | 10 | 3 | 8 | 58 | 1 | |||
| 163484 | 208173 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.7443394340168 | -122.460502016448 | (37.7443394340168, -122.460502016448) | 1 | 8 | 4 | 59 | 40 | |||
| 167306 | 200346 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 4 | : | Tree | Private 2 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | 10 | 3 | 8 | 58 | 1 | |||
| 180124 | 129818 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.7939173929283 | -122.400190373809 | (37.7939173929283, -122.400190373809) | 4 | 1 | 10 | 28860 | 6 | |||
| 186238 | 129779 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Front St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012731.79119 | 2119371.92723 | 37.8001077197496 | -122.400060579146 | (37.8001077197496, -122.400060579146) | 3 | 1 | 10 | 28860 | 6 | |||
| 26081 | 129751 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2320 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000742.15542 | 2119656.12238 | 37.8002122659526 | -122.441569636242 | (37.8002122659526, -122.441569636242) | 13 | 9 | 1 | 57 | 17 | |||
| 50047 | 129847 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012509.67235 | 2118803.01279 | 37.798533230779 | -122.400789209861 | (37.798533230779, -122.400789209861) | 3 | 1 | 10 | 28860 | 6 | |||
| 65172 | 228847 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004213.13115 | 2104548.41319 | 37.758927377407 | -122.428481260227 | (37.758927377407, -122.428481260227) | 2 | 4 | 5 | 28862 | 3 | |||
| 66349 | 129826 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012620.11049 | 2117309.34489 | 37.7944381345611 | -122.400302091187 | (37.7944381345611, -122.400302091187) | 3 | 1 | 10 | 28860 | 4 | |||
| 77597 | 200340 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 23 | : | Tree | Private 2 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.389683204014 | (37.7417134289277, -122.389683204014) | 10 | 3 | 8 | 58 | 1 | |||
| 89600 | 129814 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 433 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012557.97886 | 2117161.95783 | 37.7940299799473 | -122.400506717522 | (37.7940299799473, -122.400506717522) | 4 | 1 | 10 | 28860 | 6 | |||
| 107948 | 200343 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 39 | : | Tree | Private 2 | 8 | Width 4ft | 6015141.18947 | 2097840.20057 | 37.7411203881093 | -122.390217940008 | (37.7411203881093, -122.390217940008) | 10 | 3 | 8 | 58 | 1 | |||
| 114103 | 200341 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 24 | : | Tree | Private 2 | 8 | Width 2ft | 6015282.07626 | 2098027.62068 | 37.7416428186622 | -122.389743887597 | (37.7416428186622, -122.389743887597) | 10 | 3 | 8 | 58 | 1 | |||
| 116439 | 17643 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 120354 | 228840 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 104 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004701.59069 | 2103023.11733 | 37.754766903184 | -122.426683319388 | (37.754766903184, -122.426683319388) | 2 | 4 | 5 | 28862 | 22 | |||
| 132394 | 129794 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011926.85553 | 2120176.70877 | 37.802272542593 | -122.402902616671 | (37.802272542593, -122.402902616671) | 3 | 1 | 10 | 28860 | 6 | |||
| 132986 | 200334 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 4 | : | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.7425659089002 | -122.388913512973 | (37.7425659089002, -122.388913512973) | 10 | 3 | 8 | 58 | 1 | ||
| 135786 | 200342 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 779844 | 6015273.79393 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | 10 | 3 | 8 | 58 | 1 | ||
| 150134 | 200363 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 5 | : | Tree | Private 2 | 8 | Width 5ft | 6014137.38405 | 2096492.68968 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | 10 | 3 | 8 | 58 | 1 | |||
| 155747 | 129836 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 733 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012782.07244 | 2118635.55361 | 37.7980886176578 | -122.399834849323 | (37.7980886176578, -122.399834849323) | 3 | 1 | 10 | 28860 | 6 | |||
| 161885 | 129848 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 103 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012543.75409 | 2118806.63113 | 37.7985450667665 | -122.400671529986 | (37.7985450667665, -122.400671529986) | 3 | 1 | 10 | 28860 | 6 | |||
| 178568 | 129817 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.400209799159 | (37.793996430738, -122.400209799159) | 4 | 1 | 10 | 28860 | 6 | |||
| 182985 | 200349 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 11 | : | Tree | Private 2 | 8 | Width 4ft | 6014526.62987 | 2097016.75387 | 37.7388252669773 | -122.392285304228 | (37.7388252669773, -122.392285304228) | 10 | 3 | 8 | 58 | 1 | |||
| 186221 | 129792 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011937.51445 | 2120075.46294 | 37.8019951413282 | -122.402858606545 | (37.8019951413282, -122.402858606545) | 3 | 1 | 10 | 28860 | 6 | |||
| 191015 | 17644 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 193306 | 200357 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6014316.3111 | 2096732.35884 | 37.7380326962502 | -122.392992601233 | (37.7380326962502, -122.392992601233) | 10 | 3 | 8 | 58 | 1 | |||
| 1024 | 200362 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 3 | : | Tree | Private 2 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.393495590258 | (37.7374749933851, -122.393495590258) | 10 | 3 | 8 | 58 | 1 | |||
| 28094 | 129831 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012476.45918 | 2117195.30949 | 37.7941170091435 | -122.40079112993 | (37.7941170091435, -122.40079112993) | 3 | 1 | 10 | 28860 | 4 | |||
| 29034 | 129824 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 333 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012608.14 | 2117404.20841 | 37.7946979397237 | -122.400350177025 | (37.7946979397237, -122.400350177025) | 3 | 1 | 10 | 28860 | 4 | |||
| 32409 | 39384 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.12069 | 37.7934654530274 | -122.441926131987 | (37.7934654530274, -122.441926131987) | 13 | 9 | 1 | 57 | 27 | ||
| 35332 | 200356 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6014331.31299 | 2096752.73935 | 37.7380894902424 | -122.392942157366 | (37.7380894902424, -122.392942157366) | 10 | 3 | 8 | 58 | 1 | |||
| 39193 | 200350 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 12 | : | Tree | Private 2 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.7387556252824 | -122.392345164903 | (37.7387556252824, -122.392345164903) | 10 | 3 | 8 | 58 | 1 | |||
| 45782 | 200361 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 1 | : | Tree | Private 2 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.393444381967 | (37.7375336444497, -122.393444381967) | 10 | 3 | 8 | 58 | 1 | |||
| 62839 | 129795 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011922.61764 | 2120202.56088 | 37.8023432895615 | -122.402919101237 | (37.8023432895615, -122.402919101237) | 3 | 1 | 10 | 28860 | 6 | |||
| 66382 | 129748 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.8002382734424 | -122.441353858292 | (37.8002382734424, -122.441353858292) | 13 | 9 | 1 | 57 | 17 | |||
| 67848 | 129786 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011965.83445 | 2119897.8199 | 37.8015089579449 | -122.402748105054 | (37.8015089579449, -122.402748105054) | 3 | 1 | 10 | 28860 | 6 | |||
| 77678 | 129832 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 354 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012451.48028 | 2117191.95794 | 37.7941064133197 | -122.400877324536 | (37.7941064133197, -122.400877324536) | 3 | 1 | 10 | 28860 | 4 | |||
| 78811 | 129764 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.421903498241 | (37.7977976222176, -122.421903498241) | 13 | 9 | 10 | 28858 | 32 | |||
| 78987 | 228846 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | 2 | 4 | 5 | 28862 | 3 | |||
| 87581 | 129811 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012498.50919 | 2117154.1734 | 37.7940052890658 | -122.400711942828 | (37.7940052890658, -122.400711942828) | 4 | 1 | 10 | 28860 | 6 | |||
| 88454 | 129787 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011959.46477 | 2119924.96913 | 37.8015831474946 | -122.402772057584 | (37.8015831474946, -122.402772057584) | 3 | 1 | 10 | 28860 | 6 | |||
| 88892 | 200368 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6014118.97804 | 2116248.97229 | 37.7916100652992 | -122.395041482589 | (37.7916100652992, -122.395041482589) | 12 | 2 | 9 | 28855 | 6 | |||
| 101429 | 39387 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.441956528179 | (37.7934637371134, -122.441956528179) | 13 | 9 | 1 | 57 | 27 | ||
| 108765 | 129801 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011895.86595 | 2120414.05559 | 37.8029225087266 | -122.403026560337 | (37.8029225087266, -122.403026560337) | 3 | 1 | 10 | 28860 | 6 | |||
| 111169 | 129785 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011966.59622 | 2119867.20019 | 37.8014249261853 | -122.402743314356 | (37.8014249261853, -122.402743314356) | 3 | 1 | 10 | 28860 | 6 | |||
| 116930 | 129788 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011956.16596 | 2119957.68161 | 37.8016727838339 | -122.402785774963 | (37.8016727838339, -122.402785774963) | 3 | 1 | 10 | 28860 | 6 | |||
| 127399 | 200369 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | 14 | 2 | 9 | 28853 | 34 | |||
| 136630 | 129791 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.8019139721219 | -122.402839125451 | (37.8019139721219, -122.402839125451) | 3 | 1 | 10 | 28860 | 6 | |||
| 139160 | 129789 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011950.17532 | 2119985.5388 | 37.8017489384237 | -122.402808465741 | (37.8017489384237, -122.402808465741) | 3 | 1 | 10 | 28860 | 6 | |||
| 140150 | 129768 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6011131.65669 | 2118977.19841 | 37.7989345451634 | -122.405569873672 | (37.7989345451634, -122.405569873672) | 3 | 1 | 10 | 308 | 23 | |||
| 160698 | 140288 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | 15 | 5 | 11 | 29492 | 16 | |||
| 187145 | 129765 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006424.31939 | 2118660.78506 | 37.7978014110634 | -122.421836357588 | (37.7978014110634, -122.421836357588) | 13 | 9 | 10 | 28858 | 32 | |||
| 28803 | 27659 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014051.97429 | 2116162.83492 | 37.7913698260154 | -122.395267279985 | (37.7913698260154, -122.395267279985) | 12 | 2 | 9 | 28855 | 6 | |||
| 35348 | 17631 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | ||
| 40856 | 129790 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1160 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011945.5166 | 2120015.13463 | 37.8018299412604 | -122.402826669824 | (37.8018299412604, -122.402826669824) | 3 | 1 | 10 | 28860 | 6 | |||
| 52940 | 17658 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 59314 | 14844 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649175 | (37.7782909152526, -122.43388649175) | 15 | 5 | 11 | 29492 | 41 | ||
| 71834 | 17642 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 76139 | 200345 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 900 Phelps St | 3 | : | Tree | Private 2 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | 10 | 3 | 8 | 58 | 1 | |||
| 78700 | 86807 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 84419 | 129806 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 901 Sacramento St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6010377.17129 | 2116863.70379 | 37.7930891856797 | -122.408031526727 | (37.7930891856797, -122.408031526727) | 3 | 1 | 10 | 28857 | 4 | |||
| 89345 | 17639 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 108380 | 17634 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 109808 | 15116 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014033.61686 | 2116167.83271 | 37.7913825278275 | -122.39533114703 | (37.7913825278275, -122.39533114703) | 12 | 2 | 9 | 28855 | 6 | |||
| 114242 | 129797 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011917.15823 | 2120261.12287 | 37.8025037816892 | -122.402942114884 | (37.8025037816892, -122.402942114884) | 3 | 1 | 10 | 28860 | 6 | |||
| 114333 | 200365 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1300 Phelps St | 7 | : | Tree | Private 2 | 6 | Width 5ft | 6014060.81183 | 2096393.54047 | 37.7370881751809 | -122.393852285648 | (37.7370881751809, -122.393852285648) | 10 | 3 | 8 | 58 | 1 | |||
| 119788 | 17656 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | ||
| 126645 | 62971 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | 5 | 1 | 10 | 28858 | 21 | |
| 130244 | 17662 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | 10 | 3 | 8 | 58 | 1 | |||
| 136267 | 200360 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 1150 Phelps St | 5 | : | Tree | Private 2 | 6 | Width 5ft | 6014196.6239 | 2096573.24629 | 37.737589156905 | -122.393395290662 | (37.737589156905, -122.393395290662) | 10 | 3 | 8 | 58 | 1 | |||
| 141698 | 129750 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.8002175638503 | -122.441506243943 | (37.8002175638503, -122.441506243943) | 13 | 9 | 1 | 57 | 17 | |||
| 151268 | 17647 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 154440 | 208174 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | 1 | 8 | 4 | 59 | 40 | |||
| 162528 | 15119 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 201 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6014087.04677 | 2116219.82682 | 37.7915282629576 | -122.395149922854 | (37.7915282629576, -122.395149922854) | 12 | 2 | 9 | 28855 | 6 | |||
| 184119 | 228850 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.428631303115 | (37.7589211990752, -122.428631303115) | 2 | 4 | 5 | 28862 | 3 | |||
| 187134 | 177154 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.7256153880361 | -122.423636416303 | (37.7256153880361, -122.423636416303) | 9 | 7 | 6 | 309 | 5 | |||
| 14628 | 96325 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919 | 2120150.9 | 37.8022012393453 | -122.402927984504 | (37.8022012393453, -122.402927984504) | 3 | 1 | 10 | 28860 | 6 |
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) );