7,322 rows where qSpecies_id = 1 sorted by Neighborhoods (old)

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);