trees
861 rows where qSpecies_id = 18 sorted by Location 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 164984 | 84614 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 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 | |||
| 105798 | 84613 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.35978 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 80866 | 129453 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6007720.64474 | 2120576.42054 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | 5 | 1 | 1 | 308 | 32 | |||
| 56414 | 129456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.417489658942 | (37.803134284681, -122.417489658942) | 5 | 1 | 1 | 308 | 32 | |||
| 136872 | 129455 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.417484972552 | (37.8031342846798, -122.417484972552) | 5 | 1 | 1 | 308 | 32 | |||
| 156724 | 129454 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713 | (37.8031318169374, -122.41748848713) | 5 | 1 | 1 | 308 | 32 | |||
| 36673 | 129452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.8031318169312 | -122.417485363758 | (37.8031318169312, -122.417485363758) | 5 | 1 | 1 | 308 | 32 | |||
| 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 | ||
| 77228 | 129405 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3545 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000706.97602 | 2120551.39476 | 37.8026684412687 | -122.441755658294 | (37.8026684412687, -122.441755658294) | 13 | 9 | 1 | 57 | 17 | |||
| 104428 | 129406 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3545 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000708.23072 | 2120533.57312 | 37.8026195792908 | -122.441750036631 | (37.8026195792908, -122.441750036631) | 13 | 9 | 1 | 57 | 17 | |||
| 112569 | 129450 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1257 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6006338.43207 | 2120038.90392 | 37.8015805322681 | -122.422231514268 | (37.8015805322681, -122.422231514268) | 13 | 9 | 1 | 28858 | 32 | |||
| 137277 | 87873 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | 13 | 9 | 1 | 57 | 17 | |
| 166939 | 35235 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | 5 | 1 | 1 | 308 | 32 | |
| 131351 | 61519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | 5 | 1 | 1 | 28858 | 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 | |||
| 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 | |||||
| 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 | |||
| 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 | |
| 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 | |
| 62830 | 129391 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.7987016585207 | -122.429844394124 | (37.7987016585207, -122.429844394124) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 171650 | 129402 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | ||||
| 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 |
| 4194 | 143382 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005275.1713 | 2118900.2974 | 37.7983941790308 | -122.425829789965 | (37.7983941790308, -122.425829789965) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 133856 | 129404 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2844 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000064.89028 | 2118400.48534 | 37.7967260116595 | -122.443822969478 | (37.7967260116595, -122.443822969478) | 13 | 9 | 1 | 57 | 17 | |||
| 119638 | 129403 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | |||
| 18551 | 129423 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003338.49011 | 2117887.74598 | 37.7955043402029 | -122.432458934629 | (37.7955043402029, -122.432458934629) | 13 | 9 | 1 | 29490 | 27 | ||
| 26767 | 129422 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003322.87221 | 2117886.87369 | 37.7955010594859 | -122.432512912861 | (37.7955010594859, -122.432512912861) | 13 | 9 | 1 | 29490 | 27 | |||
| 7817 | 129424 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.432429869467 | (37.7955010594853, -122.432429869467) | 13 | 9 | 1 | 29490 | 27 | ||
| 30144 | 129421 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447999 | (37.795493917972, -122.43256447999) | 13 | 9 | 1 | 29490 | 27 | |||
| 139123 | 129420 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003293.36064 | 2117882.88889 | 37.7954884446923 | -122.432614743086 | (37.7954884446923, -122.432614743086) | 13 | 9 | 1 | 29490 | 27 | |||
| 108655 | 129419 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003276.06747 | 2117879.65532 | 37.7954785854301 | -122.432674349259 | (37.7954785854301, -122.432674349259) | 13 | 9 | 1 | 29490 | 27 | |||
| 80856 | 97675 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000810.80569 | 2117928.44871 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | 13 | 9 | 1 | 57 | 17 | ||||
| 112382 | 97676 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | 13 | 9 | 1 | 57 | 17 | ||||
| 172563 | 129418 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.7954621799809 | -122.432746053085 | (37.7954621799809, -122.432746053085) | 13 | 9 | 1 | 29490 | 27 | |||
| 8088 | 129417 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.7954534844407 | -122.432811866398 | (37.7954534844407, -122.432811866398) | 13 | 9 | 1 | 29490 | 27 | ||
| 105414 | 104725 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | ||
| 167223 | 104724 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | |||
| 78623 | 97442 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||||
| 12709 | 129426 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | 13 | 9 | 1 | 29490 | 27 | |||
| 67835 | 129427 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.7944511216666 | -122.43271221522 | (37.7944511216666, -122.43271221522) | 13 | 9 | 1 | 29490 | 27 | |||
| 129419 | 129425 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 50974 | 36881 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | 13 | 9 | 1 | 29490 | 27 | |
| 121828 | 36882 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | Permit Number 776215 | 6002659.25886 | 2116979.55031 | 37.7929721299187 | -122.434744211776 | (37.7929721299187, -122.434744211776) | 13 | 9 | 1 | 29490 | 27 | |
| 102588 | 36883 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.24208 | 37.7929220655455 | -122.434730389195 | (37.7929220655455, -122.434730389195) | 13 | 9 | 1 | 29490 | 27 | |
| 23268 | 36880 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776215 | 6002666.11082 | 2116940.62149 | 37.7928656304089 | -122.434717718651 | (37.7928656304089, -122.434717718651) | 13 | 9 | 1 | 29490 | 27 |
| 143913 | 129428 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2250 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003926.50699 | 2116660.02571 | 37.7921666602192 | -122.430336659605 | (37.7921666602192, -122.430336659605) | 13 | 9 | 1 | 29490 | 27 | |||
| 127489 | 64471 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2332 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1988 12:00:00 AM | 4 | Permit Number 25341 | 6003518.39121 | 2116605.0137 | 37.7919924858215 | -122.431744816269 | (37.7919924858215, -122.431744816269) | 13 | 9 | 1 | 29490 | 27 | ||
| 112126 | 129414 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2501 Jackson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001550.43955 | 2116611.49961 | 37.7918985453389 | -122.438554394686 | (37.7918985453389, -122.438554394686) | 13 | 6 | 1 | 29490 | 27 | |||
| 109753 | 54086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.7916772707399 | -122.433147915142 | (37.7916772707399, -122.433147915142) | 13 | 9 | 1 | 29490 | 27 | ||
| 44640 | 46211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.432615424763 | (37.7915512424562, -122.432615424763) | 13 | 9 | 1 | 29490 | 27 | ||
| 126715 | 129435 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004184.0136 | 2116319.13373 | 37.7912452400168 | -122.429421362005 | (37.7912452400168, -122.429421362005) | 13 | 9 | 1 | 29490 | 27 | |||
| 101511 | 129434 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004173.55874 | 2116318.162 | 37.7912419799702 | -122.429457466206 | (37.7912419799702, -122.429457466206) | 13 | 9 | 1 | 29490 | 27 | |||
| 68793 | 129433 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004155.37388 | 2116318.23991 | 37.7912411642935 | -122.429520390877 | (37.7912411642935, -122.429520390877) | 13 | 9 | 1 | 29490 | 27 | |||
| 113547 | 129432 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004124.61142 | 2116315.60844 | 37.7912321971464 | -122.429626640374 | (37.7912321971464, -122.429626640374) | 13 | 9 | 1 | 29490 | 27 | |||
| 38886 | 129431 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004108.39045 | 2116309.70837 | 37.7912150785667 | -122.429682343483 | (37.7912150785667, -122.429682343483) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 133587 | 129429 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004071.91056 | 2116304.52286 | 37.7911987747643 | -122.429808192813 | (37.7911987747643, -122.429808192813) | 13 | 9 | 1 | 29490 | 27 | |||
| 18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
| 47953 | 105316 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | ||||
| 92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
| 106447 | 129408 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003263.17406 | 2116138.42129 | 37.7906968721156 | -122.432594525436 | (37.7906968721156, -122.432594525436) | 13 | 9 | 1 | 29490 | 27 | |||
| 162130 | 129409 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.432585105024 | (37.7906117953446, -122.432585105024) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 9449 | 18861 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3X3 | 6004226.06461 | 2116051.48796 | 37.790512733214 | -122.42925677349 | (37.790512733214, -122.42925677349) | 13 | 9 | 1 | 29490 | 27 | |||
| 165110 | 44092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 43607 | 6004180.10381 | 2116042.60341 | 37.7904857364673 | -122.429415161181 | (37.7904857364673, -122.429415161181) | 13 | 9 | 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 | |||
| 144360 | 111668 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2200 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3PL | 6004109.02078 | 2116034.23701 | 37.790458739741 | -122.429660507029 | (37.790458739741, -122.429660507029) | 13 | 9 | 1 | 29490 | 27 | |||
| 39393 | 129411 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003275.40801 | 2116033.98168 | 37.7904108013651 | -122.432544733549 | (37.7904108013651, -122.432544733549) | 13 | 9 | 1 | 29490 | 27 |
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) );