Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23026 | 23026 | 21824 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2741 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6008240.407980001 | 2122263.00335 | 37.8077944465112 | -122.415807371838 | (37.8077944465112, -122.415807371838) | |||
154474 | 154474 | 130949 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2615 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008295.257540001 | 2121884.0209 | 37.80675694004471 | -122.41559070084499 | (37.8067569400447, -122.415590700845) | |||
99916 | 99916 | 21813 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2633 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | ||
4619 | 4619 | 130948 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2361 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/2015 12:00:00 AM | 2 | Width 3ft | 6008329.55597 | 2121605.69745 | 37.8059946620911 | -122.41545228710501 | (37.8059946620911, -122.415452287105) | ||
145339 | 145339 | 21788 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2585 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | ||
153892 | 153892 | 130607 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1410 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002443.95782 | 2121625.2952900003 | 37.8057159055264 | -122.435821714711 | (37.8057159055264, -122.435821714711) | |||
44676 | 44676 | 143154 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2017 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010301.2446 | 2121458.3909 | 37.8057008191213 | -122.408618514203 | (37.8057008191213, -122.408618514203) | |||
178752 | 178752 | 64350 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2233 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1988 12:00:00 AM | 14 | Permit Number 25186 | 6009339.9131 | 2121381.1435 | 37.80543482991229 | -122.411939892864 | (37.8054348299123, -122.411939892864) | ||
182105 | 182105 | 71431 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | ||
165368 | 165368 | 142701 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2450 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008418.6967 | 2121348.7772 | 37.8052942337736 | -122.415125602969 | (37.8052942337736, -122.415125602969) | |||
36081 | 36081 | 130608 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3730 Webster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6002569.200540001 | 2121458.63125 | 37.8052654036378 | -122.435376365035 | (37.8052654036378, -122.435376365035) | |||
151831 | 151831 | 142649 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2111 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009833.562000001 | 2121305.911 | 37.8052559432141 | -122.410226232656 | (37.8052559432141, -122.410226232656) | |||
157406 | 157406 | 142700 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2450 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008419.2668 | 2121323.1249 | 37.8052238310614 | -122.415121813151 | (37.8052238310614, -122.415121813151) | |||
158307 | 158307 | 69370 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3730 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 10 | Permit Number 33464 | 6002569.58562 | 2121440.71208 | 37.8052162242015 | -122.435373749816 | (37.8052162242015, -122.435373749816) | |
165685 | 165685 | 69351 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3747 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 15 | Permit Number 33442 | 6001992.91155 | 2121450.30554 | 37.8052097985611 | -122.437370085564 | (37.8052097985611, -122.437370085564) | |
78979 | 78979 | 21769 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
89357 | 89357 | 21775 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
93829 | 93829 | 21768 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
99865 | 99865 | 21772 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
101517 | 101517 | 21774 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 6 | 4x4 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | ||
102079 | 102079 | 21770 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | ||
111132 | 111132 | 21771 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
123113 | 123113 | 21773 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2495X Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008373.539903 | 2121303.5524130003 | 37.80516752013779 | -122.41527867083799 | (37.8051675201378, -122.415278670838) | |||
23949 | 23949 | 142707 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2449 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008379.5042 | 2121293.6328 | 37.8051406185808 | -122.415257327963 | (37.8051406185808, -122.415257327963) | |||
35018 | 35018 | 142650 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 300 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009812.9504 | 2121264.1724 | 37.805140184051 | -122.41029461316099 | (37.805140184051, -122.410294613161) | |||
64632 | 64632 | 71432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 265 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 6 | Permit Number 774166 | 6010066.2856 | 2121257.2948 | 37.805135497346 | -122.409417426777 | (37.805135497346, -122.409417426777) | |
147030 | 147030 | 142699 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2440 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6008424.9673 | 2121275.5258 | 37.805093456275 | -122.415098714484 | (37.805093456275, -122.415098714484) | |||
75677 | 75677 | 143225 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 275 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009963.1531 | 2121243.4037 | 37.805091576851396 | -122.409773349552 | (37.8050915768514, -122.409773349552) | |||
55232 | 55232 | 143224 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 281 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009943.3996 | 2121240.2176 | 37.805081721611096 | -122.409841484115 | (37.8050817216111, -122.409841484115) | |||
18618 | 18618 | 98576 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
49056 | 49056 | 142698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2430 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008430.0977 | 2121244.7431 | 37.8050092230426 | -122.415078779844 | (37.8050092230426, -122.415078779844) | |||
37792 | 37792 | 142708 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2449 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008382.691000001 | 2121245.3002 | 37.8050080885425 | -122.415242876101 | (37.8050080885425, -122.415242876101) | |||
187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
32393 | 32393 | 142697 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2430 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008435.7982 | 2121215.1005 | 37.8049281522696 | -122.41505695309799 | (37.8049281522696, -122.415056953098) | |||
46882 | 46882 | 142709 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2449 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008389.5956 | 2121212.3703 | 37.8049180593721 | -122.415216649398 | (37.8049180593721, -122.415216649398) | |||
25881 | 25881 | 142696 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2420 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008439.7886 | 2121183.7478 | 37.8048422898895 | -122.415040923283 | (37.8048422898895, -122.415040923283) | |||
57469 | 57469 | 142710 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2431 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008393.8447 | 2121181.5649 | 37.8048337143002 | -122.415199762904 | (37.8048337143002, -122.415199762904) | |||
44092 | 44092 | 58203 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3710 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 7 | Permit Number 33432 | 6002102.41669 | 2121302.62052 | 37.804810519355 | -122.436980550526 | (37.804810519355, -122.436980550526) | ||
170824 | 170824 | 142966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1925 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010344.2214 | 2121127.0433 | 37.8047934276651 | -122.40844639891 | (37.8047934276651, -122.40844639891) | |||
76253 | 76253 | 142711 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2425 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008395.9692 | 2121161.9132 | 37.8047798750762 | -122.415191018887 | (37.8047798750762, -122.415191018887) | |||
43400 | 43400 | 142695 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2420 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008443.7789 | 2121154.6753 | 37.804762688355396 | -122.415025055344 | (37.8047626883554, -122.415025055344) | |||
172240 | 172240 | 142967 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1925 GRANT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010343.755 | 2121112.5855 | 37.8047537040102 | -122.408446992497 | (37.8047537040102, -122.408446992497) | |||
157324 | 157324 | 130494 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3636 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999178.804830001 | 2121342.50895 | 37.8047534357904 | -122.44710084811899 | (37.8047534357904, -122.447100848119) | |||
40409 | 40409 | 130495 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3636 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999167.03977 | 2121341.8360099997 | 37.804750915876 | -122.44714151369 | (37.804750915876, -122.44714151369) | |||
31589 | 31589 | 142712 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2425 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008400.7493 | 2121143.3237 | 37.8047291016251 | -122.41517316011699 | (37.8047291016251, -122.415173160117) | |||
34343 | 34343 | 142694 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2410 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6008448.3393 | 2121130.1631 | 37.8046956402899 | -122.41500753752199 | (37.8046956402899, -122.415007537522) | |||
166686 | 166686 | 130493 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3636 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999170.74175 | 2121320.42041 | 37.8046923259617 | -122.447127160497 | (37.8046923259617, -122.447127160497) | |||
171929 | 171929 | 143282 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1919 GRANT AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6010347.0196 | 2121086.0019 | 37.8046808948511 | -122.408433818682 | (37.8046808948511, -122.408433818682) | |||
147178 | 147178 | 142713 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2415 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008400.7493 | 2121122.6097 | 37.80467222619679 | -122.415171692954 | (37.8046722261968, -122.415171692954) | |||
99970 | 99970 | 30448 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 162 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | Permit Number 97 | 6001177.91304525 | 2121268.79222575 | 37.8046650454957 | -122.44017745720501 | (37.8046650454957, -122.440177457205) | |||
175282 | 175282 | 130956 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 159 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011155.36791 | 2121057.17715 | 37.804646983936 | -122.405634403599 | (37.804646983936, -122.405634403599) | |||
167947 | 167947 | 130955 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 159 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011140.46997 | 2121055.2291 | 37.804640801990004 | -122.40568582233801 | (37.80464080199, -122.405685822338) | |||
23552 | 23552 | 142693 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2410 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008450.6195 | 2121097.1003 | 37.804604986293796 | -122.41499730502899 | (37.8046049862938, -122.414997305029) | |||
119309 | 119309 | 55908 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3700 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52033 | 5999664.71321 | 2121276.06917 | 37.8045987604857 | -122.44541453836 | (37.8045987604857, -122.44541453836) | |
71036 | 71036 | 142714 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2415 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008404.9983 | 2121095.5222 | 37.8045980895264 | -122.41515507024799 | (37.8045980895264, -122.415155070248) | |||
162318 | 162318 | 130951 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011318.41105 | 2121033.08349 | 37.8045899444258 | -122.40506847644501 | (37.8045899444258, -122.405068476445) | |||
55716 | 55716 | 21765 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/1999 12:00:00 AM | 3 | 3X3 | 6008457.434245901 | 2121063.933871 | 37.804514302563895 | -122.41497137296301 | (37.8045143025639, -122.414971372963) | ||
116763 | 116763 | 21764 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/1999 12:00:00 AM | 4 | 3X5 | 6008457.434245901 | 2121063.933871 | 37.804514302563895 | -122.41497137296301 | (37.8045143025639, -122.414971372963) | ||
101695 | 101695 | 21766 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | ||
102139 | 102139 | 21760 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | ||
108634 | 108634 | 21761 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | |||
113034 | 113034 | 21759 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | |||
116094 | 116094 | 21767 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | ||
117383 | 117383 | 21763 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | |||
139144 | 139144 | 21758 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1992 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | ||
146185 | 146185 | 21762 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2400X Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008457.43425 | 2121063.9338700003 | 37.804514302561294 | -122.41497137294901 | (37.8045143025613, -122.414971372949) | |||
162760 | 162760 | 142563 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 555 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008640.5494 | 2121060.0298 | 37.8045138709312 | -122.414337407838 | (37.8045138709312, -122.414337407838) | |||
134570 | 134570 | 130950 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011323.352530001 | 2120991.25336 | 37.8044753654006 | -122.40504842875 | (37.8044753654006, -122.40504842875) | |||
144449 | 144449 | 29749 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2399X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008409.403630001 | 2121046.09417 | 37.8044626201651 | -122.415136324243 | (37.8044626201651, -122.415136324243) | ||
173992 | 173992 | 142565 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 583 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008509.1559 | 2121042.1339 | 37.8044573515499 | -122.414790841135 | (37.8044573515499, -122.414790841135) | |||
67042 | 67042 | 130492 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3600 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999183.88886 | 2121232.4978400003 | 37.804451665577396 | -122.44707533255699 | (37.8044516655774, -122.447075332557) | |||
62137 | 62137 | 142564 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 585 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008487.9634 | 2121040.2501 | 37.804450988342296 | -122.414864046478 | (37.8044509883423, -122.414864046478) | |||
173332 | 173332 | 130502 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | |||
148585 | 148585 | 130957 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011282.95134 | 2120977.70481 | 37.804435905853296 | -122.40518728677401 | (37.8044359058533, -122.405187286774) | |||
129987 | 129987 | 130501 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.804433356268895 | -122.44492317037201 | (37.8044333562689, -122.444923170372) | |||
109654 | 109654 | 7695 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 593 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6008478.30149 | 2121033.13033 | 37.8044308963449 | -122.414896978257 | (37.8044308963449, -122.414896978257) | |||
119472 | 119472 | 7696 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 593 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6008478.30149 | 2121033.13033 | 37.8044308963449 | -122.414896978257 | (37.8044308963449, -122.414896978257) | |||
88914 | 88914 | 7692 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 575 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008592.045580001 | 2121028.31371 | 37.804424061757494 | -122.41450301461599 | (37.8044240617575, -122.414503014616) | ||
76079 | 76079 | 87874 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1975 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50846 | 5999774.890869999 | 2121208.24001 | 37.8044188088434 | -122.44502838025299 | (37.8044188088434, -122.445028380253) | |
33062 | 33062 | 68979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3748 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 11 | Permit Number 32969 | 6000173.53852 | 2121195.0306599997 | 37.804405283944895 | -122.443647880443 | (37.8044052839449, -122.443647880443) | |
49099 | 49099 | 130491 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3600 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999185.88824 | 2121208.01394 | 37.8043845536551 | -122.447066650499 | (37.8043845536551, -122.447066650499) | |||
134441 | 134441 | 130958 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011286.3808699995 | 2120955.76241 | 37.804375849141394 | -122.40517387247101 | (37.8043758491414, -122.405173872471) | |||
7957 | 7957 | 21757 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008462.5324 | 2121012.4644 | 37.8043732668186 | -122.414950085154 | (37.8043732668186, -122.414950085154) | |||
127992 | 127992 | 59832 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2080 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | Permit Number 19285 | 5999268.33868417 | 2121186.40779193 | 37.8043299394007 | -122.446779769241 | (37.8043299394007, -122.446779769241) | ||
1566 | 1566 | 21756 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.41494559157199 | (37.8043254753522, -122.414945591572) | |||
67257 | 67257 | 130602 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2098 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999214.22058 | 2121174.78163 | 37.804294925432295 | -122.44696621152399 | (37.8042949254323, -122.446966211524) | |||
32383 | 32383 | 249815 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1740 Kearny St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 6010857.72173 | 2120932.6485599997 | 37.8042884107407 | -122.406655661138 | (37.8042884107407, -122.406655661138) | |||
1396 | 1396 | 21755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | |||
64931 | 64931 | 249814 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1740 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010861.46651 | 2120893.20029 | 37.8041803050268 | -122.40663992031901 | (37.8041803050268, -122.406639920319) | |||
173965 | 173965 | 48837 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3700X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 4 | Permit Number 46054 | 6003123.001069999 | 2121037.37532 | 37.8041401808883 | -122.433429748295 | (37.8041401808883, -122.433429748295) | ||
61626 | 61626 | 35679 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 888 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 4 | Permit Number 38985 | 6007117.3304 | 2120899.52807 | 37.803987491295 | -122.419597262408 | (37.803987491295, -122.419597262408) | ||
184859 | 184859 | 35680 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 888 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 4 | Permit Number 38985 | 6007093.37266 | 2120896.31156 | 37.803977310053796 | -122.419679941575 | (37.8039773100538, -122.419679941575) | ||
68754 | 68754 | 62422 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 95 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1985 12:00:00 AM | 8 | Permit Number 22579 | 6001457.33968 | 2121011.90467 | 37.8039756049481 | -122.43919205268101 | (37.8039756049481, -122.439192052681) | ||
183232 | 183232 | 130603 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 95 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001474.70029 | 2121000.99469 | 37.8039466368988 | -122.43913119287 | (37.8039466368988, -122.43913119287) | |||
126226 | 126226 | 142590 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2340 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6008485.6087 | 2120854.6980000003 | 37.803941376606005 | -122.41485905476802 | (37.803941376606, -122.414859054768) | |||
29082 | 29082 | 130959 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011307.66946 | 2120789.85005 | 37.8039214846418 | -122.405088511532 | (37.8039214846418, -122.405088511532) | |||
23342 | 23342 | 4711 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6008439.857000001 | 2120847.9647 | 37.8039203178058 | -122.41501690508801 | (37.8039203178058, -122.415016905088) | |||
52956 | 52956 | 142589 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2334 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008484.6668 | 2120837.273 | 37.8038934790088 | -122.414861080292 | (37.8038934790088, -122.414861080292) | |||
74001 | 74001 | 130604 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 95 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001502.4675199995 | 2120981.00729 | 37.8038933367603 | -122.439033669467 | (37.8038933367603, -122.439033669467) | |||
183906 | 183906 | 142588 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2330 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008488.4343 | 2120815.1386 | 37.8038329151977 | -122.41484647509701 | (37.8038329151977, -122.414846475097) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");