trees
7,322 rows where qSpecies_id = 1 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );