trees
2,421 rows where qSpecies_id = 8 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
176409 | 100356 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
85115 | 100357 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 566 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.7754914959302 | -122.427243048056 | (37.7754914959302, -122.427243048056) | 7 | 9 | 11 | 28852 | 10 | ||
75430 | 100358 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | 11 | 6 | 2 | 54 | 26 | ||||
153976 | 100359 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | 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 | |||
56042 | 100781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 211 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007785.14748 | 2109092.4486 | 37.7716057300517 | -122.416449390639 | (37.7716057300517, -122.416449390639) | 8 | 2 | 9 | 28853 | 19 | |||
74309 | 101123 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990813.05778 | 2113422.53635 | 37.7825259029173 | -122.475472443708 | (37.7825259029173, -122.475472443708) | 11 | 6 | 2 | 54 | 26 | |||
60251 | 101124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990795.23328 | 2113422.41957 | 37.7825245490117 | -122.475534099586 | (37.7825245490117, -122.475534099586) | 11 | 6 | 2 | 54 | 26 | |||
119269 | 101126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990758.62584 | 2113423.68557 | 37.7825259029155 | -122.47566083662 | (37.7825259029155, -122.47566083662) | 11 | 6 | 2 | 54 | 26 | |||
112769 | 101127 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Clement St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990738.2441 | 2113419.67903 | 37.7825137204538 | -122.475731055208 | (37.7825137204538, -122.475731055208) | 11 | 6 | 2 | 54 | 26 | |||
31535 | 101129 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990852.81168 | 2113469.73907 | 37.7826578128527 | -122.475338361197 | (37.7826578128527, -122.475338361197) | 11 | 6 | 2 | 54 | 26 | |||
174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
7811 | 10192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005805.59526 | 2102140.15786 | 37.7524048554241 | -122.422802617046 | (37.7524048554241, -122.422802617046) | 2 | 4 | 5 | 28859 | 19 | ||
171916 | 10198 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | 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 | ||
119594 | 10207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6005836.97194 | 2101563.95801 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | 2 | 4 | 5 | 28859 | 19 | |||
54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
89001 | 102356 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
119510 | 102645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | 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 | ||
63011 | 102695 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000881 | 2096712 | 37.7372213335044 | -122.439443565515 | (37.7372213335044, -122.439443565515) | 2 | 7 | 5 | 63 | 7 | |||
56396 | 103366 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 769396 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | ||
42971 | 103367 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | |||
39029 | 103456 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003658 | 2091068 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | 9 | 7 | 6 | 28861 | 5 | ||||
152275 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 748 Treat Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 8 | 3x3 | 6008496.2 | 2104169 | 37.7581270399512 | -122.413641518528 | (37.7581270399512, -122.413641518528) | 2 | 4 | 7 | 28859 | 19 | |||
187500 | 103915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
159416 | 103923 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | 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 | ||
76174 | 104074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | 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 | ||
26950 | 104269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2867 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 7x7 | 5999338.58115 | 2117675.40642 | 37.7946936832082 | -122.446283969628 | (37.7946936832082, -122.446283969628) | 13 | 9 | 1 | 57 | 27 | |||
147358 | 104643 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769396 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | |||
156485 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 4355 ANZA ST | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | 11 | 6 | 2 | 55 | 26 | ||||
118346 | 105752 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6004519.3 | 2107402.1 | 37.7667802417179 | -122.427625698984 | (37.7667802417179, -122.427625698984) | 8 | 4 | 5 | 28862 | 3 | |||
10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
134922 | 106798 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009957 | 2113442 | 37.783670474647 | -122.409243780474 | (37.783670474647, -122.409243780474) | 14 | 10 | 9 | 28852 | 36 | ||||
78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
122980 | 107236 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3326 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2015 12:00:00 AM | Permit Number 775776 | 6006851 | 2102663.4 | 37.7539004875763 | -122.419224541208 | (37.7539004875763, -122.419224541208) | 2 | 4 | 7 | 28859 | 19 | |||
91912 | 107688 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 6008820.4 | 2095497.5 | 37.7343352217744 | -122.411907523711 | (37.7343352217744, -122.411907523711) | 10 | 7 | 7 | 28859 | 2 | ||||
37832 | 108155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 875 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | 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 | |
132969 | 108369 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 |
97924 | 108432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2676 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773725 | 6010053.51551 | 2103992.82932 | 37.7577306409511 | -122.408243201207 | (37.7577306409511, -122.408243201207) | 2 | 4 | 7 | 28859 | 19 |
122709 | 108553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
64302 | 108554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61-79X Santa Ysabel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.7274504222348 | -122.439236196788 | (37.7274504222348, -122.439236196788) | 9 | 7 | 6 | 28861 | 25 |
106009 | 108578 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
187764 | 108579 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
105051 | 108580 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | |
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
106652 | 108684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.7153792289568 | -122.440813996186 | (37.7153792289568, -122.440813996186) | 9 | 7 | 6 | 28861 | 5 | |
55160 | 108690 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005327.5 | 2105108.8 | 37.7605290659119 | -122.424667111807 | (37.7605290659119, -122.424667111807) | 2 | 4 | 5 | 28859 | 19 | ||||
116488 | 108888 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | |
72474 | 108891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.224 | 37.7307509423916 | -122.447388264722 | (37.7307509423916, -122.447388264722) | 9 | 7 | 4 | 59 | 40 | |
45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
170788 | 109075 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773945 | 5993143.3 | 2105315.7 | 37.7604014971278 | -122.466821372375 | (37.7604014971278, -122.466821372375) | 1 | 8 | 4 | 56 | 12 |
64267 | 109098 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 442 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774790 | 6003487.8 | 2102768.8 | 37.7539999097808 | -122.430862790198 | (37.7539999097808, -122.430862790198) | 2 | 4 | 5 | 28862 | 22 |
88033 | 109232 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 307 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773233 | 6004826.5 | 2101863.3 | 37.7515893763796 | -122.426168783014 | (37.7515893763796, -122.426168783014) | 2 | 4 | 5 | 28862 | 22 |
139248 | 109859 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775087 | 5992103.1 | 2104731.7 | 37.7587378977777 | -122.470376377669 | (37.7587378977777, -122.470376377669) | 1 | 8 | 4 | 56 | 12 |
9151 | 110107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4130 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430 | 2103553 | 37.7548786426579 | -122.507200765499 | (37.7548786426579, -122.507200765499) | 1 | 8 | 3 | 56 | 35 |
95257 | 110438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | 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 | |
122742 | 110457 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775373 | 5991635.3 | 2099042.5 | 37.7430897750827 | -122.471579655796 | (37.7430897750827, -122.471579655796) | 1 | 8 | 4 | 29491 | 40 | |||
145092 | 110714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994812 | 2091798 | 37.7233814241751 | -122.460070840792 | (37.7233814241751, -122.460070840792) | 9 | 8 | 4 | 28861 | 24 | ||||
188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
154897 | 111560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | 10 | 3 | 8 | 28856 | 29 | |||
16058 | 111561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.38867 | 37.7508975116216 | -122.402317008737 | (37.7508975116216, -122.402317008737) | 10 | 3 | 8 | 28856 | 29 | |
45437 | 111562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011716.74502 | 2101442.02185 | 37.7508196762016 | -122.402311688344 | (37.7508196762016, -122.402311688344) | 10 | 3 | 8 | 28856 | 29 | |||
99100 | 111742 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776572 | 5990114.7617 | 2111254.66631 | 37.7765330298264 | -122.477729702528 | (37.7765330298264, -122.477729702528) | 11 | 6 | 2 | 55 | 26 | |
108841 | 111743 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5990130.37359 | 2111254.12016 | 37.7765324362559 | -122.477675657167 | (37.7765324362559, -122.477675657167) | 11 | 6 | 2 | 55 | 26 | |||
38972 | 111744 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5990148.86908 | 2111256.53838 | 37.7765401493402 | -122.47761185344 | (37.7765401493402, -122.47761185344) | 11 | 6 | 2 | 55 | 26 | |||
94802 | 112066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 768 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5991979.16642 | 2110231.12718 | 37.77383069132 | -122.471205661727 | (37.77383069132, -122.471205661727) | 11 | 6 | 2 | 54 | 11 | |||
86029 | 112676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.407893097298 | (37.8017163995107, -122.407893097298) | 3 | 1 | 10 | 308 | 23 | |||
107804 | 112688 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720 | 2088919 | 37.71541351482 | -122.4636368036 | (37.71541351482, -122.4636368036) | 9 | 8 | 6 | 64 | 24 | ||
44731 | 112816 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | Permit Number 773547 | 5992490.3 | 2111549.9 | 37.7774812369392 | -122.46953360311 | (37.7774812369392, -122.46953360311) | 11 | 6 | 2 | 54 | 11 | |||
49306 | 112862 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5990594 | 2098423 | 37.7413284897401 | -122.475134938873 | (37.7413284897401, -122.475134938873) | 1 | 8 | 4 | 29491 | 40 | |||
9259 | 112872 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5999621 | 2110473 | 37.7749338721416 | -122.444788804756 | (37.7749338721416, -122.444788804756) | 15 | 5 | 11 | 29492 | 16 | |||
169314 | 113391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
136341 | 113703 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
88456 | 113809 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 06/15/2016 07:36:00 AM | 3 | 5x5 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
87336 | 113817 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
90434 | 113818 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
155183 | 113826 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1599x CASTRO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2016 07:10:00 AM | 3 | 3x3 | 6002577 | 2101074 | 37.7492947436898 | -122.433891418078 | (37.7492947436898, -122.433891418078) | 2 | 4 | 5 | 28862 | 22 | ||
166045 | 113827 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1599x CASTRO ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 02/16/2016 05:50:00 AM | 3 | 3x3 | 6002577 | 2101074 | 37.7492947436898 | -122.433891418078 | (37.7492947436898, -122.433891418078) | 2 | 4 | 5 | 28862 | 22 | |
188571 | 114248 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 2 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
91138 | 114442 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
64253 | 114443 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
41732 | 114444 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
99511 | 114445 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
148937 | 114446 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
149422 | 114447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6010564.67556 | 2098126.12029 | 37.7416505555295 | -122.406062091517 | (37.7416505555295, -122.406062091517) | 10 | 3 | 8 | 58 | 1 | |||
172911 | 114448 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
120511 | 114551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322 | -122.401957083855 | (37.759370822322, -122.401957083855) | 10 | 3 | 8 | 28856 | 29 | ||
112026 | 114562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 774856 | 6005427.79379 | 2117145.93262 | 37.7935857616223 | -122.425176769692 | (37.7935857616223, -122.425176769692) | 13 | 9 | 1 | 28858 | 27 | ||
165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | 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 | |||
134349 | 114648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6001582.412 | 2113946.0192 | 37.7845816411392 | -122.438252733323 | (37.7845816411392, -122.438252733323) | 15 | 6 | 11 | 29490 | 13 | |||
124455 | 114649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001565.303 | 2113942.4968 | 37.7845709964296 | -122.43831167213 | (37.7845709964296, -122.43831167213) | 15 | 6 | 11 | 29490 | 13 | |||
127391 | 114650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6001545.1748 | 2113940.4839 | 37.784564324662 | -122.438381164493 | (37.784564324662, -122.438381164493) | 15 | 6 | 11 | 29490 | 13 | |||
52716 | 114651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001524.5433 | 2113938.4711 | 37.7845576244995 | -122.438452398093 | (37.7845576244995, -122.438452398093) | 15 | 6 | 11 | 29490 | 13 | |||
113949 | 114653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001412.8316 | 2113920.3557 | 37.7845015292891 | -122.438837583296 | (37.7845015292891, -122.438837583296) | 15 | 6 | 11 | 29490 | 13 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );