trees
3,247 rows where qSpecies_id = 22 sorted by qCaretaker_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3819 | 6627 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016607.54293 | 2097762.50213 | 37.7409882686849 | -122.385142357926 | (37.7409882686849, -122.385142357926) | 10 | 3 | 8 | 58 | 1 | ||
48351 | 6624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/04/2004 12:00:00 AM | 3 | 3x3 | 6016547.14534 | 2097807.00624 | 37.7411071266849 | -122.385354293091 | (37.7411071266849, -122.385354293091) | 10 | 3 | 8 | 58 | 1 | ||
146898 | 6625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | 10 | 3 | 8 | 58 | 1 | ||
168314 | 6623 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 18 | 3x3 | 6016531.01979 | 2097819.10411 | 37.7411394528345 | -122.385410892796 | (37.7411394528345, -122.385410892796) | 10 | 3 | 8 | 58 | 1 | |||
176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
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 | |
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
49590 | 7378 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | 14 | 2 | 9 | 28853 | 34 | |||
52190 | 98423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
79505 | 112131 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
91265 | 7382 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | 14 | 2 | 9 | 28853 | 34 | |||
98712 | 98434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
101404 | 102516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 4x4 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
104845 | 75258 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.412211492867 | (37.7840518741506, -122.412211492867) | 14 | 10 | 9 | 28852 | 36 | |||
121936 | 112128 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
130766 | 75415 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 290 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 04:14:00 PM | 3 | 6009037.88726419 | 2113590.00375699 | 37.7840253217877 | -122.412434037929 | (37.7840253217877, -122.412434037929) | 14 | 10 | 9 | 28852 | 36 | |||
149555 | 7377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | 14 | 2 | 9 | 28853 | 34 | |||
149960 | 24950 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2199X Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 06/22/1998 12:00:00 AM | 3 | 3X3 | 6001667.0796215 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | 13 | 6 | 11 | 29490 | 13 | ||
155217 | 7379 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600364 | (37.7783600402028, -122.40594600364) | 14 | 2 | 9 | 28853 | 34 | |||
156162 | 102375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983887.37527 | 2110050.49294 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | 11 | 6 | 2 | 55 | 26 | ||||
158540 | 98435 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
161077 | 98422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
165276 | 102374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | 11 | 6 | 2 | 55 | 26 | ||||
166192 | 98432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
166253 | 110046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | 14 | 10 | 9 | 28852 | 36 | ||||
172055 | 112127 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
174435 | 112129 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
187311 | 7380 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.406004508334 | (37.7783210049209, -122.406004508334) | 14 | 2 | 9 | 28853 | 34 | |||
189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
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 |
79109 | 116057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266 | (37.760947638753, -122.40338680266) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
112770 | 116059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.7609349466036 | -122.403557559651 | (37.7609349466036, -122.403557559651) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 |
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 | |||
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 | ||
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 | ||||
164578 | 116058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262 | -122.403464154268 | (37.760944177262, -122.403464154268) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |
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 |
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 | |
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 | |
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
757 | 226221 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009154.30275 | 2103871.8716 | 37.7573481256189 | -122.411344516752 | (37.7573481256189, -122.411344516752) | 2 | 4 | 7 | 28859 | 19 | |||
796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
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 | ||
1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
1198 | 225665 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300x Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
1258 | 190419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 15 | : | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6017844.32202 | 2096957.74462 | 37.7388469037738 | -122.380810054756 | (37.7388469037738, -122.380810054756) | 10 | 3 | 8 | 58 | 1 | ||
1277 | 220672 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.424223091727 | (37.759066695887, -122.424223091727) | 2 | 4 | 5 | 28859 | 19 | |||
1506 | 70618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007346.38924 | 2116443.24691 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | 5 | 1 | 10 | 28858 | 21 | |||
1566 | 124023 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991830.31416 | 2113050.03169 | 37.781562022994 | -122.471926053077 | (37.781562022994, -122.471926053077) | 11 | 6 | 2 | 54 | 11 | |||
1594 | 264718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
1608 | 32205 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1697 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 8 | Permit Number 35528 | 6009341.58261 | 2099615.8477 | 37.7456725350783 | -122.410396317437 | (37.7456725350783, -122.410396317437) | 2 | 7 | 7 | 28859 | 2 | |
1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
1686 | 225676 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008816.88964 | 2096900.69924 | 37.7381879057352 | -122.412018790637 | (37.7381879057352, -122.412018790637) | 10 | 7 | 7 | 28859 | 2 | |||
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 | |||
2060 | 150281 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012538.7082 | 2106843.10365 | 37.7656957093017 | -122.399848467747 | (37.7656957093017, -122.399848467747) | 14 | 3 | 8 | 28856 | 20 | |||
2109 | 71599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.459970121431 | (37.7083363538073, -122.459970121431) | 9 | 8 | 6 | 28861 | 25 | |||
2312 | 71328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004151.95998 | 2089814.42795 | 37.7184677472758 | -122.427643069565 | (37.7184677472758, -122.427643069565) | 9 | 7 | 6 | 28861 | 5 | |||
2367 | 226104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005509.798 | 2107472.48259 | 37.7670294722636 | -122.424204733868 | (37.7670294722636, -122.424204733868) | 8 | 4 | 5 | 28853 | 19 | |||
2409 | 225663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006114.92527 | 2097621.73369 | 37.7400157373359 | -122.421412046638 | (37.7400157373359, -122.421412046638) | 2 | 7 | 7 | 28859 | 2 | |||
2416 | 192496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | 8 | 3 | 8 | 28853 | 20 | |||
2577 | 31869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 166 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 1 | Permit Number 35311 | 6000215.42905 | 2104900.21847 | 37.759666310759 | -122.442332399837 | (37.759666310759, -122.442332399837) | 2 | 4 | 5 | 28862 | 3 | |
2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
2645 | 137669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1927 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000327.0363 | 2111629.9151 | 37.7781507333481 | -122.442429558556 | (37.7781507333481, -122.442429558556) | 15 | 5 | 11 | 29490 | 16 | |||
2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
2836 | 219119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002030.49307 | 2095074.13161 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | 9 | 7 | 5 | 63 | 40 | |||
2843 | 243848 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2976 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6009037.26284 | 2102182.62574 | 37.7527032720445 | -122.411629937289 | (37.7527032720445, -122.411629937289) | 2 | 4 | 7 | 28859 | 19 | ||
3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
3076 | 228280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
3143 | 46360 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2002 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.31969 | 37.7779021128043 | -122.482350384801 | (37.7779021128043, -122.482350384801) | 11 | 6 | 2 | 55 | 26 | |
3155 | 171861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009150.18336 | 2091330.30171 | 37.722911477365 | -122.410473193303 | (37.722911477365, -122.410473193303) | 9 | 3 | 7 | 309 | 28 | |||
3160 | 228282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3306 | 228286 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3333 | 66070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 517 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 7 | Permit Number 29111 | 6014120.17951 | 2104674.3104 | 37.7598287157536 | -122.39422660508 | (37.7598287157536, -122.39422660508) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
3435 | 226185 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 160 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008635.20088 | 2097780.05534 | 37.7405922297483 | -122.412709130925 | (37.7405922297483, -122.412709130925) | 10 | 7 | 7 | 28859 | 2 | |||
3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
3595 | 219121 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.435367602937 | (37.7327212453836, -122.435367602937) | 9 | 7 | 5 | 63 | 40 | |||
3597 | 93954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.90951 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | 6 | 2 | 9 | 28855 | 6 | |
3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 |
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) );