trees
953 rows where qSpecies_id = 60 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32876 | 188339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.404294355303 | (37.7324490889606, -122.404294355303) | 10 | 3 | 8 | 58 | 1 | |||
| 33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
| 33277 | 69157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | 1 | 8 | 3 | 56 | 35 | |
| 34147 | 110720 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
| 34465 | 222549 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.7406038022373 | -122.417680295405 | (37.7406038022373, -122.417680295405) | 2 | 7 | 7 | 28859 | 2 | |||
| 34526 | 22825 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.445084674243 | (37.7436157369876, -122.445084674243) | 2 | 7 | 5 | 63 | 7 | ||
| 35110 | 188332 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013443.088 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | 14 | 3 | 8 | 28856 | 29 | |||
| 35216 | 204656 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Sargent St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993464.3561 | 2089166.28112 | 37.7160777557502 | -122.464538359982 | (37.7160777557502, -122.464538359982) | 9 | 8 | 6 | 64 | 24 | |||
| 35674 | 222588 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | 15 | 5 | 5 | 28862 | 3 | |||
| 35714 | 147127 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 583 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x6 | 5986876.14797 | 2111982.26615 | 37.7783423311713 | -122.488986349742 | (37.7783423311713, -122.488986349742) | 11 | 6 | 2 | 55 | 26 | |||
| 36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
| 37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
| 37366 | 181746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | 1 | 8 | 3 | 56 | 35 | |||
| 37578 | 221355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008404.74116 | 2103860.62661 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | 2 | 4 | 7 | 28859 | 19 | |||
| 37810 | 222597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002444.78145 | 2096589.20481 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | 2 | 7 | 5 | 63 | 7 | |||
| 37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
| 37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
| 39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
| 39230 | 222571 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.438130138611 | (37.7501768003212, -122.438130138611) | 2 | 4 | 5 | 28862 | 22 | |||
| 39556 | 26989 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.410143394801 | (37.7311259838562, -122.410143394801) | 9 | 3 | 7 | 309 | 28 | ||
| 40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
| 40262 | 221321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | 2 | 4 | 5 | 28859 | 19 | |||
| 40526 | 121353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.7641755703197 | -122.496596073864 | (37.7641755703197, -122.496596073864) | 1 | 8 | 3 | 56 | 35 | ||
| 40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
| 40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
| 41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
| 42079 | 252895 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282 | 2090432 | 37.7197724640349 | -122.45143407539 | (37.7197724640349, -122.45143407539) | 9 | 8 | 6 | 28861 | 24 | ||
| 42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
| 42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
| 42376 | 27049 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.21971 | 37.7287190140661 | -122.416853547777 | (37.7287190140661, -122.416853547777) | 9 | 3 | 7 | 309 | 5 | ||
| 42439 | 221348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.417896696594 | (37.7380362287807, -122.417896696594) | 2 | 7 | 7 | 28859 | 2 | |||
| 42933 | 38322 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
| 43630 | 26977 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 526 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004737.76851 | 2093468.91574 | 37.728535287917 | -122.425878161452 | (37.728535287917, -122.425878161452) | 9 | 7 | 6 | 28861 | 5 | ||
| 44101 | 4392 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.7345352795846 | -122.436474498408 | (37.7345352795846, -122.436474498408) | 2 | 7 | 5 | 63 | 7 | |||
| 44295 | 204649 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994044.08453 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | 9 | 8 | 6 | 28861 | 24 | |||
| 44525 | 27187 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.432382378945 | (37.7292145657007, -122.432382378945) | 9 | 7 | 6 | 28861 | 25 | ||
| 44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
| 45604 | 204647 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.7166594390698 | -122.455354045254 | (37.7166594390698, -122.455354045254) | 9 | 8 | 6 | 28861 | 24 | |||
| 45916 | 175782 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.7290892244848 | -122.419690364741 | (37.7290892244848, -122.419690364741) | 9 | 7 | 7 | 309 | 5 | |||
| 46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
| 47496 | 45707 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 | |||
| 48420 | 27011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1468 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010181.11487 | 2094586.49515 | 37.7319100425197 | -122.407138874981 | (37.7319100425197, -122.407138874981) | 10 | 3 | 7 | 309 | 28 | ||
| 48513 | 36468 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.7289687842477 | -122.456513863949 | (37.7289687842477, -122.456513863949) | 9 | 7 | 4 | 28861 | 40 | ||
| 50195 | 96837 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009513 | 2097465 | 37.7397763850106 | -122.409651795241 | (37.7397763850106, -122.409651795241) | 10 | 7 | 7 | 28859 | 2 | |||
| 50910 | 222561 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | 2 | 7 | 7 | 28859 | 2 | |||
| 51488 | 57741 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762 | 2096689 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | 2 | 7 | 5 | 63 | 7 | |
| 52066 | 27119 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2345X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6013094.94494 | 2096422.25687 | 37.7371133006396 | -122.397193759945 | (37.7371133006396, -122.397193759945) | 10 | 3 | 8 | 58 | 1 | ||
| 52154 | 26999 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6008714.80501 | 2094009.36438 | 37.7302431967539 | -122.412167462084 | (37.7302431967539, -122.412167462084) | 9 | 3 | 7 | 309 | 28 | ||
| 52425 | 204640 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | 9 | 7 | 4 | 28861 | 40 | |||
| 52854 | 123824 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | 11 | 6 | 2 | 54 | 11 | |||
| 52915 | 188310 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.65853 | 2106249.78561 | 37.7640873186114 | -122.398520326465 | (37.7640873186114, -122.398520326465) | 14 | 3 | 8 | 28856 | 29 | |||
| 52992 | 4194 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | 2 | 4 | 5 | 63 | 22 | |||
| 53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
| 53960 | 47228 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.39624 | 2091994.05057 | 37.724845479317 | -122.403633167442 | (37.724845479317, -122.403633167442) | 10 | 3 | 7 | 309 | 28 | |
| 54184 | 56623 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001932.70639357 | 2100631.3679946 | 37.7480427977008 | -122.43608772435 | (37.7480427977008, -122.43608772435) | 2 | 4 | 5 | 28862 | 22 | |||||
| 55938 | 175783 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.7290628338846 | -122.419916279827 | (37.7290628338846, -122.419916279827) | 9 | 7 | 7 | 309 | 5 | |||
| 56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
| 56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
| 56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
| 56360 | 181646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | 1 | 8 | 3 | 56 | 35 | |||
| 57042 | 109185 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 198x JUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998796 | 2093546 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | 9 | 7 | 4 | 28861 | 40 | ||||
| 57614 | 25940 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | 10 | 3 | 8 | 58 | 1 | ||
| 57687 | 27191 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 270 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002970.12798 | 2093687.91706 | 37.729036562883 | -122.432004617843 | (37.729036562883, -122.432004617843) | 9 | 7 | 6 | 28861 | 25 | ||
| 58302 | 188285 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.7761914064457 | -122.408266129292 | (37.7761914064457, -122.408266129292) | 8 | 2 | 9 | 28853 | 34 | |||
| 58365 | 188334 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013355.93912 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | 10 | 3 | 8 | 28856 | 29 | |||
| 58533 | 222576 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | 15 | 4 | 5 | 28862 | 3 | |||
| 58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
| 59817 | 221362 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | 2 | 4 | 5 | 63 | 22 | |||
| 60265 | 221323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3517 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006097.76573 | 2104905.61236 | 37.7600146325834 | -122.421988676659 | (37.7600146325834, -122.421988676659) | 2 | 4 | 5 | 28859 | 19 | |||
| 60384 | 204655 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 452 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.465299811433 | (37.7188834957636, -122.465299811433) | 9 | 8 | 6 | 64 | 24 | |||
| 60641 | 204654 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 222 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.468865962403 | (37.7165410523041, -122.468865962403) | 9 | 8 | 6 | 64 | 24 | |||
| 60659 | 175761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011060.579 | 2091989.46007 | 37.7248283040662 | -122.403915678669 | (37.7248283040662, -122.403915678669) | 10 | 3 | 7 | 309 | 28 | |||
| 60860 | 221365 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.436110461831 | (37.748183708409, -122.436110461831) | 2 | 4 | 5 | 28862 | 22 | |||
| 60961 | 188300 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791 | (37.7728541761188, -122.41480452791) | 8 | 2 | 9 | 28853 | 34 | |||
| 61208 | 188348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 135 Bridgeview Dr | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6013321.68612 | 2095651.63967 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | 10 | 3 | 8 | 58 | 1 | |||
| 61510 | 10401 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.7703686867394 | -122.44462080278 | (37.7703686867394, -122.44462080278) | 15 | 5 | 11 | 29492 | 9 | |||
| 61548 | 34932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.7859000712136 | -122.442821815392 | (37.7859000712136, -122.442821815392) | 13 | 6 | 1 | 29490 | 27 | ||
| 61661 | 27185 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 238 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002801.11945 | 2093793.8954 | 37.7293179724305 | -122.432596459871 | (37.7293179724305, -122.432596459871) | 9 | 7 | 6 | 28861 | 25 | ||
| 61923 | 95866 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) | 8 | 2 | 9 | 28853 | 34 |
| 63443 | 116373 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6014023.28278 | 2105408.18049 | 37.7618383767519 | -122.394613116617 | (37.7618383767519, -122.394613116617) | 10 | 3 | 8 | 28856 | 29 | |||
| 63468 | 204661 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 218 Acadia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001436.20899 | 2095068.95473 | 37.7327414936084 | -122.437406337246 | (37.7327414936084, -122.437406337246) | 9 | 7 | 5 | 63 | 40 | |||
| 63758 | 188328 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1850 23rd St | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012921.09525 | 2102885.82617 | 37.7548512056382 | -122.398248195201 | (37.7548512056382, -122.398248195201) | 10 | 3 | 8 | 28856 | 29 | |||
| 64562 | 204644 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994179.89282 | 2090937.7889 | 37.7209831150476 | -122.462193545901 | (37.7209831150476, -122.462193545901) | 9 | 8 | 6 | 28861 | 24 | |||
| 65055 | 101156 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013453.76144 | 2105247.59109 | 37.7613657542352 | -122.396571621485 | (37.7613657542352, -122.396571621485) | 10 | 3 | 8 | 28856 | 29 | |||
| 65125 | 49467 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3624 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46393 | 6006125.2277225 | 2104366.11259234 | 37.7585348409416 | -122.421855375902 | (37.7585348409416, -122.421855375902) | 2 | 4 | 5 | 28859 | 19 |
| 65282 | 221342 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 211 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | 2 | 7 | 5 | 63 | 22 | |||
| 65291 | 221359 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999338.89083 | 2104005.40055 | 37.7571593642224 | -122.445299560921 | (37.7571593642224, -122.445299560921) | 2 | 5 | 5 | 28862 | 3 | |||
| 65589 | 22551 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.69902 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | 2 | 7 | 5 | 63 | 7 | ||
| 66237 | 175786 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008114.21781 | 2093492.54626 | 37.7287904076408 | -122.414207227876 | (37.7287904076408, -122.414207227876) | 9 | 3 | 7 | 309 | 28 | |||
| 66804 | 48736 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553 | (37.7355533009373, -122.39050541553) | 10 | 3 | 8 | 58 | 1 | ||
| 66818 | 222545 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002444.04339 | 2095477.86439 | 37.7339215111673 | -122.43395122468 | (37.7339215111673, -122.43395122468) | 2 | 7 | 5 | 63 | 7 | |||
| 66946 | 188341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2351 Silver Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013156.07372 | 2096444.56636 | 37.7371779607887 | -122.396983972339 | (37.7371779607887, -122.396983972339) | 10 | 3 | 8 | 58 | 1 | |||
| 67374 | 97995 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6013004.40763 | 2106156.2643 | 37.7638357521307 | -122.398189511757 | (37.7638357521307, -122.398189511757) | 14 | 3 | 8 | 28856 | 29 | ||
| 67527 | 30677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | 8 | 2 | 9 | 28853 | 34 | |
| 67530 | 27609 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | 13 | 6 | 1 | 29490 | 27 | ||
| 67658 | 56722 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | 10 | 3 | 8 | 58 | 1 | ||
| 68767 | 59352 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 469 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1980 12:00:00 AM | 11 | 4x4 | Permit Number 18701 | 5994737.99829015 | 2091686.56057322 | 37.7230711817022 | -122.460318578759 | (37.7230711817022, -122.460318578759) | 9 | 8 | 4 | 28861 | 24 | |
| 69202 | 43888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.7756943547316 | -122.412113186199 | (37.7756943547316, -122.412113186199) | 8 | 2 | 9 | 28853 | 34 |
| 69956 | 120687 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:45:00 PM | 3 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.7765498370385 | -122.480925799615 | (37.7765498370385, -122.480925799615) | 11 | 6 | 2 | 55 | 26 | ||
| 69965 | 252891 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 07:17:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 |
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) );