trees
861 rows where qSpecies_id = 18 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 173385 | 129410 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003271.2174 | 2116075.89812 | 37.7905256555748 | -122.432562228073 | (37.7905256555748, -122.432562228073) | 13 | 9 | 1 | 29490 | 27 | |||
| 174473 | 254175 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1089 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 3x3 | 6006628.18877 | 2120429.73547 | 37.8026699959528 | -122.421256591898 | (37.8026699959528, -122.421256591898) | 5 | 1 | 1 | 28858 | 32 | ||
| 175651 | 129401 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | 15 | 6 | 1 | 54 | 31 | |||
| 177495 | 42710 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) | 13 | 9 | 1 | 57 | 17 |
| 180161 | 34271 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
| 180251 | 129430 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004093.9756 | 2116304.66162 | 37.7912004052335 | -122.429731858334 | (37.7912004052335, -122.429731858334) | 13 | 9 | 1 | 29490 | 27 | |||
| 181301 | 108995 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772985 | 5993924.20809 | 2115202.12337 | 37.7875920194037 | -122.464838574554 | (37.7875920194037, -122.464838574554) | 11 | 6 | 1 | 54 | 11 |
| 183807 | 102256 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.7876549629941 | -122.440900572101 | (37.7876549629941, -122.440900572101) | 13 | 6 | 1 | 29490 | 27 | |
| 187023 | 18862 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3X3PL | 6004143.20725 | 2116038.00121 | 37.7904710109775 | -122.429542492602 | (37.7904710109775, -122.429542492602) | 13 | 9 | 1 | 29490 | 27 | |||
| 191886 | 129392 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 31 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001624.74168 | 2121508.73342 | 37.8053492888098 | -122.438648369353 | (37.8053492888098, -122.438648369353) | 13 | 9 | 1 | 57 | 17 | |||
| 697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
| 2588 | 101345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.8037364477628 | -122.413855954453 | (37.8037364477628, -122.413855954453) | 3 | 1 | 10 | 308 | 23 | ||
| 4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
| 19602 | 129440 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008519.41832 | 2114901.84945 | 37.7875982238142 | -122.414320608106 | (37.7875982238142, -122.414320608106) | 5 | 1 | 10 | 28858 | 21 | |||
| 25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
| 26105 | 111098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.7876092819021 | -122.414263235869 | (37.7876092819021, -122.414263235869) | 5 | 1 | 10 | 28858 | 21 | ||
| 35814 | 51087 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.420299857748 | (37.7966452201661, -122.420299857748) | 13 | 9 | 10 | 28858 | 32 | ||
| 42036 | 1713 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012507.60717 | 2118114.90232 | 37.796643729085 | -122.40074798855 | (37.796643729085, -122.40074798855) | 3 | 1 | 10 | 28860 | 4 | |||
| 42195 | 1714 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x9 | 6012511.35044 | 2118080.94057 | 37.7965506870182 | -122.400732648813 | (37.7965506870182, -122.400732648813) | 3 | 1 | 10 | 28860 | 4 | |||
| 46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 | |||
| 48303 | 115988 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.403255425209 | (37.7963995082912, -122.403255425209) | 3 | 1 | 10 | 28860 | 4 | |
| 50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
| 57443 | 129441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.408772631062 | (37.7859174259901, -122.408772631062) | 14 | 10 | 10 | 28852 | 36 | |||
| 62145 | 32357 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452059 | (37.7959569797808, -122.40333452059) | 3 | 1 | 10 | 28860 | 4 | ||
| 63090 | 31965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.415729001311 | (37.7987324288073, -122.415729001311) | 5 | 1 | 10 | 308 | 32 | |||
| 68049 | 129448 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008230.44958 | 2115909.44994 | 37.7903486123517 | -122.415391745646 | (37.7903486123517, -122.415391745646) | 5 | 1 | 10 | 28858 | 21 | |||
| 83760 | 129459 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 458 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011895.81451 | 2118092.21584 | 37.7965472956624 | -122.402863344166 | (37.7965472956624, -122.402863344166) | 3 | 1 | 10 | 28860 | 4 | |||
| 87905 | 101350 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 93478 | 129444 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008418.05988 | 2116953.62618 | 37.7932262072758 | -122.414816555443 | (37.7932262072758, -122.414816555443) | 5 | 1 | 10 | 28858 | 21 | |||
| 94349 | 94202 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232 | 2118962 | 37.7987302484859 | -122.415602598872 | (37.7987302484859, -122.415602598872) | 5 | 1 | 10 | 308 | 32 | |
| 102200 | 129447 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.415335839278 | (37.7903556945065, -122.415335839278) | 5 | 1 | 10 | 28858 | 21 | |||
| 106589 | 65445 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 922 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | 13 | 1 | 10 | 28858 | 21 | ||
| 111235 | 107371 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 448 BROADWAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | 3 | 1 | 10 | 308 | 23 | ||||
| 112886 | 101353 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
| 114966 | 98192 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.416087385628 | (37.7986859077751, -122.416087385628) | 5 | 1 | 10 | 308 | 32 | |||
| 115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
| 124686 | 129449 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 884 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008727.37725 | 2119383.41122 | 37.7999151722102 | -122.413918255029 | (37.7999151722102, -122.413918255029) | 3 | 1 | 10 | 308 | 32 | |||
| 130306 | 129460 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011856.71365 | 2118087.11906 | 37.7965311177706 | -122.402998283841 | (37.7965311177706, -122.402998283841) | 3 | 1 | 10 | 28860 | 4 | |||
| 134590 | 94203 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | 5 | 1 | 10 | 308 | 32 | |
| 135688 | 1716 | Landmark tree 11 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x15 | 6012528.51285 | 2117974.41064 | 37.7962591384932 | -122.400665775228 | (37.7962591384932, -122.400665775228) | 3 | 1 | 10 | 28860 | 4 | |||
| 138410 | 101359 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.413295071436 | (37.803771736238, -122.413295071436) | 3 | 1 | 10 | 308 | 23 | ||
| 142096 | 57397 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.415186043726 | (37.7903739066804, -122.415186043726) | 5 | 1 | 10 | 28858 | 21 | ||
| 143341 | 129445 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 24 Priest St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008315.59279 | 2117230.60537 | 37.793980966003 | -122.415190714801 | (37.793980966003, -122.415190714801) | 5 | 1 | 10 | 28858 | 21 | |||
| 144399 | 129436 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | 5 | 1 | 10 | 28857 | 21 | |||
| 147267 | 129461 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 468 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011829.88032 | 2118083.51366 | 37.7965197197689 | -122.403090879839 | (37.7965197197689, -122.403090879839) | 3 | 1 | 10 | 28860 | 4 | |||
| 147547 | 129462 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 584 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011873.80865 | 2117764.68671 | 37.7956467505394 | -122.402916441935 | (37.7956467505394, -122.402916441935) | 3 | 1 | 10 | 28860 | 4 | |||
| 152651 | 27626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008495.09386 | 2120769.31703 | 37.8037074748624 | -122.414820184334 | (37.8037074748624, -122.414820184334) | 5 | 1 | 10 | 308 | 23 | |||
| 153900 | 142587 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2320 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008491.26 | 2120799.1265 | 37.8037891087643 | -122.414835562646 | (37.8037891087643, -122.414835562646) | 5 | 1 | 10 | 308 | 23 | |||
| 155983 | 129437 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010035.0094 | 2115756.16478 | 37.7900289878849 | -122.409137245009 | (37.7900289878849, -122.409137245009) | 5 | 1 | 10 | 28857 | 21 | |||
| 158830 | 1715 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5x6 | 6012518.40757 | 2118034.67495 | 37.796424046288 | -122.400704977573 | (37.796424046288, -122.400704977573) | 3 | 1 | 10 | 28860 | 4 | |||
| 159355 | 129458 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 731 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6012131.08094 | 2118327.87745 | 37.7972074996935 | -122.402065841564 | (37.7972074996935, -122.402065841564) | 3 | 1 | 10 | 308 | 4 | |||
| 159582 | 129443 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010100.50138 | 2114305.77616 | 37.7860502369758 | -122.408808278389 | (37.7860502369758, -122.408808278389) | 14 | 10 | 10 | 28852 | 36 | |||
| 164313 | 142575 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008927.1192 | 2120859.172 | 37.8039784592472 | -122.413331490554 | (37.8039784592472, -122.413331490554) | 3 | 1 | 10 | 308 | 23 | |||
| 166949 | 1718 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 9x6 | 6012538.25649 | 2117884.3369 | 37.7960123609319 | -122.400625729299 | (37.7960123609319, -122.400625729299) | 3 | 1 | 10 | 28860 | 4 | |||
| 166998 | 33958 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | 3 | 1 | 10 | 308 | 23 | ||
| 168624 | 115987 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011766.1004 | 2118039.48156 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | 3 | 1 | 10 | 28860 | 4 | |||
| 172622 | 129446 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | 5 | 1 | 10 | 28858 | 21 | |||
| 183685 | 142580 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 650 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008660.8 | 2120758.6253 | 37.8036874273397 | -122.414245990591 | (37.8036874273397, -122.414245990591) | 3 | 1 | 10 | 308 | 23 | |||
| 190708 | 129438 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.7900271217973 | -122.409114812309 | (37.7900271217973, -122.409114812309) | 5 | 1 | 10 | 28857 | 21 | |||
| 192764 | 106106 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | 3 | 1 | 10 | 28860 | 4 | ||||
| 4681 | 6924 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 446 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6005254.8423 | 2110638.1989 | 37.775707366557 | -122.425311885836 | (37.775707366557, -122.425311885836) | 7 | 9 | 11 | 28852 | 10 | |||
| 4785 | 16923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 503 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6004556.4237 | 2110140.1804 | 37.7743004469023 | -122.427692399322 | (37.7743004469023, -122.427692399322) | 7 | 9 | 11 | 28852 | 10 | ||||
| 5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
| 6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
| 8222 | 240694 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 316 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004685.09774 | 2109764.27844 | 37.7732755894234 | -122.427220510535 | (37.7732755894234, -122.427220510535) | 7 | 9 | 11 | 28852 | 10 | |||
| 8667 | 54838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.7734387411862 | -122.447706373612 | (37.7734387411862, -122.447706373612) | 15 | 5 | 11 | 29492 | 16 | ||
| 11930 | 4545 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 16467 | 16902 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 427 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004930.51635 | 2110189.46412 | 37.7744569217764 | -122.426401853189 | (37.7744569217764, -122.426401853189) | 7 | 9 | 11 | 28852 | 10 | |||
| 24287 | 247479 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002709.4266 | 2109671.5189 | 37.7729089683714 | -122.434047985824 | (37.7729089683714, -122.434047985824) | 15 | 5 | 11 | 29492 | 9 | |||
| 27439 | 227588 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 435 Oak St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.7744360692067 | -122.42655134748 | (37.7744360692067, -122.42655134748) | 7 | 9 | 11 | 28852 | 10 | |||
| 29417 | 27607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001133.4058 | 2111053.0447 | 37.7766127217509 | -122.439598674592 | (37.7766127217509, -122.439598674592) | 15 | 5 | 11 | 29492 | 10 | |||
| 31088 | 142250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | 7 | 9 | 11 | 28852 | 10 | |||
| 31268 | 30586 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481 | (37.7726573855875, -122.43410610481) | 15 | 5 | 11 | 29492 | 9 | |
| 31494 | 4538 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 34539 | 245954 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.449203198504 | (37.7671425117336, -122.449203198504) | 15 | 5 | 11 | 29492 | 9 | |||
| 42307 | 4533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 45 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2016 03:02:00 PM | 6 | 5x5 | 6005057.0165 | 2113679.5647 | 37.7840470307287 | -122.42621279071 | (37.7840470307287, -122.42621279071) | 7 | 9 | 11 | 28858 | 41 | ||
| 42397 | 4516 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
| 43874 | 20250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1880 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6002537.9918 | 2114673.3066 | 37.7866328903431 | -122.434998786713 | (37.7866328903431, -122.434998786713) | 13 | 9 | 11 | 29490 | 27 | |||
| 44775 | 227659 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | 7 | 9 | 11 | 29492 | 10 | |||
| 47462 | 247480 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002710.1595 | 2109648.0677 | 37.7728446187699 | -122.434043773953 | (37.7728446187699, -122.434043773953) | 15 | 5 | 11 | 29492 | 9 | |||
| 48527 | 4552 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.427279741881 | (37.7839147367985, -122.427279741881) | 7 | 9 | 11 | 28858 | 41 | |||
| 52238 | 244059 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.448006327683 | (37.7708917674934, -122.448006327683) | 15 | 5 | 11 | 29492 | 9 | |||
| 52831 | 30703 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34614 | 6005258.9715 | 2110239.8029 | 37.7746137012839 | -122.425269246 | (37.7746137012839, -122.425269246) | 7 | 9 | 11 | 28852 | 10 | |
| 56833 | 38678 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
| 60028 | 4518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | |||
| 70376 | 30582 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
| 70731 | 30584 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
| 73444 | 16909 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 457 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2009 12:00:00 AM | 18 | 3X3 | 6004854.34153 | 2110178.37501 | 37.7744221674765 | -122.426664566741 | (37.7744221674765, -122.426664566741) | 7 | 9 | 11 | 28852 | 10 | ||
| 76581 | 7147 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 685X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
| 76762 | 247478 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002704.2967 | 2109689.8401 | 37.7729589827195 | -122.434067040661 | (37.7729589827195, -122.434067040661) | 15 | 5 | 11 | 29492 | 9 | |||
| 77639 | 16894 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.425186971324 | (37.7745648206797, -122.425186971324) | 7 | 9 | 11 | 28852 | 10 | ||
| 83215 | 32892 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) | 11 | 5 | 11 | 56 | 12 |
| 88007 | 4548 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 93109 | 247493 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 806 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | 15 | 5 | 11 | 29492 | 9 | |||
| 94052 | 247481 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 309 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002713.0909 | 2109626.0822 | 37.7727844183865 | -122.434032062031 | (37.7727844183865, -122.434032062031) | 15 | 5 | 11 | 29492 | 9 | |||
| 99134 | 4519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2015 11:31:00 AM | 12 | 3x3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | ||
| 100490 | 4553 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6004771.4236 | 2113636.9625 | 37.7839139091534 | -122.427197803426 | (37.7839139091534, -122.427197803426) | 7 | 9 | 11 | 28858 | 41 | |||
| 103222 | 4541 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 106621 | 244199 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 697 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | 7 | 9 | 11 | 29492 | 10 | |||
| 106623 | 27608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001149.4313 | 2111053.53 | 37.7766149663433 | -122.439543272646 | (37.7766149663433, -122.439543272646) | 15 | 5 | 11 | 29492 | 10 |
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) );