7,322 rows where qSpecies_id = 1 sorted by DBH

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)
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
680 47114 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 65 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM     Permit Number 45098 6008176.0434029 2098254.72889507 37.7418697970416 -122.414330302805 (37.7418697970416, -122.414330302805) 2 7 7 28859 2
976 258329 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 105 Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5998052 2087327 37.7112909098977 -122.448548966881 (37.7112909098977, -122.448548966881) 9 7 6 28861 25
1095 255202 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1125 101207 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 3 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
1229 264907 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
1358 109891 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1398x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013218 2106201 37.7639704813344 -122.397453893083 (37.7639704813344, -122.397453893083) 14 3 8 28856 29
1499 262277 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996515 2091798 37.7234792274288 -122.454183919247 (37.7234792274288, -122.454183919247) 9 8 4 28861 24
1651 37169 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 151 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1998 12:00:00 AM     Permit Number 39743 6005565.93572779 2099898.57048032 37.7462364463923 -122.423472053683 (37.7462364463923, -122.423472053683) 2 7 5 28859 22
1788 262276 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996515 2091798 37.7234792274288 -122.454183919247 (37.7234792274288, -122.454183919247) 9 8 4 28861 24
2879 261758 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 49 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007215 2095432 37.7340651744382 -122.417453284567 (37.7340651744382, -122.417453284567) 2 7 7 28859 2
2913 264905 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 3 Median : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
2937 104069 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1340 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2013 12:00:00 AM   3x3 Permit Number 770297 6007143.4 2107674.1 37.7676751698972 -122.418568643249 (37.7676751698972, -122.418568643249) 8 4 7 28853 19
3289 262310 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1356 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM       5989914.31197 2106134.19071 37.7624619657204 -122.478048663847 (37.7624619657204, -122.478048663847) 1 8 3 56 35
3648 262535 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 15 Russia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 10/05/2019 12:00:00 AM   3x3   6001472.85598 2090996.66296 37.7215619917613 -122.43698819828 (37.7215619917613, -122.43698819828) 9 7 6 28861 5
3728 264799 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 698 Dwight St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009708 2091117 37.7223570514359 -122.408529889307 (37.7223570514359, -122.408529889307) 10 3 7 309 28
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
3824 252901 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 598 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
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
4009 54330 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1257 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2012 12:00:00 AM     Permit Number 769330 5994831.50805386 2106979.48216267 37.7650671008227 -122.461103283683 (37.7650671008227, -122.461103283683) 15 5 11 56 12
4112 255223 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
4232 264908 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
4314 261587 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2700x San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5997075 2088509 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306) 9 8 6 28861 24
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
4368 262109 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 340 Oak St 10 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6005374.8248 2110307.1287 37.7748051060186 -122.424873276976 (37.7748051060186, -122.424873276976) 7 9 11 28852 10
4458 37157 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 88 29th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1998 12:00:00 AM     Permit Number 39737 6005841.01788139 2099087.47125623 37.7440248746354 -122.422463228878 (37.7440248746354, -122.422463228878) 2 7 5 28859 2
4712 39418 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401Bldg #8 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40928 6004636.26366245 2109802.84186708 37.773378713416 -122.427392181999 (37.773378713416, -122.427392181999) 7 9 11 28852 10
5291 95249 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 483 22nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989019.4 2112018.5 37.778566675209 -122.4815747855 (37.778566675209, -122.4815747855) 11 6 2 55 26
5493 264903 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
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
5603 36757 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1578 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39522 5993099.35503511 2104739.07158377 37.7588156897013 -122.466931435386 (37.7588156897013, -122.466931435386) 1 8 4 56 12
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
6071 258212 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2501 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987967 2106401 37.7630813299835 -122.484803190012 (37.7630813299835, -122.484803190012) 1 8 3 56 35
6355 100391 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 226 Paris St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x7   6002817 2092256 37.7250961583897 -122.432431760897 (37.7250961583897, -122.432431760897) 9 7 6 28861 5
6640 255204 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6672 39412 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401Bldg #8 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1998 12:00:00 AM     Permit Number 40928 6004636.26366245 2109802.84186708 37.773378713416 -122.427392181999 (37.773378713416, -122.427392181999) 7 9 11 28852 10
6675 264798 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 698 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009708 2091117 37.7223570514359 -122.408529889307 (37.7223570514359, -122.408529889307) 10 3 7 309 28
6742 264909 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
6874 258105 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 49 Naglee Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1           5998652.17813 2087511.67596 37.7118322871785 -122.446487885746 (37.7118322871785, -122.446487885746) 9 7 6 28861 25
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
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                    
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                            
8231 258103 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 4001 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1           5994656.53411 2112804.2386 37.7810502710743 -122.462130924837 (37.7810502710743, -122.462130924837) 11 6 2 54 11
8354 261712 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 31 Ruth St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001602.2183 2091588.36368 37.7231940205575 -122.436583359467 (37.7231940205575, -122.436583359467) 9 7 6 28861 25
8506 258378 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1100 Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x5   6007594.19766 2093376.79647 37.7284433601031 -122.415996783146 (37.7284433601031, -122.415996783146) 9 3 7 309 5
9006 112755 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 2038 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM   3x3   5989157.5 2111303.8 37.7766123371313 -122.481044705999 (37.7766123371313, -122.481044705999) 11 6 2 55 26
9127 95439 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1874 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM   3x3 Permit Number 767301 5986339.2 2102491.9 37.7522530747906 -122.490145565656 (37.7522530747906, -122.490145565656) 1 8 3 56 35
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
9674 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree Private 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
9772 95689 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2415 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767440 5982968.9 2098671.4 37.7415656423265 -122.501517800216 (37.7415656423265, -122.501517800216) 1 8 3 29491 35
9965 83767 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 280 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2008 12:00:00 AM   3x3 Permit Number 51874 6004709.30002437 2099902.50025003 37.7461988489012 -122.42643447623 (37.7461988489012, -122.42643447623) 2 7 5 63 22
10561 261942 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1 Verna St 7 Unaccepted Street : Yard Tree Private 2       Width 3ft   5998303 2096292 37.7359210601709 -122.448326617787 (37.7359210601709, -122.448326617787) 9 7 4 59 40
10640 41309 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 34 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2000 12:00:00 AM     Permit Number 41981 5992910.03093479 2098919.83529447 37.7428266345167 -122.467163100034 (37.7428266345167, -122.467163100034) 1 8 4 59 40
11066 96252 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/18/2011 12:00:00 AM     Permit Number 56953 5996248.46954 2091917.74069 37.7237927195289 -122.455113909949 (37.7237927195289, -122.455113909949) 9 7 4 28861 40
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                            
11388 101208 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 4 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
11477 261366 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 39 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007224 2095531 37.7343375131321 -122.417429182406 (37.7343375131321, -122.417429182406) 2 7 7 28859 2
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
11571 258104 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 118 Circular Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       5x3   6001282.24432 2094484.29682 37.7311274034584 -122.437896768674 (37.7311274034584, -122.437896768674) 9 7 4 63 40
11767 255200 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
11880 42194 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1016 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42470 6010410.48288619 2109291.59089856 37.772299817533 -122.407382201369 (37.772299817533, -122.407382201369) 14 2 9 28853 34
12582 32159 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 600 Linden St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1995 12:00:00 AM     Permit Number 35508 6004513.09393523 2110705.7048246 37.77585078754 -122.42788259012 (37.77585078754, -122.42788259012) 7 9 11 28852 10
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
13025 258109 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 737 Woolsey St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x5   6009616.36663 2091549.37053 37.7235391182911 -122.408877136022 (37.7235391182911, -122.408877136022) 9 3 7 309 28
13150 44035 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1147 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2000 12:00:00 AM     Permit Number 43570 6003860.00449326 2101604.35206058 37.75082369093 -122.429492581147 (37.75082369093, -122.429492581147) 2 4 5 28862 22
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
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
13565 104520 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 295-299 Lee Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2013 12:00:00 AM   3x3 Permit Number 770416 5996485.8 2091712.7 37.723243339338 -122.454278699409 (37.723243339338, -122.454278699409) 9 8 4 28861 24
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                            
13918 112756 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 590x 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2015 12:00:00 AM   3x3   5989085.68012 2111584.93801 37.7773800886213 -122.481313741677 (37.7773800886213, -122.481313741677) 11 6 2 55 26
14125 258397 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 400 Persia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     5x4   6002678.8614 2090971.0772 37.7215602134912 -122.432817540406 (37.7215602134912, -122.432817540406) 9 7 6 28861 5
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                    
14366 32816 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3770 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37175 6003302.6047116 2103041.70072149 37.7547387357637 -122.431522720463 (37.7547387357637, -122.431522720463) 2 4 5 28862 22
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                    
14454 32825 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 4388 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37183 6000688.62823937 2102311.71658566 37.752585873246 -122.440510188354 (37.752585873246, -122.440510188354) 2 4 5 28862 22
14457 262275 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996515 2091798 37.7234792274288 -122.454183919247 (37.7234792274288, -122.454183919247) 9 8 4 28861 24
15329 264906 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
15549 264810 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 56 Keystone Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994250 2093087 37.7268883657721 -122.462106990145 (37.7268883657721, -122.462106990145) 9 8 4 28861 40
15903 255203 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
16076 261362 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 22 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007176 2095611 37.7345544747405 -122.417600802536 (37.7345544747405, -122.417600802536) 2 7 7 28859 2
16174 107381 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 14 MOSS ST   Sidewalk: Curb side : Cutout Tree Private 2           6010161.8 2111354.5 37.7779501635385 -122.408387955783 (37.7779501635385, -122.408387955783) 14 2 9 28853 34
16478 49101 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 601 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2003 12:00:00 AM     Permit Number 46246 6012933.18722113 2110757.22353588 37.7764649850887 -122.398758756879 (37.7764649850887, -122.398758756879) 14 2 9 28856 20
17090 261200 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 699x Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
17820 101211 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 7 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
17933 264904 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 259 Clara St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011556 2111491 37.778402936715 -122.403574504421 (37.778402936715, -122.403574504421) 14 2 9 28856 34
18197 261588 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2700x San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5997075 2088509 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306) 9 8 6 28861 24
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                    
18643 36313 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 110 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1998 12:00:00 AM     Permit Number 39291 5996172.05456486 2093809.43581436 37.7289824784834 -122.455514723268 (37.7289824784834, -122.455514723268) 9 7 4 28861 40
19029 110863 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1608 20TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013178 2104809 37.7601461286042 -122.397494610871 (37.7601461286042, -122.397494610871) 10 3 8 28856 29
19199 258106 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3400 California St 2 Sidewalk: Curb side : Tree DPW 1           5998152.86517 2114854.93765 37.7868816373151 -122.45018328933 (37.7868816373151, -122.45018328933) 11 6 1 54 31
19212 114723 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1798x 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM   3x3 Permit Number 776812 5989675.01356 2103450.6164 37.7550796972417 -122.478680033071 (37.7550796972417, -122.478680033071) 1 8 3 56 35
19766 100334 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 2 Sidewalk: Curb side : Cutout Tree Private 2       2x9   6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
20053 88130 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 822 Duncan St   Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51154 6001234 2099702 37.7454512540188 -122.438437243524 (37.7454512540188, -122.438437243524) 2 4 5 63 22
20387 40292 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3695X 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41437 6005149.32455817 2101953.724968 37.7518559035882 -122.425058847152 (37.7518559035882, -122.425058847152) 2 4 5 28859 19
20409 34062 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1960 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37964 6008029.26997895 2107027.39297988 37.7659492963405 -122.415458730511 (37.7659492963405, -122.415458730511) 8 4 7 28853 19
21046 95730 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 207 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767476 6004003.2 2092421.6 37.7256180518537 -122.428342990208 (37.7256180518537, -122.428342990208) 9 7 6 28861 5
21110 87947 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 145 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50970 6000915.1 2105542.6 37.7614699863558 -122.439958652567 (37.7614699863558, -122.439958652567) 15 5 5 28862 3

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