trees
3,247 rows where qSpecies_id = 22 sorted by Police Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 480 | 225991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Laussat St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6004313.0789 | 2109253.93974 | 37.7718532783246 | -122.428470991768 | (37.7718532783246, -122.428470991768) | 7 | 9 | 11 | 28852 | 10 | |||
| 1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
| 4259 | 33111 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.7971858916671 | -122.442801853125 | (37.7971858916671, -122.442801853125) | 13 | 9 | 1 | 57 | 17 | |
| 5007 | 30714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34618 | 6005877.6805 | 2109983.4249 | 37.7739446835862 | -122.423110779148 | (37.7739446835862, -122.423110779148) | 7 | 9 | 11 | 28852 | 10 | |
| 5452 | 137906 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004699.2421 | 2115366.2455 | 37.7886580058302 | -122.427570767585 | (37.7886580058302, -122.427570767585) | 13 | 9 | 11 | 28858 | 27 | |||
| 8005 | 128927 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004695.29857 | 2116719.42491 | 37.7923732722634 | -122.427680861803 | (37.7923732722634, -122.427680861803) | 13 | 9 | 1 | 28858 | 27 | |||
| 10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10470 | 128936 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2618 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003606.06388 | 2117505.00365 | 37.7944685972958 | -122.431505746802 | (37.7944685972958, -122.431505746802) | 13 | 9 | 1 | 29490 | 27 | |||
| 12006 | 17808 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004382.775 | 2115429.5647 | 37.7888139592602 | -122.4286702126 | (37.7888139592602, -122.4286702126) | 13 | 9 | 11 | 28858 | 27 | |||
| 12559 | 30713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 3 | Permit Number 34618 | 6005868.3438 | 2109981.6465 | 37.7739392736408 | -122.42314294996 | (37.7739392736408, -122.42314294996) | 7 | 9 | 11 | 28852 | 10 | |
| 12858 | 128984 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006377.26428 | 2110951.50272 | 37.7766309716791 | -122.421451397362 | (37.7766309716791, -122.421451397362) | 7 | 9 | 11 | 28852 | 10 | |||
| 15719 | 7346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2225 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1980 12:00:00 AM | 1 | 3X3 | 6002798.59801 | 2115979.15257 | 37.7902332041481 | -122.43419054146 | (37.7902332041481, -122.43419054146) | 13 | 9 | 1 | 29490 | 27 | ||
| 16074 | 128922 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004454.93777 | 2116689.88617 | 37.7922785673477 | -122.428510409935 | (37.7922785673477, -122.428510409935) | 13 | 9 | 1 | 28858 | 27 | |||
| 16377 | 94114 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 16691 | 94109 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.421562636328 | (37.7769909819764, -122.421562636328) | 7 | 9 | 11 | 28852 | 10 | |
| 18798 | 71245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1732 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006396.12471 | 2117006.83983 | 37.7932585028357 | -122.421816375523 | (37.7932585028357, -122.421816375523) | 13 | 9 | 10 | 28858 | 32 | |||
| 19320 | 33230 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | Permit Number 37416 | 6000651.12195 | 2117750.428 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | 13 | 9 | 1 | 57 | 27 | ||
| 19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
| 20200 | 109784 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 20435 | 128934 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004762.88198 | 2115822.85089 | 37.7899153288661 | -122.427383123225 | (37.7899153288661, -122.427383123225) | 13 | 9 | 1 | 28858 | 27 | |||
| 21892 | 50870 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6001002.60746 | 2117608.08082 | 37.7946037186291 | -122.440521399949 | (37.7946037186291, -122.440521399949) | 13 | 9 | 1 | 57 | 27 | |||
| 22492 | 128946 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 880 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005803.3615 | 2112793.88056 | 37.7816573167765 | -122.423567714377 | (37.7816573167765, -122.423567714377) | 7 | 9 | 11 | 28852 | 41 | |||
| 23659 | 228328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006665.66427 | 2110481.14442 | 37.7753557375232 | -122.420420341729 | (37.7753557375232, -122.420420341729) | 7 | 9 | 11 | 28852 | 10 | |||
| 25519 | 99895 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.59896 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | 13 | 9 | 1 | 28858 | 27 | ||
| 29173 | 98963 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 29223 | 65857 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3444 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1990 12:00:00 AM | 2 | 3x3 | Permit Number 49753 | 6000794.66575 | 2120227.32857 | 37.8017836378592 | -122.441428940891 | (37.8017836378592, -122.441428940891) | 13 | 9 | 1 | 57 | 17 | |
| 29226 | 228316 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 11 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004193.31394 | 2108893.70276 | 37.7708573771991 | -122.428859580726 | (37.7708573771991, -122.428859580726) | 7 | 9 | 11 | 29492 | 10 | |||
| 29625 | 228290 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 58 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003779.3441 | 2108006.41718 | 37.7683976675499 | -122.430228200469 | (37.7683976675499, -122.430228200469) | 7 | 9 | 5 | 28862 | 3 | |||
| 29797 | 61370 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1984 12:00:00 AM | Permit Number 21280 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||
| 30811 | 128921 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2120 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004519.58933 | 2116743.38015 | 37.7924291066587 | -122.428290528411 | (37.7924291066587, -122.428290528411) | 13 | 9 | 1 | 28858 | 27 | |||
| 31025 | 128967 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006036.9572 | 2111786.26725 | 37.7789038390656 | -122.422687956181 | (37.7789038390656, -122.422687956181) | 7 | 9 | 11 | 28852 | 10 | |||
| 31128 | 128943 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007076.9364 | 2114307.93952 | 37.7858863580241 | -122.41926917535 | (37.7858863580241, -122.41926917535) | 13 | 9 | 9 | 28858 | 36 | |||
| 31468 | 33116 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.68486 | 2118474.07473 | 37.7969291406212 | -122.443763225693 | (37.7969291406212, -122.443763225693) | 13 | 9 | 1 | 57 | 17 | |
| 31830 | 58810 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.04088 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | 13 | 9 | 1 | 57 | 17 | |
| 33532 | 44053 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | 13 | 9 | 1 | 57 | 17 | |||
| 35111 | 17821 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6004660.7047 | 2115356.9434 | 37.7886302847667 | -122.427703438305 | (37.7886302847667, -122.427703438305) | 13 | 9 | 11 | 28858 | 27 | |||
| 35642 | 98967 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 35703 | 228320 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006273.61713 | 2109890.30806 | 37.7737113424482 | -122.421734550735 | (37.7737113424482, -122.421734550735) | 7 | 9 | 11 | 28852 | 10 | |||
| 35761 | 128888 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1549 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003944.76829 | 2120400.71212 | 37.8024386572819 | -122.430540507163 | (37.8024386572819, -122.430540507163) | 13 | 9 | 1 | 57 | 17 | |||
| 35944 | 109787 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 36427 | 98965 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 37675 | 49963 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1770X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46714 | 6004517.12801131 | 2114993.0452944 | 37.7876229893912 | -122.428174248262 | (37.7876229893912, -122.428174248262) | 13 | 9 | 11 | 28858 | 27 | |
| 38072 | 128919 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2600 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6000714.71077 | 2117296.03713 | 37.793730530888 | -122.441495154374 | (37.793730530888, -122.441495154374) | 13 | 9 | 1 | 57 | 27 | |||
| 38258 | 28721 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1881 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004471.9612 | 2114982.8802 | 37.7875925229583 | -122.428329791837 | (37.7875925229583, -122.428329791837) | 13 | 9 | 11 | 28858 | 27 | ||
| 38767 | 117594 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 329x IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3x6 | 6005708 | 2111040 | 37.7768362060225 | -122.423772874681 | (37.7768362060225, -122.423772874681) | 7 | 9 | 11 | 28852 | 10 | ||
| 40349 | 128929 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004845.70245 | 2116743.27362 | 37.7924472612924 | -122.42716215983 | (37.7924472612924, -122.42716215983) | 13 | 9 | 1 | 28858 | 27 | |||
| 41686 | 128909 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1620 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.371 | 2120116.17018 | 37.8016631907718 | -122.430165140031 | (37.8016631907718, -122.430165140031) | 13 | 9 | 1 | 57 | 17 | |||
| 42229 | 225994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6005633.11959 | 2109553.55666 | 37.7727505652198 | -122.423926183265 | (37.7727505652198, -122.423926183265) | 7 | 9 | 11 | 28852 | 10 | |||
| 42871 | 108698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) | 13 | 9 | 1 | 57 | 17 |
| 42956 | 17817 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1901X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/29/2012 12:00:00 AM | 3 | 3X3 | 6004800.82205 | 2115382.8409 | 37.7887093176914 | -122.427220498403 | (37.7887093176914, -122.427220498403) | 13 | 9 | 11 | 28858 | 27 | ||
| 43066 | 57165 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2616 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | 13 | 9 | 1 | 29490 | 27 | |||
| 45775 | 107780 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000893.56163 | 2119195.20013 | 37.7989553203824 | -122.441012627647 | (37.7989553203824, -122.441012627647) | 13 | 9 | 1 | 57 | 17 | |
| 46277 | 128886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2201 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002294.64841 | 2119130.10879 | 37.7988562978392 | -122.436159749193 | (37.7988562978392, -122.436159749193) | 13 | 9 | 1 | 57 | 17 | |||
| 46282 | 110937 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 46474 | 30729 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 45 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
| 46635 | 228321 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006257.78716 | 2109887.18689 | 37.7737018797836 | -122.421789087419 | (37.7737018797836, -122.421789087419) | 7 | 9 | 11 | 28852 | 10 | |||
| 47229 | 49961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1881 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46714 | 6004517.12801131 | 2114993.0452944 | 37.7876229893912 | -122.428174248262 | (37.7876229893912, -122.428174248262) | 13 | 9 | 11 | 28858 | 27 | |
| 47248 | 128931 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6004999.26308 | 2116762.74652 | 37.7925094116358 | -122.42663222262 | (37.7925094116358, -122.42663222262) | 13 | 9 | 1 | 28858 | 27 | |||
| 47519 | 128908 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000146.67214 | 2118481.01335 | 37.7969517846466 | -122.443545774121 | (37.7969517846466, -122.443545774121) | 13 | 9 | 1 | 57 | 17 | |||
| 48085 | 128881 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2785 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999690.87391 | 2118073.65713 | 37.7958072876205 | -122.44509363868 | (37.7958072876205, -122.44509363868) | 13 | 9 | 1 | 57 | 17 | |||
| 48949 | 244952 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 290 Page St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | 7 | 9 | 11 | 28852 | 10 | |||
| 49293 | 228291 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 68 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003784.7471 | 2107921.7623 | 37.7681655318274 | -122.430203471821 | (37.7681655318274, -122.430203471821) | 7 | 9 | 5 | 28862 | 3 | |||
| 49478 | 50869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6000989.97476 | 2117606.30096 | 37.7945981122598 | -122.440564982893 | (37.7945981122598, -122.440564982893) | 13 | 9 | 1 | 57 | 27 | |||
| 50865 | 228329 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006643.38674 | 2110482.36773 | 37.7753578410187 | -122.420497491888 | (37.7753578410187, -122.420497491888) | 7 | 9 | 11 | 28852 | 10 | |||
| 50985 | 33117 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | 13 | 9 | 1 | 57 | 17 | |
| 51767 | 128985 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006362.06478 | 2110951.45455 | 37.7766299824148 | -122.421503973538 | (37.7766299824148, -122.421503973538) | 7 | 9 | 11 | 28852 | 10 | |||
| 52190 | 98423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
| 52377 | 128947 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 880 Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005781.19536 | 2112793.6006 | 37.7816552968871 | -122.423644378899 | (37.7816552968871, -122.423644378899) | 7 | 9 | 11 | 28852 | 41 | |||
| 53318 | 228289 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 22 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003765.88833 | 2108198.91876 | 37.7689254679626 | -122.430288478427 | (37.7689254679626, -122.430288478427) | 7 | 9 | 5 | 28862 | 3 | |||
| 55490 | 109788 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 56471 | 49959 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1770X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46714 | 6004517.12801131 | 2114993.0452944 | 37.7876229893912 | -122.428174248262 | (37.7876229893912, -122.428174248262) | 13 | 9 | 11 | 28858 | 27 | |
| 56853 | 107781 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000894.3565 | 2119181.32338 | 37.7989172637699 | -122.441008881075 | (37.7989172637699, -122.441008881075) | 13 | 9 | 1 | 57 | 17 | |
| 57016 | 94116 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 58155 | 129001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1564 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006030.23381 | 2118308.73674 | 37.7968125435181 | -122.423174967846 | (37.7968125435181, -122.423174967846) | 13 | 9 | 10 | 28858 | 32 | |||
| 59102 | 30726 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 45 Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
| 61577 | 225995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 3 | : | Tree | Private 2 | 3 | Width 4ft | 6005634.6441 | 2109541.93365 | 37.7727187373036 | -122.423920083153 | (37.7727187373036, -122.423920083153) | 7 | 9 | 11 | 28852 | 10 | |||
| 61650 | 35468 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 430 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.7805889355944 | -122.418577996505 | (37.7805889355944, -122.418577996505) | 7 | 9 | 9 | 28852 | 36 | |||
| 63597 | 129005 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2620 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006623.13144 | 2120229.16523 | 37.8021189959583 | -122.421259841781 | (37.8021189959583, -122.421259841781) | 5 | 9 | 1 | 28858 | 32 | |||
| 63617 | 48898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2220 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2002 12:00:00 AM | 3 | Permit Number 46101 | 6003904.89835 | 2116333.07844 | 37.7912677221834 | -122.430388088265 | (37.7912677221834, -122.430388088265) | 13 | 9 | 1 | 29490 | 27 | |
| 64861 | 94115 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 65252 | 128972 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 388 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2017 12:00:00 AM | 3 | Width 3ft | 6005916.28411 | 2111770.5884 | 37.7788539797694 | -122.42310429823 | (37.7788539797694, -122.42310429823) | 7 | 9 | 11 | 28852 | 10 | ||
| 65840 | 228317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 3 | Width 3ft | Permit Number 37770 | 6003543.43313 | 2108799.052 | 37.7705606845675 | -122.4311007758 | (37.7705606845675, -122.4311007758) | 15 | 9 | 11 | 29492 | 10 | |
| 66352 | 109786 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 67642 | 138046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 17 WILMOT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003266.873 | 2115013.7912 | 37.7876091337765 | -122.432501364739 | (37.7876091337765, -122.432501364739) | 13 | 9 | 11 | 29490 | 27 | |||
| 68370 | 249647 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2460 Lyon St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | Width 10ft | 5999284.57219 | 2117293.77828 | 37.7936427489551 | -122.446443378971 | (37.7936427489551, -122.446443378971) | 13 | 9 | 1 | 57 | 27 | |||
| 69374 | 128966 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006056.77701 | 2111792.39689 | 37.7789217877593 | -122.42261982717 | (37.7789217877593, -122.42261982717) | 7 | 9 | 11 | 28852 | 10 | |||
| 69788 | 128983 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006393.62293 | 2110955.13092 | 37.7766418561721 | -122.421395065639 | (37.7766418561721, -122.421395065639) | 7 | 9 | 11 | 28852 | 10 | |||
| 70289 | 128885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2201 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002262.59094 | 2119125.25384 | 37.7988411460494 | -122.436270330726 | (37.7988411460494, -122.436270330726) | 13 | 9 | 1 | 57 | 17 | |||
| 70540 | 50452 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2821 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 3 | Permit Number 47098 | 6002052.06788 | 2117856.8779 | 37.7953465532623 | -122.436907957234 | (37.7953465532623, -122.436907957234) | 13 | 9 | 1 | 57 | 27 | ||
| 71952 | 138139 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1790 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004444.7552 | 2114952.0351 | 37.7875062905858 | -122.42842171989 | (37.7875062905858, -122.42842171989) | 13 | 9 | 11 | 28858 | 27 | |||
| 72179 | 128882 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999935.66766 | 2118151.33165 | 37.7960345301288 | -122.444252194282 | (37.7960345301288, -122.444252194282) | 13 | 9 | 1 | 57 | 17 | |||
| 72285 | 138033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Wilmot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6003063.913 | 2114996.9833 | 37.7875514722435 | -122.433202364375 | (37.7875514722435, -122.433202364375) | 13 | 9 | 11 | 29490 | 27 | |||
| 72912 | 128935 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004767.77033 | 2115797.41949 | 37.7898457771089 | -122.427364397564 | (37.7898457771089, -122.427364397564) | 13 | 9 | 1 | 28858 | 27 | |||
| 72946 | 99896 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 768908 | 6004371.30251 | 2116674.47154 | 37.7922315094359 | -122.428798690309 | (37.7922315094359, -122.428798690309) | 13 | 9 | 1 | 28858 | 27 | |||
| 73213 | 117595 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 329x IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3x6 | 6005708 | 2111040 | 37.7768362060225 | -122.423772874681 | (37.7768362060225, -122.423772874681) | 7 | 9 | 11 | 28852 | 10 | ||
| 73554 | 94110 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006363.6521 | 2111083.4813 | 37.7769925854655 | -122.421507861308 | (37.7769925854655, -122.421507861308) | 7 | 9 | 11 | 28852 | 10 | |
| 73563 | 117596 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 329x IVY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3x6 | 6005708 | 2111040 | 37.7768362060225 | -122.423772874681 | (37.7768362060225, -122.423772874681) | 7 | 9 | 11 | 28852 | 10 | ||
| 74135 | 117597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 329x IVY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3x6 | 6005708 | 2111040 | 37.7768362060225 | -122.423772874681 | (37.7768362060225, -122.423772874681) | 7 | 9 | 11 | 28852 | 10 | ||
| 76178 | 87645 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1770X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004459.18866 | 2114839.9257 | 37.7871992830496 | -122.428363789521 | (37.7871992830496, -122.428363789521) | 13 | 9 | 11 | 28858 | 27 | |||
| 76420 | 33316 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346 | (37.8026370063559, -122.42893607346) | 13 | 9 | 1 | 57 | 17 |
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) );