trees
3,247 rows where qSpecies_id = 22 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
136878 | 110521 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
139612 | 110517 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
149801 | 110518 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
150794 | 110522 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
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 | |||
133328 | 128941 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007034.60407 | 2114302.44848 | 37.7858688967833 | -122.419415244113 | (37.7858688967833, -122.419415244113) | 13 | 9 | 9 | 28858 | 36 | |||
139730 | 128942 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007052.43012 | 2114306.6758 | 37.785881507968 | -122.419353870795 | (37.785881507968, -122.419353870795) | 13 | 9 | 9 | 28858 | 36 | |||
166523 | 128940 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007019.65132 | 2114299.92893 | 37.7858611365224 | -122.419466797772 | (37.7858611365224, -122.419466797772) | 13 | 9 | 9 | 28858 | 36 | |||
172966 | 128939 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 999 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007005.09645 | 2114299.52069 | 37.7858591957899 | -122.419517124708 | (37.7858591957899, -122.419517124708) | 13 | 9 | 9 | 28858 | 36 | |||
191344 | 5220 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | 15 | 5 | 11 | 29490 | 41 | ||
3402 | 81722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.391338017739 | (37.758352394954, -122.391338017739) | 10 | 3 | 8 | 28856 | 29 | |||
9806 | 81718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576085 | (37.7581095159642, -122.39130576085) | 10 | 3 | 8 | 28856 | 29 | |||
15486 | 81720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014948.39032 | 2104075.36829 | 37.7582301501175 | -122.39132033706 | (37.7582301501175, -122.39132033706) | 10 | 3 | 8 | 28856 | 29 | |||
128417 | 35560 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 994 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38933 | 6005676.53456798 | 2103185.0108578 | 37.7552664968553 | -122.423323199789 | (37.7552664968553, -122.423323199789) | 2 | 4 | 5 | 28859 | 19 | ||
8872 | 80804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532 | -122.389332239092 | (37.759796756532, -122.389332239092) | 10 | 3 | 8 | 28856 | 29 | |||
19360 | 80805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015535.39126 | 2104617.20142 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | 10 | 3 | 8 | 28856 | 29 | |||
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
6545 | 254389 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
18963 | 262441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
79381 | 219056 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995605.82709 | 2093268.59885 | 37.7274649625165 | -122.457433088986 | (37.7274649625165, -122.457433088986) | 9 | 7 | 4 | 28861 | 40 | |||
11217 | 36019 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.7440602847413 | -122.419391331569 | (37.7440602847413, -122.419391331569) | 2 | 7 | 7 | 28859 | 2 | ||
8396 | 225575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.434436211974 | (37.7703836584071, -122.434436211974) | 15 | 5 | 5 | 29492 | 9 | |||
20089 | 10729 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.5110714 | 2095183.8764266 | 37.7339566260964 | -122.381913486724 | (37.7339566260964, -122.381913486724) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||||
84958 | 110935 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | |||
153970 | 110938 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
188520 | 110936 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
55804 | 116018 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6002644.26893 | 2105609.7942 | 37.761752768149 | -122.433982982543 | (37.761752768149, -122.433982982543) | 15 | 4 | 5 | 28862 | 3 | ||
176671 | 116017 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6002644.26893 | 2105609.7942 | 37.761752768149 | -122.433982982543 | (37.761752768149, -122.433982982543) | 15 | 4 | 5 | 28862 | 3 | ||
44151 | 121298 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||
70703 | 121301 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||||
102220 | 121300 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||||
134361 | 121299 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 98x Elgin Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005790 | 2108524 | 37.7699325053292 | -122.423310314383 | (37.7699325053292, -122.423310314383) | 8 | 2 | 5 | 28853 | 19 | ||||
81706 | 122697 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
101909 | 122699 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
183675 | 122698 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
20531 | 226057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005745.17661 | 2104047.1264 | 37.7576375391616 | -122.423147091592 | (37.7576375391616, -122.423147091592) | 2 | 4 | 5 | 28859 | 19 | |||
55983 | 226056 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005758.1686 | 2104047.53999 | 37.7576394079475 | -122.423102189331 | (37.7576394079475, -122.423102189331) | 2 | 4 | 5 | 28859 | 19 | |||
61005 | 226058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005730.13561 | 2104046.75525 | 37.757635671255 | -122.423199083189 | (37.757635671255, -122.423199083189) | 2 | 4 | 5 | 28859 | 19 | |||
29589 | 129017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010033.78329 | 2117473.19929 | 37.7947434804789 | -122.409262704913 | (37.7947434804789, -122.409262704913) | 3 | 1 | 10 | 28857 | 4 | |||
29718 | 129019 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010068.23962 | 2117476.51245 | 37.7947545079644 | -122.409143714711 | (37.7947545079644, -122.409143714711) | 3 | 1 | 10 | 28857 | 4 | |||
67790 | 129020 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010113.76388 | 2117481.29123 | 37.7947701795629 | -122.408986531214 | (37.7947701795629, -122.408986531214) | 3 | 1 | 10 | 28857 | 4 | |||
72689 | 129022 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010179.58419 | 2117492.42024 | 37.7948044239469 | -122.408759568426 | (37.7948044239469, -122.408759568426) | 3 | 1 | 10 | 28857 | 4 | |||
111317 | 129018 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010048.24656 | 2117474.59523 | 37.794748123684 | -122.40921275837 | (37.794748123684, -122.40921275837) | 3 | 1 | 10 | 28857 | 4 | |||
160038 | 129021 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010133.14197 | 2117484.27799 | 37.7947794659604 | -122.408919690903 | (37.7947794659604, -122.408919690903) | 3 | 1 | 10 | 28857 | 4 | |||
23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
46097 | 51658 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
111239 | 51657 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
131416 | 51659 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
54293 | 172446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 964 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009459.97745 | 2118085.18417 | 37.7963916769881 | -122.411291411782 | (37.7963916769881, -122.411291411782) | 3 | 1 | 10 | 308 | 4 | ||
121110 | 98804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010297.35863 | 2117215.00262 | 37.7940492982967 | -122.408332474088 | (37.7940492982967, -122.408332474088) | 3 | 1 | 10 | 28857 | 4 |
130969 | 116857 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6010080.35093 | 2117187.65635 | 37.793962057763 | -122.409081415981 | (37.793962057763, -122.409081415981) | 3 | 1 | 10 | 28857 | 4 | ||
169090 | 98805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) | 3 | 1 | 10 | 28857 | 4 |
170083 | 98803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
35002 | 98799 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
78186 | 98801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010237.16405 | 2117207.30409 | 37.79402478906 | -122.408540211182 | (37.79402478906, -122.408540211182) | 3 | 1 | 10 | 28857 | 4 | |
95513 | 98800 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010265.98354 | 2117209.83013 | 37.7940333389111 | -122.408440670611 | (37.7940333389111, -122.408440670611) | 3 | 1 | 10 | 28857 | 4 | |
187706 | 98797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010116.35805 | 2117191.91562 | 37.7939757697248 | -122.408957127878 | (37.7939757697248, -122.408957127878) | 3 | 1 | 10 | 28857 | 4 | |
45429 | 192433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011659.35399 | 2111367.95244 | 37.7780708492141 | -122.403208304326 | (37.7780708492141, -122.403208304326) | 14 | 2 | 9 | 28856 | 34 | |||
58742 | 46278 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 6 | Permit Number 44559 | 6011747.79836 | 2111454.68409 | 37.7783139332727 | -122.402908443379 | (37.7783139332727, -122.402908443379) | 14 | 2 | 9 | 28856 | 34 | ||
61666 | 46277 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44559 | 6011769.32018 | 2111474.71903 | 37.7783701463122 | -122.402835400428 | (37.7783701463122, -122.402835400428) | 14 | 2 | 9 | 28856 | 34 | ||
87378 | 46279 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 4 | Permit Number 44559 | 6011712.63161 | 2111419.43384 | 37.7782151805114 | -122.40302761884 | (37.7782151805114, -122.40302761884) | 14 | 2 | 9 | 28856 | 34 | ||
142163 | 192432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6011668.99845 | 2111377.71615 | 37.7780981967176 | -122.403175627468 | (37.7780981967176, -122.403175627468) | 14 | 2 | 9 | 28856 | 34 | |||
160835 | 46276 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44559 | 6011785.75336 | 2111490.43088 | 37.7784142049779 | -122.402779656872 | (37.7784142049779, -122.402779656872) | 14 | 2 | 9 | 28856 | 34 | ||
164332 | 46275 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 3 | 3x3 | Permit Number 44559 | 6011683.17622 | 2111391.81389 | 37.7781376976202 | -122.403127573075 | (37.7781376976202, -122.403127573075) | 14 | 2 | 9 | 28856 | 34 | |
167271 | 46280 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 4 | Permit Number 44559 | 6011730.78732 | 2111437.87728 | 37.7782668357705 | -122.402966108791 | (37.7782668357705, -122.402966108791) | 14 | 2 | 9 | 28856 | 34 | ||
188988 | 98791 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | 3 | 1 | 10 | 28857 | 4 | |
8238 | 195098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6015116.41348 | 2103939.58285 | 37.7578666360554 | -122.390729746003 | (37.7578666360554, -122.390729746003) | 10 | 3 | 8 | 28856 | 29 | |||
103865 | 95014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 95 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010465.4 | 2087260.9 | 37.7118113779993 | -122.405640255324 | (37.7118113779993, -122.405640255324) | 9 | 7 | 8 | 309 | 39 | ||||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
99627 | 107884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
122492 | 107885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
163523 | 107883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
171481 | 107886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
171965 | 226004 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 94 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 7ft | 6006211.97543 | 2099539.93145 | 37.7452881477378 | -122.421212661561 | (37.7452881477378, -122.421212661561) | 2 | 7 | 5 | 28859 | 2 | |||
146600 | 141104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 94 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996713.4321 | 2112519.8611 | 37.7803876592113 | -122.454994576895 | (37.7803876592113, -122.454994576895) | 11 | 6 | 2 | 54 | 16 | |||
37256 | 4902 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 94 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017502.5740617 | 2095232.3549831 | 37.73409045999 | -122.381871694314 | (37.73409045999, -122.381871694314) | 10 | 3 | 8 | 58 | 1 | ||
120820 | 226048 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 939 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009966.30699 | 2103737.55457 | 37.7570248301416 | -122.408526798688 | (37.7570248301416, -122.408526798688) | 2 | 4 | 7 | 28859 | 19 | |||
30779 | 225748 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003741.02277 | 2102799.93356 | 37.7540997393121 | -122.429989306366 | (37.7540997393121, -122.429989306366) | 2 | 4 | 5 | 28862 | 22 | |||
179242 | 225747 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003740.09444 | 2102804.53814 | 37.754112329828 | -122.429992845196 | (37.754112329828, -122.429992845196) | 2 | 4 | 5 | 28862 | 22 | |||
21646 | 44771 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
50055 | 44778 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
85276 | 44777 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
96115 | 44775 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
98208 | 44770 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
98998 | 44774 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
118757 | 44776 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
136601 | 44772 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
158403 | 44773 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
99777 | 128944 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 930 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005719.79248 | 2112825.02179 | 37.7817381055603 | -122.423859038957 | (37.7817381055603, -122.423859038957) | 7 | 9 | 11 | 28852 | 41 | |||
173172 | 60269 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 930 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2007 12:00:00 AM | Permit No. 49263 | 6009376.47544968 | 2103749.96199504 | 37.7570258477157 | -122.410567544275 | (37.7570258477157, -122.410567544275) | 2 | 4 | 7 | 28859 | 19 | ||
54607 | 108196 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 930 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | 2 | 4 | 7 | 28859 | 19 | |||||
11687 | 95013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.405649829104 | (37.7118779294401, -122.405649829104) | 9 | 7 | 8 | 309 | 39 |
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) );