502 rows where Supervisor Districts = 7 and qSpecies_id = 50

View and edit SQL

Supervisor 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)
13570 34057 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1718 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37959 6009442.90556489 2106775.8067624 37.7653378532253 -122.410551467879 (37.7653378532253, -122.410551467879) 8 4 7 28859 19
13592 162301 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 238 Olmstead St 1 Sidewalk: Property side : Cutout Tree Private 2   08/17/2019 12:00:00 AM 3 Width 0ft   6010941.2062 2091035.49966 37.7222022558199 -122.404261226995 (37.7222022558199, -122.404261226995) 10 3 7 309 28
13796 46609 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1078 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2002 12:00:00 AM     Permit Number 44732 6010490.67134457 2102955.14321265 37.7549058552549 -122.406658202843 (37.7549058552549, -122.406658202843) 10 4 7 28859 19
13806 36597 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1325 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/2002 12:00:00 AM     Permit Number 39450 6009555.90279082 2101454.80149403 37.7507339080729 -122.409785009854 (37.7507339080729, -122.409785009854) 2 4 7 28859 19
14210 85214 - 12 Jacaranda mimosifolia :: Jacaranda 50 2889 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.7526413233918 -122.409722943913 (37.7526413233918, -122.409722943913) 2 4 7 28859 19
14306 35546 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 110 Bartlett St 1 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
14333 68480 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1218 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32350 6010273.43286101 2102111.66598921 37.7525776974999 -122.407350018785 (37.7525776974999, -122.407350018785) 2 4 7 28859 19
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
14632 224584 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 6x3 Permit Number 781047 6008542.99689 2106795.22797 37.76534068665 -122.413665425938 (37.76534068665, -122.413665425938) 8 4 7 28859 19
15185 223092 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2719 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 3x3 Permit Number 782363 6010376.57029 2102801.69474 37.7544781353795 -122.407041982913 (37.7544781353795, -122.407041982913) 10 4 7 28859 19
15488 228530 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1736 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6009448.17881 2106596.433 37.7648456296528 -122.410520561485 (37.7648456296528, -122.410520561485) 8 4 7 28859 19
15490 264795 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 685 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009656 2091058 37.7221921373886 -122.40870548174 (37.7221921373886, -122.40870548174) 10 3 7 309 28
16490 233463 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2598 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008858.41145 2103392.91601 37.7560164221241 -122.41233397694 (37.7560164221241, -122.41233397694) 2 4 7 28859 19
17028 264796 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 685 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009656 2091058 37.7221921373886 -122.40870548174 (37.7221921373886, -122.40870548174) 10 3 7 309 28
17101 36665 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1361 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39471 6010110.56144118 2101283.13510395 37.750293617943 -122.407854839546 (37.750293617943, -122.407854839546) 2 4 7 28859 19
17882 240751 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2500 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 Width 3ft   6008841.50071 2103703.05088 37.7568670332937 -122.412414380831 (37.7568670332937, -122.412414380831) 2 4 7 28859 19
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
18756 166228 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3180 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007809.26595 2102700.74025 37.7540569360932 -122.41591326789 (37.7540569360932, -122.41591326789) 2 4 7 28859 19
19464 224582 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2701 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 09:45:00 PM 3 6x3 Permit Number 781047 6008579.87348 2106797.48808 37.7653489631036 -122.413538037855 (37.7653489631036, -122.413538037855) 8 4 7 28859 19
19970 42662 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 205 Bartlett St 1 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
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
20414 226318 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1453 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009324.95877 2100785.02024 37.7488818925933 -122.410536346369 (37.7488818925933, -122.410536346369) 2 4 7 28859 19
20654 37663 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3236 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 12 6x6 Permit Number 40069 6007902.47556564 2105636.26552701 37.7621224556474 -122.415798773861 (37.7621224556474, -122.415798773861) 8 4 7 28859 19
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
21656 255546 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 209 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006712 2104859 37.7599212687364 -122.419861024185 (37.7599212687364, -122.419861024185) 2 4 7 28859 19
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
23163 35804 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 233 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1998 12:00:00 AM     Permit Number 39048 6006716.02273257 2104761.27467675 37.7596531643404 -122.41984017695 (37.7596531643404, -122.41984017695) 2 4 7 28859 19
23830 34752 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 667 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 38399 6007930.97034241 2104052.78354238 37.7577761801817 -122.415588103657 (37.7577761801817, -122.415588103657) 2 4 7 28859 19
23886 37758 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1301 York St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52226 6010092.02702876 2101618.78120771 37.7512141902983 -122.40794259966 (37.7512141902983, -122.40794259966) 2 4 7 28859 19
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
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
24898 226454 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3273 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006579.31902 2103170.31631 37.7552770588978 -122.420200053701 (37.7552770588978, -122.420200053701) 2 4 7 28859 19
25581 36604 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1449 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39457 6009591.69172547 2100806.68710724 37.748956335196 -122.409615508849 (37.748956335196, -122.409615508849) 2 4 7 28859 19
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
26670 226355 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2175 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008795.60516 2105650.73446 37.7622123526471 -122.412710792894 (37.7622123526471, -122.412710792894) 8 4 7 28859 19
26703 101946 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 1045 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007665.9 2103581.6 37.7564675147494 -122.41647145397 (37.7564675147494, -122.41647145397) 2 4 7 28859 19
26785 33029 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3428 26th St 1 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
26942 37739 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 18 Sidewalk: Curb side : Cutout Tree Private 2   07/01/1998 12:00:00 AM     Permit Number 40095 6009484.78268632 2101799.61949938 37.751676715706 -122.410055290726 (37.751676715706, -122.410055290726) 2 4 7 28859 19
27538 226448 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3070 23rd St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008539 2102800 37.7543704799177 -122.41339668212 (37.7543704799177, -122.41339668212) 2 4 7 28859 19
27550 228526 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 405 Florida St 2 : Tree Private 2     1 Width 3ft   6009242.70378 2106296.28434 37.7640099687976 -122.411210045617 (37.7640099687976, -122.411210045617) 8 4 7 28859 19
27597 34735 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3246 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38385 6008060.11038004 2101550.08300487 37.7509115908716 -122.41496434851 (37.7509115908716, -122.41496434851) 2 4 7 28859 19
28096 35326 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 239 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1998 12:00:00 AM     Permit Number 38793 6006717.55595043 2104727.62386215 37.7595608533974 -122.41983248648 (37.7595608533974, -122.41983248648) 2 4 7 28859 19
28301 226433 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 106 Bartlett St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006663.83853 2103099.55931 37.7550875384663 -122.419902738742 (37.7550875384663, -122.419902738742) 2 4 7 28859 19
28612 226325 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 825 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007984.60499 2102879.52609 37.7545576974837 -122.415319557045 (37.7545576974837, -122.415319557045) 2 4 7 28859 19
28697 228540 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2620 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010291.15626 2104007.47358 37.757784154732 -122.407422370055 (37.757784154732, -122.407422370055) 10 4 7 28859 19
28755 226347 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3175 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008486.7284 2101525.46437 37.7508679571961 -122.413487316996 (37.7508679571961, -122.413487316996) 2 4 7 28859 19
28782 81873 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1312 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52224 6010043.81301103 2101548.7849116 37.7510192965024 -122.408104393789 (37.7510192965024, -122.408104393789) 2 4 7 28859 19
28802 226329 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 351 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007821.99816 2105868.63243 37.7627559568505 -122.416093572069 (37.7627559568505, -122.416093572069) 8 4 7 28859 19
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
28887 37673 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3330 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 8 0x0 Permit Number 40071 6008076 2104474 37.758940895326 -122.415116344354 (37.758940895326, -122.415116344354) 2 4 7 28859 19
29003 40334 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1359 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM   3x3 Permit Number 41465 6007740.61181979 2101748.78645974 37.7514392269717 -122.416083278537 (37.7514392269717, -122.416083278537) 2 4 7 28859 19
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
29253 226437 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 205 Bartlett St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006735.95617 2102521.24604 37.7535036857516 -122.419612305359 (37.7535036857516, -122.419612305359) 2 4 7 28859 19
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
30307 37730 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1466X Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/1998 12:00:00 AM 10 3x3 Permit Number 40094 6009550 2100728 37.7487379414946 -122.409754126164 (37.7487379414946, -122.409754126164) 2 4 7 28859 19
30369 226440 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 501 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006828.67283 2100820.93756 37.7488402485934 -122.419171070095 (37.7488402485934, -122.419171070095) 2 4 7 28859 19
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
30844 36599 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1423 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1998 12:00:00 AM     Permit Number 39452 6009585.61659215 2100916.70354088 37.7492580755485 -122.409644280871 (37.7492580755485, -122.409644280871) 2 4 7 28859 19
31962 33030 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3428 26th St 2 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
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
32997 40317 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 999 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41459 6006351.75417313 2103777.48351974 37.7569313744996 -122.421030150349 (37.7569313744996, -122.421030150349) 2 4 7 28859 19
33145 226330 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 351 Shotwell St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007820.88393 2105900.22293 37.7628426343977 -122.416099663169 (37.7628426343977, -122.416099663169) 8 4 7 28859 19
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
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
34711 44001 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
35048 46554 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2002 12:00:00 AM     Permit Number 44694 6008148.92674441 2105809.63139765 37.7626123299985 -122.414958662117 (37.7626123299985, -122.414958662117) 8 4 7 28859 19
35462 50281 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 2890 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM     Permit Number 46985 6009507.79940806 2102799.18720578 37.7544225953783 -122.410046254665 (37.7544225953783, -122.410046254665) 2 4 7 28859 19
35536 34771 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1112 Shotwell St 2 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
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
35810 34056 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1718 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37959 6009442.90556489 2106775.8067624 37.7653378532253 -122.410551467879 (37.7653378532253, -122.410551467879) 8 4 7 28859 19
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
36827 37740 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 1 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
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
37180 44003 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
37473 37697 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 590 Shotwell St 3 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
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
37788 34059 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1736 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM 12 6x7 Permit Number 37961 6009447.37701969 2106694.23265708 37.7651141201322 -122.410530241296 (37.7651141201322, -122.410530241296) 8 4 7 28859 19
38719 226320 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1237 Alabama St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6009255.59412 2102037.09938 37.7523159340399 -122.410864628624 (37.7523159340399, -122.410864628624) 2 4 7 28859 19
39039 35325 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 226 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1998 12:00:00 AM     Permit Number 38792 6006662.54340548 2104792.55869269 37.7597360500369 -122.42002735576 (37.7597360500369, -122.42002735576) 2 4 7 28859 19
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
39204 108736 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1351 Minna St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 3x3   6006994.99302 2107616.27188 37.76750803134 -122.419077863332 (37.76750803134, -122.419077863332) 8 4 7 28853 19
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
39886 37737 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1266 Florida St 6 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
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
40085 226333 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 383 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006558.03164 2103902.48298 37.7572862199038 -122.42032563593 (37.7572862199038, -122.42032563593) 2 4 7 28859 19
40292 82604 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1306 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52223 6010041.95956984 2101582.34952093 37.7511113537145 -122.408113170097 (37.7511113537145, -122.408113170097) 2 4 7 28859 19
40544 226445 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3176 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008495.22679 2101571.86166 37.7509958309158 -122.41346120966 (37.7509958309158, -122.41346120966) 2 4 7 28859 19
41565 81287 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3145 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50544 6008016.04178081 2102664.62636249 37.7539693984201 -122.415195628809 (37.7539693984201, -122.415195628809) 2 4 7 28859 19
41706 226443 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3190 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008436.7771 2101566.08648 37.7509766915292 -122.413662926703 (37.7509766915292, -122.413662926703) 2 4 7 28859 19
42682 226444 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3184 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6008475.72782 2101569.16263 37.750987325127 -122.413528448383 (37.750987325127, -122.413528448383) 2 4 7 28859 19
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
42972 226342 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 205 Bartlett St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006734.79318 2102518.91234 37.7534972124365 -122.419616161673 (37.7534972124365, -122.419616161673) 2 4 7 28859 19
43233 226460 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3236 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007913.34927 2105633.2143 37.7621146889646 -122.415760949718 (37.7621146889646, -122.415760949718) 8 4 7 28859 19
43994 229790 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 1471 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007575.95086 2107340.46198 37.7667834204423 -122.417048857113 (37.7667834204423, -122.417048857113) 8 4 7 28853 19
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

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