trees
6,344 rows where qSpecies_id = 19 sorted by YCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36363 | 21824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2741 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6008240.40798 | 2122263.00335 | 37.8077944465112 | -122.415807371838 | (37.8077944465112, -122.415807371838) | 5 | 1 | 10 | 308 | 23 | |||
67238 | 130949 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2615 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008295.25754 | 2121884.0209 | 37.8067569400447 | -122.415590700845 | (37.8067569400447, -122.415590700845) | 5 | 1 | 10 | 308 | 23 | |||
103180 | 21813 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2633 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | 5 | 1 | 10 | 308 | 23 | ||
162406 | 255994 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 179 Retiro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6001908 | 2121813 | 37.8062008335618 | -122.437689923584 | (37.8062008335618, -122.437689923584) | 13 | 9 | 1 | 57 | 17 | ||||
139860 | 128055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | 3 | 1 | 10 | 308 | 23 | |
37379 | 130607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1410 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002443.95782 | 2121625.29529 | 37.8057159055264 | -122.435821714711 | (37.8057159055264, -122.435821714711) | 13 | 9 | 1 | 57 | 17 | |||
103593 | 130948 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/2015 12:00:00 AM | 2 | Width 3ft | 6008329.55597 | 2121605.69745 | 37.8059946620911 | -122.415452287105 | (37.8059946620911, -122.415452287105) | 5 | 1 | 10 | 308 | 23 | ||
191196 | 21788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2585 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | ||
161450 | 130608 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3730 Webster St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6002569.20054 | 2121458.63125 | 37.8052654036378 | -122.435376365035 | (37.8052654036378, -122.435376365035) | 13 | 9 | 1 | 57 | 17 | |||
52460 | 143154 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2017 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010301.2446 | 2121458.3909 | 37.8057008191213 | -122.408618514203 | (37.8057008191213, -122.408618514203) | 3 | 1 | 10 | 308 | 23 | |||
185106 | 69351 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3747 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 15 | Permit Number 33442 | 6001992.91155 | 2121450.30554 | 37.8052097985611 | -122.437370085564 | (37.8052097985611, -122.437370085564) | 13 | 9 | 1 | 57 | 17 | |
141739 | 69370 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3730 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 10 | Permit Number 33464 | 6002569.58562 | 2121440.71208 | 37.8052162242015 | -122.435373749816 | (37.8052162242015, -122.435373749816) | 13 | 9 | 1 | 57 | 17 | |
125919 | 64350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2233 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1988 12:00:00 AM | 14 | Permit Number 25186 | 6009339.9131 | 2121381.1435 | 37.8054348299123 | -122.411939892864 | (37.8054348299123, -122.411939892864) | 3 | 1 | 10 | 308 | 23 | ||
124494 | 130609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1500 Beach St | 1 | Side Yard : Yard | Tree | Private 2 | 20 | 6002918.83172 | 2121356.11513 | 37.8050037710817 | -122.434159090397 | (37.8050037710817, -122.434159090397) | 13 | 9 | 1 | 57 | 17 | ||||
77288 | 142701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2450 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008418.6967 | 2121348.7772 | 37.8052942337736 | -122.415125602969 | (37.8052942337736, -122.415125602969) | 5 | 1 | 10 | 308 | 23 | |||
90696 | 130494 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3636 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999178.80483 | 2121342.50895 | 37.8047534357904 | -122.447100848119 | (37.8047534357904, -122.447100848119) | 13 | 9 | 1 | 57 | 17 | |||
186364 | 130495 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3636 Baker St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999167.03977 | 2121341.83601 | 37.804750915876 | -122.44714151369 | (37.804750915876, -122.44714151369) | 13 | 9 | 1 | 57 | 17 | |||
4219 | 71431 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | 3 | 1 | 10 | 308 | 23 | |||
27411 | 142700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2450 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008419.2668 | 2121323.1249 | 37.8052238310614 | -122.415121813151 | (37.8052238310614, -122.415121813151) | 5 | 1 | 10 | 308 | 23 | |||
177724 | 130493 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3636 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999170.74175 | 2121320.42041 | 37.8046923259617 | -122.447127160497 | (37.8046923259617, -122.447127160497) | 13 | 9 | 1 | 57 | 17 | |||
170912 | 142649 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2111 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009833.562 | 2121305.911 | 37.8052559432141 | -122.410226232656 | (37.8052559432141, -122.410226232656) | 3 | 1 | 10 | 308 | 23 | |||
56584 | 21769 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
65754 | 21775 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
80018 | 21768 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
98677 | 21774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 6 | 4x4 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | ||
112737 | 21770 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | ||
112915 | 21772 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
136596 | 21771 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
155209 | 21773 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2495X Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008373.539903 | 2121303.552413 | 37.8051675201378 | -122.415278670838 | (37.8051675201378, -122.415278670838) | 5 | 1 | 10 | 308 | 23 | |||
45776 | 58203 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3710 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 7 | Permit Number 33432 | 6002102.41669 | 2121302.62052 | 37.804810519355 | -122.436980550526 | (37.804810519355, -122.436980550526) | 13 | 9 | 1 | 57 | 17 | ||
103720 | 142707 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2449 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008379.5042 | 2121293.6328 | 37.8051406185808 | -122.415257327963 | (37.8051406185808, -122.415257327963) | 5 | 1 | 10 | 308 | 23 | |||
76961 | 55908 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3700 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52033 | 5999664.71321 | 2121276.06917 | 37.8045987604857 | -122.44541453836 | (37.8045987604857, -122.44541453836) | 13 | 9 | 1 | 57 | 17 | |
34931 | 142699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2440 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008424.9673 | 2121275.5258 | 37.805093456275 | -122.415098714484 | (37.805093456275, -122.415098714484) | 5 | 1 | 10 | 308 | 23 | |||
109452 | 30448 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 162 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 97 | 6001177.91304525 | 2121268.79222575 | 37.8046650454957 | -122.440177457205 | (37.8046650454957, -122.440177457205) | 13 | 9 | 1 | 57 | 17 | |||
60035 | 142650 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009812.9504 | 2121264.1724 | 37.805140184051 | -122.410294613161 | (37.805140184051, -122.410294613161) | 3 | 1 | 10 | 308 | 23 | |||
34592 | 71432 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 265 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2015 12:00:00 AM | 6 | Permit Number 774166 | 6010066.2856 | 2121257.2948 | 37.805135497346 | -122.409417426777 | (37.805135497346, -122.409417426777) | 3 | 1 | 10 | 308 | 23 | |
24857 | 142708 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2449 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008382.691 | 2121245.3002 | 37.8050080885425 | -122.415242876101 | (37.8050080885425, -122.415242876101) | 5 | 1 | 10 | 308 | 23 | |||
85014 | 142698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2430 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008430.0977 | 2121244.7431 | 37.8050092230426 | -122.415078779844 | (37.8050092230426, -122.415078779844) | 5 | 1 | 10 | 308 | 23 | |||
186694 | 143225 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 275 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6009963.1531 | 2121243.4037 | 37.8050915768514 | -122.409773349552 | (37.8050915768514, -122.409773349552) | 3 | 1 | 10 | 308 | 23 | |||
45960 | 143224 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 281 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009943.3996 | 2121240.2176 | 37.8050817216111 | -122.409841484115 | (37.8050817216111, -122.409841484115) | 3 | 1 | 10 | 308 | 23 | |||
120562 | 130492 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999183.88886 | 2121232.49784 | 37.8044516655774 | -122.447075332557 | (37.8044516655774, -122.447075332557) | 13 | 9 | 1 | 57 | 17 | |||
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
184939 | 142697 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2430 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008435.7982 | 2121215.1005 | 37.8049281522696 | -122.415056953098 | (37.8049281522696, -122.415056953098) | 5 | 1 | 10 | 308 | 23 | |||
166687 | 142709 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2449 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008389.5956 | 2121212.3703 | 37.8049180593721 | -122.415216649398 | (37.8049180593721, -122.415216649398) | 5 | 1 | 10 | 308 | 23 | |||
164244 | 87874 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1975 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50846 | 5999774.89087 | 2121208.24001 | 37.8044188088434 | -122.445028380253 | (37.8044188088434, -122.445028380253) | 13 | 9 | 1 | 57 | 17 | |
127379 | 130491 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5999185.88824 | 2121208.01394 | 37.8043845536551 | -122.447066650499 | (37.8043845536551, -122.447066650499) | 13 | 9 | 1 | 57 | 17 | |||
131211 | 68979 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3748 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 11 | Permit Number 32969 | 6000173.53852 | 2121195.03066 | 37.8044052839449 | -122.443647880443 | (37.8044052839449, -122.443647880443) | 13 | 9 | 1 | 57 | 17 | |
21792 | 59832 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2080 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1990 12:00:00 AM | Permit Number 19285 | 5999268.33868417 | 2121186.40779193 | 37.8043299394007 | -122.446779769241 | (37.8043299394007, -122.446779769241) | 13 | 9 | 1 | 57 | 17 | ||
141983 | 142696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2420 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008439.7886 | 2121183.7478 | 37.8048422898895 | -122.415040923283 | (37.8048422898895, -122.415040923283) | 5 | 1 | 10 | 308 | 23 | |||
76101 | 142710 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2431 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008393.8447 | 2121181.5649 | 37.8048337143002 | -122.415199762904 | (37.8048337143002, -122.415199762904) | 5 | 1 | 10 | 308 | 23 | |||
130150 | 130602 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2098 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999214.22058 | 2121174.78163 | 37.8042949254323 | -122.446966211524 | (37.8042949254323, -122.446966211524) | 13 | 9 | 1 | 57 | 17 | |||
62247 | 142711 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2425 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008395.9692 | 2121161.9132 | 37.8047798750762 | -122.415191018887 | (37.8047798750762, -122.415191018887) | 5 | 1 | 10 | 308 | 23 | |||
29083 | 142695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2420 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008443.7789 | 2121154.6753 | 37.8047626883554 | -122.415025055344 | (37.8047626883554, -122.415025055344) | 5 | 1 | 10 | 308 | 23 | |||
65304 | 142712 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2425 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008400.7493 | 2121143.3237 | 37.8047291016251 | -122.415173160117 | (37.8047291016251, -122.415173160117) | 5 | 1 | 10 | 308 | 23 | |||
187953 | 142694 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2410 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6008448.3393 | 2121130.1631 | 37.8046956402899 | -122.415007537522 | (37.8046956402899, -122.415007537522) | 3 | 1 | 10 | 308 | 23 | |||
86632 | 142966 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 GRANT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010344.2214 | 2121127.0433 | 37.8047934276651 | -122.40844639891 | (37.8047934276651, -122.40844639891) | 3 | 1 | 10 | 308 | 23 | |||
70931 | 142713 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2415 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008400.7493 | 2121122.6097 | 37.8046722261968 | -122.415171692954 | (37.8046722261968, -122.415171692954) | 5 | 1 | 10 | 308 | 23 | |||
64515 | 142967 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 GRANT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010343.755 | 2121112.5855 | 37.8047537040102 | -122.408446992497 | (37.8047537040102, -122.408446992497) | 3 | 1 | 10 | 308 | 23 | |||
107677 | 142693 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2410 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008450.6195 | 2121097.1003 | 37.8046049862938 | -122.414997305029 | (37.8046049862938, -122.414997305029) | 5 | 1 | 10 | 308 | 23 | |||
130422 | 142714 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2415 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008404.9983 | 2121095.5222 | 37.8045980895264 | -122.415155070248 | (37.8045980895264, -122.415155070248) | 5 | 1 | 10 | 308 | 23 | |||
52909 | 143282 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1919 GRANT AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 6010347.0196 | 2121086.0019 | 37.8046808948511 | -122.408433818682 | (37.8046808948511, -122.408433818682) | 3 | 1 | 10 | 308 | 23 | |||
15435 | 21765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/1999 12:00:00 AM | 3 | 3X3 | 6008457.4342459 | 2121063.933871 | 37.8045143025639 | -122.414971372963 | (37.8045143025639, -122.414971372963) | 3 | 1 | 10 | 308 | 23 | ||
163995 | 21764 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/1999 12:00:00 AM | 4 | 3X5 | 6008457.4342459 | 2121063.933871 | 37.8045143025639 | -122.414971372963 | (37.8045143025639, -122.414971372963) | 3 | 1 | 10 | 308 | 23 | ||
99849 | 21760 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | ||
103579 | 21766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | ||
120830 | 21761 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | |||
135664 | 21759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | |||
137944 | 21767 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | ||
165453 | 21763 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | |||
175906 | 21758 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/1992 12:00:00 AM | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | ||
193478 | 21762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2400X Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008457.43425 | 2121063.93387 | 37.8045143025613 | -122.414971372949 | (37.8045143025613, -122.414971372949) | 3 | 1 | 10 | 308 | 23 | |||
41797 | 130956 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 159 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011155.36791 | 2121057.17715 | 37.804646983936 | -122.405634403599 | (37.804646983936, -122.405634403599) | 3 | 1 | 10 | 28860 | 23 | |||
66055 | 130955 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 159 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011140.46997 | 2121055.2291 | 37.80464080199 | -122.405685822338 | (37.80464080199, -122.405685822338) | 3 | 1 | 10 | 28860 | 23 | |||
178887 | 29749 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2399X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008409.40363 | 2121046.09417 | 37.8044626201651 | -122.415136324243 | (37.8044626201651, -122.415136324243) | 5 | 1 | 10 | 308 | 23 | ||
42790 | 142565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 583 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008509.1559 | 2121042.1339 | 37.8044573515499 | -122.414790841135 | (37.8044573515499, -122.414790841135) | 3 | 1 | 10 | 308 | 23 | |||
180847 | 142564 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 585 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008487.9634 | 2121040.2501 | 37.8044509883423 | -122.414864046478 | (37.8044509883423, -122.414864046478) | 3 | 1 | 10 | 308 | 23 | |||
158020 | 48837 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3700X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 4 | Permit Number 46054 | 6003123.00107 | 2121037.37532 | 37.8041401808883 | -122.433429748295 | (37.8041401808883, -122.433429748295) | 13 | 9 | 1 | 57 | 17 | ||
128181 | 7695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 593 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6008478.30149 | 2121033.13033 | 37.8044308963449 | -122.414896978257 | (37.8044308963449, -122.414896978257) | 3 | 1 | 10 | 308 | 23 | |||
164500 | 7696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 593 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6008478.30149 | 2121033.13033 | 37.8044308963449 | -122.414896978257 | (37.8044308963449, -122.414896978257) | 3 | 1 | 10 | 308 | 23 | |||
113665 | 130951 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011318.41105 | 2121033.08349 | 37.8045899444258 | -122.405068476445 | (37.8045899444258, -122.405068476445) | 3 | 1 | 10 | 28860 | 6 | |||
73043 | 7692 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 575 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6008592.04558 | 2121028.31371 | 37.8044240617575 | -122.414503014616 | (37.8044240617575, -122.414503014616) | 3 | 1 | 10 | 308 | 23 | ||
68960 | 21757 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008462.5324 | 2121012.4644 | 37.8043732668186 | -122.414950085154 | (37.8043732668186, -122.414950085154) | 5 | 1 | 10 | 308 | 23 | |||
115619 | 62422 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 95 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1985 12:00:00 AM | 8 | Permit Number 22579 | 6001457.33968 | 2121011.90467 | 37.8039756049481 | -122.439192052681 | (37.8039756049481, -122.439192052681) | 13 | 9 | 1 | 57 | 17 | ||
97091 | 130603 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 95 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001474.70029 | 2121000.99469 | 37.8039466368988 | -122.43913119287 | (37.8039466368988, -122.43913119287) | 13 | 9 | 1 | 57 | 17 | |||
25833 | 21756 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008463.4743 | 2120995.0395 | 37.8043254753522 | -122.414945591572 | (37.8043254753522, -122.414945591572) | 5 | 1 | 10 | 308 | 23 | |||
36486 | 130593 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3621 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999657.88862 | 2120993.39037 | 37.8038222111963 | -122.445417817273 | (37.8038222111963, -122.445417817273) | 13 | 9 | 1 | 57 | 17 | |||
81727 | 130950 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011323.35253 | 2120991.25336 | 37.8044753654006 | -122.40504842875 | (37.8044753654006, -122.40504842875) | 3 | 1 | 10 | 28860 | 6 | |||
188541 | 130604 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 95 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001502.46752 | 2120981.00729 | 37.8038933367603 | -122.439033669467 | (37.8038933367603, -122.439033669467) | 13 | 9 | 1 | 57 | 17 | |||
92851 | 130957 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011282.95134 | 2120977.70481 | 37.8044359058533 | -122.405187286774 | (37.8044359058533, -122.405187286774) | 3 | 1 | 10 | 28860 | 23 | |||
71252 | 21755 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | 5 | 1 | 10 | 308 | 23 | |||
106934 | 130958 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011286.38087 | 2120955.76241 | 37.8043758491414 | -122.405173872471 | (37.8043758491414, -122.405173872471) | 3 | 1 | 10 | 28860 | 23 | |||
176123 | 249815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1740 Kearny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 6010857.72173 | 2120932.64856 | 37.8042884107407 | -122.406655661138 | (37.8042884107407, -122.406655661138) | 3 | 1 | 10 | 308 | 23 | |||
51892 | 41207 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 8 | Permit Number 41914 | 6001577.45007 | 2120928.60225 | 37.8037537125351 | -122.438770430732 | (37.8037537125351, -122.438770430732) | 13 | 9 | 1 | 57 | 17 | |
155479 | 87880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1756 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50852 | 6002331.48039 | 2120914.85321 | 37.8037588296709 | -122.436160086425 | (37.8037588296709, -122.436160086425) | 13 | 9 | 1 | 57 | 17 | |
41854 | 35679 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 888 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 4 | Permit Number 38985 | 6007117.3304 | 2120899.52807 | 37.803987491295 | -122.419597262408 | (37.803987491295, -122.419597262408) | 5 | 1 | 1 | 28858 | 32 | ||
126591 | 35680 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 888 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 4 | Permit Number 38985 | 6007093.37266 | 2120896.31156 | 37.8039773100538 | -122.419679941575 | (37.8039773100538, -122.419679941575) | 5 | 1 | 1 | 28858 | 32 | ||
90626 | 249814 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1740 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010861.46651 | 2120893.20029 | 37.8041803050268 | -122.406639920319 | (37.8041803050268, -122.406639920319) | 3 | 1 | 10 | 308 | 23 | |||
86515 | 130600 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2220 Beach St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999571.11438 | 2120878.32333 | 37.8035013142 | -122.445709823545 | (37.8035013142, -122.445709823545) | 13 | 9 | 1 | 57 | 17 | |||
133831 | 130601 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2220 Beach St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999556.85937 | 2120873.79549 | 37.8034880680838 | -122.44575882763 | (37.8034880680838, -122.44575882763) | 13 | 9 | 1 | 57 | 17 | |||
85479 | 142590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2340 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008485.6087 | 2120854.698 | 37.803941376606 | -122.414859054768 | (37.803941376606, -122.414859054768) | 3 | 1 | 10 | 308 | 23 |
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) );