trees
38 rows where DBH = 7 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 599 | 78256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | 9 | 7 | 6 | 28861 | 5 | |||
| 11064 | 196994 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 7 | : | Tree | Private 2 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.394724774624 | (37.7473596740254, -122.394724774624) | 10 | 3 | 8 | 58 | 1 | |||
| 15698 | 241342 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2122 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009546.72381 | 2104789.44467 | 37.7598895755605 | -122.410052140597 | (37.7598895755605, -122.410052140597) | 2 | 4 | 7 | 28859 | 19 | |||
| 20599 | 196997 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 11 | : | Tree | Private 2 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.7473355578075 | -122.395144856947 | (37.7473355578075, -122.395144856947) | 10 | 3 | 8 | 58 | 1 | |||
| 29262 | 91646 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
| 32482 | 65937 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.445985572784 | (37.7958202522453, -122.445985572784) | 13 | 9 | 1 | 57 | 17 | ||
| 39070 | 241380 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4050 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008348.5979 | 2096262.44881 | 37.7364091240834 | -122.413592786804 | (37.7364091240834, -122.413592786804) | 10 | 7 | 7 | 28859 | 2 | |||
| 41188 | 91672 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
| 45602 | 65010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | 11 | 6 | 2 | 55 | 26 | ||
| 46530 | 136183 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | 5 | 9 | 1 | 28858 | 32 | |||
| 50595 | 241318 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 280 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007336.81249 | 2108065.49507 | 37.7687607355409 | -122.417927400355 | (37.7687607355409, -122.417927400355) | 8 | 4 | 7 | 28853 | 19 | |||
| 53750 | 91599 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | ||
| 70671 | 196993 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6013912.09606 | 2100139.02388 | 37.7473642236913 | -122.394628673985 | (37.7473642236913, -122.394628673985) | 10 | 3 | 8 | 58 | 1 | |||
| 86529 | 179278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | 9 | 7 | 7 | 309 | 5 | |||
| 89482 | 91663 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 859 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007573.699386 | 2104662.928197 | 37.7594314080197 | -122.416866925134 | (37.7594314080197, -122.416866925134) | 2 | 4 | 7 | 28859 | 19 | ||
| 95270 | 241307 | Undocumented 4 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 629 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007511.70266 | 2105973.00163 | 37.7630250789657 | -122.417174173153 | (37.7630250789657, -122.417174173153) | 8 | 4 | 7 | 28859 | 19 | |||
| 100139 | 67314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | 11 | 6 | 2 | 54 | 11 | |
| 103146 | 49557 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Arco Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 7 | Permit Number 46446 | 5999409.77309 | 2093045.09949 | 37.7270690458815 | -122.444266822659 | (37.7270690458815, -122.444266822659) | 9 | 7 | 6 | 28861 | 25 | ||
| 104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
| 111720 | 196987 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
| 113993 | 36966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.52093 | 2112981.13075 | 37.7815162715185 | -122.463326949801 | (37.7815162715185, -122.463326949801) | 11 | 6 | 2 | 54 | 11 | |
| 116025 | 30565 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | 13 | 9 | 1 | 57 | 17 | ||
| 118012 | 241319 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007346.30903 | 2107764.0705 | 37.7679336290724 | -122.417873182915 | (37.7679336290724, -122.417873182915) | 8 | 4 | 7 | 28853 | 19 | |||
| 131142 | 241308 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.7641989649233 | -122.417285889641 | (37.7641989649233, -122.417285889641) | 8 | 4 | 7 | 28859 | 19 | |||
| 133771 | 91586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.7674935541002 | -122.417782265097 | (37.7674935541002, -122.417782265097) | 8 | 4 | 7 | 28853 | 19 | |||
| 134611 | 241336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | 2 | 7 | 7 | 28859 | 2 | |||
| 137048 | 241309 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007486.87936 | 2106417.71309 | 37.7642447566068 | -122.417291544578 | (37.7642447566068, -122.417291544578) | 8 | 4 | 7 | 28859 | 19 | |||
| 139041 | 241316 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007332.32989 | 2108125.54734 | 37.7689253726442 | -122.41794716295 | (37.7689253726442, -122.41794716295) | 8 | 4 | 7 | 28853 | 19 | |||
| 139882 | 91608 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | 2 | 4 | 7 | 28859 | 19 | |||
| 143264 | 31983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.72464 | 2113855.38064 | 37.7839533587811 | -122.461189396885 | (37.7839533587811, -122.461189396885) | 11 | 6 | 2 | 54 | 11 |
| 161394 | 91673 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
| 167044 | 241320 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007347.08663 | 2107747.30956 | 37.7678876512341 | -122.417869305024 | (37.7678876512341, -122.417869305024) | 8 | 4 | 7 | 28853 | 19 | |||
| 168558 | 241302 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 741 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007545.5728 | 2105350.70249 | 37.7613182952255 | -122.417012932805 | (37.7613182952255, -122.417012932805) | 2 | 4 | 7 | 28859 | 19 | |||
| 168607 | 196986 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
| 176194 | 241296 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1350 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007156.61283 | 2107616.82741 | 37.7675186566968 | -122.41851887996 | (37.7675186566968, -122.41851887996) | 8 | 4 | 7 | 28853 | 19 | |||
| 176735 | 241332 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 263 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007398.28361 | 2108137.64954 | 37.7689623140896 | -122.417719890785 | (37.7689623140896, -122.417719890785) | 8 | 4 | 7 | 28853 | 19 | |||
| 181888 | 241310 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007485.43036 | 2106430.0255 | 37.7642784820932 | -122.417297428844 | (37.7642784820932, -122.417297428844) | 8 | 4 | 7 | 28859 | 19 | |||
| 193907 | 196992 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.7473701394162 | -122.394524516312 | (37.7473701394162, -122.394524516312) | 10 | 3 | 8 | 58 | 1 |
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) );