trees
256 rows where qSpecies_id = 151 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 |
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 | ||
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 | ||
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 | |||
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 | ||
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 |
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 | ||
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 | ||
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 | ||
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 |
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 | |||
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 | ||
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 | |||
14127 | 45367 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2001 12:00:00 AM | Permit Number 44192 | 6007805.03016333 | 2096352.99475391 | 37.7366272057089 | -122.415478542826 | (37.7366272057089, -122.415478542826) | 2 | 7 | 7 | 28859 | 2 | ||
25935 | 66407 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 533 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29534 | 6008039.98859373 | 2096389.06187115 | 37.7367394418447 | -122.414668739511 | (37.7367394418447, -122.414668739511) | 2 | 7 | 7 | 28859 | 2 | ||
29365 | 231964 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 332 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008801.63861 | 2097226.11377 | 37.7390805674202 | -122.412094512652 | (37.7390805674202, -122.412094512652) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
34596 | 66400 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 531 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29526 | 6007491.7583768 | 2096409.40123315 | 37.7367644721833 | -122.416565655603 | (37.7367644721833, -122.416565655603) | 2 | 7 | 7 | 28859 | 2 | ||
42223 | 37689 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 385 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 43282 | 6007841.95638313 | 2105703.00432184 | 37.7623023025462 | -122.416012813552 | (37.7623023025462, -122.416012813552) | 8 | 4 | 7 | 28859 | 19 | ||
42735 | 63835 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 480 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24525 | 6007455.04270761 | 2096578.56376841 | 37.737226890345 | -122.416704578376 | (37.737226890345, -122.416704578376) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
53579 | 66397 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 508 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29523 | 6007446.33784222 | 2096483.57459282 | 37.7369655813708 | -122.416727947771 | (37.7369655813708, -122.416727947771) | 2 | 7 | 7 | 28859 | 2 | ||
58332 | 231961 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007544.54493 | 2097042.23546 | 37.7385050642556 | -122.416427960701 | (37.7385050642556, -122.416427960701) | 2 | 7 | 7 | 28859 | 2 | |||
66509 | 67173 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 308 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30617 | 6006778.80431339 | 2096277.81486238 | 37.7363630429498 | -122.419021324056 | (37.7363630429498, -122.419021324056) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | ||
77589 | 63838 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 310 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24529 | 6007512.21907746 | 2097215.58579661 | 37.7389792281053 | -122.416552004438 | (37.7389792281053, -122.416552004438) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |
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 | ||
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 | ||
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 | |||
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 | |
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 | ||
161821 | 231948 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 365 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6007200.80171 | 2096289.89745 | 37.7364199734891 | -122.417563155128 | (37.7364199734891, -122.417563155128) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
163588 | 63364 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 103 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30639 | 6006732.73114879 | 2096957.82345997 | 37.7382276012884 | -122.419228840922 | (37.7382276012884, -122.419228840922) | 2 | 7 | 7 | 28859 | 2 | ||
164763 | 66919 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 256 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | 3x3 | Permit Number 30240 | 6007515.01387925 | 2097464.03098478 | 37.7396615608777 | -122.416559935715 | (37.7396615608777, -122.416559935715) | 2 | 7 | 7 | 28859 | 2 | |
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 | |
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 | ||
170715 | 66902 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 280 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30220 | 6007505.06075356 | 2097348.955435 | 37.7393450290906 | -122.416586199821 | (37.7393450290906, -122.416586199821) | 2 | 7 | 7 | 28859 | 2 | ||
172297 | 63837 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 443 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24528 | 6007534.27332128 | 2096872.17856811 | 37.7380375478753 | -122.416451432701 | (37.7380375478753, -122.416451432701) | 2 | 7 | 7 | 28859 | 2 | ||
175004 | 231962 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 500 Andover St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007543.01124 | 2097062.2707 | 37.7385599903583 | -122.416434682233 | (37.7385599903583, -122.416434682233) | 2 | 7 | 7 | 28859 | 2 | |||
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 |
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 | |||
177910 | 59774 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 460 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1991 12:00:00 AM | Permit Number 29632 | 6007462.52860048 | 2096660.25076168 | 37.7374516058806 | -122.416684481311 | (37.7374516058806, -122.416684481311) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
184194 | 63836 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 449 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24527 | 6007531.71339338 | 2096844.47873768 | 37.7379613462812 | -122.416458322142 | (37.7379613462812, -122.416458322142) | 2 | 7 | 7 | 28859 | 2 | ||
186935 | 62942 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 375 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30478 | 6006773.07754365 | 2097002.00015366 | 37.7383511728239 | -122.419092475387 | (37.7383511728239, -122.419092475387) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
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 | |||
1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
1945 | 44489 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 8 | Permit Number 43794 | 6005364.27294 | 2093438.07689 | 37.7284859970226 | -122.423710107629 | (37.7284859970226, -122.423710107629) | 9 | 7 | 6 | 28861 | 5 | |
9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
16040 | 78382 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 606 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6001696.66297 | 2089972.42102 | 37.7187623714737 | -122.436141300492 | (37.7187623714737, -122.436141300492) | 9 | 7 | 6 | 28861 | 5 | ||||
18805 | 78255 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 512 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001977.46264 | 2090420.81734 | 37.7200095171006 | -122.435202744616 | (37.7200095171006, -122.435202744616) | 9 | 7 | 6 | 28861 | 5 | |||
21835 | 65598 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 966 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28500 | 6001950.73496364 | 2088338.48153862 | 37.7142903680478 | -122.435146273727 | (37.7142903680478, -122.435146273727) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
49524 | 209294 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 246 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994759.39259 | 2090227.21808 | 37.7190654070329 | -122.460138948468 | (37.7190654070329, -122.460138948468) | 9 | 8 | 6 | 28861 | 24 | |||
51461 | 83403 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 24 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50775 | 6000910.29193694 | 2092966.50207531 | 37.7269387297254 | -122.439073931559 | (37.7269387297254, -122.439073931559) | 9 | 7 | 6 | 28861 | 25 | ||
76546 | 177523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 321 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998908.35184 | 2087935.66658 | 37.7130110981499 | -122.44563295221 | (37.7130110981499, -122.44563295221) | 9 | 7 | 6 | 28861 | 25 | |||
78371 | 33939 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 378 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 37898 | 6003089.72357803 | 2091687.1316724 | 37.72354963405 | -122.431448393386 | (37.72354963405, -122.431448393386) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
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 | |||
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 | |
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 | |
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 | ||
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 | ||
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 | |
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 | |||
163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
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 |
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) );