2,421 rows where qSpecies_id = 8

View and edit SQL

qCaretaker_id

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)
10 264794 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 31 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3   6011433 2091603 37.7237879639177 -122.40260109208 (37.7237879639177, -122.40260109208) 10 3 7 309 28
32 264850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 172 University St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
495 69056 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1235 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33064 5992348.34951393 2107046.09564514 37.7651067945026 -122.469696689595 (37.7651067945026, -122.469696689595) 11 8 11 56 12
499 180799 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Mount Vernon Ave 1 Front Yard : Yard Tree Private 2   10/23/2019 12:00:00 AM 3 8x8 Permit Number 782754 5998557.73755 2089669.84713 37.7177527376786 -122.446969503064 (37.7177527376786, -122.446969503064) 9 7 6 28861 25
806 189267 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300 Fairfax Ave 6 : Tree Private 2     1 Width 4ft   6017011.55747 2097196.03632 37.7394552087924 -122.383705980546 (37.7394552087924, -122.383705980546) 10 3 8 58 1
814 261435 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 371 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6007244 2095778 37.7350168462428 -122.417377534221 (37.7350168462428, -122.417377534221) 2 7 7 28859 2
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
908 207538 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 725 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5993510.99578 2106611.92865 37.7639818164203 -122.465643867796 (37.7639818164203, -122.465643867796) 1 8 11 56 12
1004 50532 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2003 12:00:00 AM     Permit Number 47171 5996679.82856356 2106618.62344586 37.7641824656847 -122.454684361894 (37.7641824656847, -122.454684361894) 15 5 11 29492 12
1037 63388 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 139 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1987 12:00:00 AM     Permit Number 23969 6005989.66886949 2095872.0431692 37.7352044148911 -122.421720887046 (37.7352044148911, -122.421720887046) 2 7 7 28859 2
1085 223588 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 890x Jarboe Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6009063.07444 2096876.26549 37.7381346254237 -122.411165877211 (37.7381346254237, -122.411165877211) 10 7 7 28859 2
1123 72265 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 358 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6002353.80444 2091524.36294 37.7230609707806 -122.433980702666 (37.7230609707806, -122.433980702666) 9 7 6 28861 5
1140 223581 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 85 Bessie St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008353.87265 2100058.32291 37.7468320543491 -122.413842976384 (37.7468320543491, -122.413842976384) 2 7 7 28859 2
1153 223389 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99x Oakwood St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
1156 31893 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 333 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 8   Permit Number 35323 6008432.94494 2108718.71395 37.7706159506067 -122.414182168285 (37.7706159506067, -122.414182168285) 8 2 9 28853 19
1161 223387 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 99x Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6005306 2104928 37.7600314174308 -122.424728608314 (37.7600314174308, -122.424728608314) 2 4 5 28859 19
1238 144982 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 676 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 3ft   5990689.31249 2110785.3324 37.7752776943529 -122.4757079065 (37.7752776943529, -122.4757079065) 11 6 2 54 26
1268 261097 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1999 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 4x6   6012390 2093339 37.7286080475288 -122.399414697344 (37.7286080475288, -122.399414697344) 10 3 8 58 1
1304 91006 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2401X Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 3x3   5988072.26413 2111179.36369 37.7762075240837 -122.484789675521 (37.7762075240837, -122.484789675521) 11 6 2 55 26
1308 52427 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1815X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 5 3x3 Permit Number 48544 6004786.32091155 2115731.58720361 37.7896660673411 -122.427295522794 (37.7896660673411, -122.427295522794) 13 9 11 28858 27
1327 261443 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 354 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007142 2095710 37.7348243937619 -122.417725367022 (37.7348243937619, -122.417725367022) 2 7 7 28859 2
1419 148015 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 703 Italy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002502.98722 2088786.72578 37.7155524923237 -122.433269485517 (37.7155524923237, -122.433269485517) 9 7 6 28861 5
1423 223556 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 701x Andover St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007456 2095683 37.7347679226533 -122.416637845271 (37.7347679226533, -122.416637845271) 2 7 7 28859 2
1507 74233 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2400 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6010292.05063 2106000.69739 37.7632571481177 -122.407559806245 (37.7632571481177, -122.407559806245) 8 4 8 28859 19
1511 260421 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bacon St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
1530 191101 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2041 26th St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6012369.93883 2101402.46492 37.7507475020033 -122.400050093052 (37.7507475020033, -122.400050093052) 10 3 8 28856 1
1541 70231 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6005265.5585 2110935.6138 37.7765246008409 -122.425295984643 (37.7765246008409, -122.425295984643) 7 9 11 28852 10
1628 72055 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2161 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6008082.6141 2119894.27994 37.8012816578905 -122.416185586193 (37.8012816578905, -122.416185586193) 5 1 1 308 32
1653 159947 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 157 Bertita St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 0ft   6000525.42449 2090002.91659 37.7187794927682 -122.440191978283 (37.7187794927682, -122.440191978283) 9 7 6 28861 25
1793 260413 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1510 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015825 2096697 37.7380192974637 -122.387773802776 (37.7380192974637, -122.387773802776) 10 3 8 58 1
1997 61779 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2227 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21800 6011831.44367 2102306.03776 37.7531984774519 -122.401975779864 (37.7531984774519, -122.401975779864) 10 3 8 28856 29
2148 154032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1662 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014879.40227 2097032.81009 37.7388889362706 -122.391066694069 (37.7388889362706, -122.391066694069) 10 3 8 58 1
2215 49868 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
2248 90191 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1860X Balboa St   Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2008 12:00:00 AM 3 3x3   5989777.17693 2111298.44542 37.7766336380006 -122.478900695137 (37.7766336380006, -122.478900695137) 11 6 2 55 26
2303 223507 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351 23rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006548.17508 2102589.95451 37.7536817641104 -122.420266570244 (37.7536817641104, -122.420266570244) 2 4 7 28859 19
2337 223401 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3647 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6005476.77928 2102530.01598 37.7534567573481 -122.423967438743 (37.7534567573481, -122.423967438743) 2 4 5 28859 19
2408 162789 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 237 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   5996026.23717 2090535.13208 37.71998365171 -122.455782228671 (37.71998365171, -122.455782228671) 9 8 6 28861 24
2430 224109 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 33 Gough St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006481.46308 2109309.64111 37.7721286885111 -122.420974342101 (37.7721286885111, -122.420974342101) 8 2 9 28853 19
2450 251744 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 70 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002620 2086992 37.710631205907 -122.432736905509 (37.710631205907, -122.432736905509) 9 7 6 28861 5
2532 72297 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 463 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6002248.50751 2090769.44278 37.7209821527804 -122.434290747523 (37.7209821527804, -122.434290747523) 9 7 6 28861 5
2581 170684 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 400X San Juan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2020 12:00:00 AM 3 Width 3ft   6000643.43225 2092709.34496 37.7262174472681 -122.439978026889 (37.7262174472681, -122.439978026889) 9 7 6 28861 25
2884 46077 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 814 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2001 12:00:00 AM     Permit Number 44458 6003949.63841524 2110800.90118746 37.7760802817088 -122.429838518249 (37.7760802817088, -122.429838518249) 7 9 11 29492 10
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
2999 94036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Lane St 4 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/14/2019 09:52:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968) 10 3 8 58 1
3110 126516 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3449 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   5997745.83933 2116374.85745 37.7910316321555 -122.451701179872 (37.7910316321555, -122.451701179872) 11 6 1 54 31
3218 84023 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 309 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 773233 6004808.26935881 2101900.57071737 37.7516906826671 -122.42623448013 (37.7516906826671, -122.42623448013) 2 4 5 28862 22
3255 72399 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 794-798 19th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2013 12:00:00 AM 3 3x3 Permit Number 769948 5990094.17599 2109997.03923 37.7730787370976 -122.477708963104 (37.7730787370976, -122.477708963104) 11 6 2 55 26
3265 255205 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 320 Bacon St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
3320 245104 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 250 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999855.4831 2109410.1992 37.7720290692692 -122.443901304248 (37.7720290692692, -122.443901304248) 15 5 11 29492 9
3440 223611 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 255 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6006745.90219 2102323.75764 37.752961988114 -122.419563899379 (37.752961988114, -122.419563899379) 2 4 7 28859 19
3623 69046 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3623 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1994 12:00:00 AM 3   Permit Number 33053 5984457.0554 2106305.4338 37.762613882253 -122.496935660667 (37.762613882253, -122.496935660667) 1 8 3 56 35
3646 189251 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 120 Loomis St 1 : Tree Private 2     1 Width 4ft   6010844.92077 2097998.29295 37.7413152397136 -122.405084094075 (37.7413152397136, -122.405084094075) 10 3 8 58 1
3696 262180 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 263 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/07/2019 12:00:00 AM 3     6009676.04228 2087903.41357 37.713531417046 -122.408413797613 (37.713531417046, -122.408413797613) 9 7 8 309 39
3729 260419 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200x Bacon St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
3755 200657 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1520 Oakdale Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015286.398 2095330.3246 37.7342368342044 -122.389540612503 (37.7342368342044, -122.389540612503) 10 3 8 58 1
3799 63192 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 439 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 7   Permit Number 33572 5984052.00356 2112858.19024 37.7805821307687 -122.498820690141 (37.7805821307687, -122.498820690141) 11 6 2 55 26
3889 223641 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006696.02527 2102542.97279 37.753561093073 -122.419751936808 (37.753561093073, -122.419751936808) 2 4 7 28859 19
3936 172254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1007 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6004516.89039 2090643.22078 37.7207640671979 -122.426440635537 (37.7207640671979, -122.426440635537) 9 7 6 28861 5
3971 172343 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 164 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6001347.87441 2087361.61872 37.7115738673031 -122.437160092082 (37.7115738673031, -122.437160092082) 9 7 6 28861 5
3984 243570 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
4081 145032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 154 15th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 5x5   5991192.39146 2114393.22168 37.7852131174265 -122.47423097869 (37.7852131174265, -122.47423097869) 11 6 2 54 26
4187 78365 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 671 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6002103.17705 2090031.785 37.7189484591704 -122.434740388752 (37.7189484591704, -122.434740388752) 9 7 6 28861 5
4341 255207 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 320 Bacon St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4370 38420 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
4434 31506 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 275 Collins St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 7   Permit Number 35066 5998177.9524 2112750.4955 37.7811048271727 -122.449944767442 (37.7811048271727, -122.449944767442) 15 6 2 54 16
4498 58438 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 905 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1979 12:00:00 AM   3x3 Permit Number 51484 5999161.38005537 2107089.77623283 37.7656181571992 -122.446135313725 (37.7656181571992, -122.446135313725) 15 5 11 29492 9
4522 141909 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 900 MCALLISTER ST 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004576.1236 2111931.0419 37.7792188274982 -122.427751880486 (37.7792188274982, -122.427751880486) 7 9 11 29490 41
4551 189261 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2215 Newcomb Ave 1 : Tree Private 2     1 Width 3ft   6011901.66973 2098145.68488 37.7417789652237 -122.401440561855 (37.7417789652237, -122.401440561855) 10 3 8 58 1
4634 61780 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2127 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/1985 12:00:00 AM 9   Permit Number 21802 6012087.28443 2102320.53166 37.7532525500908 -122.401092043975 (37.7532525500908, -122.401092043975) 10 3 8 28856 29
4685 163919 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 528 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2020 12:00:00 AM 3 4x4 Permit Number 785290 5993187.06549 2105302.66577 37.7603682343238 -122.466669061634 (37.7603682343238, -122.466669061634) 1 8 4 56 12
4693 255208 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 320 Bacon St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4923 31224 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1386 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/1995 12:00:00 AM 0   Permit Number 42098 5999592.83400965 2107841.48506455 37.76770679076 -122.444697050343 (37.76770679076, -122.444697050343) 15 5 11 29492 9
4986 51031 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1085 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2004 12:00:00 AM 6   Permit Number 47506 6011820.57141 2089923.66488 37.7191984823926 -122.401143367398 (37.7191984823926, -122.401143367398) 10 7 8 309 28
5105 153628 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3140 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 780837 6004230.96494 2119993.8857 37.8013378259475 -122.429521095049 (37.8013378259475, -122.429521095049) 13 9 1 57 17
5142 259872 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2666 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3     5996410.48132 2110785.34876 37.7756077608376 -122.455917191866 (37.7756077608376, -122.455917191866) 11 6 2 54 16
5257 62102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 440 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22195 6006762.92692973 2101210.352632 37.7499057910946 -122.419426042368 (37.7499057910946, -122.419426042368) 2 4 7 28859 19
5283 71380 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1415 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015545.815 2094978.0232 37.7332838660921 -122.388619133184 (37.7332838660921, -122.388619133184) 10 3 8 58 1
5373 224056 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4609 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787677 6000381.16624 2105168.69891 37.7604129369301 -122.441778467817 (37.7604129369301, -122.441778467817) 2 4 5 28862 3
5449 245103 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 250 Central Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999859.4717 2109392.5831 37.7719809274281 -122.443886241527 (37.7719809274281, -122.443886241527) 15 5 11 29492 9
5548 64543 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1547 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1988 12:00:00 AM     Permit Number 25426 6015321.62159268 2095235.25021997 37.7339777321734 -122.389412195042 (37.7339777321734, -122.389412195042) 10 3 8 58 1
5654 31560 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 178 Ewing Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   05/10/1995 12:00:00 AM     Permit Number 35104 5998523.78697564 2112531.01963796 37.7805219856792 -122.448732545056 (37.7805219856792, -122.448732545056) 15 6 2 54 16
5781 207615 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 134 Ralston St 1 : Tree Private 2     4 Width 3ft   5992209.13787 2088815.67824 37.7150426450832 -122.46885145275 (37.7150426450832, -122.46885145275) 9 8 6 64 24
5953 181063 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 280 Guttenberg St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 04:21:00 PM 3 Width 3ft   5999687.90058 2086653.14824 37.7095340664096 -122.44284654224 (37.7095340664096, -122.44284654224) 9 7 6 28861 5
5985 247277 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 404 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2015 12:00:00 AM 9 Width 0ft   5998904.2718 2109290.33 37.7716456345938 -122.447182976567 (37.7716456345938, -122.447182976567) 15 5 11 29492 9
6010 162250 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 40 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2020 12:00:00 AM 3 Width 0ft   6011508.76761 2091210.5075 37.7227144898747 -122.402311591215 (37.7227144898747, -122.402311591215) 10 3 7 309 28
6040 90220 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2500 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 3x3   5987751.08815 2111228.00123 37.7763223582458 -122.485904267418 (37.7763223582458, -122.485904267418) 11 6 2 55 26
6046 81390 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1588 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015103.68734 2101191.55999 37.750320442739 -122.390581737352 (37.750320442739, -122.390581737352) 10 3 8 28856 1
6250 261442 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 364 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
6256 25549 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 141 Industrial St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/1998 12:00:00 AM 3 2X3   6011617.33955 2097194.17651 37.739150457318 -122.402356800142 (37.739150457318, -122.402356800142) 10 3 8 58 1
6315 46517 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 182 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2003 12:00:00 AM     Permit Number 46010 6005209.24135079 2109497.7250609 37.7725733258296 -122.425388452589 (37.7725733258296, -122.425388452589) 7 9 11 28852 10
6326 117138 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
6331 261440 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 374x Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007239 2095686 37.7347639531109 -122.417388303298 (37.7347639531109, -122.417388303298) 2 7 7 28859 2
6422 260907 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 2125 Lake St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5988893.20555 2114661.62902 37.7858166251674 -122.482205030291 (37.7858166251674, -122.482205030291) 11 6 2 55 26
6423 161312 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 486 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 0ft   6002939.11369 2090932.78769 37.7214698362342 -122.431915186563 (37.7214698362342, -122.431915186563) 9 7 6 28861 5
6424 170682 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 400X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000690.30065 2092674.87518 37.7261254691045 -122.439813535471 (37.7261254691045, -122.439813535471) 9 7 6 28861 25
6449 71444 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1088 Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6012034.251 2119394.2595 37.8001301227773 -122.402475922527 (37.8001301227773, -122.402475922527) 3 1 10 28860 6
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
6857 83788 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 482 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5994387.70821 2112243.63782 37.779495530287 -122.463020234423 (37.779495530287, -122.463020234423) 11 6 2 54 11
7024 141437 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 535 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005239.6877 2110933.7323 37.7765179730819 -122.425385345316 (37.7765179730819, -122.425385345316) 7 9 11 28852 10
7031 126517 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3835 Scott St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6000579.5194 2121468.07283 37.8051781307269 -122.44226256568 (37.8051781307269, -122.44226256568) 13 9 1 57 17

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