trees
7,322 rows where qSpecies_id = 1 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
605 | 52150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 5 | Permit Number 48341 | 6014994.17904 | 2096246.44188 | 37.7367360986871 | -122.390614910664 | (37.7367360986871, -122.390614910664) | 10 | 3 | 8 | 58 | 1 | |
1221 | 154034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1670 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6014842.11456 | 2097062.95564 | 37.7389696405262 | -122.391197725313 | (37.7389696405262, -122.391197725313) | 10 | 3 | 8 | 58 | 1 | |||
1271 | 256035 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1478 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x5 | 6015597 | 2093725 | 37.7298461523087 | -122.388354746587 | (37.7298461523087, -122.388354746587) | 10 | 3 | 8 | 58 | 1 | ||
1636 | 199812 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1450 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015205.5584 | 2091901.4217 | 37.7248172716421 | -122.389580707536 | (37.7248172716421, -122.389580707536) | 10 | 3 | 8 | 58 | 1 | |||
1737 | 121771 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016276.86465 | 2101451.8833 | 37.7511002511867 | -122.386542923434 | (37.7511002511867, -122.386542923434) | 10 | 3 | 8 | 58 | 1 | |||
2142 | 84383 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012616.61055 | 2098993.72766 | 37.7441473756935 | -122.399028026147 | (37.7441473756935, -122.399028026147) | 10 | 3 | 8 | 58 | 1 | |||
2476 | 61679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21676 | 6013741.75867 | 2093626.49588 | 37.729472702598 | -122.394761681005 | (37.729472702598, -122.394761681005) | 10 | 3 | 8 | 58 | 1 | |
2872 | 47238 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | Permit Number 45189 | 6014641.0147 | 2090577.1277 | 37.7211497042731 | -122.39143974641 | (37.7211497042731, -122.39143974641) | 10 | 3 | 8 | 58 | 1 |
2906 | 121776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6016268.76318 | 2101583.58756 | 37.7514614351207 | -122.386580122093 | (37.7514614351207, -122.386580122093) | 10 | 3 | 8 | 58 | 1 | |||
3540 | 198190 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3308 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013400.76782 | 2089956.39224 | 37.7193763737002 | -122.395683481624 | (37.7193763737002, -122.395683481624) | 10 | 3 | 8 | 58 | 1 | |||
3747 | 36212 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2006 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
4328 | 36209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
4920 | 12041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | ||
4987 | 84397 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012443.22283 | 2099122.96445 | 37.7444925687938 | -122.399636638738 | (37.7444925687938, -122.399636638738) | 10 | 3 | 8 | 58 | 1 | |||
4994 | 260596 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 4x6 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | |
5402 | 259405 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6013491.54198 | 2090383.23631 | 37.7205534514179 | -122.395399593578 | (37.7205534514179, -122.395399593578) | 10 | 3 | 8 | 58 | 1 | ||
5497 | 200583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016440.4137 | 2094932.3213 | 37.7332079157453 | -122.385523046608 | (37.7332079157453, -122.385523046608) | 10 | 3 | 8 | 58 | 1 | |||
5558 | 38535 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40515 | 6015241.886192 | 2096337.56497418 | 37.7370000434098 | -122.389764834673 | (37.7370000434098, -122.389764834673) | 10 | 3 | 8 | 58 | 1 | ||
5609 | 83165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1903 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015168.2313 | 2093359.9647 | 37.7288200702379 | -122.389811574581 | (37.7288200702379, -122.389811574581) | 10 | 3 | 8 | 58 | 1 | |||
5743 | 30556 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011713.13245 | 2086267.11073 | 37.7091523239944 | -122.40125793023 | (37.7091523239944, -122.40125793023) | 10 | 3 | 8 | 309 | 1 | ||
5940 | 84389 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012558.72681 | 2099037.97239 | 37.7442656365553 | -122.399231281913 | (37.7442656365553, -122.399231281913) | 10 | 3 | 8 | 58 | 1 | |||
5984 | 262524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 27 Ledyard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011604 | 2095169 | 37.7335890054418 | -122.402260572751 | (37.7335890054418, -122.402260572751) | 10 | 3 | 8 | 58 | 1 | ||||
6219 | 198125 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 75 Williams Ave | 5 | : | Tree | Private 2 | 9 | Width 3ft | 6013825.74476 | 2093610.04486 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | 10 | 3 | 8 | 58 | 1 | |||
6680 | 84384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012605.75567 | 2099001.93015 | 37.7441692930905 | -122.399066135804 | (37.7441692930905, -122.399066135804) | 10 | 3 | 8 | 58 | 1 | |||
6819 | 198078 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501 25th St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014189.20223 | 2101966.89329 | 37.752398567346 | -122.393798376688 | (37.752398567346, -122.393798376688) | 10 | 3 | 8 | 28856 | 1 | ||||
6889 | 173762 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.71929 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | 10 | 3 | 8 | 58 | 1 | |
7008 | 84391 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012539.7904 | 2099051.16113 | 37.744300794662 | -122.39929768604 | (37.744300794662, -122.39929768604) | 10 | 3 | 8 | 58 | 1 | |||
7336 | 29544 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2900X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2019 12:00:00 AM | 3 | 3X3 | 6014624.5697 | 2090476.0215 | 37.7208711738855 | -122.39148952766 | (37.7208711738855, -122.39148952766) | 10 | 3 | 8 | 58 | 1 | ||
7381 | 261038 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701 Phelps St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011783.11668 | 2093247.60163 | 37.728323242206 | -122.401506319354 | (37.728323242206, -122.401506319354) | 10 | 3 | 8 | 58 | 1 | ||
7674 | 259377 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1486 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015207.81311 | 2093285.95013 | 37.7286190359645 | -122.389669569097 | (37.7286190359645, -122.389669569097) | 10 | 3 | 8 | 58 | 1 | ||
7732 | 198246 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Navy Rd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018108.95866 | 2093601.24715 | 37.7296452240452 | -122.379661929856 | (37.7296452240452, -122.379661929856) | 10 | 3 | 8 | 58 | 1 | |||
7924 | 200199 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3125 Jennings St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 7 | Width 0ft | 6013712.0206 | 2090295.7773 | 37.7203255667293 | -122.394631341935 | (37.7203255667293, -122.394631341935) | 10 | 3 | 8 | 58 | 1 | ||
8026 | 71384 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1607 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015481.5732 | 2096159.9134 | 37.7365255368588 | -122.388923722935 | (37.7365255368588, -122.388923722935) | 10 | 3 | 8 | 58 | 1 | |||
8646 | 84388 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012568.10677 | 2099031.13024 | 37.7442473722189 | -122.399198367617 | (37.7442473722189, -122.399198367617) | 10 | 3 | 8 | 58 | 1 | |||
8862 | 84382 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012627.48932 | 2098986.68874 | 37.7441286545312 | -122.398989915558 | (37.7441286545312, -122.398989915558) | 10 | 3 | 8 | 58 | 1 | |||
9180 | 26891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1593X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1999 12:00:00 AM | 6 | 3X3 | 6015736.99422 | 2097371.34935 | 37.7398660478734 | -122.388125132194 | (37.7398660478734, -122.388125132194) | 10 | 3 | 8 | 58 | 1 | ||
9203 | 30559 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 4 | Permit Number 34540 | 6011712.00106 | 2086211.42806 | 37.7089993673055 | -122.401257930213 | (37.7089993673055, -122.401257930213) | 10 | 3 | 8 | 309 | 1 | ||
9597 | 88675 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
9636 | 84385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012596.88679 | 2099009.26073 | 37.7441889270701 | -122.399097317095 | (37.7441889270701, -122.399097317095) | 10 | 3 | 8 | 58 | 1 | |||
9887 | 84280 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016140.4247 | 2093648.9439 | 37.7296674147143 | -122.386470746676 | (37.7296674147143, -122.386470746676) | 10 | 3 | 8 | 58 | 1 | |||
10518 | 121773 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6016274.96779 | 2101507.19442 | 37.75125201898 | -122.386553339378 | (37.75125201898, -122.386553339378) | 10 | 3 | 8 | 58 | 1 | |||
11563 | 259753 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1229 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013525 | 2101361 | 37.7506979810533 | -122.396052856578 | (37.7506979810533, -122.396052856578) | 10 | 3 | 8 | 28856 | 1 | ||||
12265 | 200804 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 Arelious Walker Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6016205.7238 | 2089277.3654 | 37.717667530358 | -122.385940394841 | (37.717667530358, -122.385940394841) | 10 | 3 | 8 | 58 | 1 | |||
12314 | 200588 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 16 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016368.8303 | 2095045.3476 | 37.7335143024736 | -122.385778407329 | (37.7335143024736, -122.385778407329) | 10 | 3 | 8 | 58 | 1 | |||
12796 | 83871 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1431 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6016609.56128 | 2096718.62341 | 37.7381221005503 | -122.385062666315 | (37.7381221005503, -122.385062666315) | 10 | 3 | 8 | 58 | 1 | |||
12958 | 36213 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
12998 | 80732 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1951 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013374.43232 | 2096002.02585 | 37.7359749889588 | -122.396197995467 | (37.7359749889588, -122.396197995467) | 10 | 3 | 8 | 58 | 1 | |||
13160 | 36755 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39521 | 6011153.23525132 | 2095168.62195256 | 37.733562795365 | -122.403818978685 | (37.733562795365, -122.403818978685) | 10 | 3 | 8 | 58 | 1 | |||
13224 | 84394 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012485.34131 | 2099091.8442 | 37.7444094669397 | -122.399488816268 | (37.7444094669397, -122.399488816268) | 10 | 3 | 8 | 58 | 1 | |||
13411 | 262523 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 27 Ledyard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011604 | 2095169 | 37.7335890054418 | -122.402260572751 | (37.7335890054418, -122.402260572751) | 10 | 3 | 8 | 58 | 1 | ||||
13837 | 84396 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012453.41363 | 2099114.94176 | 37.7444711082579 | -122.399600837636 | (37.7444711082579, -122.399600837636) | 10 | 3 | 8 | 58 | 1 | |||
14058 | 260595 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | ||
14236 | 261123 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2006 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6012116.10801 | 2093842.55366 | 37.7299754321605 | -122.400396918667 | (37.7299754321605, -122.400396918667) | 10 | 3 | 8 | 58 | 1 | ||
14344 | 84278 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6016119.4924 | 2093666.0202 | 37.7297131440727 | -122.386544302761 | (37.7297131440727, -122.386544302761) | 10 | 3 | 8 | 58 | 1 | |||
14642 | 12098 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
15209 | 12164 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1439X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
15255 | 259404 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1443 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015439.42332 | 2092015.64337 | 37.7251438663465 | -122.388780227503 | (37.7251438663465, -122.388780227503) | 10 | 3 | 8 | 58 | 1 | ||
15373 | 84395 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012475.47106 | 2099099.19515 | 37.7444291009223 | -122.399523461754 | (37.7444291009223, -122.399523461754) | 10 | 3 | 8 | 58 | 1 | |||
15682 | 79032 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1475 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6015238.0441 | 2092152.5097 | 37.7255085106933 | -122.389485934479 | (37.7255085106933, -122.389485934479) | 10 | 3 | 8 | 58 | 1 | |||
15689 | 84390 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2101 Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012549.35386 | 2099045.14684 | 37.7442848136983 | -122.399264195308 | (37.7442848136983, -122.399264195308) | 10 | 3 | 8 | 58 | 1 | |||
16051 | 259371 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1483 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015539.17512 | 2093687.83967 | 37.729740913102 | -122.388552062738 | (37.729740913102, -122.388552062738) | 10 | 3 | 8 | 58 | 1 | ||
16098 | 200163 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014648.9326 | 2090536.3198 | 37.7210380933108 | -122.391409524959 | (37.7210380933108, -122.391409524959) | 10 | 3 | 8 | 58 | 1 | |
16177 | 12190 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1463 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016279.6460328 | 2095463.27872 | 37.734656922024 | -122.386115870582 | (37.734656922024, -122.386115870582) | 10 | 3 | 8 | 58 | 1 | ||
16379 | 22378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5545 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6014125.8203 | 2092742.8788 | 37.7270678150826 | -122.393372120942 | (37.7270678150826, -122.393372120942) | 10 | 3 | 8 | 58 | 1 | ||
16771 | 12133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X La Salle Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2015 07:34:00 AM | 3 | 3X3 | 6016420.28727 | 2095262.82518 | 37.7341142997293 | -122.385615655843 | (37.7341142997293, -122.385615655843) | 10 | 3 | 8 | 58 | 1 | ||
17415 | 121782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1501x Illinois St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6016262.89138 | 2101740.52577 | 37.7518920296128 | -122.386611369945 | (37.7518920296128, -122.386611369945) | 10 | 3 | 8 | 58 | 1 | |||
17421 | 200595 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 13 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016329.2711 | 2095082.3952 | 37.7336138386239 | -122.385917757569 | (37.7336138386239, -122.385917757569) | 10 | 3 | 8 | 58 | 1 | |||
17573 | 84279 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6016131.0603 | 2093656.105 | 37.7296865592841 | -122.386503619825 | (37.7296865592841, -122.386503619825) | 10 | 3 | 8 | 58 | 1 | |||
17627 | 50733 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1490 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2004 12:00:00 AM | 4 | Permit Number 47285 | 6015353.8122 | 2093538.7741 | 37.7293213347153 | -122.389182483794 | (37.7293213347153, -122.389182483794) | 10 | 3 | 8 | 58 | 1 | |
17655 | 259373 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1526 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015316.17509 | 2093903.39119 | 37.7303204136401 | -122.389338051321 | (37.7303204136401, -122.389338051321) | 10 | 3 | 8 | 58 | 1 | ||
17664 | 198242 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Navy Rd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6018274.99402 | 2093475.43151 | 37.7293089153583 | -122.379079187167 | (37.7293089153583, -122.379079187167) | 10 | 3 | 8 | 58 | 1 | |||
18115 | 259375 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1562 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015131.96015 | 2094040.00388 | 37.7306853098384 | -122.389984452411 | (37.7306853098384, -122.389984452411) | 10 | 3 | 8 | 58 | 1 | ||
18613 | 59677 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1700 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1981 12:00:00 AM | 10 | 3x3 | Permit Number 19103 | 6014064.15131 | 2093105.02491 | 37.728058768696 | -122.393610646816 | (37.728058768696, -122.393610646816) | 10 | 3 | 8 | 58 | 1 |
18881 | 200582 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016451.0884 | 2094912.8556 | 37.733155057434 | -122.385484784854 | (37.733155057434, -122.385484784854) | 10 | 3 | 8 | 58 | 1 | |||
19758 | 200589 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 18 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016356.8997 | 2095071.7205 | 37.7335860569774 | -122.385821492802 | (37.7335860569774, -122.385821492802) | 10 | 3 | 8 | 58 | 1 |
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) );