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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1122 | 1122 | 38279 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.39502820678801 | (37.7580416558018, -122.395028206788) | ||
| 1126 | 1126 | 38276 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 3 | Permit Number 40367 | 6013924.79961 | 2103962.8321 | 37.757864288826795 | -122.394852504434 | (37.7578642888268, -122.394852504434) | ||
| 1135 | 1135 | 38277 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013910.55501 | 2103982.27082 | 37.757916871294796 | -122.394903129995 | (37.7579168712948, -122.394903129995) | ||
| 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 | ||||||||
| 5445 | 5445 | 71960 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 6008996.95317 | 2116013.9295900003 | 37.7906785394346 | -122.41274707603701 | (37.7906785394346, -122.412747076037) | |||
| 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) | ||
| 15543 | 15543 | 106166 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6012226.18355 | 2103510.5202200003 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | ||||
| 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) | ||||
| 19790 | 19790 | 53252 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | ||
| 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) | ||
| 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) | |||
| 25065 | 25065 | 32969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 580 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37284 | 6014077.45388 | 2104409.80131 | 37.759100056248606 | -122.39435585294399 | (37.7591000562486, -122.394355852944) | |
| 25170 | 25170 | 39568 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 800 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40987 | 6011544.30248 | 2104593.03235 | 37.7594620297563 | -122.40312963433998 | (37.7594620297563, -122.40312963434) | |
| 25783 | 25783 | 70682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 8 | 6010606.08274 | 2106339.87511 | 37.764206026409795 | -122.406497569303 | (37.7642060264098, -122.406497569303) | ||
| 25919 | 25919 | 40096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | ||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 27540 | 27540 | 68129 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31880 | 6013874.62108 | 2104078.7495 | 37.7581797826985 | -122.39503416301001 | (37.7581797826985, -122.39503416301) | |
| 27605 | 27605 | 39569 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.776869999 | 2104583.27285 | 37.7594352029858 | -122.40313076567101 | (37.7594352029858, -122.403130765671) | |
| 28765 | 28765 | 35362 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 979 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 6 | Permit Number 38824 | 6011922.436290001 | 2103880.66513 | 37.75752713659001 | -122.401771780343 | (37.75752713659, -122.401771780343) | |
| 28823 | 28823 | 37988 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40209 | 6013865.90817 | 2104201.25783 | 37.7585156794839 | -122.39507287703199 | (37.7585156794839, -122.395072877032) | |
| 28840 | 28840 | 37987 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | |
| 30560 | 30560 | 32977 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 448 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 4 | Permit Number 46744 | 6014321.91414 | 2105021.23892 | 37.76079251737271 | -122.393553179256 | (37.7607925173727, -122.393553179256) | |
| 31195 | 31195 | 35348 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.40080483467301 | (37.7553687870439, -122.400804834673) | |
| 33670 | 33670 | 67525 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | |
| 35605 | 35605 | 49762 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 123@ GIRARD Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46556 | 6011554.1535 | 2090217.48516 | 37.7199903867389 | -122.402084923384 | (37.7199903867389, -122.402084923384) | |
| 35695 | 35695 | 35366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.1446700003 | 37.756647404478 | -122.40189800918999 | (37.756647404478, -122.40189800919) | |
| 36302 | 36302 | 38643 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.39897796896099 | (37.7565441236392, -122.398977968961) | |
| 37810 | 37810 | 39586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.756609729177896 | -122.401682552328 | (37.7566097291779, -122.401682552328) | |
| 38020 | 38020 | 32982 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 559 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 14 | Permit Number 37295 | 6013853.095 | 2104468.98134 | 37.7592500775456 | -122.39513594376899 | (37.7592500775456, -122.395135943769) | |
| 38097 | 38097 | 190683 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Minnesota St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015372.42654 | 2102509.7647599997 | 37.7539548603504 | -122.389744472134 | (37.7539548603504, -122.389744472134) | ||||
| 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) | ||
| 42129 | 42129 | 108456 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | ||||
| 47604 | 47604 | 69898 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277004 | -122.401657284058 | (37.756311243277, -122.401657284058) | ||
| 48448 | 48448 | 37938 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.799319999 | 2105128.09339 | 37.7609678851705 | -122.40089326501499 | (37.7609678851705, -122.400893265015) | |
| 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) | ||
| 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) | ||
| 52736 | 52736 | 46565 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 642 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 11 | Permit Number 44700 | 6012366.61584 | 2104950.40498 | 37.7604891841446 | -122.400310752549 | (37.7604891841446, -122.400310752549) | ||
| 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) | ||
| 60089 | 60089 | 67473 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 880 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 6 | Permit Number 30995 | 6012731.1830400005 | 2103360.24925 | 37.75614328768621 | -122.39893826479499 | (37.7561432876862, -122.398938264795) | |
| 60691 | 60691 | 37945 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.39988268066601 | (37.7581101796629, -122.399882680666) | |
| 61684 | 61684 | 69888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 10 | 6012175.72633 | 2103309.76161 | 37.755973692659396 | -122.40085568686101 | (37.7559736926594, -122.400855686861) | ||
| 62717 | 62717 | 78495 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 7 | 6011953.72275 | 2102256.16538 | 37.7530683626141 | -122.40154940677401 | (37.7530683626141, -122.401549406774) | ||
| 63686 | 63686 | 32948 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 307 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 9 | Permit Number 37265 | 6012947.03092 | 2105601.86977 | 37.76231031129179 | -122.39834906047399 | (37.7623103112918, -122.398349060474) | ||
| 63739 | 63739 | 39570 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | |
| 65946 | 65946 | 52722 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1115 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 5 | Permit Number 48775 | 6011675.49817 | 2103219.4484 | 37.755697797718796 | -122.40257930049201 | (37.7556977977188, -122.402579300492) | ||
| 67820 | 67820 | 107160 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1324 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6004955.04875 | 2120587.0969599998 | 37.80300760168571 | -122.42705771883399 | (37.8030076016857, -122.427057718834) | ||||
| 70131 | 70131 | 43301 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 515 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48334 | 6013838.69916 | 2104687.6633599997 | 37.7598497302126 | -122.39520105018299 | (37.7598497302126, -122.395201050183) | |
| 70237 | 70237 | 32980 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.0613700002 | 37.7593873374867 | -122.39515493295201 | (37.7593873374867, -122.395154932952) | |
| 70283 | 70283 | 52004 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1242 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/2005 12:00:00 AM | 3 | Permit Number 48221 | 6012214.20801 | 2102602.19108 | 37.7540330051314 | -122.400672898747 | (37.7540330051314, -122.400672898747) | |
| 76385 | 76385 | 58933 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1330 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18211 | 6011958.83687 | 2102173.2877700003 | 37.752841084147704 | -122.401525896729 | (37.7528410841477, -122.401525896729) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) |
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");