trees
1,194 rows where qSpecies_id = 50 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48539 | 121582 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6013716 | 2106401 | 37.7645473527506 | -122.395745461209 | (37.7645473527506, -122.395745461209) | 14 | 3 | 8 | 28856 | 29 | |||
| 48641 | 39193 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 862 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40846 | 6009896.76562705 | 2104189.54699772 | 37.758262004919 | -122.408799187601 | (37.758262004919, -122.408799187601) | 2 | 4 | 7 | 28859 | 19 | ||
| 49291 | 35310 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | 8 | 4 | 5 | 28859 | 19 | ||
| 49433 | 66285 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | 2 | 7 | 5 | 28861 | 25 | ||
| 49516 | 36914 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 39560 | 6001809.10067712 | 2102876.63029352 | 37.7542007293515 | -122.436675841105 | (37.7542007293515, -122.436675841105) | 2 | 4 | 5 | 28862 | 22 | ||
| 49552 | 35556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.424166028327 | (37.7547556297845, -122.424166028327) | 2 | 4 | 5 | 28859 | 19 | ||
| 50375 | 52627 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.7613185401792 | -122.408223245875 | (37.7613185401792, -122.408223245875) | 2 | 4 | 8 | 28859 | 19 | |||
| 50547 | 55554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.7595513701063 | -122.44216582584 | (37.7595513701063, -122.44216582584) | 2 | 4 | 5 | 28862 | 3 | ||
| 51327 | 111062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 51672 | 111057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | 8 | 4 | 8 | 28859 | 19 | ||||
| 52340 | 34319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 52802 | 37414 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | 2 | 4 | 5 | 28862 | 22 | ||
| 52832 | 37699 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | 3x3 | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | |
| 52895 | 121751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 14 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 53978 | 34556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.7413192965243 | -122.410459272722 | (37.7413192965243, -122.410459272722) | 10 | 7 | 7 | 28859 | 2 | ||
| 55105 | 39192 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | 2 | 4 | 7 | 28859 | 19 | |||
| 55486 | 37153 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 170 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468 | (37.7471459516063, -122.42400799468) | 2 | 7 | 5 | 28859 | 22 | |||
| 55836 | 46116 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 648 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44475 | 6012371.38389312 | 2104918.06745502 | 37.7604006583276 | -122.400291990633 | (37.7604006583276, -122.400291990633) | 10 | 3 | 8 | 28856 | 29 | |||
| 55948 | 50586 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | 2 | 4 | 5 | 28862 | 22 | |||
| 56528 | 34320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 56577 | 35969 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 176 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.421637006977 | (37.7364952030819, -122.421637006977) | 2 | 7 | 7 | 28859 | 2 | ||
| 56787 | 83340 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.436139491461 | (37.7607508108309, -122.436139491461) | 2 | 4 | 5 | 28862 | 3 | |
| 56791 | 42908 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2728 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51144 | 6009776.67669238 | 2103983.6124683 | 37.7576898279618 | -122.409199977722 | (37.7576898279618, -122.409199977722) | 2 | 4 | 7 | 28859 | 19 | ||
| 56905 | 34792 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38428 | 6008691.00817577 | 2101734.24862099 | 37.7514527000041 | -122.412795655117 | (37.7514527000041, -122.412795655117) | 2 | 4 | 7 | 28859 | 19 | ||
| 56991 | 35544 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
| 57222 | 95619 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767387 | 6007152 | 2106175 | 37.7635594768753 | -122.418432588523 | (37.7635594768753, -122.418432588523) | 8 | 4 | 7 | 28859 | 19 | |
| 57918 | 69428 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 689 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1994 12:00:00 AM | Permit Number 33534 | 6009310.24317295 | 2105050.63111101 | 37.7605934769524 | -122.410888462342 | (37.7605934769524, -122.410888462342) | 2 | 4 | 7 | 28859 | 19 | ||
| 58181 | 34312 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 58895 | 94579 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 615 Noe St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53757 | 6003043 | 2104661 | 37.7591702275755 | -122.432536159886 | (37.7591702275755, -122.432536159886) | 2 | 4 | 5 | 28862 | 3 | ||
| 59383 | 34753 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 667 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 38399 | 6007930.97034241 | 2104052.78354238 | 37.7577761801817 | -122.415588103657 | (37.7577761801817, -122.415588103657) | 2 | 4 | 7 | 28859 | 19 | ||
| 60196 | 121738 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 60733 | 36054 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 60736 | 34327 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 61102 | 68472 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2753 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32338 | 6009679.35333294 | 2103342.23929983 | 37.7559233085758 | -122.409491298475 | (37.7559233085758, -122.409491298475) | 2 | 4 | 7 | 28859 | 19 | ||
| 61242 | 37731 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
| 61584 | 40245 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
| 61704 | 121736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 61958 | 34774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1139 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 38415 | 6008083.82317224 | 2101294.64403942 | 37.750211545435 | -122.414864270544 | (37.750211545435, -122.414864270544) | 2 | 4 | 7 | 28859 | 19 | ||
| 62540 | 35320 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | 3x3 | Permit Number 49714 | 6006478.26782541 | 2104557.18271924 | 37.7590793783837 | -122.420647965923 | (37.7590793783837, -122.420647965923) | 2 | 4 | 7 | 28859 | 19 | ||
| 63482 | 88536 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 64355 | 36539 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39412 | 6008405.93467714 | 2097334.19751076 | 37.7393551313718 | -122.413470323165 | (37.7393551313718, -122.413470323165) | 2 | 7 | 7 | 28859 | 2 | ||
| 66452 | 35577 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 267 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38946 | 6006724.71096873 | 2104570.58669243 | 37.7591300688749 | -122.419796597864 | (37.7591300688749, -122.419796597864) | 2 | 4 | 7 | 28859 | 19 | ||
| 66767 | 88284 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 270 Whitney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | 2 | 7 | 5 | 63 | 7 | |||
| 66845 | 121803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 21 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 67227 | 47749 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 10 | 3 | 8 | 28856 | 29 | |||
| 67944 | 34742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2901 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38391 | 6008387.19520521 | 2101524.63770013 | 37.7508600981217 | -122.413831454694 | (37.7508600981217, -122.413831454694) | 2 | 4 | 7 | 28859 | 19 | ||
| 69045 | 37319 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 584 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.434112472119 | (37.7553821115396, -122.434112472119) | 2 | 4 | 5 | 28862 | 22 | ||
| 69087 | 35795 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.7596328461688 | -122.42070069541 | (37.7596328461688, -122.42070069541) | 2 | 4 | 7 | 28859 | 19 | ||
| 69251 | 36608 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1457 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39460 | 6009593.56099734 | 2100772.83589567 | 37.7488634920028 | -122.409606655966 | (37.7488634920028, -122.409606655966) | 2 | 4 | 7 | 28859 | 19 | ||
| 69633 | 94514 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 476 27th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53699 | 6003420 | 2100114 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | 2 | 7 | 5 | 63 | 22 | ||||
| 70598 | 40721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41700 | 6009320.76573459 | 2097115.38530681 | 37.7388056449049 | -122.410291784296 | (37.7388056449049, -122.410291784296) | 10 | 7 | 7 | 28859 | 2 | ||
| 70750 | 36055 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
| 71406 | 37746 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
| 72482 | 64228 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2012 12:00:00 AM | Permit Number 769264 | 6003122.11049357 | 2108174.45220479 | 37.7688218028269 | -122.43251351352 | (37.7688218028269, -122.43251351352) | 15 | 5 | 5 | 28862 | 3 | |||
| 72715 | 44010 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
| 72978 | 34338 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 73453 | 37734 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
| 74546 | 40303 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 256 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41448 | 6006670.20949575 | 2104624.30459875 | 37.7592744953125 | -122.41998890239 | (37.7592744953125, -122.41998890239) | 2 | 4 | 7 | 28859 | 19 | ||
| 74571 | 40729 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41708 | 6007052.60593678 | 2095671.4040371 | 37.7347133867785 | -122.418031698759 | (37.7347133867785, -122.418031698759) | 2 | 7 | 7 | 28859 | 2 | ||
| 74612 | 256119 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250X Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
| 74982 | 121755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 18 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 76026 | 121748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 11 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 76731 | 46556 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
| 77220 | 121726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 1 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 77294 | 37757 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.7512141902983 | -122.40794259966 | (37.7512141902983, -122.40794259966) | 2 | 4 | 7 | 28859 | 19 | ||
| 78054 | 52117 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | ||
| 78208 | 36018 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 93 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39164 | 6006753.30500561 | 2099126.43768618 | 37.7441832900966 | -122.419311502826 | (37.7441832900966, -122.419311502826) | 2 | 7 | 7 | 28859 | 2 | ||
| 78982 | 50683 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 114 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47255 | 6001960.98018226 | 2108347.90798031 | 37.7692321564841 | -122.436542190439 | (37.7692321564841, -122.436542190439) | 15 | 5 | 5 | 29492 | 9 | |||
| 79030 | 37748 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
| 79369 | 95629 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767396 | 6004866 | 2102499 | 37.753337093137 | -122.426077437274 | (37.753337093137, -122.426077437274) | 2 | 4 | 5 | 28862 | 22 | |
| 80034 | 95634 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767401 | 6005462 | 2101644 | 37.7510231280856 | -122.42395554828 | (37.7510231280856, -122.42395554828) | 2 | 4 | 5 | 28859 | 19 | ||
| 80309 | 39102 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40791 | 6008669.18392722 | 2102170.48666916 | 37.7526492866943 | -122.412901966068 | (37.7526492866943, -122.412901966068) | 2 | 4 | 7 | 28859 | 19 | |||
| 81858 | 34307 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 82797 | 37263 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39807 | 6004880.29315542 | 2103713.53429444 | 37.7566727279873 | -122.426114465107 | (37.7566727279873, -122.426114465107) | 2 | 4 | 5 | 28862 | 3 | ||
| 83461 | 36913 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 506 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39559 | 6001808.51272351 | 2102888.32664908 | 37.7542328113234 | -122.436678711571 | (37.7542328113234, -122.436678711571) | 2 | 4 | 5 | 28862 | 22 | ||
| 83829 | 36715 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 155 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39501 | 6006494.25547109 | 2105211.24809202 | 37.7608761905332 | -122.420639103812 | (37.7608761905332, -122.420639103812) | 2 | 4 | 7 | 28859 | 19 | ||
| 84648 | 68106 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31852 | 6008212.57916811 | 2099552.28991109 | 37.7454346644163 | -122.414295759595 | (37.7454346644163, -122.414295759595) | 2 | 7 | 7 | 28859 | 2 | ||
| 84685 | 32944 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 225 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37262 | 6012923.17595221 | 2106002.78448692 | 37.7634098055879 | -122.398459699211 | (37.7634098055879, -122.398459699211) | 14 | 3 | 8 | 28856 | 29 | |||
| 84695 | 37318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 584 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.434112472119 | (37.7553821115396, -122.434112472119) | 2 | 4 | 5 | 28862 | 22 | ||
| 84808 | 86797 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | 3x3 | Permit Number 49714 | 6006494 | 2104554 | 37.7590715260193 | -122.42059333056 | (37.7590715260193, -122.42059333056) | 2 | 4 | 7 | 28859 | 19 | ||
| 85186 | 40244 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
| 85315 | 33045 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 435 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2000 12:00:00 AM | Permit Number 37322 | 6005530.37891091 | 2101176.15171839 | 37.7497423846708 | -122.423685826158 | (37.7497423846708, -122.423685826158) | 2 | 4 | 5 | 28859 | 19 | ||
| 85522 | 37415 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 935 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39893 | 6001946.57451683 | 2101373.82273034 | 37.75008219015 | -122.436092890574 | (37.75008219015, -122.436092890574) | 2 | 4 | 5 | 28862 | 22 | ||
| 85653 | 34305 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38093 | 6010822.82923264 | 2102485.1673324 | 37.7536339837486 | -122.405476404222 | (37.7536339837486, -122.405476404222) | 10 | 4 | 8 | 28859 | 19 | ||
| 85838 | 33044 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 417 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37321 | 6005524.82070863 | 2101276.46802426 | 37.7500175164074 | -122.423712178429 | (37.7500175164074, -122.423712178429) | 2 | 4 | 5 | 28859 | 19 | ||
| 86642 | 40279 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 353 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 41431 | 6006785.630987 | 2101729.148301 | 37.7513315645396 | -122.419384330204 | (37.7513315645396, -122.419384330204) | 2 | 4 | 7 | 28859 | 19 | ||
| 88179 | 43128 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42946 | 6006098.21265371 | 2097579.74571646 | 37.73989950547 | -122.421466850906 | (37.73989950547, -122.421466850906) | 2 | 7 | 7 | 28859 | 2 | ||
| 88732 | 47750 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 993 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | 10 | 3 | 8 | 28856 | 29 | |||
| 88772 | 94952 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 763 Brannan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909 | 2109793 | 37.7737603305178 | -122.402233924084 | (37.7737603305178, -122.402233924084) | 14 | 2 | 9 | 28853 | 34 | ||
| 89178 | 34318 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 89672 | 121756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 19 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
| 89909 | 40262 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3668 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45085 | 6005347.95435348 | 2101987.4938302 | 37.7519598434296 | -122.424374358675 | (37.7519598434296, -122.424374358675) | 2 | 4 | 5 | 28859 | 19 | ||
| 90048 | 36592 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
| 90226 | 121729 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
| 90509 | 52078 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 266 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 3x3 | Permit Number 50281 | 6006938.43131737 | 2107937.41791562 | 37.7683866372255 | -122.419296287373 | (37.7683866372255, -122.419296287373) | 8 | 4 | 7 | 28853 | 19 | ||
| 91308 | 107509 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | 13 | 9 | 1 | 57 | 17 | ||||||
| 92950 | 37752 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43814 | 6009595.89758738 | 2100730.52187726 | 37.7487474379975 | -122.409595589892 | (37.7487474379975, -122.409595589892) | 2 | 4 | 7 | 28859 | 19 | ||
| 93171 | 34746 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2633 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38394 | 6008932.99171324 | 2103129.73681544 | 37.7552979763123 | -122.412057454279 | (37.7552979763123, -122.412057454279) | 2 | 4 | 7 | 28859 | 19 | ||
| 94159 | 97024 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1455 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349 | 2100759.5 | 37.7488131674601 | -122.410451409671 | (37.7488131674601, -122.410451409671) | 2 | 4 | 7 | 28859 | 19 | ||||
| 94181 | 34791 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1165 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 38427 | 6008689.09005555 | 2101767.92143829 | 37.7515450503444 | -122.412804668606 | (37.7515450503444, -122.412804668606) | 2 | 4 | 7 | 28859 | 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) );