trees
7,322 rows where qSpecies_id = 1 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
38731 | 218719 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | 1 | 8 | 4 | 29491 | 40 | |||
98701 | 218721 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.7466566307978 | -122.464476068412 | (37.7466566307978, -122.464476068412) | 1 | 8 | 4 | 29491 | 40 | |||
131893 | 218720 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Marcos Ave | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.7466556145593 | -122.464499198102 | (37.7466556145593, -122.464499198102) | 1 | 8 | 4 | 29491 | 40 | |||
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
98555 | 242320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006209.1521 | 2102634.3543 | 37.75378456653 | -122.421442142453 | (37.75378456653, -122.421442142453) | 2 | 4 | 5 | 28859 | 19 | |||
178712 | 33745 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338 | 2102697 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | 2 | 4 | 5 | 28859 | 19 | |
19151 | 242322 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006212.50813 | 2102671.12138 | 37.7538857096745 | -122.421433147433 | (37.7538857096745, -122.421433147433) | 2 | 4 | 5 | 28859 | 19 | |
83645 | 242323 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006214.26543 | 2102686.33739 | 37.7539275884093 | -122.421428150793 | (37.7539275884093, -122.421428150793) | 2 | 4 | 5 | 28859 | 19 | |||
121510 | 242324 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006214.10132 | 2102706.48549 | 37.7539829011917 | -122.421430149091 | (37.7539829011917, -122.421430149091) | 2 | 4 | 5 | 28859 | 19 | |||
175437 | 242325 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006215.7234 | 2102729.1867 | 37.7540453249341 | -122.421426151609 | (37.7540453249341, -122.421426151609) | 2 | 4 | 5 | 28859 | 19 | |||
123540 | 20129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 18 | 3X3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | 15 | 9 | 11 | 29492 | 10 | ||
7214 | 31890 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||
68891 | 253688 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||||
100872 | 246777 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 999 Esmeralda Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6009797.21776 | 2098767.51115 | 37.7433687202062 | -122.408760953364 | (37.7433687202062, -122.408760953364) | 2 | 7 | 7 | 28859 | 2 | |||
30736 | 42949 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 996 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42843 | 6007571.84518521 | 2103864.78808287 | 37.7572397945138 | -122.416816791906 | (37.7572397945138, -122.416816791906) | 2 | 4 | 7 | 28859 | 19 | |||
43052 | 42950 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 996 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42843 | 6007571.84518521 | 2103864.78808287 | 37.7572397945138 | -122.416816791906 | (37.7572397945138, -122.416816791906) | 2 | 4 | 7 | 28859 | 19 | |||
143484 | 241910 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 996 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007560.04138 | 2103904.33435 | 37.7573477155531 | -122.416860415892 | (37.7573477155531, -122.416860415892) | 2 | 4 | 7 | 28859 | 19 | |||
183228 | 241911 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 996 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007559.6207 | 2103883.79865 | 37.7572913055712 | -122.416860415884 | (37.7572913055712, -122.416860415884) | 2 | 4 | 7 | 28859 | 19 | |||
34308 | 105924 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 995 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2014 12:00:00 AM | 3x3 | Permit Number 769111 | 6007873.5 | 2115092.6 | 37.7880856736468 | -122.416568881841 | (37.7880856736468, -122.416568881841) | 13 | 1 | 10 | 28858 | 21 | ||
177190 | 198192 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 994 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013231.44182 | 2089529.73255 | 37.7181954307556 | -122.396238895717 | (37.7181954307556, -122.396238895717) | 10 | 3 | 8 | 58 | 1 | |||
182069 | 198191 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 994 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013245.77687 | 2089519.27662 | 37.7181675184984 | -122.39618861282 | (37.7181675184984, -122.39618861282) | 10 | 3 | 8 | 58 | 1 | |||
149211 | 20131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 990X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003129.07268 | 2110685.22533 | 37.7757161626447 | -122.432668806584 | (37.7757161626447, -122.432668806584) | 15 | 9 | 11 | 29492 | 10 | ||
39808 | 244734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781234 | 6002400.58496 | 2096245.1457 | 37.7360258231402 | -122.434156306092 | (37.7360258231402, -122.434156306092) | 2 | 7 | 5 | 63 | 7 |
36737 | 242249 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003360.64283 | 2108454.84052 | 37.7696052043469 | -122.431708469274 | (37.7696052043469, -122.431708469274) | 15 | 9 | 5 | 29492 | 9 | |||
36774 | 242247 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003349.42995 | 2108514.94087 | 37.7697695896261 | -122.431751545909 | (37.7697695896261, -122.431751545909) | 15 | 9 | 5 | 29492 | 9 | |||
56455 | 242250 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003364.83525 | 2108429.09579 | 37.7695347532487 | -122.431692129502 | (37.7695347532487, -122.431692129502) | 15 | 9 | 5 | 29492 | 9 | |||
67050 | 242246 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003347.84858 | 2108542.34207 | 37.7698447369831 | -122.431758972522 | (37.7698447369831, -122.431758972522) | 15 | 9 | 5 | 29492 | 9 | |||
165887 | 242248 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003353.64 | 2108490.05096 | 37.7697014866621 | -122.43173520612 | (37.7697014866621, -122.43173520612) | 15 | 9 | 5 | 29492 | 9 | |||
102070 | 214980 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996774.676 | 2098563.58789 | 37.7420707925418 | -122.453774598332 | (37.7420707925418, -122.453774598332) | 9 | 7 | 4 | 59 | 40 | |||
28422 | 242199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003832.05636 | 2107789.07621 | 37.7678038874682 | -122.430030367613 | (37.7678038874682, -122.430030367613) | 7 | 9 | 5 | 28862 | 3 | |||
45729 | 242200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003829.67017 | 2107803.36453 | 37.7678429845897 | -122.430039640543 | (37.7678429845897, -122.430039640543) | 7 | 9 | 5 | 28862 | 3 | |||
35339 | 36401 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98X COLON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199 | 2093723 | 37.7287466926272 | -122.455415326965 | (37.7287466926272, -122.455415326965) | 9 | 7 | 4 | 28861 | 40 | ||
93787 | 36396 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98X COLON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199 | 2093723 | 37.7287466926272 | -122.455415326965 | (37.7287466926272, -122.455415326965) | 9 | 7 | 4 | 28861 | 40 | ||
149086 | 36399 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98X COLON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199 | 2093723 | 37.7287466926272 | -122.455415326965 | (37.7287466926272, -122.455415326965) | 9 | 7 | 4 | 28861 | 40 | ||
168483 | 36397 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98X COLON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996199 | 2093723 | 37.7287466926272 | -122.455415326965 | (37.7287466926272, -122.455415326965) | 9 | 7 | 4 | 28861 | 40 | ||
169248 | 103272 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | 13 | 1 | 10 | 28858 | 21 | |
139652 | 17005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 988 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2015 11:46:00 AM | 3 | 3X3 | 6002274.9132 | 2109899.1296 | 37.7735092615764 | -122.435567303378 | (37.7735092615764, -122.435567303378) | 15 | 5 | 11 | 29492 | 10 | ||
48345 | 198077 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 987 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012517.13544 | 2103383.6869 | 37.7561957127753 | -122.399680164128 | (37.7561957127753, -122.399680164128) | 10 | 3 | 8 | 28856 | 29 | |||
182732 | 241694 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 986 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005675.10731 | 2103244.45106 | 37.7554296252817 | -122.423332360924 | (37.7554296252817, -122.423332360924) | 2 | 4 | 5 | 28859 | 19 | |||
23902 | 247459 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 985 Oak St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6002326.2969 | 2109831.4554 | 37.7733263633354 | -122.435384717986 | (37.7733263633354, -122.435384717986) | 15 | 5 | 11 | 29492 | 9 | |||
175869 | 17006 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 985 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2007 12:00:00 AM | 3 | 3X3 | 6002267.7577 | 2109821.1715 | 37.773294801594 | -122.435586477022 | (37.773294801594, -122.435586477022) | 15 | 5 | 11 | 29492 | 9 | ||
134191 | 242104 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 980 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003750.427 | 2102580.67234 | 37.7534982322778 | -122.429941144994 | (37.7534982322778, -122.429941144994) | 2 | 4 | 5 | 28862 | 22 | |||
137602 | 242103 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 980 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003749.00596 | 2102595.91053 | 37.753539992281 | -122.429947146145 | (37.753539992281, -122.429947146145) | 2 | 4 | 5 | 28862 | 22 | |||
124733 | 139648 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000741.7514 | 2112361.7335 | 37.7801837496249 | -122.441047428154 | (37.7801837496249, -122.441047428154) | 15 | 5 | 1 | 29490 | 41 | |||
158049 | 19510 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 4x4 | 6000739.4662845 | 2112395.3462739 | 37.78027591157 | -122.441057745549 | (37.78027591157, -122.441057745549) | 15 | 5 | 1 | 29490 | 41 | |||
20217 | 218570 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546 | (37.7305168532543, -122.47426667546) | 9 | 8 | 4 | 64 | 40 | |||
20554 | 218572 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 3 | : | Tree | Private 2 | 6 | Width 3ft | 5990712.73892 | 2094463.91628 | 37.7304647357382 | -122.474435535782 | (37.7304647357382, -122.474435535782) | 9 | 8 | 4 | 64 | 40 | |||
128682 | 218571 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Rossmoor Dr | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5990740.27734 | 2094470.45315 | 37.7304842798098 | -122.474340809303 | (37.7304842798098, -122.474340809303) | 9 | 8 | 4 | 64 | 40 | |||
96124 | 242862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005927.34644 | 2109152.65833 | 37.7716664010214 | -122.422879920976 | (37.7716664010214, -122.422879920976) | 8 | 2 | 9 | 28853 | 19 | |||
167900 | 241241 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006130.56818 | 2109161.24748 | 37.7717014494004 | -122.422177573853 | (37.7717014494004, -122.422177573853) | 8 | 2 | 9 | 28853 | 19 | |||
188931 | 242861 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005943.14409 | 2109153.03232 | 37.7716683192733 | -122.422825302451 | (37.7716683192733, -122.422825302451) | 8 | 2 | 9 | 28853 | 19 | |||
85792 | 237085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Hoff St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006552.13964 | 2106214.02177 | 37.7636328345225 | -122.420510089594 | (37.7636328345225, -122.420510089594) | 8 | 4 | 7 | 28859 | 19 | |||
115376 | 243276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Hoff St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006552.66122 | 2106194.3589 | 37.7635788742896 | -122.42050688979 | (37.7635788742896, -122.42050688979) | 8 | 4 | 7 | 28859 | 19 | |||
187465 | 237084 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006548.40896 | 2106250.77586 | 37.7637335423826 | -122.420525601982 | (37.7637335423826, -122.420525601982) | 8 | 4 | 7 | 28859 | 19 | |||
56166 | 241659 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005992.80292 | 2099970.75678 | 37.7464587376849 | -122.422001124173 | (37.7464587376849, -122.422001124173) | 2 | 7 | 5 | 28859 | 22 | |||
69347 | 136857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006964.61401 | 2114500.55499 | 37.7864089064042 | -122.41967145198 | (37.7864089064042, -122.41967145198) | 13 | 9 | 9 | 28858 | 36 | |||
82920 | 136856 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Cedar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006975.39457 | 2114504.09716 | 37.7864192396018 | -122.4196344053 | (37.7864192396018, -122.4196344053) | 13 | 9 | 9 | 28858 | 36 | |||
57274 | 123745 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5995418.55494 | 2110821.81217 | 37.7756508992149 | -122.459351125835 | (37.7756508992149, -122.459351125835) | 11 | 6 | 2 | 54 | 11 | ||
7712 | 242303 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 6006798.43283 | 2109401.96826 | 37.7724000589509 | -122.4198844681 | (37.7724000589509, -122.4198844681) | 8 | 2 | 9 | 28853 | 19 | ||
10758 | 242302 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6006775.56275 | 2109426.23035 | 37.7724653884074 | -122.419965300064 | (37.7724653884074, -122.419965300064) | 8 | 2 | 9 | 28853 | 19 | ||
15987 | 87029 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775743 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | 8 | 2 | 9 | 28853 | 19 | |
91515 | 87030 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49973 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | 8 | 2 | 9 | 28853 | 19 | |
169606 | 138991 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 979 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003203.9527 | 2110647.2389 | 37.7756161076176 | -122.432407064392 | (37.7756161076176, -122.432407064392) | 15 | 9 | 11 | 29492 | 10 | |||
27382 | 10349 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 978 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2012 12:00:00 AM | 3 | 4x6 | 6001439.9402 | 2109063.1942 | 37.7711665324235 | -122.438395689895 | (37.7711665324235, -122.438395689895) | 15 | 5 | 11 | 29492 | 9 | ||
55064 | 242280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 97 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002430.06906 | 2096216.55505 | 37.7359489931432 | -122.434052324679 | (37.7359489931432, -122.434052324679) | 2 | 7 | 5 | 63 | 7 | |||
73832 | 242278 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 97 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002416.5475 | 2096231.48102 | 37.7359892090275 | -122.434100140709 | (37.7359892090275, -122.434100140709) | 2 | 7 | 5 | 63 | 7 | |||
90687 | 242279 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 97 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002424.06039 | 2096223.23738 | 37.7359670002736 | -122.434073576558 | (37.7359670002736, -122.434073576558) | 2 | 7 | 5 | 63 | 7 | |||
191613 | 242281 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 97 Surrey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002436.28815 | 2096209.43112 | 37.7359297854187 | -122.434030313749 | (37.7359297854187, -122.434030313749) | 2 | 7 | 5 | 63 | 7 | |||
4652 | 35361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 969 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 4 | Permit Number 38823 | 6011919.41112 | 2103909.48398 | 37.7576060979734 | -122.401784268334 | (37.7576060979734, -122.401784268334) | 10 | 3 | 8 | 28856 | 29 | |
104627 | 198041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 966 Natoma St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6007944.08688 | 2109820.93616 | 37.7736149216237 | -122.415951204886 | (37.7736149216237, -122.415951204886) | 8 | 2 | 9 | 28853 | 34 | |||
166565 | 198042 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 966 Natoma St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6007955.48118 | 2109829.77546 | 37.7736398328458 | -122.415912416224 | (37.7736398328458, -122.415912416224) | 8 | 2 | 9 | 28853 | 34 | |||
200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
111207 | 32152 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | 3x3 | Permit Number 35503 | 6003262.9720017 | 2110652.44096654 | 37.7756337376694 | -122.432203273909 | (37.7756337376694, -122.432203273909) | 15 | 9 | 11 | 29492 | 10 | |
4529 | 160228 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 960 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001238.61931 | 2088721.92434 | 37.7153027532862 | -122.437635063623 | (37.7153027532862, -122.437635063623) | 9 | 7 | 6 | 28861 | 5 | ||
164640 | 242001 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 960 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009389.49526 | 2103586.96463 | 37.7565790236267 | -122.410511007101 | (37.7565790236267, -122.410511007101) | 2 | 4 | 7 | 28859 | 19 | |||
50045 | 214959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 San Andreas Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993574.3517 | 2095241.11953 | 37.7327641241706 | -122.464599021031 | (37.7327641241706, -122.464599021031) | 9 | 8 | 4 | 59 | 40 | |||
95931 | 214961 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 San Andreas Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993562.89782 | 2095215.21804 | 37.7326923447694 | -122.464636739504 | (37.7326923447694, -122.464636739504) | 9 | 8 | 4 | 59 | 40 | |||
190129 | 214960 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 San Andreas Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993567.2652 | 2095228.36715 | 37.7327287007546 | -122.464622594975 | (37.7327287007546, -122.464622594975) | 9 | 8 | 4 | 59 | 40 | |||
65905 | 254352 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781320 | 6011026.29864 | 2088238.77352 | 37.7145277707382 | -122.403770388077 | (37.7145277707382, -122.403770388077) | 9 | 7 | 8 | 309 | 39 |
127531 | 19509 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6000691.8143212 | 2112375.2561029 | 37.7802180348157 | -122.4412211534 | (37.7802180348157, -122.4412211534) | 15 | 5 | 1 | 29490 | 16 | |||
179609 | 19508 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000691.8143212 | 2112375.2561029 | 37.7802180348157 | -122.4412211534 | (37.7802180348157, -122.4412211534) | 15 | 5 | 1 | 29490 | 16 | |||
3957 | 101709 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 95X Milton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.429360672359 | (37.7334469335284, -122.429360672359) | 2 | 7 | 5 | 28861 | 25 | ||||
106379 | 242102 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 958 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003747.21802 | 2102677.52154 | 37.7537639756265 | -122.429959150315 | (37.7537639756265, -122.429959150315) | 2 | 4 | 5 | 28862 | 22 | |||
148358 | 39509 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 958 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40961 | 6003748.2922704 | 2102673.97071857 | 37.7537542867453 | -122.429955182043 | (37.7537542867453, -122.429955182043) | 2 | 4 | 5 | 28862 | 22 | ||
107152 | 247412 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 955 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002000.2833 | 2109442.3236 | 37.7722393839925 | -122.436484585301 | (37.7722393839925, -122.436484585301) | 15 | 5 | 11 | 29492 | 9 | |||
124168 | 247411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 955 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002024.0271 | 2109445.0372 | 37.7722481840495 | -122.436402647798 | (37.7722481840495, -122.436402647798) | 15 | 5 | 11 | 29492 | 9 | |||
53003 | 89348 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 954 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51932 | 6014423.4461 | 2089689.5134 | 37.7187004128037 | -122.39212978087 | (37.7187004128037, -122.39212978087) | 10 | 3 | 8 | 58 | 1 | |
167363 | 162771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 954 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2017 10:37:00 AM | 3 | Width 0ft | 5995054.32818 | 2090275.30897 | 37.7192144129887 | -122.459122957373 | (37.7192144129887, -122.459122957373) | 9 | 8 | 6 | 28861 | 24 | ||
164512 | 242314 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 953 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005731.38967 | 2103485.55664 | 37.7560948214478 | -122.423154856305 | (37.7560948214478, -122.423154856305) | 2 | 4 | 5 | 28859 | 19 | |||
104288 | 214855 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 952 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5992759.79285 | 2106648.41249 | 37.7640386338056 | -122.468244687344 | (37.7640386338056, -122.468244687344) | 11 | 8 | 11 | 56 | 12 | |||
157802 | 69090 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 952 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33102 | 5992844.10994008 | 2106645.81494842 | 37.7640363710788 | -122.467952872913 | (37.7640363710788, -122.467952872913) | 11 | 8 | 11 | 56 | 12 | ||
89466 | 180359 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 952 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998466.40456 | 2089317.70711 | 37.7167806236002 | -122.447259868958 | (37.7167806236002, -122.447259868958) | 9 | 7 | 6 | 28861 | 25 | |||
115259 | 180360 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 952 Delano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998452.56484 | 2089292.31285 | 37.7167101059706 | -122.447305879179 | (37.7167101059706, -122.447305879179) | 9 | 7 | 6 | 28861 | 25 | |||
172140 | 180358 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 952 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998479.18294 | 2089342.08749 | 37.716848296685 | -122.447217454239 | (37.716848296685, -122.447217454239) | 9 | 7 | 6 | 28861 | 25 | |||
15692 | 247491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6001998.5873 | 2109485.4017 | 37.7723575693759 | -122.436493535723 | (37.7723575693759, -122.436493535723) | 15 | 5 | 11 | 29492 | 9 | |||
34985 | 198017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 950 Clara St | 6 | : | Tree | Private 2 | 3 | Width 2ft | 6011612.66203 | 2111564.03025 | 37.7786066257438 | -122.403383627176 | (37.7786066257438, -122.403383627176) | 14 | 2 | 9 | 28856 | 34 |
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) );