trees
1,194 rows where qSpecies_id = 50 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109741 | 39737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
111132 | 37445 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 428 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39919 | 6009952.87320759 | 2098588.12487014 | 37.7428848816788 | -122.408210085028 | (37.7428848816788, -122.408210085028) | 10 | 7 | 7 | 28859 | 2 | ||
111960 | 68104 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) | 2 | 7 | 7 | 28859 | 2 |
112129 | 50512 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2170 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47148 | 6008097.65074175 | 2105795.48714346 | 37.7625706116889 | -122.415135006616 | (37.7625706116889, -122.415135006616) | 8 | 4 | 7 | 28859 | 19 | ||
113140 | 39551 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 814 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 6 | Permit Number 40977 | 6012407.86986 | 2104192.73872 | 37.7584111000042 | -122.40011486132 | (37.7584111000042, -122.40011486132) | 10 | 3 | 8 | 28856 | 29 | |
113449 | 37029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 314 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39639 | 6003842.3126639 | 2099561.92709037 | 37.7452146656232 | -122.429408127516 | (37.7452146656232, -122.429408127516) | 2 | 7 | 5 | 63 | 22 | ||
113967 | 32967 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | 10 | 3 | 8 | 28856 | 29 | |
116173 | 37022 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
117197 | 34779 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
117701 | 34729 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3171 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38382 | 6008528.73936526 | 2101523.94206267 | 37.7508661360797 | -122.413341931038 | (37.7508661360797, -122.413341931038) | 2 | 4 | 7 | 28859 | 19 | ||
117756 | 35348 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.400804834673 | (37.7553687870439, -122.400804834673) | 10 | 3 | 8 | 28856 | 29 | |
118063 | 68774 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 559 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | Permit Number 32703 | 6003671.21705714 | 2105010.40354042 | 37.7601652112687 | -122.430388414345 | (37.7601652112687, -122.430388414345) | 2 | 4 | 5 | 28862 | 3 | ||
118867 | 39570 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011544.20572 | 2104572.19135 | 37.759404799599 | -122.403128503001 | (37.759404799599, -122.403128503001) | 10 | 3 | 8 | 28856 | 29 | |
118901 | 37938 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.79932 | 2105128.09339 | 37.7609678851705 | -122.400893265015 | (37.7609678851705, -122.400893265015) | 10 | 3 | 8 | 28856 | 29 | |
119742 | 39569 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 806 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40988 | 6011543.77687 | 2104583.27285 | 37.7594352029858 | -122.403130765671 | (37.7594352029858, -122.403130765671) | 10 | 3 | 8 | 28856 | 29 | |
119841 | 34060 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 3x3 | Permit Number 37962 | 6009449.36433284 | 2106657.97750104 | 37.7650146832031 | -122.410520807301 | (37.7650146832031, -122.410520807301) | 8 | 4 | 7 | 28859 | 19 | |
120105 | 37443 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 423 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39917 | 6010005.91327801 | 2098599.86014619 | 37.742920074008 | -122.408027513819 | (37.742920074008, -122.408027513819) | 10 | 7 | 7 | 28859 | 2 | ||
121096 | 36598 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1334 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39451 | 6009507.07319393 | 2101395.95284749 | 37.7505695862007 | -122.40994971369 | (37.7505695862007, -122.40994971369) | 2 | 4 | 7 | 28859 | 19 | ||
121695 | 34770 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
124078 | 36595 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 3 | 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 | ||
124310 | 34772 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
124479 | 37738 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 12 | 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 | ||
126418 | 36541 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39414 | 6008400.50795497 | 2097269.02278879 | 37.7391758711573 | -122.413484478256 | (37.7391758711573, -122.413484478256) | 2 | 7 | 7 | 28859 | 2 | ||
127792 | 33046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
127965 | 36578 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2833 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2002 12:00:00 AM | Permit Number 39440 | 6010288.37913672 | 2101036.1480817 | 37.7496253993391 | -122.407222522654 | (37.7496253993391, -122.407222522654) | 2 | 4 | 7 | 28859 | 19 | ||
129239 | 36603 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1446 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39456 | 6009539.30350757 | 2100812.2828298 | 37.7489687640594 | -122.409797063203 | (37.7489687640594, -122.409797063203) | 2 | 4 | 7 | 28859 | 19 | ||
130082 | 95630 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3737 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767398 | 6004828 | 2102496 | 37.753326708053 | -122.426208635682 | (37.753326708053, -122.426208635682) | 2 | 4 | 5 | 28862 | 22 | |
130325 | 35308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3524 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38776 | 6006060.26352617 | 2105533.64133784 | 37.761736937829 | -122.422162997439 | (37.761736937829, -122.422162997439) | 8 | 4 | 5 | 28859 | 19 | ||
130336 | 39735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3892 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
130550 | 34378 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38129 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | 2 | 7 | 5 | 63 | 7 | ||
130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
130836 | 62086 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 508 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | 4 | Permit Number 22172 | 6013224.51154 | 2104585.93548 | 37.7595362319382 | -122.397318105545 | (37.7595362319382, -122.397318105545) | 10 | 3 | 8 | 28856 | 29 | |
132012 | 37661 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
132383 | 42046 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 162 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45105 | 6005486.77037609 | 2099946.40187796 | 37.7463633118872 | -122.423749198438 | (37.7463633118872, -122.423749198438) | 2 | 7 | 5 | 28859 | 22 | ||
133172 | 37028 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 238 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39638 | 6004336.0974524 | 2099589.08608997 | 37.7453171819754 | -122.427702638011 | (37.7453171819754, -122.427702638011) | 2 | 7 | 5 | 63 | 22 | ||
133178 | 108708 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1220 Diamond St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774630 | 6001943.85423 | 2100537.23082 | 37.7477849526289 | -122.436042440417 | (37.7477849526289, -122.436042440417) | 2 | 4 | 5 | 63 | 22 | |
134370 | 35545 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 3 | 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 | ||
134812 | 42592 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 974 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2001 12:00:00 AM | Permit Number 42665 | 6009932.75878018 | 2103534.24461305 | 37.7564647077179 | -122.40862847969 | (37.7564647077179, -122.40862847969) | 2 | 4 | 7 | 28859 | 19 | ||
135649 | 37744 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 4 | 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 | ||
136750 | 59221 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2009 12:00:00 AM | 3x3 | Permit Number 52989 | 6004451.77295889 | 2107409.78146369 | 37.7667975133385 | -122.427859811231 | (37.7667975133385, -122.427859811231) | 8 | 4 | 5 | 28862 | 3 | |
137953 | 34734 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38384 | 6008507.54779719 | 2101522.76910569 | 37.7508617255783 | -122.413415130751 | (37.7508617255783, -122.413415130751) | 2 | 4 | 7 | 28859 | 19 | ||
138892 | 40302 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 241 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41447 | 6006718.06702337 | 2104716.40691697 | 37.7595300830635 | -122.419829922993 | (37.7595300830635, -122.419829922993) | 2 | 4 | 7 | 28859 | 19 |
139101 | 36602 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1440 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43812 | 6009537.9015539 | 2100837.67123452 | 37.7490383964317 | -122.40980370305 | (37.7490383964317, -122.40980370305) | 2 | 4 | 7 | 28859 | 19 | ||
140682 | 66211 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 543 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 6 | 3x3 | Permit Number 53588 | 6011817.82357 | 2105837.41873 | 37.7628941088863 | -122.402271150494 | (37.7628941088863, -122.402271150494) | 8 | 3 | 8 | 28856 | 29 |
140964 | 39588 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.11928 | 37.7562633193119 | -122.401863767506 | (37.7562633193119, -122.401863767506) | 10 | 3 | 8 | 28856 | 29 | |
141115 | 34778 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1153 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38418 | 6008088.1654875 | 2101216.34832832 | 37.7499968070134 | -122.414843713866 | (37.7499968070134, -122.414843713866) | 2 | 4 | 7 | 28859 | 19 | ||
141895 | 67581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.36958 | 37.7622066365616 | -122.39736679307 | (37.7622066365616, -122.39736679307) | 10 | 3 | 8 | 28856 | 29 | |
142531 | 43929 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1097x York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2003 12:00:00 AM | Permit Number 43519 | 6010038 | 2102851 | 37.7545945643559 | -122.408216329842 | (37.7545945643559, -122.408216329842) | 2 | 4 | 7 | 28859 | 19 | ||
145234 | 33027 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
146505 | 68109 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 87 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31855 | 6008266.5705023 | 2099517.92121492 | 37.7453433283283 | -122.414106634567 | (37.7453433283283, -122.414106634567) | 2 | 7 | 7 | 28859 | 2 | ||
147463 | 49994 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 908@ 20TH ST Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 8 | Permit Number 46738 | 6011568.01566 | 2104131.09801 | 37.7581949848158 | -122.403015130859 | (37.7581949848158, -122.403015130859) | 10 | 3 | 8 | 28856 | 29 | |
149126 | 38643 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.398977968961 | (37.7565441236392, -122.398977968961) | 10 | 3 | 8 | 28856 | 29 | |
149172 | 69228 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 537 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 12 | 7x7 | Permit Number 33281 | 6005209.5873 | 2111278.8914 | 37.7774639950364 | -122.425514041455 | (37.7774639950364, -122.425514041455) | 7 | 9 | 11 | 28852 | 10 |
150230 | 37662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3236 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40069 | 6007902.47556564 | 2105636.26552701 | 37.7621224556474 | -122.415798773861 | (37.7621224556474, -122.415798773861) | 8 | 4 | 7 | 28859 | 19 | ||
150369 | 37965 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 448 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40196 | 6013488.00942657 | 2104993.46196391 | 37.7606698772605 | -122.396435357808 | (37.7606698772605, -122.396435357808) | 10 | 3 | 8 | 28856 | 29 | ||
152400 | 37698 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
152448 | 40005 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41258 | 6019178.20708985 | 2094459.30382263 | 37.7320602007089 | -122.376024856319 | (37.7320602007089, -122.376024856319) | 10 | 3 | 8 | 58 | 1 | ||
152666 | 32965 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 550 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 11 | 7x6 | Permit Number 37280 | 6014071.41137 | 2104533.66356 | 37.7594398192185 | -122.394385423553 | (37.7594398192185, -122.394385423553) | 10 | 3 | 8 | 28856 | 29 |
153478 | 37047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39653 | 6005177.12153831 | 2098757.26684492 | 37.7430807339727 | -122.424735348964 | (37.7430807339727, -122.424735348964) | 2 | 7 | 5 | 63 | 22 | ||
153879 | 39493 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40951 | 6004185.70363157 | 2100750.04388013 | 37.7484963949206 | -122.428305402815 | (37.7484963949206, -122.428305402815) | 2 | 4 | 5 | 28862 | 22 | ||
155304 | 33026 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
155463 | 36721 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 31 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39505 | 6005645.10091643 | 2108871.29821034 | 37.7708779241001 | -122.423836216701 | (37.7708779241001, -122.423836216701) | 8 | 2 | 5 | 28853 | 19 | ||
156239 | 35551 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
156260 | 40004 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 2 | Permit Number 41258 | 6019111.21169 | 2094496.3329 | 37.7321581870346 | -122.376259043617 | (37.7321581870346, -122.376259043617) | 10 | 3 | 8 | 58 | 1 | |
156367 | 94883 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53950 | 6014292.7 | 2095395.8 | 37.7343614687147 | -122.392980749985 | (37.7343614687147, -122.392980749985) | 10 | 3 | 8 | 58 | 1 | ||
156536 | 68108 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1993 12:00:00 AM | Permit Number 31854 | 6008265.27071667 | 2099541.297285 | 37.7454074408153 | -122.414112782506 | (37.7454074408153, -122.414112782506) | 2 | 7 | 7 | 28859 | 2 | ||
157743 | 38250 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40360 | 6007553.94098134 | 2107334.22981902 | 37.7667650702265 | -122.417124544174 | (37.7667650702265, -122.417124544174) | 8 | 4 | 7 | 28853 | 19 | ||
157884 | 32980 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 553 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | Permit Number 37293 | 6013848.61872 | 2104519.06137 | 37.7593873374867 | -122.395154932952 | (37.7593873374867, -122.395154932952) | 10 | 3 | 8 | 28856 | 29 | |
158000 | 35547 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 4 | 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 | ||
158498 | 35323 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 209 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45862 | 6006709.88986016 | 2104895.8779561 | 37.76002240815 | -122.419870939027 | (37.76002240815, -122.419870939027) | 2 | 4 | 7 | 28859 | 19 | ||
161158 | 36061 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
161348 | 44333 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2001 12:00:00 AM | Permit Number 43718 | 6011390.61929335 | 2101865.00809081 | 37.7519628937204 | -122.403469222223 | (37.7519628937204, -122.403469222223) | 10 | 4 | 8 | 28859 | 19 | ||
161520 | 41430 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.397296450777 | (37.7593731443828, -122.397296450777) | 10 | 3 | 8 | 28856 | 29 | |
162120 | 58905 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 655 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | Permit Number 769760 | 6002418.15212939 | 2104399.4018004 | 37.7584164881822 | -122.434678474426 | (37.7584164881822, -122.434678474426) | 2 | 4 | 5 | 28862 | 3 | ||
162205 | 36596 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 2 | 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 | ||
163174 | 63722 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 282 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | Permit Number 24387 | 6008301.23026628 | 2100182.88719283 | 37.7471711235701 | -122.414033820067 | (37.7471711235701, -122.414033820067) | 2 | 7 | 7 | 28859 | 2 | ||
163566 | 37677 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40072 | 6008031 | 2104525 | 37.7590784006599 | -122.415275586184 | (37.7590784006599, -122.415275586184) | 2 | 4 | 7 | 28859 | 19 |
165980 | 35552 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38926 | 6005365.24269409 | 2103216.6337934 | 37.7553357524994 | -122.424401989918 | (37.7553357524994, -122.424401989918) | 2 | 4 | 5 | 28859 | 19 | ||
166181 | 37741 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 9 | 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 | ||
166276 | 95624 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767391 | 6005934 | 2105520 | 37.761692359374 | -122.422598723522 | (37.761692359374, -122.422598723522) | 8 | 4 | 5 | 28859 | 19 | |
166588 | 37015 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3027 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39628 | 6009057.00887193 | 2100861.48300975 | 37.7490768167034 | -122.411468322066 | (37.7490768167034, -122.411468322066) | 2 | 4 | 7 | 28859 | 19 | ||
168394 | 34557 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Nebraska St | 2 | 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 | ||
168405 | 37760 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1349 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2001 12:00:00 AM | Permit Number 43826 | 6010106.85455823 | 2101350.26433307 | 37.7504777324538 | -122.407872391397 | (37.7504777324538, -122.407872391397) | 2 | 4 | 7 | 28859 | 19 | ||
169574 | 121581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 6013754.46885 | 2106222.83027 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | 14 | 3 | 8 | 28856 | 29 | ||
169650 | 42663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42694 | 6006739.09438078 | 2102580.17039633 | 37.7536656552896 | -122.419605633092 | (37.7536656552896, -122.419605633092) | 2 | 4 | 7 | 28859 | 19 | ||
170113 | 35796 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 230 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39044 | 6006467.16362039 | 2104758.98191383 | 37.7596328461688 | -122.42070069541 | (37.7596328461688, -122.42070069541) | 2 | 4 | 7 | 28859 | 19 | ||
170353 | 68103 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.7456638906333 | -122.414137374358 | (37.7456638906333, -122.414137374358) | 2 | 7 | 7 | 28859 | 2 |
172051 | 35555 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 121 Fair Oaks St | 2 | 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 | ||
172836 | 37451 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39924 | 6009949.70212209 | 2098546.33795552 | 37.7427699663381 | -122.408218103257 | (37.7427699663381, -122.408218103257) | 10 | 7 | 7 | 28859 | 2 | ||
173427 | 68130 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 636 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31881 | 6013816.64959872 | 2104131.08746025 | 37.75832026754 | -122.395238321176 | (37.75832026754, -122.395238321176) | 10 | 3 | 8 | 28856 | 29 | ||
173888 | 51288 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1143 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/2004 12:00:00 AM | Permit Number 47660 | 6009497.00762937 | 2102519.03673443 | 37.7536527600356 | -122.410063798952 | (37.7536527600356, -122.410063798952) | 2 | 4 | 7 | 28859 | 19 | ||
174641 | 67525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | 10 | 3 | 8 | 28856 | 29 | |
175959 | 37023 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 402 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39634 | 6003883.04118176 | 2100148.50226599 | 37.7468275709653 | -122.429309115245 | (37.7468275709653, -122.429309115245) | 2 | 7 | 5 | 63 | 22 | ||
176006 | 33047 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 444 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37323 | 6005481.54643554 | 2101117.54369538 | 37.7495787038819 | -122.423850524117 | (37.7495787038819, -122.423850524117) | 2 | 4 | 5 | 28859 | 19 | ||
176666 | 96068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767693 | 6008044 | 2101787 | 37.7515612062089 | -122.415036827298 | (37.7515612062089, -122.415036827298) | 2 | 4 | 7 | 28859 | 19 | |
176868 | 40243 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | 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 | ||
176921 | 35574 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38942 | 6005781.80020082 | 2103418.56410023 | 37.7559137201977 | -122.422975758251 | (37.7559137201977, -122.422975758251) | 2 | 4 | 5 | 28859 | 19 | ||
178334 | 37742 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 7 | 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 | ||
178845 | 34366 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1891 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38122 | 6004628.22720814 | 2097641.9206333 | 37.7399872310586 | -122.426553875593 | (37.7399872310586, -122.426553875593) | 2 | 7 | 5 | 63 | 7 | ||
179365 | 99928 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298 | 2105556 | 37.7618680647923 | -122.417883738243 | (37.7618680647923, -122.417883738243) | 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) );