trees
1,098 rows where qCaretaker_id = 4 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
124279 | 113571 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
125465 | 142523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.8049770715314 | -122.410638645677 | (37.8049770715314, -122.410638645677) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||
132915 | 100984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
134500 | 142542 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | 3 | 1 | 10 | 308 | 23 | |||
137680 | 98571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
144374 | 95264 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2245 Jones St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
145088 | 95267 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 2245 Jones St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
145225 | 98567 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
150198 | 98089 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.7893623618415 | -122.419068380099 | (37.7893623618415, -122.419068380099) | 13 | 9 | 10 | 28858 | 21 | ||
152258 | 98578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
153778 | 142519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.8048657081731 | -122.411533760714 | (37.8048657081731, -122.411533760714) | 3 | 1 | 10 | 308 | 23 | |||
153795 | 98792 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950 Clay St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 5x4 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
155011 | 98574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
156452 | 98568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
156639 | 95266 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2245 Jones St | 5 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
156959 | 42841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/03/2000 12:00:00 AM | Permit Number 42773 | 6008051.69679947 | 2120116.37092576 | 37.8018897255523 | -122.416308313185 | (37.8018897255523, -122.416308313185) | 5 | 1 | 10 | 308 | 32 | ||
157895 | 98793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950x CLAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x6 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
159114 | 98563 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
160459 | 98572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
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 | ||||
165062 | 142548 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | 3 | 1 | 10 | 308 | 23 | |||
168362 | 95269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |||
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 |
169903 | 130257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2213 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | Width 5ft | 6008055.23608 | 2120086.84866 | 37.8018088638398 | -122.416293973386 | (37.8018088638398, -122.416293973386) | 5 | 1 | 10 | 308 | 32 | ||
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 |
173648 | 95265 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
175355 | 98575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
177484 | 98565 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301X Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
177916 | 113574 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
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 | |
182607 | 100976 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | 3 | 1 | 10 | 308 | 23 | ||
185078 | 113572 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 901 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
188027 | 100980 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
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 | |
188990 | 98560 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2035X Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | ||||
191008 | 142543 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | 3 | 1 | 10 | 308 | 23 | |||
191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
192694 | 95270 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
22092 | 30745 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 486X Page St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) | 7 | 9 | 11 | 28852 | 10 |
23622 | 99684 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
25180 | 30744 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004178.56485 | 2109886.01831 | 37.7735811988523 | -122.428981357915 | (37.7735811988523, -122.428981357915) | 7 | 9 | 11 | 28852 | 10 |
25949 | 30741 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
34106 | 31711 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.7638376395234 | -122.450514467435 | (37.7638376395234, -122.450514467435) | 15 | 5 | 11 | 29492 | 9 |
37865 | 99674 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
40750 | 30740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004184.33514 | 2109844.20882 | 37.7734667268354 | -122.428958416203 | (37.7734667268354, -122.428958416203) | 7 | 9 | 11 | 28852 | 10 |
41872 | 41128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
45783 | 99671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
52988 | 99678 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | |
55011 | 99667 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
56802 | 99677 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 |
57934 | 30739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
66778 | 99664 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997932 | 2106516 | 37.7639724300488 | -122.450346083136 | (37.7639724300488, -122.450346083136) | 15 | 5 | 11 | 29492 | 9 | ||
67135 | 99683 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 |
69253 | 72535 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/21/1992 12:00:00 AM | 20 | 3x3 | 5997957.39996807 | 2106223.02713962 | 37.7631694542329 | -122.450237113175 | (37.7631694542329, -122.450237113175) | 15 | 5 | 11 | 29492 | 9 | |
72831 | 30743 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
74685 | 30746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004256.1031 | 2109802.2559 | 37.7733555963905 | -122.428707169176 | (37.7733555963905, -122.428707169176) | 7 | 9 | 11 | 28852 | 10 |
79000 | 99679 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
81109 | 99665 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
86443 | 76019 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
94523 | 99689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
97737 | 30738 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004189.67673 | 2109821.80854 | 37.773405523492 | -122.428938341537 | (37.773405523492, -122.428938341537) | 7 | 9 | 11 | 28852 | 10 |
97987 | 99681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
99360 | 99687 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
106593 | 41127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
111390 | 92750 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2049 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/02/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52971 | 5998090.3691 | 2110284.0117 | 37.7743274908907 | -122.450069934151 | (37.7743274908907, -122.450069934151) | 15 | 5 | 11 | 29492 | 16 |
114759 | 99670 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
115682 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1860 HAYES ST | 4 | Front Yard : Yard | Tree | SFUSD 4 | 5998973 | 2110255 | 37.7742982989317 | -122.447014674672 | (37.7742982989317, -122.447014674672) | 15 | 5 | 11 | 29492 | 16 | |||||
117961 | 99675 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
127608 | 76051 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
128554 | 30747 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 496X Page St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004231.9845 | 2109799.7949 | 37.7733474740483 | -122.428790423308 | (37.7733474740483, -122.428790423308) | 7 | 9 | 11 | 28852 | 10 |
132145 | 41129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
136087 | 30737 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42884 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
146578 | 30736 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
150789 | 99672 | DPW Maintained 1 | Shrub :: Shrub 66 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
156345 | 72536 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/21/1992 12:00:00 AM | 10 | 3x3 | 5997766.568459 | 2106397.97443782 | 37.7636388926021 | -122.45090974788 | (37.7636388926021, -122.45090974788) | 15 | 5 | 11 | 29492 | 9 | |
157508 | 99686 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
159694 | 76205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
163071 | 30742 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004180.58298 | 2109863.27384 | 37.7735188623338 | -122.428972754992 | (37.7735188623338, -122.428972754992) | 7 | 9 | 11 | 28852 | 10 |
167966 | 76185 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
171377 | 99688 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
175889 | 99669 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x6 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
176228 | 99673 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
180042 | 99682 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
183108 | 99680 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Grattan St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
192959 | 76112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
193525 | 99685 | DPW Maintained 1 | Tree(s) :: 17 | 165 Grattan St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
8020 | 95515 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | 11 | 6 | 2 | 55 | 26 | |||
8399 | 95483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.7779797279503 | -122.490036770148 | (37.7779797279503, -122.490036770148) | 11 | 6 | 2 | 55 | 26 | ||
10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 |
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) );