trees
256 rows where qSpecies_id = 151 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
127221 | 53339 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 701 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6231 | 5992196.93740977 | 2089828.37078741 | 37.7178225482589 | -122.468967276491 | (37.7178225482589, -122.468967276491) | 9 | 8 | 6 | 64 | 24 | ||
153381 | 45327 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
168262 | 45325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
170769 | 53492 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 255 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1994 12:00:00 AM | Permit Number 6402 | 5992175.72287884 | 2089558.97106605 | 37.7170816163747 | -122.469021010071 | (37.7170816163747, -122.469021010071) | 9 | 8 | 6 | 64 | 24 | ||
173866 | 45326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
174951 | 47805 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 51 Escondido Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2002 12:00:00 AM | 0 | Permit Number 45573 | 5986262.03154998 | 2096094.88833599 | 37.7346840880203 | -122.489941970727 | (37.7346840880203, -122.489941970727) | 1 | 8 | 3 | 64 | 35 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
140306 | 57830 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 307 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29419 | 6000730.804091 | 2094971.1282722 | 37.7324327564376 | -122.439838080651 | (37.7324327564376, -122.439838080651) | 9 | 7 | 5 | 63 | 40 | ||
154668 | 66320 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 221 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29437 | 6000609.84219196 | 2094923.1600046 | 37.7322941604972 | -122.440252834618 | (37.7322941604972, -122.440252834618) | 9 | 7 | 4 | 63 | 40 | ||
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 | ||
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 | ||
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 | |||
188615 | 68833 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 178 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32784 | 5999570.75659197 | 2094098.77581282 | 37.7299713792854 | -122.443785974037 | (37.7299713792854, -122.443785974037) | 9 | 7 | 4 | 63 | 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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
31598 | 5809 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 25 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 6 | 3X4 | 6016112.32175 | 2096327.0001 | 37.7370192646182 | -122.386754585178 | (37.7370192646182, -122.386754585178) | 10 | 3 | 8 | 58 | 1 | ||
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 | |
85647 | 193531 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6018621.46299 | 2096962.90365 | 37.7389039297614 | -122.378123392174 | (37.7389039297614, -122.378123392174) | 10 | 3 | 8 | 58 | 1 | |||
168613 | 25930 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1940 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2008 12:00:00 AM | 12 | 3x3 | 6013172.33562 | 2096908.97422 | 37.7384540331375 | -122.396960298598 | (37.7384540331375, -122.396960298598) | 10 | 3 | 8 | 58 | 1 | ||
174781 | 193532 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6018580.21539 | 2096908.74747 | 37.7387529542923 | -122.378262250201 | (37.7387529542923, -122.378262250201) | 10 | 3 | 8 | 58 | 1 | |||
41699 | 52773 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2380@ STEINER Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2006 12:00:00 AM | 5 | Permit Number 48816 | 6002179.59387 | 2117772.23813 | 37.7951214016938 | -122.436460636263 | (37.7951214016938, -122.436460636263) | 13 | 9 | 1 | 57 | 17 | ||
97256 | 87303 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2426 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2008 12:00:00 AM | 38 | 3x3 | Permit Number 50313 | 6001931.96776 | 2117738.10536 | 37.7950136080408 | -122.43731501379 | (37.7950136080408, -122.43731501379) | 13 | 9 | 1 | 57 | 27 | |
110307 | 42646 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
166834 | 42645 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 6 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
3370 | 67249 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 559 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 5 | Permit Number 30713 | 5983459.33471 | 2112007.07812 | 37.7782104457147 | -122.500808022251 | (37.7782104457147, -122.500808022251) | 11 | 6 | 2 | 55 | 26 | |
19381 | 70028 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 555 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983452.32231 | 2112030.75964 | 37.7782750565666 | -122.500834032057 | (37.7782750565666, -122.500834032057) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
135642 | 51700 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1935 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2005 12:00:00 AM | Permit Number 47976 | 5989632.50224537 | 2110558.09504806 | 37.7745924384823 | -122.479346986422 | (37.7745924384823, -122.479346986422) | 11 | 6 | 2 | 55 | 26 | ||
142389 | 67229 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 524 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30688 | 5984121.20049596 | 2112265.52046408 | 37.7789588900523 | -122.498537517397 | (37.7789588900523, -122.498537517397) | 11 | 6 | 2 | 55 | 26 | ||
149721 | 34268 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 166 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 3 | Permit Number 38071 | 5987436.71132 | 2114846.84684 | 37.7862403554066 | -122.487257635976 | (37.7862403554066, -122.487257635976) | 11 | 6 | 1 | 55 | 33 | |
153122 | 67227 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 807 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 6 | Permit Number 30686 | 5983524.12809 | 2110277.94013 | 37.7734665377075 | -122.500456000342 | (37.7734665377075, -122.500456000342) | 11 | 6 | 2 | 55 | 26 | |
32603 | 87041 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993785.44399 | 2110433.89839 | 37.7744917610659 | -122.464972234911 | (37.7744917610659, -122.464972234911) | 11 | 6 | 2 | 54 | 11 | |
40483 | 87042 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993785.1728 | 2110455.01638 | 37.7745497297907 | -122.464974707047 | (37.7745497297907, -122.464974707047) | 11 | 6 | 2 | 54 | 11 | |
62954 | 103530 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 155 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x9 | 5993328.74433 | 2114475.40992 | 37.7855623136611 | -122.466845895101 | (37.7855623136611, -122.466845895101) | 11 | 6 | 2 | 54 | 11 | |||
78472 | 123457 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 607 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995303.78835 | 2111399.35412 | 37.7772300773628 | -122.459789972595 | (37.7772300773628, -122.459789972595) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
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 | ||
116366 | 59096 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993787.7809 | 2110375.019 | 37.7743302287246 | -122.464959874093 | (37.7743302287246, -122.464959874093) | 11 | 6 | 2 | 54 | 11 | |
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 | ||||
141258 | 87040 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993786.75747 | 2110417.02828 | 37.7744455159827 | -122.4649664659 | (37.7744455159827, -122.4649664659) | 11 | 6 | 2 | 54 | 11 | |
143358 | 47401 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 442 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45312 | 5994381.12828597 | 2112514.18639084 | 37.780238005012 | -122.463062632294 | (37.780238005012, -122.463062632294) | 11 | 6 | 2 | 54 | 11 | ||
157761 | 87043 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993784.66357 | 2110476.13962 | 37.7746076992047 | -122.464978002989 | (37.7746076992047, -122.464978002989) | 11 | 6 | 2 | 54 | 11 | |
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 | |
190815 | 68179 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 73 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31951 | 5996326.92288367 | 2111711.14123213 | 37.7781449475636 | -122.456273193477 | (37.7781449475636, -122.456273193477) | 11 | 6 | 2 | 54 | 16 | ||
51718 | 43139 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005713.11166 | 2093478.24293 | 37.7286159697368 | -122.422507005398 | (37.7286159697368, -122.422507005398) | 9 | 7 | 7 | 309 | 5 | ||
96848 | 43137 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42953 | 6005718.46144 | 2093462.75751 | 37.728573751977 | -122.422487410986 | (37.728573751977, -122.422487410986) | 9 | 7 | 7 | 309 | 5 | |
106884 | 177525 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 100 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006897.82744 | 2093555.37403 | 37.7288945185586 | -122.418416832071 | (37.7288945185586, -122.418416832071) | 9 | 3 | 7 | 309 | 5 | |||
152379 | 43141 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 45 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 10 | Permit Number 42954 | 6005755.19133 | 2093338.41647 | 37.7282344107702 | -122.422351602551 | (37.7282344107702, -122.422351602551) | 9 | 7 | 7 | 309 | 5 | |
161958 | 43169 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 351 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 6 | Permit Number 42978 | 6005826.41516 | 2092089.07714 | 37.7248080153712 | -122.422016663551 | (37.7248080153712, -122.422016663551) | 9 | 7 | 7 | 309 | 5 | |
165181 | 43138 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005709.81909 | 2093489.20943 | 37.7286458955884 | -122.422519166951 | (37.7286458955884, -122.422519166951) | 9 | 7 | 7 | 309 | 5 | ||
167774 | 42973 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 538 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 8 | Permit Number 42858 | 6007050.21421 | 2092033.4761 | 37.7247242929748 | -122.4177821868 | (37.7247242929748, -122.4177821868) | 9 | 7 | 7 | 309 | 28 | |
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 | ||
156905 | 66086 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 895 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | Permit Number 29130 | 6008704.72380049 | 2119330.26525123 | 37.7997679743153 | -122.413992883013 | (37.7997679743153, -122.413992883013) | 3 | 1 | 10 | 308 | 32 | ||
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 | ||
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 | |||
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 | ||
125608 | 63771 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 590 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24450 | 6003156.31583287 | 2110278.10733635 | 37.7745998623789 | -122.432545479611 | (37.7745998623789, -122.432545479611) | 15 | 9 | 11 | 29492 | 10 | ||
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 | ||
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 | |
173277 | 231946 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 301 Webster St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6004139.43859 | 2109828.95399 | 37.7734222994207 | -122.429112631967 | (37.7734222994207, -122.429112631967) | 7 | 9 | 11 | 29492 | 10 | |||
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 |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
9741 | 131187 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6001696.09346 | 2116629.35582 | 37.7919558582198 | -122.438051712318 | (37.7919558582198, -122.438051712318) | 13 | 6 | 1 | 29490 | 27 | |||
28120 | 131190 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2451 Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002262.78346 | 2116332.95188 | 37.7911742205576 | -122.436069745025 | (37.7911742205576, -122.436069745025) | 13 | 9 | 1 | 29490 | 27 | |||
48519 | 131189 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002000.17825 | 2116671.28438 | 37.792088271701 | -122.4370025821 | (37.792088271701, -122.4370025821) | 13 | 6 | 1 | 29490 | 27 |
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) );