trees
47 rows where DBH = 5 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 15680 | 91641 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216 | 2101489.31094 | 37.7507272674606 | -122.416034053567 | (37.7507272674606, -122.416034053567) | 2 | 4 | 7 | 28859 | 19 | |||
| 17020 | 82125 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 317 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50070 | 6006739.55759841 | 2104266.9934198 | 37.75829730851 | -122.41972370977 | (37.75829730851, -122.41972370977) | 2 | 4 | 7 | 28859 | 19 |
| 21871 | 246838 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 399 Broderick St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6001188.47767 | 2109990.61312 | 37.7736986862745 | -122.439331993472 | (37.7736986862745, -122.439331993472) | 15 | 5 | 11 | 29492 | 10 | |||
| 26140 | 136187 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010038.55828 | 2116686.60963 | 37.7925839636381 | -122.409190650353 | (37.7925839636381, -122.409190650353) | 3 | 1 | 10 | 28857 | 4 | |||
| 31987 | 39269 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 5 | Permit Number 40882 | 6010051.67469 | 2116602.92631 | 37.7923549243012 | -122.409139359294 | (37.7923549243012, -122.409139359294) | 3 | 1 | 10 | 28857 | 4 | |
| 42736 | 241305 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 697 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | Width 3ft | 6007530.22491 | 2105637.84626 | 37.7621058621135 | -122.417086361543 | (37.7621058621135, -122.417086361543) | 8 | 4 | 7 | 28859 | 19 | ||
| 52753 | 241325 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 425 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007441.87524 | 2107194.22963 | 37.766374357512 | -122.417502238664 | (37.766374357512, -122.417502238664) | 8 | 4 | 7 | 28853 | 19 | |||
| 52926 | 241317 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007335.93397 | 2108086.9588 | 37.7688196204438 | -122.417931960818 | (37.7688196204438, -122.417931960818) | 8 | 4 | 7 | 28853 | 19 | |||
| 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 | |||
| 58857 | 197005 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015945.83282 | 2113971.21012 | 37.7854572671771 | -122.388561464349 | (37.7854572671771, -122.388561464349) | 6 | 2 | 9 | 28856 | 6 | |||
| 59684 | 91684 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | 8 | 4 | 7 | 28853 | 19 | ||
| 67006 | 91687 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352338 | 2107516.072508 | 37.7672565139252 | -122.417620248867 | (37.7672565139252, -122.417620248867) | 8 | 4 | 7 | 28853 | 19 | |||
| 71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
| 75650 | 241361 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 608 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009795.10344 | 2105420.22693 | 37.7616354789124 | -122.409237625525 | (37.7616354789124, -122.409237625525) | 2 | 4 | 8 | 28859 | 19 | |||
| 79863 | 241303 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007544.46079 | 2105381.89304 | 37.7614038747014 | -122.417018988842 | (37.7614038747014, -122.417018988842) | 2 | 4 | 7 | 28859 | 19 | |||
| 80892 | 120913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
| 81154 | 91654 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1169 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007673.711302 | 2102857.771696 | 37.7544804867979 | -122.416393171829 | (37.7544804867979, -122.416393171829) | 2 | 4 | 7 | 28859 | 19 | |||
| 84968 | 241376 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3777 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004606.4364 | 2101890.62925 | 37.7516519753774 | -122.426931737306 | (37.7516519753774, -122.426931737306) | 2 | 4 | 5 | 28862 | 22 | |||
| 92157 | 121263 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | |||
| 92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
| 92727 | 241365 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1475 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010134.56863 | 2100721.5441 | 37.7487529567978 | -122.407732226982 | (37.7487529567978, -122.407732226982) | 2 | 4 | 7 | 28859 | 19 | |||
| 97177 | 82510 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52478 | 6009746.4088 | 2094920.98232 | 37.7328041358849 | -122.408665340153 | (37.7328041358849, -122.408665340153) | 10 | 3 | 7 | 309 | 28 | |
| 101968 | 41934 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.01316 | 37.7769765383201 | -122.461929924013 | (37.7769765383201, -122.461929924013) | 11 | 6 | 2 | 54 | 11 | |
| 103723 | 241301 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007553.45453 | 2105201.24032 | 37.7609083500518 | -122.416975083028 | (37.7609083500518, -122.416975083028) | 2 | 4 | 7 | 28859 | 19 | |||
| 104883 | 241373 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.7516472125622 | -122.427186107874 | (37.7516472125622, -122.427186107874) | 2 | 4 | 5 | 28862 | 22 | |||
| 105398 | 91651 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
| 105407 | 241312 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007473.64747 | 2105479.75896 | 37.7616686081336 | -122.41727083858 | (37.7616686081336, -122.41727083858) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 109877 | 241372 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004512.71197 | 2101888.89737 | 37.7516419200596 | -122.427255725271 | (37.7516419200596, -122.427255725271) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |
| 115556 | 50665 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 5 | Permit Number 47244 | 6000927.33064 | 2091848.93503 | 37.7238711151562 | -122.438934974279 | (37.7238711151562, -122.438934974279) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 128361 | 91689 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 335 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007402.197577 | 2107728.718925 | 37.7678397070843 | -122.417677364286 | (37.7678397070843, -122.417677364286) | 8 | 4 | 7 | 28853 | 19 | |||
| 128961 | 91690 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 315 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007395.800334 | 2107840.638089 | 37.7681466508094 | -122.417707425394 | (37.7681466508094, -122.417707425394) | 8 | 4 | 7 | 28853 | 19 | |||
| 130878 | 123179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992862.96444 | 2110216.56004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | 11 | 6 | 2 | 54 | 11 | |||
| 138245 | 46563 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | Permit Number 44698 | 6007428.13103163 | 2106459.60978175 | 37.7643564897484 | -122.41749770835 | (37.7643564897484, -122.41749770835) | 8 | 4 | 7 | 28859 | 19 | ||
| 141067 | 241375 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004575.52977 | 2101893.77166 | 37.7516588560771 | -122.427038840268 | (37.7516588560771, -122.427038840268) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 148421 | 196998 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 13 | : | Tree | Private 2 | 5 | Width 4ft | 6013702.50003 | 2100126.86267 | 37.7473191766464 | -122.395352595851 | (37.7473191766464, -122.395352595851) | 10 | 3 | 8 | 58 | 1 | |||
| 149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
| 151093 | 241311 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007420.66445 | 2106451.36867 | 37.7643334414537 | -122.417522949121 | (37.7643334414537, -122.417522949121) | 8 | 4 | 7 | 28859 | 19 | |||
| 152731 | 213852 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991160.08427 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | 1 | 8 | 11 | 56 | 12 | |||
| 171522 | 91648 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
| 187830 | 91683 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 395 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007421.389304 | 2107392.96146 | 37.7669188758381 | -122.41758718246 | (37.7669188758381, -122.41758718246) | 8 | 4 | 7 | 28853 | 19 |
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) );