home / trees

Street_Tree_List

Data source: data.sfgov.org

2,347 rows where qSpecies = 64

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
341 100356 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 566 Fell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/08/2012 12:00:00 AM 1   Permit Number 769115 6004695.2 2110571.1 37.775491495930204 -122.427243048056 (37.7754914959302, -122.427243048056) 7 9 11 28852 10
342 100357 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 566 Fell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/08/2012 12:00:00 AM 1   Permit Number 769115 6004695.2 2110571.1 37.775491495930204 -122.427243048056 (37.7754914959302, -122.427243048056) 7 9 11 28852 10
343 100358 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 295X 16th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5990859.3 2113441.8 37.782581476001 -122.475313874173 (37.782581476001, -122.475313874173) 11 6 2 54 26
344 100359 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 295X 16th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/08/2012 12:00:00 AM   3x3   5990859.3 2113441.8 37.782581476001 -122.475313874173 (37.782581476001, -122.475313874173) 11 6 2 54 26
699 100781 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 211 12th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6007785.147480001 2109092.4486 37.771605730051704 -122.416449390639 (37.7716057300517, -122.416449390639) 8 2 9 28853 19
967 101123 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1500 Clement St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5990813.05778 2113422.53635 37.78252590291729 -122.475472443708 (37.7825259029173, -122.475472443708) 11 6 2 54 26
968 101124 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1500 Clement St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5990795.23328 2113422.41957 37.782524549011704 -122.47553409958599 (37.7825245490117, -122.475534099586) 11 6 2 54 26
970 101126 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1500 Clement St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5990758.62584 2113423.68557 37.7825259029155 -122.47566083662 (37.7825259029155, -122.47566083662) 11 6 2 54 26
971 101127 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1500 Clement St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5990738.2441 2113419.6790299998 37.7825137204538 -122.475731055208 (37.7825137204538, -122.475731055208) 11 6 2 54 26
973 101129 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 295X 16th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5990852.81168 2113469.73907 37.782657812852705 -122.47533836119699 (37.7826578128527, -122.475338361197) 11 6 2 54 26
1090 101247 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 725 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 9951 5993550.0 2106615.0 37.7639924992069 -122.465509188009 (37.7639924992069, -122.465509188009) 1 8 11 56 12
1654 10192 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1169 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/16/2016 04:46:00 AM 3 3X3   6005808.6696938 2102164.8077902 37.7524727119111 -122.42279373679199 (37.7524727119111, -122.422793736792) 2 4 5 28859 19
1699 10198 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1209 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/25/1991 12:00:00 AM 3 2X2   6005820.58037 2101870.80495 37.7516661199201 -122.422731656039 (37.7516661199201, -122.422731656039) 2 4 5 28859 19
1790 10207 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1273 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 2X2   6005836.971940001 2101563.9580099997 37.7508245136462 -122.422653168634 (37.7508245136462, -122.422653168634) 2 4 5 28859 19
2064 102355 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 176X Wisconsin St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6012524.1 2106651.0 37.765167421152206 -122.399885503722 (37.7651674211522, -122.399885503722) 14 3 8 28856 20
2065 102356 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 176X Wisconsin St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6012524.1 2106651.0 37.765167421152206 -122.399885503722 (37.7651674211522, -122.399885503722) 14 3 8 28856 20
2339 102645 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1800 Oakdale Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/16/2015 12:33:00 PM 3 3x3   6013980.4 2096382.2 37.7370525675082 -122.394129514082 (37.7370525675082, -122.394129514082) 10 3 8 58 1
2390 102695 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 384 Sussex St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6000881.0 2096712.0 37.7372213335044 -122.439443565515 (37.7372213335044, -122.439443565515) 2 7 5 63 7
3005 103366 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 290X Bartlett St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3 Permit Number 769396 6006718.6 2102097.0 37.7523378256517 -122.41964222832199 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
3006 103367 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 290X Bartlett St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6006718.6 2102097.0 37.7523378256517 -122.41964222832199 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
3092 103456 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 410 Vienna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   6003658.0 2091068.0 37.721881827041 -122.429439831937 (37.721881827041, -122.429439831937) 9 7 6 28861 5
3334 103719 Significant Tree 4 Eriobotrya deflexa :: Bronze Loquat 64 748 Treat Ave 1 Front Yard : Cutout 10 Tree 1 Private 2     8 3x3   6008496.2 2104169.0 37.758127039951205 -122.41364151852801 (37.7581270399512, -122.413641518528) 2 4 7 28859 19
3539 103915 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1300X Fitzgerald Ave 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728) 10 3 8 58 1
3541 103917 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1300X Fitzgerald Ave 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728) 10 3 8 58 1
3543 103919 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1300X Fitzgerald Ave 6 Sidewalk: Property side : Yard 5 Tree 1 Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728) 10 3 8 58 1
3546 103921 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1300X Fitzgerald Ave 8 Sidewalk: Property side : Yard 5 Tree 1 Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728) 10 3 8 58 1
3548 103923 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1300X Fitzgerald Ave 10 Sidewalk: Property side : Yard 5 Tree 1 Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6014139.7 2090933.3 37.722099845446294 -122.39319756972799 (37.7220998454463, -122.393197569728) 10 3 8 58 1
3560 103937 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2300 Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/24/2013 12:00:00 AM 26   Permit Number 770288 6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
3650 104074 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 841 32nd Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2   08/06/2013 12:00:00 AM 2   Permit Number 770392 5986000.25731 2110187.13166 37.7733622428275 -122.491884144737 (37.7733622428275, -122.491884144737) 11 6 2 55 26
3793 104269 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2867 Green St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 7x7   5999338.58115 2117675.40642 37.7946936832082 -122.44628396962798 (37.7946936832082, -122.446283969628) 13 9 1 57 27
4131 104643 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 290X Bartlett St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769396 6006718.6 2102097.0 37.7523378256517 -122.41964222832199 (37.7523378256517, -122.419642228322) 2 4 7 28859 19
4785 105434 Significant Tree 4 Eriobotrya deflexa :: Bronze Loquat 64 4355 ANZA ST 1 Back Yard : Yard 6 Tree 1 Private 2     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501) 11 6 2 55 26
5081 105752 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 67 LANDERS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 4x4   6004519.3 2107402.1 37.766780241717896 -122.42762569898399 (37.7667802417179, -122.427625698984) 8 4 5 28862 3
5547 106353 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 3520X 26TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6006283.0 2100840.0 37.748861844431204 -122.42105936248699 (37.7488618444312, -122.421059362487) 2 4 5 28859 19
5895 106798 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 39 Mason St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009957.0 2113442.0 37.783670474647 -122.409243780474 (37.783670474647, -122.409243780474) 14 10 9 28852 36
5968 106892 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 629 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/2014 12:00:00 AM 1   Permit Number 773229 6014439.75654 2104200.5982 37.758545762695896 -122.393088190163 (37.7585457626959, -122.393088190163) 10 3 8 28856 29
6248 107236 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 3326 23RD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/13/2015 12:00:00 AM     Permit Number 775776 6006851.0 2102663.4 37.753900487576296 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
6631 107688 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 300X ALEMANY BLVD 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     16     6008820.4 2095497.5 37.734335221774394 -122.411907523711 (37.7343352217744, -122.411907523711) 10 7 7 28859 2
7049 108155 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 875 36th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/06/2015 12:00:00 AM 3 3x3 Permit Number 773852 5984778.38849 2109898.30957 37.772497726788 -122.496089384061 (37.772497726788, -122.496089384061) 11 6 2 55 26
7249 108369 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 611 Paris St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2014 12:00:00 AM 3 3x3 Permit Number 773814 6001475.26516 2090061.55368 37.7189945287407 -122.436912960177 (37.7189945287407, -122.436912960177) 9 7 6 28861 5
7309 108432 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 2676 21st St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773725 6010053.51551 2103992.82932 37.7577306409511 -122.40824320120701 (37.7577306409511, -122.408243201207) 2 4 7 28859 19
7435 108553 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 61-79X Santa Ysabel Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773713 6000867.23405 2093153.75099 37.727450422234796 -122.439236196788 (37.7274504222348, -122.439236196788) 9 7 6 28861 25
7436 108554 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 61-79X Santa Ysabel Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773713 6000867.23405 2093153.75099 37.727450422234796 -122.439236196788 (37.7274504222348, -122.439236196788) 9 7 6 28861 25
7460 108578 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1655X Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6008581.0 2118626.0 37.7978272872591 -122.414371155882 (37.7978272872591, -122.414371155882) 5 1 10 308 21
7461 108579 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1655X Noe St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6008581.0 2118626.0 37.7978272872591 -122.414371155882 (37.7978272872591, -122.414371155882) 5 1 10 308 21
7463 108580 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1655X Noe St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x5   6008581.0 2118626.0 37.7978272872591 -122.414371155882 (37.7978272872591, -122.414371155882) 5 1 10 308 21
7497 108612 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 3628 16th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3   Permit Number 774590 6002731.19846 2106518.35077 37.764252377203 -122.433747267607 (37.764252377203, -122.433747267607) 15 5 5 28862 3
7500 108615 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 136 Precita Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774598 6007320.4947 2100127.53408 37.746964004181706 -122.417421212351 (37.7469640041817, -122.417421212351) 2 7 7 28859 2
7570 108684 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 46 Rolph St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2014 12:00:00 AM 3   Permit Number 774614 6000319.87619 2088768.81693 37.71537922895679 -122.44081399618601 (37.7153792289568, -122.440813996186) 9 7 6 28861 5
7577 108690 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 61 OAKWOOD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6005327.5 2105108.8 37.760529065911896 -122.424667111807 (37.7605290659119, -122.424667111807) 2 4 5 28859 19
7788 108888 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 658 Monterey Blvd   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 772760 5997727.10617 2094743.09717 37.7316352013333 -122.450206090909 (37.7316352013333, -122.450206090909) 9 7 4 59 40
7792 108891 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 434 Hearst Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773352 5998535.11764 2094404.2240000002 37.7307509423916 -122.44738826472201 (37.7307509423916, -122.447388264722) 9 7 4 59 40
7836 108934 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 361 Elsie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 Fire Dept 11 01/12/2015 12:00:00 AM 3 3x3 Permit Number 774685 6006490.6 2097118.7 37.7386556931549 -122.42007742591001 (37.7386556931549, -122.42007742591) 2 7 7 28859 2
7975 109075 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 542 Kirkham St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/23/2015 12:00:00 AM 3 3x3 Permit Number 773945 5993143.3 2105315.7 37.760401497127795 -122.466821372375 (37.7604014971278, -122.466821372375) 1 8 4 56 12
7996 109098 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 442 Alvarado St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774790 6003487.8 2102768.8 37.753999909780795 -122.430862790198 (37.7539999097808, -122.430862790198) 2 4 5 28862 22
8139 109232 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 307 Chattanooga St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/04/2015 12:00:00 AM 3 3x3 Permit Number 773233 6004826.5 2101863.3 37.7515893763796 -122.42616878301399 (37.7515893763796, -122.426168783014) 2 4 5 28862 22
8656 109859 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 1575 Funston Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/05/2015 12:00:00 AM 3 3x3 Permit Number 775087 5992103.1 2104731.7 37.758737897777706 -122.47037637766898 (37.7587378977777, -122.470376377669) 1 8 4 56 12
9055 110438 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 224 12th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/14/2015 12:00:00 AM 3 3x3 Permit Number 775407 6007788.2 2109003.3 37.7713611206973 -122.416432516069 (37.7713611206973, -122.416432516069) 8 2 9 28853 19
9072 110457 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 501 TARAVAL ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 775373 5991635.3 2099042.5 37.7430897750827 -122.47157965579599 (37.7430897750827, -122.471579655796) 1 8 4 29491 40
9317 110714 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 484 FAXON AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994812.0 2091798.0 37.7233814241751 -122.46007084079201 (37.7233814241751, -122.460070840792) 9 8 4 28861 24
9620 111022 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 1254 07TH AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993942.0 2106950.0 37.7649349225469 -122.464177708405 (37.7649349225469, -122.464177708405) 11 5 11 56 12
9789 111193 Section 143 6 Eriobotrya deflexa :: Bronze Loquat 64 890x JARBOE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/30/2015 12:00:00 AM 1 3x3 Permit Number 774267 6009115.0 2096842.0 37.738043451743295 -122.41098392432899 (37.7380434517433, -122.410983924329) 10 7 7 28859 2
9790 111194 Section 143 6 Eriobotrya deflexa :: Bronze Loquat 64 890x JARBOE AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/30/2015 12:00:00 AM   3x3 Permit Number 774267 6009115.0 2096842.0 37.738043451743295 -122.41098392432899 (37.7380434517433, -122.410983924329) 10 7 7 28859 2
10123 111560 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1498x Kansas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6011715.03072 2101496.45297 37.7509690365089 -122.402321443274 (37.7509690365089, -122.402321443274) 10 3 8 28856 29
10124 111561 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1498x Kansas St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737) 10 3 8 28856 29
10125 111562 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1498x Kansas St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6011716.745019999 2101442.02185 37.7508196762016 -122.402311688344 (37.7508196762016, -122.402311688344) 10 3 8 28856 29
10260 111742 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1751 Balboa St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/28/2016 12:00:00 AM 3 3x3 Permit Number 776572 5990114.7617 2111254.66631 37.776533029826396 -122.477729702528 (37.7765330298264, -122.477729702528) 11 6 2 55 26
10261 111743 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1751 Balboa St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5990130.37359 2111254.12016 37.7765324362559 -122.477675657167 (37.7765324362559, -122.477675657167) 11 6 2 55 26
10262 111744 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1751 Balboa St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5990148.869080001 2111256.53838 37.77654014934021 -122.47761185344 (37.7765401493402, -122.47761185344) 11 6 2 55 26
10526 112066 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 768 Funston Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   5991979.16642 2110231.12718 37.77383069132 -122.47120566172701 (37.77383069132, -122.471205661727) 11 6 2 54 11
11111 112676 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1601 Grant Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     21 3x3   6010481.2 2120003.6 37.8017163995107 -122.40789309729799 (37.8017163995107, -122.407893097298) 3 1 10 308 23
11124 112688 Section 143 6 Eriobotrya deflexa :: Bronze Loquat 64 259 BRIGHT ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/18/2015 12:00:00 AM 3 5x4   5993720.0 2088919.0 37.71541351482001 -122.46363680360001 (37.71541351482, -122.4636368036) 9 8 6 64 24
11249 112816 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 575 11th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/20/2015 12:00:00 AM     Permit Number 773547 5992490.3 2111549.9 37.7774812369392 -122.46953360311001 (37.7774812369392, -122.46953360311) 11 6 2 54 11
11295 112862 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 1732 ULLOA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   5990594.0 2098423.0 37.7413284897401 -122.47513493887301 (37.7413284897401, -122.475134938873) 1 8 4 29491 40
11306 112872 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 599x CENTRAL AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   5999621.0 2110473.0 37.7749338721416 -122.44478880475599 (37.7749338721416, -122.444788804756) 15 5 11 29492 16
11759 113391 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 2151 15TH AVE 1 Front Yard : Yard 4 Tree 1 Private 2 FUF 2 12/10/2015 12:00:00 AM 1   Permit Number 776062 5991602.0 2100781.0 37.7478613219593 -122.47182147099899 (37.7478613219593, -122.471821470999) 1 8 4 29491 40
12056 113703 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 14 LUNDYS LN 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6007138.0 2099599.0 37.7455024988094 -122.418014802057 (37.7455024988094, -122.418014802057) 2 7 7 28859 2
12162 113809 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 4101x 25TH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5 SFUSD 8 06/15/2016 07:36:00 AM 3 5x5   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
12168 113814 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 4101x 25TH ST 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5 SFUSD 8 02/16/2016 06:05:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
12171 113817 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 4101x 25TH ST 10 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5 SFUSD 8 02/16/2016 06:00:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
12172 113818 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 4101x 25TH ST 11 Sidewalk: Curb side : Cutout 2 Tree 1 DPW for City Agency 5 SFUSD 8 02/16/2016 05:57:00 AM 3 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
12181 113826 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 1599x CASTRO ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/16/2016 07:10:00 AM 3 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
12182 113827 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 02/16/2016 05:50:00 AM 3 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
12554 114248 Permitted Site 2 Eriobotrya deflexa :: Bronze Loquat 64 2151 15TH AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 09/30/2015 12:00:00 AM 2   Permit Number 776062 5991602.0 2100781.0 37.7478613219593 -122.47182147099899 (37.7478613219593, -122.471821470999) 1 8 4 29491 40
12708 114442 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 140 LOOMIS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010781.0 2097775.0 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
12709 114443 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 140 LOOMIS ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010781.0 2097775.0 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
12710 114444 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 140 LOOMIS ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010781.0 2097775.0 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
12711 114445 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 140 LOOMIS ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010781.0 2097775.0 37.7406985517125 -122.405289390042 (37.7406985517125, -122.405289390042) 10 3 8 58 1
12712 114446 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 367 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010572.0 2098095.0 37.7415655155901 -122.406034574078 (37.7415655155901, -122.406034574078) 10 3 8 58 1
12713 114447 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 367 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 4x4   6010564.675559999 2098126.12029 37.741650555529496 -122.40606209151699 (37.7416505555295, -122.406062091517) 10 3 8 58 1
12714 114448 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 367 BAY SHORE BLVD 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       4x4   6010572.0 2098095.0 37.7415655155901 -122.406034574078 (37.7415655155901, -122.406034574078) 10 3 8 58 1
12811 114551 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 815 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/24/2015 12:00:00 AM 2   Permit Number 777069 6011882.52063 2104552.93824 37.759370822322005 -122.401957083855 (37.759370822322, -122.401957083855) 10 3 8 28856 29
12822 114562 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 1815 Jackson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/24/2015 12:00:00 AM 2   Permit Number 774856 6005427.7937900005 2117145.93262 37.793585761622296 -122.425176769692 (37.7935857616223, -122.425176769692) 13 9 1 28858 27
12904 114647 Private 7 Eriobotrya deflexa :: Bronze Loquat 64 331 Prentiss St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/30/2015 12:00:00 AM     Permit Number 774946 6008851.6 2097283.6 37.7392412152063 -122.41192582952 (37.7392412152063, -122.41192582952) 10 7 7 28859 2
12905 114648 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6001582.4120000005 2113946.0192 37.784581641139205 -122.438252733323 (37.7845816411392, -122.438252733323) 15 6 11 29490 13
12906 114649 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6001565.302999999 2113942.4968 37.7845709964296 -122.43831167213001 (37.7845709964296, -122.43831167213) 15 6 11 29490 13
12908 114650 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6001545.1748 2113940.4839 37.784564324662 -122.43838116449301 (37.784564324662, -122.438381164493) 15 6 11 29490 13
12909 114651 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6001524.5433 2113938.4711 37.7845576244995 -122.43845239809299 (37.7845576244995, -122.438452398093) 15 6 11 29490 13
12911 114653 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6001412.8316 2113920.3557 37.7845015292891 -122.43883758329599 (37.7845015292891, -122.438837583296) 15 6 11 29490 13
12913 114655 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 64 2200 Post St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6001302.3779 2113905.5111 37.7844544851842 -122.43921865019199 (37.7844544851842, -122.439218650192) 15 6 11 29490 13

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 79.88ms · Data source: data.sfgov.org