trees

193 rows where Police Districts = 7 and qSpecies_id = 50

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

Police Districts ✖

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)
543 100400 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 88 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 6x3   6008223 2099495 37.7452779444232 -122.414255673266 (37.7452779444232, -122.414255673266) 2 7 7 28859 2
1529 36010 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 190 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39158 6005991.6913929 2099142.23667474 37.7441837468315 -122.421946122617 (37.7441837468315, -122.421946122617) 2 7 5 28859 2
4829 158177 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 340 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x5   6003950.61422 2096725.29328 37.7374320507564 -122.42883145083 (37.7374320507564, -122.42883145083) 2 7 5 63 7
6306 237343 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99x Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007651 2096616 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695) 2 7 7 28859 2
6465 261249 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 23 Porter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007038 2095471 37.7341622992343 -122.418067993983 (37.7341622992343, -122.418067993983) 2 7 7 28859 2
6669 229888 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 83 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008255.19246 2099602.19695 37.7455740916772 -122.414151939365 (37.7455740916772, -122.414151939365) 2 7 7 28859 2
6734 226402 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 88 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008216.93199 2099535.32688 37.7453883322157 -122.414279508218 (37.7453883322157, -122.414279508218) 2 7 7 28859 2
7478 226407 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 59 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006002.53632 2097682.69863 37.7401767960293 -122.421804971219 (37.7401767960293, -122.421804971219) 2 7 7 28859 2
9376 237344 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 99x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007651 2096616 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695) 2 7 7 28859 2
10934 226371 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 626 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002431.85737 2098894.22226 37.7433013483718 -122.43423751036 (37.7433013483718, -122.43423751036) 2 7 5 63 22
11124 230876 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 241 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 01:31:00 PM 3 Width 4ft   6004420.76549 2097018.25838 37.7382630656916 -122.427226779685 (37.7382630656916, -122.427226779685) 2 7 5 63 7
11283 96093 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 116 Drake St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2011 12:00:00 AM   3x3 Permit Number 56922 6001481 2086737 37.7098663684689 -122.436655293893 (37.7098663684689, -122.436655293893) 9 7 6 28861 5
12676 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
13095 226377 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 267 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2020 12:00:00 AM 3 Width 3ft Permit Number 785520 6007909.30084 2097390.1768 37.739480940202 -122.415191429754 (37.739480940202, -122.415191429754) 2 7 7 28859 2
14521 259145 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 115 Wool St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007403 2097606 37.7400450761075 -122.416957288885 (37.7400450761075, -122.416957288885) 2 7 7 28859 2
14868 93885 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 61@ San Jose Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2010 12:00:00 AM     Permit Number 53373 6006171 2099937 37.7463760977894 -122.421382540818 (37.7463760977894, -122.421382540818) 2 7 5 28859 2
18066 220829 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 147 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2019 12:00:00 AM 3 4x4 Permit Number 784791 6008911.9321 2099119.05037 37.7442843442566 -122.411846891528 (37.7442843442566, -122.411846891528) 2 7 7 28859 2
18224 248227 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 38 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007014.76999 2099297.76945 37.7446684509831 -122.418419557911 (37.7446684509831, -122.418419557911) 2 7 7 28859 2
18656 229861 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1509 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010132.55959 2100497.58386 37.7481378987515 -122.407723384842 (37.7481378987515, -122.407723384842) 2 7 7 28859 2
18693 226764 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 18 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004212.35359 2095476.21584 37.7340171774496 -122.427837519201 (37.7340171774496, -122.427837519201) 2 7 5 28861 25
20282 226409 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 340 Bennington St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007041.57099 2096614.16719 37.7373013855609 -122.418136666301 (37.7373013855609, -122.418136666301) 2 7 7 28859 2
20342 226375 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 235 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004677.73219 2096935.71561 37.7380509507014 -122.426332439909 (37.7380509507014, -122.426332439909) 2 7 5 63 7
21276 226310 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 110 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010345.87417 2099884.35237 37.7464660383936 -122.406942531387 (37.7464660383936, -122.406942531387) 2 7 7 28859 2
21766 36029 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 57 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39176 6008256.82211369 2099693.24167493 37.7458241717762 -122.414152744353 (37.7458241717762, -122.414152744353) 2 7 7 28859 2
22460 65976 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 59 & 1/2 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM 8 6x6 Permit Number 31847 6008257.4720065 2099681.55363989 37.7457921155362 -122.414149670347 (37.7457921155362, -122.414149670347) 2 7 7 28859 2
22913 96092 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 116 Drake St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2011 12:00:00 AM   3x3 Permit Number 56922 6001481 2086737 37.7098663684689 -122.436655293893 (37.7098663684689, -122.436655293893) 9 7 6 28861 5
24108 226363 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 178 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6006046.41496 2096344.01449 37.7365035429963 -122.421558204449 (37.7365035429963, -122.421558204449) 2 7 7 28859 2
24224 229868 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 248 28th St 1 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6004337.80093 2099585.86328 37.7453084292413 -122.427696518086 (37.7453084292413, -122.427696518086) 2 7 5 63 22
24866 255162 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 598 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 779511 6007652.9891 2096583.60222 37.7372518561065 -122.416020541778 (37.7372518561065, -122.416020541778) 2 7 7 28859 2
25503 94663 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1883 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53800 6004614 2097695 37.7401321706185 -122.426606846161 (37.7401321706185, -122.426606846161) 2 7 5 63 7
25857 43125 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 28 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM     Permit Number 42943 6006014.62206932 2098348.860336 37.7420066078017 -122.421810489884 (37.7420066078017, -122.421810489884) 2 7 7 28859 2
25889 52052 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 84 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/2005 12:00:00 AM     Permit Number 48254 6005362.31259493 2099645.76538508 37.7455308063117 -122.424158182307 (37.7455308063117, -122.424158182307) 2 7 5 28859 22
28240 226821 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1883 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004617.16315 2097706.60415 37.740164211802 -122.42659673537 (37.740164211802, -122.42659673537) 2 7 5 63 7
28827 229891 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 59 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008240.95046 2099813.74948 37.7461541678773 -122.414216150953 (37.7461541678773, -122.414216150953) 2 7 7 28859 2
28908 229866 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 116 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6005094.82025 2098749.88858 37.7430558262652 -122.425019400031 (37.7430558262652, -122.425019400031) 2 7 5 63 22
29233 226388 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 88 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006749.9144 2099207.72209 37.7444062878286 -122.41932899196 (37.7444062878286, -122.41932899196) 2 7 7 28859 2
29462 226390 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006633.7821 2097989.5025 37.7410547888452 -122.419644136891 (37.7410547888452, -122.419644136891) 2 7 7 28859 2
29492 94652 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 463 Arlington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2017 12:00:00 AM 3 3x3 Permit Number 779226 6003847 2095961 37.735327609986 -122.429135213798 (37.735327609986, -122.429135213798) 2 7 5 63 7
30569 44068 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/02/2003 12:00:00 AM     Permit Number 43592 6006646.88740951 2098034.91768842 37.741180227012 -122.419602044821 (37.741180227012, -122.419602044821) 2 7 7 28859 2
31293 229879 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 402 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003795.059 2100140.55813 37.7468007768344 -122.429612782729 (37.7468007768344, -122.429612782729) 2 7 5 63 22
31441 50614 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 474 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2003 12:00:00 AM     Permit Number 47214 6002793.31412073 2098675.69251057 37.7427218255103 -122.432972078444 (37.7427218255103, -122.432972078444) 2 7 5 63 22
32766 226392 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1441 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008026.30666 2099772.03767 37.7460275775108 -122.414955412565 (37.7460275775108, -122.414955412565) 2 7 7 28859 2
33353 229895 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1429 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008018.20821 2099852.67897 37.7462485454514 -122.414989122751 (37.7462485454514, -122.414989122751) 2 7 7 28859 2
33380 226305 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 84 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6006137.34667 2097561.46022 37.7398515040311 -122.421330243406 (37.7398515040311, -122.421330243406) 2 7 7 28859 2
33974 229877 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 376 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004079.13209 2100156.42335 37.7468604198839 -122.428631616054 (37.7468604198839, -122.428631616054) 2 7 5 63 22
33999 219234 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 273 Dalewood Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995327.0897 2097229.75541 37.7383253194549 -122.458683321089 (37.7383253194549, -122.458683321089) 9 7 4 59 40
34325 248003 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 428 Franconia St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009956.29023 2098510.13636 37.7426709335279 -122.408192770677 (37.7426709335279, -122.408192770677) 10 7 7 28859 2
35141 32262 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 10 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 3   Permit Number 35561 6005748.8799 2099664.71545 37.7456046578383 -122.422822837406 (37.7456046578383, -122.422822837406) 2 7 5 28859 22
35623 52402 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 92@ MISSION Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/2005 12:00:00 AM     Permit Number 48522 6006139.57045617 2097557.41563242 37.7398405238756 -122.421322267329 (37.7398405238756, -122.421322267329) 2 7 7 28859 2
35946 68105 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 78 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31851 6008211.91573535 2099564.22145596 37.7454673885178 -122.414298897694 (37.7454673885178, -122.414298897694) 2 7 7 28859 2
37084 71739 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1467 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1995 12:00:00 AM   3x3 Permit Number 56975 6008043.26276721 2099626.05915094 37.7456277058322 -122.41488645052 (37.7456277058322, -122.41488645052) 2 7 7 28859 2
37653 248002 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 428 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009958.97644 2098527.35445 37.74271836107 -122.408184696582 (37.74271836107, -122.408184696582) 10 7 7 28859 2
38739 229867 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 474 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002892.54695 2098627.83365 37.7425960442853 -122.432625542146 (37.7425960442853, -122.432625542146) 2 7 5 63 22
39052 229883 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3784 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008413.69404 2097282.59684 37.7392138829104 -122.413439846296 (37.7392138829104, -122.413439846296) 2 7 7 28859 2
39438 229804 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 10 Crescent Ave 7 Side Yard : Yard Tree Private 2     6 Width 5ft   6005354.49537 2095898.81655 37.7352420900484 -122.423918818711 (37.7352420900484, -122.423918818711) 2 7 7 28859 2
39458 67919 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 18 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31630 6004275.26721169 2095614.00906402 37.734399085455 -122.427629821288 (37.734399085455, -122.427629821288) 2 7 5 28861 25
40005 229894 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1435 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008020.95699 2099824.31502 37.7461708188376 -122.414977610555 (37.7461708188376, -122.414977610555) 2 7 7 28859 2
40026 229885 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1420 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007989.39364 2099739.34159 37.7459357270683 -122.415080739378 (37.7459357270683, -122.415080739378) 2 7 7 28859 2
41208 226823 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 192 Laidley St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004115.91768 2097275.83468 37.7389530669259 -122.428299145692 (37.7389530669259, -122.428299145692) 2 7 5 63 7
42122 93487 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 643 San Jose Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/05/2010 12:00:00 AM   3x3 Permit Number 53236 6005997.4 2099554.6 37.745316324998 -122.421955670553 (37.745316324998, -122.421955670553) 2 7 5 28859 2
42902 104963 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 1474X SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3z3 Permit Number 770948 6008023 2099506 37.7452969115591 -122.414948020341 (37.7452969115591, -122.414948020341) 2 7 7 28859 2
44395 226394 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1451 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008031.02829 2099712.86133 37.7458653577975 -122.414934898137 (37.7458653577975, -122.414934898137) 2 7 7 28859 2
46491 226357 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 645 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005980.00754 2099557.6277 37.7453236574624 -122.422016025938 (37.7453236574624, -122.422016025938) 2 7 5 28859 2
47608 176585 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 205 Seneca Ave 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 6ft   5999821.59853 2090369.86807 37.719746961831 -122.442651149242 (37.719746961831, -122.442651149242) 9 7 6 28861 25
48985 100215 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 59 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 7x6   6008249 2099678 37.7457818821655 -122.414178714053 (37.7457818821655, -122.414178714053) 2 7 7 28859 2
49433 66285 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 10 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31629 6004295.09294916 2095637.08175846 37.7344635592859 -122.427562920462 (37.7344635592859, -122.427562920462) 2 7 5 28861 25
51307 226395 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1467 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008034.1838 2099620.63234 37.7456122948636 -122.414917460292 (37.7456122948636, -122.414917460292) 2 7 7 28859 2
51890 229889 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 77 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008249.88149 2099665.88685 37.7457486716635 -122.414174809135 (37.7457486716635, -122.414174809135) 2 7 7 28859 2
53978 34556 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2 Nebraska St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1997 12:00:00 AM     Permit Number 38265 6009291.02762051 2098031.45158376 37.7413192965243 -122.410459272722 (37.7413192965243, -122.410459272722) 10 7 7 28859 2
54136 226376 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 268 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004329.65759 2096832.9872 37.7377492002742 -122.427528590399 (37.7377492002742, -122.427528590399) 2 7 5 63 7
55153 229747 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 84 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6005427.81149 2099645.37238 37.7455334252207 -122.423931669125 (37.7455334252207, -122.423931669125) 2 7 5 28859 22
55486 37153 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 170 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1998 12:00:00 AM     Permit Number 39733 6005417.81804662 2100232.85413732 37.7471459516063 -122.42400799468 (37.7471459516063, -122.42400799468) 2 7 5 28859 22
56577 35969 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 176 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39127 6006023.56999156 2096341.44627535 37.7364952030819 -122.421637006977 (37.7364952030819, -122.421637006977) 2 7 7 28859 2
57967 49762 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 123@ GIRARD Ordway St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/2018 12:00:00 AM 3   Permit Number 781437 6011554.1535 2090217.48516 37.7199903867389 -122.402084923384 (37.7199903867389, -122.402084923384) 10 7 8 309 28
58760 226396 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1483 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008038.28994 2099516.86307 37.7453275982942 -122.41489591881 (37.7453275982942, -122.41489591881) 2 7 7 28859 2
58969 255166 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 115 Wool St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 779581 6007398.90831 2097677.8344 37.7402420872899 -122.416976524667 (37.7402420872899, -122.416976524667) 2 7 7 28859 2
64290 226822 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 39 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004297.5525 2098038.31795 37.7410569481125 -122.427725448366 (37.7410569481125, -122.427725448366) 2 7 5 63 7
64355 36539 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3770 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39412 6008405.93467714 2097334.19751076 37.7393551313718 -122.413470323165 (37.7393551313718, -122.413470323165) 2 7 7 28859 2
66767 88284 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 270 Whitney St   Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51280 6004294.4 2096874.5 37.7378611907196 -122.427653449759 (37.7378611907196, -122.427653449759) 2 7 5 63 7
69053 226393 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1451 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008028.94032 2099726.7877 37.7459034791769 -122.414943103567 (37.7459034791769, -122.414943103567) 2 7 7 28859 2
69326 229892 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 59 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008238.53675 2099832.54368 37.7462056369848 -122.414225826762 (37.7462056369848, -122.414225826762) 2 7 7 28859 2
69633 94514 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 476 27th St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53699 6003420 2100114 37.746706610489 -122.430907804941 (37.746706610489, -122.430907804941) 2 7 5 63 22
70019 229864 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 76 Peralta Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6010511.83754 2100376.53881 37.7478267603098 -122.406403320374 (37.7478267603098, -122.406403320374) 2 7 7 28859 2
70598 40721 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 58 Bronte St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41700 6009320.76573459 2097115.38530681 37.7388056449049 -122.410291784296 (37.7388056449049, -122.410291784296) 10 7 7 28859 2
71284 24293 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 302 Winfield St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/03/2011 12:00:00 AM 3 2x2   6006647.73618 2098006.46065 37.741102138158 -122.419597091541 (37.741102138158, -122.419597091541) 2 7 7 28859 2
74013 229876 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 231 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6004828.77791 2100152.44223 37.746891885367 -122.42603912601 (37.746891885367, -122.42603912601) 2 7 5 63 22
74132 229869 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 314 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6003810.99153 2099557.89821 37.7452018299076 -122.42951614338 (37.7452018299076, -122.42951614338) 2 7 5 63 22
74571 40729 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 23 Porter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41708 6007052.60593678 2095671.4040371 37.7347133867785 -122.418031698759 (37.7347133867785, -122.418031698759) 2 7 7 28859 2
74771 226308 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 161 Newman St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007401.10475 2096768.52961 37.7377454608683 -122.416904522239 (37.7377454608683, -122.416904522239) 2 7 7 28859 2
75930 226391 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1437 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008021.55589 2099786.31396 37.7460665100597 -122.414972850429 (37.7460665100597, -122.414972850429) 2 7 7 28859 2
78203 229880 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 482 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003343.61389 2100112.58509 37.7466983971062 -122.431171839302 (37.7466983971062, -122.431171839302) 2 7 5 63 22
78208 36018 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 93 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39164 6006753.30500561 2099126.43768618 37.7441832900966 -122.419311502826 (37.7441832900966, -122.419311502826) 2 7 7 28859 2
83706 226401 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 96 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008220.52934 2099483.50303 37.7452462375173 -122.414263403134 (37.7452462375173, -122.414263403134) 2 7 7 28859 2
84496 226411 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 950 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009265.11627 2098029.82714 37.741313383517 -122.410548750743 (37.741313383517, -122.410548750743) 10 7 7 28859 2
84648 68106 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 80 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/1993 12:00:00 AM     Permit Number 31852 6008212.57916811 2099552.28991109 37.7454346644163 -122.414295759595 (37.7454346644163, -122.414295759595) 2 7 7 28859 2
86331 229860 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3224 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008991.73751 2099895.44974 37.7464206424026 -122.411625786002 (37.7464206424026, -122.411625786002) 2 7 7 28859 2
88179 43128 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 84 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM     Permit Number 42946 6006098.21265371 2097579.74571646 37.73989950547 -122.421466850906 (37.73989950547, -122.421466850906) 2 7 7 28859 2
90056 28275 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 304 Winfield St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/17/2016 12:00:00 AM 6 2X3   6006647.7252044 2098034.3646343 37.7411787556411 -122.419599108791 (37.7411787556411, -122.419599108791) 2 7 7 28859 2
91115 239542 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 91 Bennington St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2017 12:00:00 AM 3 2.5x4 Permit Number 779298 6007187.05082 2097389.73315 37.7394391055351 -122.417688629421 (37.7394391055351, -122.417688629421) 2 7 7 28859 2
95305 117397 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 330X Bennington St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3   Permit Number 776356 6007069.63693 2096670.72705 37.7374582661153 -122.418043637637 (37.7374582661153, -122.418043637637) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);