Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 1674 | 1674 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 52 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009049.0 | 2099828.0 | 37.746238652288106 | -122.411423013741 | (37.7462386522881, -122.411423013741) | ||||
| 5203 | 5203 | 46584 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2790 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2002 12:00:00 AM | Permit Number 44712 | ||||||||
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 9688 | 9688 | 35795 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.75963284616879 | -122.42070069541 | (37.7596328461688, -122.42070069541) | ||
| 18190 | 18190 | 73083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.41841169643601 | (37.7635727856768, -122.418411696436) | ||
| 18620 | 18620 | 121737 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 18708 | 18708 | 121749 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 19430 | 19430 | 68480 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32350 | 6010273.43286101 | 2102111.66598921 | 37.7525776974999 | -122.407350018785 | (37.7525776974999, -122.407350018785) | ||
| 19620 | 19620 | 34336 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 19800 | 19800 | 36597 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.40978500985399 | (37.7507339080729, -122.409785009854) | ||
| 19801 | 19801 | 94573 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3978 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116.0 | 2105363.0 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | ||
| 20293 | 20293 | 91075 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858.0 | 2104570.0 | 37.7591922359052 | -122.41587709061399 | (37.7591922359052, -122.415877090614) | ||
| 20984 | 20984 | 52219 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | |||
| 26647 | 26647 | 96093 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481.0 | 2086737.0 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | ||
| 37401 | 37401 | 35575 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.42314253259501 | (37.7559036789868, -122.423142532595) | |
| 38346 | 38346 | 36010 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.744183746831496 | -122.421946122617 | (37.7441837468315, -122.421946122617) | ||
| 45346 | 45346 | 121804 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 22 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 49970 | 49970 | 37676 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40072 | 6008031.0 | 2104525.0 | 37.7590784006599 | -122.41527558618401 | (37.7590784006599, -122.415275586184) | ||
| 50083 | 50083 | 36593 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1325 Florida St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.40978500985399 | (37.7507339080729, -122.409785009854) | ||
| 51130 | 51130 | 95638 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462.0 | 2107407.0 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | |
| 51133 | 51133 | 35546 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 51557 | 51557 | 52119 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 700 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.77631787229279 | -122.427977208208 | (37.7763178722928, -122.427977208208) | |
| 53612 | 53612 | 38251 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | ||
| 76134 | 76134 | 121731 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 76353 | 76353 | 94663 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614.0 | 2097695.0 | 37.7401321706185 | -122.42660684616101 | (37.7401321706185, -122.426606846161) | |
| 77536 | 77536 | 68105 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.745467388517795 | -122.414298897694 | (37.7454673885178, -122.414298897694) | ||
| 77618 | 77618 | 34735 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851001 | (37.7509115908716, -122.41496434851) | ||
| 77815 | 77815 | 71739 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.745627705832206 | -122.41488645052 | (37.7456277058322, -122.41488645052) | ||
| 78138 | 78138 | 40317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.42103015034901 | (37.7569313744996, -122.421030150349) | ||
| 78162 | 78162 | 44003 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 78209 | 78209 | 46116 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 648 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44475 | 6012371.38389312 | 2104918.06745502 | 37.760400658327605 | -122.400291990633 | (37.7604006583276, -122.400291990633) | |||
| 78330 | 78330 | 37758 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.75121419029829 | -122.40794259966002 | (37.7512141902983, -122.40794259966) | ||
| 79066 | 79066 | 52627 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642@ 18th ST Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | Permit Number 48710 | 6010085.91969508 | 2105298.86686021 | 37.761318540179204 | -122.40822324587499 | (37.7613185401792, -122.408223245875) | |||
| 79251 | 79251 | 82604 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010041.95956984 | 2101582.34952093 | 37.7511113537145 | -122.40811317009701 | (37.7511113537145, -122.408113170097) | ||
| 79276 | 79276 | 50560 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | |||
| 79377 | 79377 | 37153 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 170 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | Permit Number 39733 | 6005417.81804662 | 2100232.85413732 | 37.7471459516063 | -122.42400799468001 | (37.7471459516063, -122.42400799468) | |||
| 79557 | 79557 | 111057 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1851 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 79902 | 79902 | 35556 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 121 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38929 | 6005429.10148231 | 2103004.04163022 | 37.7547556297845 | -122.42416602832701 | (37.7547556297845, -122.424166028327) | ||
| 79962 | 79962 | 35543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 79972 | 79972 | 37737 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1266 Florida St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.41005529072599 | (37.751676715706, -122.410055290726) | ||
| 80009 | 80009 | 39079 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2280X Alameda St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | |||
| 80225 | 80225 | 42908 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2728 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51144 | 6009776.67669238 | 2103983.6124683 | 37.7576898279618 | -122.409199977722 | (37.7576898279618, -122.409199977722) | ||
| 80251 | 80251 | 34792 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1171 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38428 | 6008691.00817577 | 2101734.24862099 | 37.7514527000041 | -122.412795655117 | (37.7514527000041, -122.412795655117) | ||
| 80391 | 80391 | 37414 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39892 | 6001945.76118783 | 2101390.6122358004 | 37.7501282439333 | -122.436096904408 | (37.7501282439333, -122.436096904408) | ||
| 80413 | 80413 | 67919 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085454996 | -122.427629821288 | (37.734399085455, -122.427629821288) | ||
| 80531 | 80531 | 83340 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4201 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52615 | 6002013.46643782 | 2105257.92812677 | 37.7607508108309 | -122.43613949146099 | (37.7607508108309, -122.436139491461) | |
| 81057 | 81057 | 36914 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 508 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 39560 | 6001809.10067712 | 2102876.63029352 | 37.7542007293515 | -122.436675841105 | (37.7542007293515, -122.436675841105) | ||
| 81091 | 81091 | 35544 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 81099 | 81099 | 34556 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38265 | 6009291.02762051 | 2098031.45158376 | 37.741319296524296 | -122.410459272722 | (37.7413192965243, -122.410459272722) | ||
| 81213 | 81213 | 81287 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3145 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50544 | 6008016.04178081 | 2102664.62636249 | 37.753969398420104 | -122.41519562880899 | (37.7539693984201, -122.415195628809) | ||
| 81668 | 81668 | 37699 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 590 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | 3x3 | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | |
| 81850 | 81850 | 40242 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | ||
| 81853 | 81853 | 39159 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.42221723575199 | (37.7605645323651, -122.422217235752) | ||
| 81939 | 81939 | 39192 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | |||
| 81952 | 81952 | 37747 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1266 Florida St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.41005529072599 | (37.751676715706, -122.410055290726) | ||
| 82249 | 82249 | 35325 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38792 | 6006662.54340548 | 2104792.55869269 | 37.7597360500369 | -122.42002735576 | (37.7597360500369, -122.42002735576) | ||
| 82288 | 82288 | 35969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 176 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39127 | 6006023.56999156 | 2096341.44627535 | 37.7364952030819 | -122.42163700697701 | (37.7364952030819, -122.421637006977) | ||
| 82299 | 82299 | 95619 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767387 | 6007152.0 | 2106175.0 | 37.763559476875294 | -122.418432588523 | (37.7635594768753, -122.418432588523) | |
| 82436 | 82436 | 55554 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.70357659 | 2104857.37596764 | 37.759551370106294 | -122.44216582584 | (37.7595513701063, -122.44216582584) | ||
| 82528 | 82528 | 35310 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3620 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38778 | 6005440.34891977 | 2105498.91525501 | 37.7616066031849 | -122.424304565555 | (37.7616066031849, -122.424304565555) | ||
| 82566 | 82566 | 34320 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 82863 | 82863 | 46344 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | ||
| 82875 | 82875 | 34319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 83237 | 83237 | 121751 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 83608 | 83608 | 89008 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 707 Carolina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436.0 | 2104662.0 | 37.7597011565358 | -122.40005052882499 | (37.7597011565358, -122.400050528825) | |||
| 83730 | 83730 | 36062 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | ||
| 83734 | 83734 | 121582 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6013716.0 | 2106401.0 | 37.764547352750604 | -122.39574546120899 | (37.7645473527506, -122.395745461209) | |||
| 83848 | 83848 | 39193 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 862 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40846 | 6009896.76562705 | 2104189.54699772 | 37.758262004919 | -122.40879918760099 | (37.758262004919, -122.408799187601) | ||
| 83874 | 83874 | 121745 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 84233 | 84233 | 50586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 941 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | Permit Number 47201 | 6001947.38784558 | 2101357.03323011 | 37.7500361363805 | -122.436088876747 | (37.7500361363805, -122.436088876747) | |||
| 84328 | 84328 | 94953 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
| 84473 | 84473 | 34314 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 84526 | 84526 | 111062 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1851 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009528.24804625 | 2106163.95855958 | 37.7636626423221 | -122.410213085123 | (37.7636626423221, -122.410213085123) | ||||
| 84571 | 84571 | 66285 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | ||
| 84731 | 84731 | 93487 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | |||
| 84849 | 84849 | 121803 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 21 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 85309 | 85309 | 35320 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | 3x3 | Permit Number 49714 | 6006478.26782541 | 2104557.18271924 | 37.7590793783837 | -122.42064796592301 | (37.7590793783837, -122.420647965923) | ||
| 85431 | 85431 | 121738 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 85502 | 85502 | 36539 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3770 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39412 | 6008405.93467714 | 2097334.19751076 | 37.739355131371795 | -122.413470323165 | (37.7393551313718, -122.413470323165) | ||
| 85704 | 85704 | 88536 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
| 85813 | 85813 | 34327 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 85844 | 85844 | 44010 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 86087 | 86087 | 37734 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1266 Florida St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.41005529072599 | (37.751676715706, -122.410055290726) | |||
| 86209 | 86209 | 47749 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 993 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2002 12:00:00 AM | Permit Number 45529 | 6015544.08915786 | 2104434.58222781 | 37.7592495174377 | -122.389285216664 | (37.7592495174377, -122.389285216664) | |||
| 86552 | 86552 | 94514 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 476 27th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53699 | 6003420.0 | 2100114.0 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | ||||
| 86661 | 86661 | 40245 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | ||
| 86849 | 86849 | 37319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 584 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39833 | 6002558.90773127 | 2103291.37845472 | 37.7553821115396 | -122.43411247211901 | (37.7553821115396, -122.434112472119) | ||
| 87155 | 87155 | 68472 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2753 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32338 | 6009679.35333294 | 2103342.23929983 | 37.755923308575795 | -122.409491298475 | (37.7559233085758, -122.409491298475) | ||
| 87306 | 87306 | 121748 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 87326 | 87326 | 37746 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1266 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.41005529072599 | (37.751676715706, -122.410055290726) | ||
| 87634 | 87634 | 37731 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1266 Florida St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.41005529072599 | (37.751676715706, -122.410055290726) | ||
| 87912 | 87912 | 34338 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 87972 | 87972 | 40303 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 256 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41448 | 6006670.20949575 | 2104624.30459875 | 37.7592744953125 | -122.41998890238999 | (37.7592744953125, -122.41998890239) | ||
| 88016 | 88016 | 64228 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 24 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2012 12:00:00 AM | Permit Number 769264 | 6003122.11049357 | 2108174.45220479 | 37.7688218028269 | -122.43251351352 | (37.7688218028269, -122.43251351352) | |||
| 88061 | 88061 | 35577 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 267 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38946 | 6006724.71096873 | 2104570.58669243 | 37.759130068874896 | -122.41979659786399 | (37.7591300688749, -122.419796597864) | ||
| 88147 | 88147 | 94579 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 615 Noe St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53757 | 6003043.0 | 2104661.0 | 37.759170227575495 | -122.432536159886 | (37.7591702275755, -122.432536159886) | ||
| 88539 | 88539 | 36055 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1401 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | |||
| 88570 | 88570 | 88284 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 270 Whitney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51280 | 6004294.4 | 2096874.5 | 37.7378611907196 | -122.427653449759 | (37.7378611907196, -122.427653449759) | |||
| 88761 | 88761 | 121736 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");