trees
256 rows where qSpecies_id = 151
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
83403 | 9925 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6005193.66561 | 2116589.42028 | 37.7920444900059 | -122.425947239584 | (37.7920444900059, -122.425947239584) | 13 | 9 | 1 | 28858 | 27 | ||
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 | ||
84565 | 177524 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 151 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002754.06698 | 2092583.57784 | 37.725992044773 | -122.432672702599 | (37.725992044773, -122.432672702599) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
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 | |||
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 | ||
91294 | 231963 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007553.14308 | 2097114.00894 | 37.7387026219233 | -122.416403314785 | (37.7387026219233, -122.416403314785) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
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 | |
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 | |
97377 | 77990 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
97669 | 46851 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 440 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 8 | Permit Number 44919 | 6003321.97716 | 2091035.01696 | 37.7217722323726 | -122.430599024221 | (37.7217722323726, -122.430599024221) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
98723 | 231959 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007536.6214 | 2096940.11899 | 37.7382242293514 | -122.416448125283 | (37.7382242293514, -122.416448125283) | 2 | 7 | 7 | 28859 | 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 | ||
99923 | 131188 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2501 Jackson St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001926.62889 | 2116662.37015 | 37.7920596147963 | -122.437256424752 | (37.7920596147963, -122.437256424752) | 13 | 6 | 1 | 29490 | 27 | |||
99971 | 231960 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007542.74737 | 2097017.75117 | 37.7384377347063 | -122.416432442006 | (37.7384377347063, -122.416432442006) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | |
116585 | 35845 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 478 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 14 | Permit Number 39072 | 6001935.45212 | 2090855.28224 | 37.7212000747131 | -122.435379022551 | (37.7212000747131, -122.435379022551) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
120920 | 46820 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 470 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44898 | 6003678.47918 | 2090585.52708 | 37.7205582222597 | -122.429334652987 | (37.7205582222597, -122.429334652987) | 9 | 7 | 6 | 28861 | 5 | |
121517 | 254611 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 49 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:11:00 PM | 3 | 3X3 | 6001570.75814 | 2091771.51604 | 37.7236951277094 | -122.436705214986 | (37.7236951277094, -122.436705214986) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
124362 | 231967 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 36 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005715.33692 | 2097471.12412 | 37.7395796596638 | -122.422782959663 | (37.7395796596638, -122.422782959663) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||
127670 | 45284 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 541 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44126 | 6008215.69383326 | 2096339.71567531 | 37.7366138182396 | -122.414057758062 | (37.7366138182396, -122.414057758062) | 2 | 7 | 7 | 28859 | 2 | ||
128399 | 66439 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 256 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29583 | 6006068.54082746 | 2096076.77967326 | 37.7357710232065 | -122.421462732945 | (37.7357710232065, -122.421462732945) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
144291 | 66433 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 29576 | 6005529.27345058 | 2096644.50573799 | 37.7372994514328 | -122.423367539465 | (37.7372994514328, -122.423367539465) | 2 | 7 | 7 | 28859 | 2 | ||
144783 | 47523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 253 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45394 | 6001752.07719 | 2094109.13644 | 37.7301240051048 | -122.436245638924 | (37.7301240051048, -122.436245638924) | 9 | 7 | 6 | 28861 | 25 | |
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 |
146059 | 67909 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 124 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32837 | 5999245.55939042 | 2093517.24429142 | 37.7283560753919 | -122.444868429871 | (37.7283560753919, -122.444868429871) | 9 | 7 | 4 | 28861 | 40 | ||
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 | |||
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 | ||
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 | |
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 | |||
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 | |
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 | |||
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 | ||
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 | |
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 | |||
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 | ||
154741 | 42598 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1961 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 14 | Permit Number 42668 | 6005388.01706 | 2116488.54152 | 37.7917784840479 | -122.425267599417 | (37.7917784840479, -122.425267599417) | 13 | 9 | 1 | 28858 | 27 | |
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 | ||
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 | ||
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 | |
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 | ||
159201 | 231947 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.7371279405099 | -122.425105073942 | (37.7371279405099, -122.425105073942) | 2 | 7 | 5 | 28859 | 2 |
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) );