trees
256 rows where qSpecies_id = 151 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175004 | 231962 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007543.01124 | 2097062.2707 | 37.7385599903583 | -122.416434682233 | (37.7385599903583, -122.416434682233) | 2 | 7 | 7 | 28859 | 2 | |||
177128 | 231952 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006488.33791 | 2105047.80636 | 37.7604270841668 | -122.420647967328 | (37.7604270841668, -122.420647967328) | 2 | 4 | 7 | 28859 | 19 | |||
178828 | 131186 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001413.74236 | 2116589.85963 | 37.7918313506904 | -122.439025814797 | (37.7918313506904, -122.439025814797) | 13 | 6 | 1 | 29490 | 27 | |||
178945 | 231951 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 171 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006481.13342 | 2105135.05865 | 37.7606662525548 | -122.42067907849 | (37.7606662525548, -122.42067907849) | 2 | 4 | 7 | 28859 | 19 | |||
179331 | 49825 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012763.71929 | 2105674.81061 | 37.7625003776121 | -122.398988190679 | (37.7625003776121, -122.398988190679) | 14 | 3 | 8 | 28856 | 29 | ||
181556 | 231957 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 643 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001733.38367 | 2099398.81913 | 37.7446471838211 | -122.436688759187 | (37.7446471838211, -122.436688759187) | 2 | 7 | 5 | 63 | 22 | |||
184631 | 47495 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 222 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45388 | 6001706.9707 | 2093841.21109 | 37.7293857804089 | -122.436382409642 | (37.7293857804089, -122.436382409642) | 9 | 7 | 6 | 28861 | 25 | |
185697 | 69014 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2190 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33018 | 5982359.98589934 | 2100209.73898476 | 37.7457537141944 | -122.503737083774 | (37.7457537141944, -122.503737083774) | 1 | 8 | 3 | 29491 | 35 | |
188020 | 87046 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735@ 8th Ave 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53657 | 5993787.03862 | 2110396.38433 | 37.7743888494182 | -122.464963993756 | (37.7743888494182, -122.464963993756) | 11 | 6 | 2 | 54 | 11 | |
188557 | 231955 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004248.08815 | 2095120.37618 | 37.7330421432752 | -122.42768862922 | (37.7330421432752, -122.42768862922) | 9 | 7 | 5 | 28861 | 25 | |||
192102 | 37860 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 147 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | 13 | 6x8 | Permit Number 40147 | 6003940.89934 | 2092950.10622 | 37.7270656869264 | -122.428596014613 | (37.7270656869264, -122.428596014613) | 9 | 7 | 6 | 28861 | 5 |
192447 | 231949 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007831.76681 | 2105714.97927 | 37.7623346100862 | -122.416048903649 | (37.7623346100862, -122.416048903649) | 8 | 4 | 7 | 28859 | 19 | |||
193722 | 77213 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
15126 | 121049 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
22799 | 101714 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1240 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006918 | 2119116 | 37.7990791449181 | -122.420160405591 | (37.7990791449181, -122.420160405591) | 5 | 1 | 1 | 28858 | 32 | |||||
24703 | 121054 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
37383 | 121052 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
74510 | 121050 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
100503 | 121051 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
113343 | 113820 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4101x 25TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
125727 | 105520 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3851X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994314 | 2113544 | 37.7830617285902 | -122.463369610154 | (37.7830617285902, -122.463369610154) | 11 | 6 | 2 | 54 | 11 | ||||
137787 | 104161 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 ALPINE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770750 | 6001664 | 2107990 | 37.7682325491861 | -122.437543793089 | (37.7682325491861, -122.437543793089) | 15 | 5 | 5 | 29492 | 3 | |
160327 | 121053 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2650 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006281 | 2119745 | 37.8007703072153 | -122.422409360755 | (37.8007703072153, -122.422409360755) | 13 | 9 | 1 | 28858 | 32 | ||||
9879 | 63777 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24458 | 6004354.0616299 | 2101637.06942721 | 37.7509414857928 | -122.427786417218 | (37.7509414857928, -122.427786417218) | 2 | 4 | 5 | 28862 | 22 | ||
14127 | 45367 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44192 | 6007805.03016333 | 2096352.99475391 | 37.7366272057089 | -122.415478542826 | (37.7366272057089, -122.415478542826) | 2 | 7 | 7 | 28859 | 2 | ||
14190 | 67936 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 78 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31649 | ||||||||||||
16439 | 67516 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 327 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31052 | 5997915.17390153 | 2093778.82856929 | 37.7289983088646 | -122.449486452558 | (37.7289983088646, -122.449486452558) | 9 | 7 | 4 | 28861 | 40 | ||
18761 | 56456 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30464 | 5999359.80887308 | 2107414.28954328 | 37.7665205189943 | -122.445472331181 | (37.7665205189943, -122.445472331181) | 15 | 5 | 5 | 29492 | 9 | ||
21835 | 65598 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 966 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28500 | 6001950.73496364 | 2088338.48153862 | 37.7142903680478 | -122.435146273727 | (37.7142903680478, -122.435146273727) | 9 | 7 | 6 | 28861 | 5 | ||
23011 | 50535 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/2003 12:00:00 AM | Permit Number 47174 | 6003192.2245553 | 2109948.41523105 | 37.7736966455287 | -122.432397711934 | (37.7736966455287, -122.432397711934) | 15 | 9 | 11 | 29492 | 10 | ||
23228 | 50536 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47174 | 6003192.2245553 | 2109948.41523105 | 37.7736966455287 | -122.432397711934 | (37.7736966455287, -122.432397711934) | 15 | 9 | 11 | 29492 | 10 | |||
25626 | 68823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 306 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32772 | 5999450.43970514 | 2094100.18276953 | 37.729968379033 | -122.444202023687 | (37.729968379033, -122.444202023687) | 9 | 7 | 4 | 63 | 40 | ||
25935 | 66407 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29534 | 6008039.98859373 | 2096389.06187115 | 37.7367394418447 | -122.414668739511 | (37.7367394418447, -122.414668739511) | 2 | 7 | 7 | 28859 | 2 | ||
29959 | 45335 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1239 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2001 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | 14 | 3 | 8 | 28856 | 29 | ||
30115 | 46922 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | |||
30587 | 47753 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 70 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | Permit Number 45532 | 6000951.94406001 | 2101308.28424915 | 37.7498456794841 | -122.439527672975 | (37.7498456794841, -122.439527672975) | 2 | 4 | 5 | 28862 | 22 | ||
32738 | 66930 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30252 | 6007535.74955777 | 2097703.77171349 | 37.7403210020284 | -122.41650521811 | (37.7403210020284, -122.41650521811) | 2 | 7 | 7 | 28859 | 2 | ||
32767 | 68798 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2448 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32737 | 5992373.31469622 | 2098785.22580126 | 37.7424260349459 | -122.469009103079 | (37.7424260349459, -122.469009103079) | 1 | 8 | 4 | 29491 | 40 | ||
34596 | 66400 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 531 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29526 | 6007491.7583768 | 2096409.40123315 | 37.7367644721833 | -122.416565655603 | (37.7367644721833, -122.416565655603) | 2 | 7 | 7 | 28859 | 2 | ||
34670 | 66326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 135 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29445 | 6000528.81306712 | 2095194.53475792 | 37.7330346787859 | -122.440552427184 | (37.7330346787859, -122.440552427184) | 9 | 7 | 5 | 63 | 40 | ||
35390 | 60180 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 39 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19713 | 6005845.55661292 | 2105868.08575362 | 37.7626431308333 | -122.422929354207 | (37.7626431308333, -122.422929354207) | 8 | 4 | 5 | 28859 | 19 | ||
41931 | 64823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 324 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25832 | 6002281.26415206 | 2109593.58721525 | 37.7726706787738 | -122.435523472346 | (37.7726706787738, -122.435523472346) | 15 | 5 | 11 | 29492 | 9 | ||
42223 | 37689 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 43282 | 6007841.95638313 | 2105703.00432184 | 37.7623023025462 | -122.416012813552 | (37.7623023025462, -122.416012813552) | 8 | 4 | 7 | 28859 | 19 | ||
42735 | 63835 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 480 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24525 | 6007455.04270761 | 2096578.56376841 | 37.737226890345 | -122.416704578376 | (37.737226890345, -122.416704578376) | 2 | 7 | 7 | 28859 | 2 | ||
43235 | 57575 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 16442 | 5991446.93129096 | 2089419.02625002 | 37.7166552263353 | -122.471529877911 | (37.7166552263353, -122.471529877911) | 9 | 8 | 6 | 64 | 24 | ||
43366 | 60181 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 45 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19714 | 6005847.32276765 | 2105836.20953391 | 37.7625557059029 | -122.422920980075 | (37.7625557059029, -122.422920980075) | 8 | 4 | 5 | 28859 | 19 | ||
43590 | 66306 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 311 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29421 | 6000730.96676364 | 2094981.50970271 | 37.7324612706981 | -122.439838262312 | (37.7324612706981, -122.439838262312) | 9 | 7 | 5 | 63 | 40 | ||
43632 | 48013 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1991 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45735 | 5991253.49588687 | 2101875.72214117 | 37.7508469733877 | -122.473106392758 | (37.7508469733877, -122.473106392758) | 1 | 8 | 4 | 29491 | 12 | ||
44026 | 45318 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 651 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44155 | 5993484.7456852 | 2090166.18126819 | 37.718824416648 | -122.464540445707 | (37.718824416648, -122.464540445707) | 9 | 8 | 6 | 64 | 24 | ||
45942 | 67106 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1422 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30521 | 5994302.05947846 | 2105826.4023092 | 37.7618705618217 | -122.462850841683 | (37.7618705618217, -122.462850841683) | 1 | 5 | 11 | 56 | 12 | ||
47147 | 68648 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1935 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32553 | 5990620.64023794 | 2102219.83857431 | 37.7517551651121 | -122.475319963854 | (37.7517551651121, -122.475319963854) | 1 | 8 | 4 | 29491 | 12 | ||
47559 | 68789 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2338 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32726 | 5992037.40889194 | 2099520.42913846 | 37.7444253016329 | -122.470224079807 | (37.7444253016329, -122.470224079807) | 1 | 8 | 4 | 29491 | 40 | ||
51034 | 64836 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 420 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1989 12:00:00 AM | Permit Number 25845 | 6003164.08916748 | 2099517.74214557 | 37.745054922078 | -122.431750153289 | (37.745054922078, -122.431750153289) | 2 | 7 | 5 | 63 | 22 | ||
51461 | 83403 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50775 | 6000910.29193694 | 2092966.50207531 | 37.7269387297254 | -122.439073931559 | (37.7269387297254, -122.439073931559) | 9 | 7 | 6 | 28861 | 25 | ||
51644 | 64810 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 718 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25813 | 6001878.33374757 | 2099742.03375236 | 37.7455978068181 | -122.436212108036 | (37.7455978068181, -122.436212108036) | 2 | 7 | 5 | 63 | 22 | ||
52065 | 60182 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 64 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19715 | 6005801.28958409 | 2105727.07873438 | 37.7622534608678 | -122.423072435179 | (37.7622534608678, -122.423072435179) | 8 | 4 | 5 | 28859 | 19 | ||
53276 | 37921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2002 12:00:00 AM | Permit Number 44597 | 6013051.43972244 | 2106572.53658415 | 37.7649813631667 | -122.398056045773 | (37.7649813631667, -122.398056045773) | 14 | 3 | 8 | 28856 | 29 | ||
53579 | 66397 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 508 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29523 | 6007446.33784222 | 2096483.57459282 | 37.7369655813708 | -122.416727947771 | (37.7369655813708, -122.416727947771) | 2 | 7 | 7 | 28859 | 2 | ||
60513 | 66307 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 312 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29422 | 6000783.0417172 | 2094985.88569991 | 37.7324762502781 | -122.439658540918 | (37.7324762502781, -122.439658540918) | 9 | 7 | 5 | 63 | 40 | ||
63053 | 63989 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 445 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24735 | 6002297.0656458 | 2100886.57142057 | 37.7487642194423 | -122.434846033464 | (37.7487642194423, -122.434846033464) | 2 | 4 | 5 | 28862 | 22 | ||
64919 | 65535 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3811 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1996 12:00:00 AM | Permit Number 28426 | 6004188.15426377 | 2105377.14964975 | 37.7612014771427 | -122.428626716937 | (37.7612014771427, -122.428626716937) | 2 | 4 | 5 | 28862 | 3 | ||
66509 | 67173 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 308 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30617 | 6006778.80431339 | 2096277.81486238 | 37.7363630429498 | -122.419021324056 | (37.7363630429498, -122.419021324056) | 2 | 7 | 7 | 28859 | 2 | ||
67134 | 69042 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1315 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33049 | 5983966.84504954 | 2106204.15933041 | 37.7623070738116 | -122.498623613567 | (37.7623070738116, -122.498623613567) | 1 | 8 | 3 | 56 | 35 | ||
67640 | 66893 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30211 | 6007590.04442076 | 2097728.05974103 | 37.7403907448612 | -122.416319207408 | (37.7403907448612, -122.416319207408) | 2 | 7 | 7 | 28859 | 2 | ||
68621 | 64828 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 268 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1989 12:00:00 AM | Permit Number 25837 | 6004831.1974382 | 2099031.73640655 | 37.7438148210139 | -122.425950995798 | (37.7438148210139, -122.425950995798) | 2 | 7 | 5 | 63 | 22 | ||
70776 | 49472 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3330@ VALENCIA 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/2003 12:00:00 AM | Permit Number 46397 | 6006124.66921915 | 2103195.53921104 | 37.7553206868527 | -122.421774162179 | (37.7553206868527, -122.421774162179) | 2 | 4 | 5 | 28859 | 19 | ||
71484 | 66923 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 196 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30244 | 6007541.39171999 | 2097769.00500385 | 37.740500435503 | -122.416490329324 | (37.740500435503, -122.416490329324) | 2 | 7 | 7 | 28859 | 2 | ||
73861 | 64877 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2578 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/1989 12:00:00 AM | Permit Number 25899 | 5989272.97531246 | 2097804.00173263 | 37.7395522287807 | -122.479657246034 | (37.7395522287807, -122.479657246034) | 1 | 8 | 3 | 29491 | 35 | ||
77589 | 63838 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 310 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24529 | 6007512.21907746 | 2097215.58579661 | 37.7389792281053 | -122.416552004438 | (37.7389792281053, -122.416552004438) | 2 | 7 | 7 | 28859 | 2 | ||
78371 | 33939 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 378 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 37898 | 6003089.72357803 | 2091687.1316724 | 37.72354963405 | -122.431448393386 | (37.72354963405, -122.431448393386) | 9 | 7 | 6 | 28861 | 5 | ||
79837 | 65256 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1059 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28055 | 6009469.52961682 | 2103013.30669194 | 37.7550083744364 | -122.410193718367 | (37.7550083744364, -122.410193718367) | 2 | 4 | 7 | 28859 | 19 | ||
80939 | 30723 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 450 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34623 | 6004402.09076898 | 2109822.75168299 | 37.7734201339954 | -122.428203638325 | (37.7734201339954, -122.428203638325) | 7 | 9 | 11 | 28852 | 10 | ||
82559 | 45319 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 671 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44156 | 5993486.1732944 | 2090289.68128716 | 37.7191636002321 | -122.464544473629 | (37.7191636002321, -122.464544473629) | 9 | 8 | 6 | 64 | 24 | ||
82588 | 66076 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1830 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | Permit Number 29120 | 6008716.78878742 | 2119192.91553026 | 37.7993915237126 | -122.413941412032 | (37.7993915237126, -122.413941412032) | 3 | 1 | 10 | 308 | 32 | ||
83465 | 68848 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32811 | 5999239.62014085 | 2094052.0632873 | 37.7298242245316 | -122.444927391996 | (37.7298242245316, -122.444927391996) | 9 | 7 | 4 | 28861 | 40 | ||
84836 | 66660 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1500 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 3x3 | Permit Number 31265 | 6016229.06481316 | 2097072.60827917 | 37.7390730165912 | -122.386402918839 | (37.7390730165912, -122.386402918839) | 10 | 3 | 8 | 58 | 1 | |
85201 | 68664 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 211 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32571 | 5993343.03467885 | 2114079.66644038 | 37.7844765349697 | -122.46676767712 | (37.7844765349697, -122.46676767712) | 11 | 6 | 2 | 54 | 11 | ||
87351 | 67921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31632 | 6004231.25027354 | 2095231.88967626 | 37.7333473817874 | -122.427754784883 | (37.7333473817874, -122.427754784883) | 9 | 7 | 5 | 28861 | 25 | ||
89712 | 65793 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 932 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28761 | 5990303.87804952 | 2100435.19460738 | 37.7468366346959 | -122.476285012813 | (37.7468366346959, -122.476285012813) | 1 | 8 | 3 | 29491 | 35 | ||
89977 | 56611 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1992 12:00:00 AM | Permit Number 30977 | 5996730.28293802 | 2098448.69823617 | 37.7417527884603 | -122.453919799435 | (37.7417527884603, -122.453919799435) | 9 | 7 | 4 | 59 | 40 | ||
91979 | 66308 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29423 | 6000783.52973512 | 2095017.02999143 | 37.7325617930594 | -122.439659085695 | (37.7325617930594, -122.439659085695) | 9 | 7 | 5 | 63 | 40 | ||
96084 | 64067 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 666 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1987 12:00:00 AM | Permit Number 24827 | 6002225.57771541 | 2098886.88816265 | 37.7432695004337 | -122.434950246577 | (37.7432695004337, -122.434950246577) | 2 | 7 | 5 | 63 | 22 | ||
98615 | 46679 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1310 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44809 | 5990528.41168502 | 2106454.94562806 | 37.76337829801 | -122.475948167358 | (37.76337829801, -122.475948167358) | 1 | 8 | 3 | 56 | 12 | ||
98619 | 67938 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 86 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31651 | 6004312.01802966 | 2095698.91217619 | 37.7346342889879 | -122.427508808325 | (37.7346342889879, -122.427508808325) | 2 | 7 | 5 | 28861 | 2 | ||
99696 | 66392 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 736 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29518 | 6007726.21493711 | 2095490.25955401 | 37.7342538931553 | -122.41568997407 | (37.7342538931553, -122.41568997407) | 2 | 7 | 7 | 28859 | 2 | ||
99779 | 61031 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 341 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30462 | 5994728.25954816 | 2107000.31116511 | 37.7651183497385 | -122.461461902415 | (37.7651183497385, -122.461461902415) | 15 | 5 | 11 | 56 | 12 | ||
100849 | 67916 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 28 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31626 | 6003939.73244877 | 2095599.86834432 | 37.7343412731947 | -122.428788866832 | (37.7343412731947, -122.428788866832) | 2 | 7 | 5 | 28861 | 25 | ||
103700 | 66325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29444 | 6000554.87735499 | 2095194.20587313 | 37.7330352599042 | -122.440462292733 | (37.7330352599042, -122.440462292733) | 9 | 7 | 5 | 63 | 40 | ||
106252 | 68686 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 128 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32596 | 5992134.97207697 | 2114599.88023196 | 37.7858351044588 | -122.470985030783 | (37.7858351044588, -122.470985030783) | 11 | 6 | 2 | 54 | 11 | ||
111329 | 67925 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31638 | 6003735.12063535 | 2095135.9515003 | 37.7330558796375 | -122.42946320321 | (37.7330558796375, -122.42946320321) | 9 | 7 | 5 | 28861 | 25 | ||
114407 | 68863 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 152 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32826 | 5999067.96340072 | 2093519.65088656 | 37.7283525462917 | -122.445482558018 | (37.7283525462917, -122.445482558018) | 9 | 7 | 4 | 28861 | 40 | ||
115516 | 69060 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1254 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33068 | 5992404.85704232 | 2106915.96776858 | 37.7647527637413 | -122.4694917724 | (37.7647527637413, -122.4694917724) | 11 | 8 | 11 | 56 | 12 | ||
115628 | 66305 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 309 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29420 | 6000730.88542732 | 2094976.31898746 | 37.7324470135678 | -122.439838171481 | (37.7324470135678, -122.439838171481) | 9 | 7 | 5 | 63 | 40 | ||
118692 | 63718 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 239 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24383 | 6007990.36372433 | 2100292.13143731 | 37.7474536189761 | -122.415116506714 | (37.7474536189761, -122.415116506714) | 2 | 7 | 7 | 28859 | 2 | ||
119139 | 65406 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 555 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28257 | 6008843.98828556 | 2114419.97110382 | 37.786293329177 | -122.413163568484 | (37.786293329177, -122.413163568484) | 5 | 10 | 9 | 28852 | 36 | ||
120324 | 68556 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 753 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32445 | 5982266.13075099 | 2110637.89900645 | 37.7743809541883 | -122.50483419911 | (37.7743809541883, -122.50483419911) | 11 | 6 | 2 | 55 | 26 | ||
122547 | 67014 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 26 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30369 | 5996236.04729315 | 2090068.29308484 | 37.7187138605807 | -122.455023275935 | (37.7187138605807, -122.455023275935) | 9 | 8 | 6 | 28861 | 24 | ||
123360 | 63780 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 220 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/11/1995 12:00:00 AM | Permit Number 24461 | 6003691.42811687 | 2101600.49522177 | 37.7508035549005 | -122.430075258307 | (37.7508035549005, -122.430075258307) | 2 | 4 | 5 | 28862 | 22 | ||
123369 | 45291 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 678 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2005 12:00:00 AM | Permit Number 47958 | 6007614.60724398 | 2096238.5150245 | 37.7363021643783 | -122.416128813466 | (37.7363021643783, -122.416128813466) | 2 | 7 | 7 | 28859 | 2 | ||
124746 | 63645 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 749 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/01/1998 12:00:00 AM | Permit Number 24292 | 6000489.386797 | 2111504.70719641 | 37.777816196669 | -122.441858942096 | (37.777816196669, -122.441858942096) | 15 | 5 | 11 | 29490 | 16 |
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) );