trees
141 rows where Zip Codes = 28861 and qCaretaker_id = 4 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149448 | 43312 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.431640671199 | (37.7261742132654, -122.431640671199) | 9 | 7 | 6 | 28861 | 5 |
153384 | 43310 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 150X Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6002773.36898986 | 2092525.07870875 | 37.7258325139415 | -122.432601800105 | (37.7258325139415, -122.432601800105) | 9 | 7 | 6 | 28861 | 5 |
153739 | 77206 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
154114 | 37833 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003832.66245 | 2090342.46114 | 37.7198995444156 | -122.428784371324 | (37.7198995444156, -122.428784371324) | 9 | 7 | 6 | 28861 | 5 |
154352 | 42367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
158362 | 97250 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 301X Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003264.30376 | 2092207.68877 | 37.724988860924 | -122.430882033691 | (37.724988860924, -122.430882033691) | 9 | 7 | 6 | 28861 | 5 |
160859 | 42357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
161401 | 37831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.35388 | 37.7200688687581 | -122.428658848427 | (37.7200688687581, -122.428658848427) | 9 | 7 | 6 | 28861 | 5 |
161881 | 42369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 250 Foerster St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
162866 | 42347 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
163627 | 253146 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:29:00 PM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) | 9 | 7 | 6 | 28861 | 5 |
163795 | 37830 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2007 12:00:00 AM | 3 | 6x6 | Permit Number 49480 | 6003635.85955 | 2090436.92041 | 37.7201477680848 | -122.429471383195 | (37.7201477680848, -122.429471383195) | 9 | 7 | 6 | 28861 | 5 |
166189 | 96581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
169000 | 37827 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 450X Moscow St | 15 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003888.33038 | 2090432.03853 | 37.7201486548235 | -122.428598328547 | (37.7201486548235, -122.428598328547) | 9 | 7 | 6 | 28861 | 5 |
169868 | 96576 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 401x Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
172028 | 96582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
176834 | 37820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003945.80086 | 2090498.97809 | 37.7203357084188 | -122.428404441018 | (37.7203357084188, -122.428404441018) | 9 | 7 | 6 | 28861 | 5 |
178848 | 32728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.59612 | 2088615.91363 | 37.714656397048 | -122.459105637326 | (37.714656397048, -122.459105637326) | 9 | 8 | 6 | 28861 | 24 | |
180121 | 92959 | Permitted Site 7 | Tree(s) :: 17 | 300 Seneca Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
180230 | 96584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
180710 | 42358 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
181911 | 37840 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2007 12:00:00 AM | 3 | 4x6 | Permit Number 49480 | 6003672.4294 | 2090496.54171 | 37.7203135455184 | -122.429349222898 | (37.7203135455184, -122.429349222898) | 9 | 7 | 6 | 28861 | 5 |
182392 | 97247 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 301X Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003399 | 2092092 | 37.7246788362927 | -122.430408153397 | (37.7246788362927, -122.430408153397) | 9 | 7 | 6 | 28861 | 5 |
182513 | 42356 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
183530 | 95751 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:36:00 PM | 3 | 3x3 | Permit Number 767495 | 6003552.81378 | 2092420.08444 | 37.7255883948789 | -122.429899830124 | (37.7255883948789, -122.429899830124) | 9 | 7 | 6 | 28861 | 5 |
184034 | 76675 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
184336 | 37815 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 |
186220 | 77209 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
187446 | 37835 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752 | 2090699 | 37.720873955994 | -122.429088601305 | (37.720873955994, -122.429088601305) | 9 | 7 | 6 | 28861 | 5 |
189005 | 75040 | DPW Maintained 1 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
189331 | 92957 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
189866 | 37825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003912.01731 | 2090448.66207 | 37.7201956398999 | -122.428517635078 | (37.7201956398999, -122.428517635078) | 9 | 7 | 6 | 28861 | 5 |
190377 | 32727 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.97569 | 2088634.0427 | 37.7147061970204 | -122.459105637321 | (37.7147061970204, -122.459105637321) | 9 | 8 | 6 | 28861 | 24 | |
190901 | 92956 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.7217103076746 | -122.444931280306 | (37.7217103076746, -122.444931280306) | 9 | 7 | 6 | 28861 | 25 | |
193722 | 77213 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
194422 | 37823 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:49:00 AM | 3 | 3x3 | Permit Number 40134 | 6003922.69393 | 2090463.29382 | 37.7202364196636 | -122.428481771941 | (37.7202364196636, -122.428481771941) | 9 | 7 | 6 | 28861 | 5 |
194434 | 37829 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 450X Moscow St | 17 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:54:00 AM | 3 | 3x3 | Permit Number 40134 | 6003878.28183 | 2090416.42534 | 37.7201052157501 | -122.428631950629 | (37.7201052157501, -122.428631950629) | 9 | 7 | 6 | 28861 | 5 |
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) );