trees
256 rows where qSpecies_id = 151 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
191295 | 66903 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 228 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30221 | 6007526.62585922 | 2097598.28579286 | 37.7400308479341 | -122.416529293976 | (37.7400308479341, -122.416529293976) | 2 | 7 | 7 | 28859 | 2 | ||
177080 | 66906 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 219 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | 20 | 2x5 | Permit Number 30224 | 6007582.57957611 | 2097641.75307421 | 37.7401533460797 | -122.416338906472 | (37.7401533460797, -122.416338906472) | 2 | 7 | 7 | 28859 | 2 |
43103 | 209295 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2559 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992040.53101 | 2098014.3866 | 37.7402902733651 | -122.470103641773 | (37.7402902733651, -122.470103641773) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||
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 | ||
10268 | 231965 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 799X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007531.06073 | 2097759.54123 | 37.7404738690811 | -122.416525379751 | (37.7404738690811, -122.416525379751) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
159388 | 66895 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 168 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30213 | 6007551.53091374 | 2097886.23194596 | 37.7408228849183 | -122.4164635734 | (37.7408228849183, -122.4164635734) | 2 | 7 | 7 | 28859 | 2 | ||
137851 | 66928 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 160 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30250 | 6007554.42782644 | 2097919.72536023 | 37.7409150133245 | -122.416455928807 | (37.7409150133245, -122.416455928807) | 2 | 7 | 7 | 28859 | 2 | ||
106979 | 231966 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007085.27173 | 2097974.9068 | 37.7410401344022 | -122.418082011786 | (37.7410401344022, -122.418082011786) | 2 | 7 | 7 | 28859 | 2 | |||
168760 | 62861 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 112 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31839 | 6008289.1101765 | 2098063.77851113 | 37.7413518401577 | -122.413925848755 | (37.7413518401577, -122.413925848755) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
135210 | 46920 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 3 | 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 | |||
186568 | 46921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
170005 | 67470 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 28 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30992 | 5997437.11856426 | 2098613.47951491 | 37.7422457393208 | -122.451487690832 | (37.7422457393208, -122.451487690832) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
132348 | 66258 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 30 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29361 | 5996943.80390812 | 2098830.64453292 | 37.7428137596531 | -122.453209085576 | (37.7428137596531, -122.453209085576) | 9 | 7 | 4 | 59 | 40 | ||
131393 | 64147 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1620 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24926 | 6003320.75004876 | 2098798.13825464 | 37.7430879358174 | -122.431157094729 | (37.7430879358174, -122.431157094729) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
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 | ||
136652 | 65652 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 36 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28571 | 5997207.51801243 | 2099318.0814338 | 37.7441672533821 | -122.452332406716 | (37.7441672533821, -122.452332406716) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
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 | |||
180622 | 67834 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 614 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31496 | 6001920.673977 | 2099454.66622044 | 37.7448111687463 | -122.43604514265 | (37.7448111687463, -122.43604514265) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
166925 | 62359 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 183 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31493 | 6004713.1576588 | 2099557.75082014 | 37.7452524642677 | -122.426396594795 | (37.7452524642677, -122.426396594795) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
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 | |
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 | ||
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 | ||
14893 | 69004 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2079 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | 3x3 | Permit Number 33005 | 5982592.52058918 | 2100976.42518266 | 37.7478724914068 | -122.502989774605 | (37.7478724914068, -122.502989774605) | 1 | 8 | 3 | 29491 | 35 |
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 | ||
167461 | 63972 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/19/1987 12:00:00 AM | 6002987.03604686 | 2100924.44853758 | 37.7489073707234 | -122.432462826172 | (37.7489073707234, -122.432462826172) | 2 | 4 | 5 | 28862 | 22 | |||
45505 | 231972 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003745.92075 | 2101014.04618 | 37.7491963890986 | -122.429844992161 | (37.7491963890986, -122.429844992161) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
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 | ||
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 | ||
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 | ||
136826 | 60207 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3338 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | 7 | Permit Number 19754 | 6007475 | 2101539 | 37.7508482631719 | -122.416986935836 | (37.7508482631719, -122.416986935836) | 2 | 4 | 7 | 28859 | 19 | |
152389 | 231973 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 3ft | 6004325.56331 | 2101629.44898 | 37.7509189496627 | -122.427884424232 | (37.7509189496627, -122.427884424232) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||
8770 | 231971 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4098 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6002611.76959 | 2101830.0379 | 37.7513726180492 | -122.433825215284 | (37.7513726180492, -122.433825215284) | 2 | 4 | 5 | 28862 | 22 | |||
135798 | 231954 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 215 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6006180.99637 | 2101867.22963 | 37.751676631191 | -122.421485034734 | (37.751676631191, -122.421485034734) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
74527 | 231974 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004099.54085 | 2102284.63466 | 37.7527051471301 | -122.428712732201 | (37.7527051471301, -122.428712732201) | 2 | 4 | 5 | 28862 | 22 | |||
131792 | 67823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31479 | 6004089.22123214 | 2102351.15512092 | 37.7528872126598 | -122.428753160983 | (37.7528872126598, -122.428753160983) | 2 | 4 | 5 | 28862 | 22 | ||
26041 | 87359 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2127 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53579 | 6012075.86217 | 2102321.0716 | 37.7532533954437 | -122.401131582655 | (37.7532533954437, -122.401131582655) | 10 | 3 | 8 | 28856 | 29 | |
162661 | 231970 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 541 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001866.38418 | 2102721.13376 | 37.7537770283888 | -122.436466612253 | (37.7537770283888, -122.436466612253) | 2 | 4 | 5 | 28862 | 22 | |||
178401 | 64628 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 170 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1988 12:00:00 AM | Permit Number 25537 | 6005392.70908858 | 2102720.91068508 | 37.7539761631805 | -122.424271747549 | (37.7539761631805, -122.424271747549) | 2 | 4 | 5 | 28859 | 19 | ||
129396 | 64627 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25536 | 6005377.18111658 | 2103001.16489201 | 37.7547447992353 | -122.424345378751 | (37.7547447992353, -122.424345378751) | 2 | 4 | 5 | 28859 | 19 | ||
890 | 231975 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3666 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003943.14044 | 2103070.57421 | 37.7548542993098 | -122.429309632052 | (37.7548542993098, -122.429309632052) | 2 | 4 | 5 | 28862 | 22 | |||
16063 | 231976 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3670 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003921.45543 | 2103072.93083 | 37.7548595423439 | -122.42938479289 | (37.7548595423439, -122.42938479289) | 2 | 4 | 5 | 28862 | 22 | |||
166161 | 63980 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3666 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24720 | 6003941.47141404 | 2103077.78156468 | 37.7548739945164 | -122.429315917927 | (37.7548739945164, -122.429315917927) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
148871 | 63880 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 883 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24586 | 6003774.19132667 | 2103145.47595377 | 37.7550503955524 | -122.429899247451 | (37.7550503955524, -122.429899247451) | 2 | 4 | 5 | 28862 | 22 | ||
146596 | 231950 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 703 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007343.45792 | 2103120.91973 | 37.7551844539259 | -122.417553926284 | (37.7551844539259, -122.417553926284) | 2 | 4 | 7 | 28859 | 19 | |||
125461 | 64589 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3350 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25490 | 6006008.81445181 | 2103189.70066891 | 37.7552981215573 | -122.422174408546 | (37.7552981215573, -122.422174408546) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
171045 | 68055 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1635 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31792 | 5993371.17911644 | 2104355.17278609 | 37.7577772885613 | -122.4659634545 | (37.7577772885613, -122.4659634545) | 1 | 8 | 4 | 56 | 12 | ||
152979 | 59014 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3758 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38904 | 6005263.8024452 | 2104318.31785235 | 37.7583549902775 | -122.424831174315 | (37.7583549902775, -122.424831174315) | 2 | 4 | 5 | 28859 | 19 | ||
158729 | 55509 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50811 | 6001116.15615012 | 2104674.38897878 | 37.7590975343523 | -122.439201053877 | (37.7590975343523, -122.439201053877) | 2 | 4 | 5 | 28862 | 3 | ||
171959 | 83375 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 248 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50822 | 5999884.09113954 | 2104832.45906966 | 37.7594613698021 | -122.44347346176 | (37.7594613698021, -122.44347346176) | 2 | 4 | 5 | 28862 | 3 | ||
105022 | 231981 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 91 Clover Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6000469.66557 | 2104934.36895 | 37.7597745666642 | -122.441455575241 | (37.7597745666642, -122.441455575241) | 2 | 4 | 5 | 28862 | 3 | |||
106210 | 231953 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006489.5205 | 2105029.86683 | 37.7603778930513 | -122.420642603769 | (37.7603778930513, -122.420642603769) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
19917 | 209292 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1466 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993385.70012 | 2105501.91756 | 37.7609267888564 | -122.465996561219 | (37.7609267888564, -122.465996561219) | 1 | 8 | 11 | 56 | 12 | |||
28265 | 231979 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 478 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002951.2565 | 2105388.22536 | 37.7611618104807 | -122.43290540667 | (37.7611618104807, -122.43290540667) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
45973 | 231978 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3813 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004168.45878 | 2105381.57202 | 37.7612125052624 | -122.428695150486 | (37.7612125052624, -122.428695150486) | 2 | 4 | 5 | 28862 | 3 | |||
124678 | 231980 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 48 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002629.60405 | 2105594.78534 | 37.7617107251998 | -122.434032629514 | (37.7617107251998, -122.434032629514) | 15 | 4 | 5 | 28862 | 3 | |||
131257 | 83949 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 4800 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 3x3 | Permit Number 50899 | 5998201 | 2105706 | 37.7617637654108 | -122.449357332436 | (37.7617637654108, -122.449357332436) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
48209 | 209293 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1416 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993991.03354 | 2105859.32276 | 37.7619430335757 | -122.463928938879 | (37.7619430335757, -122.463928938879) | 1 | 5 | 11 | 56 | 12 | |||
151858 | 231977 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 20 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003286.06563 | 2105669.78053 | 37.7619538776004 | -122.431767549352 | (37.7619538776004, -122.431767549352) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
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 | ||
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 | ||
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 | |||
27044 | 49828 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012702.02381 | 2105670.26876 | 37.7624844685969 | -122.399201255332 | (37.7624844685969, -122.399201255332) | 14 | 3 | 8 | 28856 | 29 | ||
157444 | 49819 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012718.30127 | 2105671.30189 | 37.7624882124737 | -122.39914502972 | (37.7624882124737, -122.39914502972) | 14 | 3 | 8 | 28856 | 29 | ||
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 | ||
135882 | 49824 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012781.37184 | 2105676.15617 | 37.7625050558738 | -122.398927231008 | (37.7625050558738, -122.398927231008) | 14 | 3 | 8 | 28856 | 29 | ||
164137 | 49823 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012798.82942 | 2105676.31317 | 37.7625064597174 | -122.398866862242 | (37.7625064597174, -122.398866862242) | 14 | 3 | 8 | 28856 | 29 | ||
61575 | 49822 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012816.10881 | 2105676.13284 | 37.7625069273679 | -122.398807086097 | (37.7625069273679, -122.398807086097) | 14 | 3 | 8 | 28856 | 29 | ||
22053 | 49821 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012834.79813 | 2105677.969 | 37.7625130103804 | -122.398742575008 | (37.7625130103804, -122.398742575008) | 14 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | ||
125091 | 60178 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 31 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19711 | 6005843.20173996 | 2105910.5873799 | 37.7627596974043 | -122.422940519748 | (37.7627596974043, -122.422940519748) | 8 | 4 | 5 | 28859 | 19 | ||
141071 | 60176 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 19 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19708 | 6005839.66943051 | 2105974.33981931 | 37.7629345472543 | -122.422957268124 | (37.7629345472543, -122.422957268124) | 8 | 4 | 5 | 28859 | 19 | ||
168878 | 60177 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19709 | 6005786.70456433 | 2105990.31461515 | 37.7629754214805 | -122.423141591085 | (37.7629754214805, -122.423141591085) | 8 | 4 | 5 | 28859 | 19 | ||
38518 | 95809 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 691 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015468.0632 | 2105845.97691 | 37.7631206885995 | -122.389646729328 | (37.7631206885995, -122.389646729328) | 14 | 3 | 8 | 28856 | 29 |
145208 | 95813 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 691 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015467.36325 | 2105865.66469 | 37.7631747081784 | -122.389650525366 | (37.7631747081784, -122.389650525366) | 14 | 3 | 8 | 28856 | 29 |
6722 | 95806 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 570 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767550 | 6014847.40317 | 2105882.92079 | 37.7631876934897 | -122.391795984023 | (37.7631876934897, -122.391795984023) | 14 | 3 | 8 | 28856 | 29 |
173003 | 95811 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 691 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767553 | 6015465.85735 | 2105884.27578 | 37.7632257267086 | -122.389657033744 | (37.7632257267086, -122.389657033744) | 14 | 3 | 8 | 28856 | 29 |
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 | ||
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 | ||
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 | ||
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 |
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) );