trees
29 rows where Neighborhoods (old) = 29 and qSpecies_id = 123
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 925 | 34964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Permit Number 38553 | 6014444.74274 | 2102850.73033 | 37.7548395926778 | -122.392976501569 | (37.7548395926778, -122.392976501569) | 10 | 3 | 8 | 28856 | 29 | ||
| 4053 | 196973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Width 4ft | 6014457.83967 | 2102608.37301 | 37.7541748588033 | -122.392914253189 | (37.7541748588033, -122.392914253189) | 10 | 3 | 8 | 28856 | 29 | ||
| 7828 | 196969 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015866.24342 | 2105844.60301 | 37.763138987107 | -122.388269449981 | (37.763138987107, -122.388269449981) | 14 | 3 | 8 | 28856 | 29 | |||
| 9715 | 196963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.387989539601 | (37.7631558583726, -122.387989539601) | 14 | 3 | 8 | 28856 | 29 | |||
| 14984 | 68126 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 8 | Permit Number 31876 | 6013566.56944 | 2105672.60835 | 37.7625390358578 | -122.396211251447 | (37.7625390358578, -122.396211251447) | 14 | 3 | 8 | 28856 | 29 | |
| 17382 | 35346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1124 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 8 | Permit Number 38809 | 6012181.54645 | 2103168.5427 | 37.7555862611206 | -122.400825637793 | (37.7555862611206, -122.400825637793) | 10 | 3 | 8 | 28856 | 29 | |
| 20176 | 196977 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014040.95878 | 2106120.30389 | 37.7637946944947 | -122.394601850808 | (37.7637946944947, -122.394601850808) | 14 | 3 | 8 | 28856 | 29 | |||
| 39500 | 32941 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1546 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37260 | 6013066.21805 | 2105223.63069 | 37.7612783887065 | -122.397910300117 | (37.7612783887065, -122.397910300117) | 10 | 3 | 8 | 28856 | 29 | |
| 53461 | 196972 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014458.90845 | 2102627.41024 | 37.7542271903342 | -122.392911888877 | (37.7542271903342, -122.392911888877) | 10 | 3 | 8 | 28856 | 29 | |||
| 55110 | 196970 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015850.66313 | 2105843.80284 | 37.7631359267068 | -122.388323281596 | (37.7631359267068, -122.388323281596) | 14 | 3 | 8 | 28856 | 29 | |||
| 58715 | 196964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015932.05228 | 2105848.00164 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | 14 | 3 | 8 | 28856 | 29 | |||
| 60153 | 34963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 13 | Permit Number 38553 | 6014444.86373 | 2102867.97159 | 37.7548869402077 | -122.392977289379 | (37.7548869402077, -122.392977289379) | 10 | 3 | 8 | 28856 | 29 | ||
| 65789 | 37968 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 571 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40198 | 6013578.16137 | 2104406.11851 | 37.7590621767948 | -122.39608239839 | (37.7590621767948, -122.39608239839) | 10 | 3 | 8 | 28856 | 29 | |
| 89090 | 34965 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | 12 | Permit Number 38553 | 6014443.03671 | 2102833.9751 | 37.7547934916369 | -122.392981229311 | (37.7547934916369, -122.392981229311) | 10 | 3 | 8 | 28856 | 29 | ||
| 94675 | 35355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1315 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 12 | Permit Number 38817 | 6011731.8197 | 2102219.99473 | 37.7529566614441 | -122.402314252327 | (37.7529566614441, -122.402314252327) | 10 | 3 | 8 | 28856 | 29 | |
| 97888 | 37999 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 725 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 6 | Permit Number 40211 | 6012746.31439 | 2104130.05474 | 37.7582578483487 | -122.398939962714 | (37.7582578483487, -122.398939962714) | 10 | 3 | 8 | 28856 | 29 | |
| 106594 | 196968 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015876.45874 | 2105845.10564 | 37.7631409332394 | -122.388234153389 | (37.7631409332394, -122.388234153389) | 14 | 3 | 8 | 28856 | 29 | |||
| 108931 | 196974 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6014047.89224 | 2106015.09524 | 37.7635062000657 | -122.394570502234 | (37.7635062000657, -122.394570502234) | 14 | 3 | 8 | 28856 | 29 | |||
| 111114 | 47653 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 245 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 5 | Permit Number 45457 | 6013208.50894 | 2105918.56319 | 37.7631944437823 | -122.397466910967 | (37.7631944437823, -122.397466910967) | 14 | 3 | 8 | 28856 | 29 | |
| 112009 | 196975 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014043.29115 | 2106063.32562 | 37.7636383743244 | -122.394589793611 | (37.7636383743244, -122.394589793611) | 14 | 3 | 8 | 28856 | 29 | |||
| 113139 | 196971 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015840.83077 | 2105843.69764 | 37.7631350930254 | -122.388357281382 | (37.7631350930254, -122.388357281382) | 14 | 3 | 8 | 28856 | 29 | |||
| 117320 | 196966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015902.35048 | 2105846.23751 | 37.7631454756938 | -122.388144680757 | (37.7631454756938, -122.388144680757) | 14 | 3 | 8 | 28856 | 29 | |||
| 125452 | 196979 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.397014079838 | (37.7599198521353, -122.397014079838) | 10 | 3 | 8 | 28856 | 29 | |||
| 139206 | 196967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015888.58147 | 2105846.04273 | 37.7631441779792 | -122.388192289968 | (37.7631441779792, -122.388192289968) | 14 | 3 | 8 | 28856 | 29 | |||
| 147564 | 196965 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015917.99613 | 2105847.416 | 37.763149578419 | -122.38809064947 | (37.763149578419, -122.38809064947) | 14 | 3 | 8 | 28856 | 29 | |||
| 149240 | 196980 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 320 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013452.78538 | 2105563.26016 | 37.7622324578928 | -122.396597126255 | (37.7622324578928, -122.396597126255) | 10 | 3 | 8 | 28856 | 29 | |||
| 160657 | 37985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 570 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40207 | 6013793.63158 | 2104435.25023 | 37.7591541522658 | -122.395339235527 | (37.7591541522658, -122.395339235527) | 10 | 3 | 8 | 28856 | 29 | |
| 160886 | 196978 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | 10 | 3 | 8 | 28856 | 29 | |||
| 170905 | 196976 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014043.63491 | 2106091.78418 | 37.7637165344031 | -122.39459059759 | (37.7637165344031, -122.39459059759) | 14 | 3 | 8 | 28856 | 29 |
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) );