trees
7,322 rows where qSpecies_id = 1 sorted by qLegalStatus_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▲ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143556 | 112627 | Section 143 10 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2385 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002100 | 2114635 | 37.7865028312467 | -122.436511387034 | (37.7865028312467, -122.436511387034) | 13 | 6 | 1 | 29490 | 27 | ||||
179441 | 94563 | Section 143 10 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Oak St | 3 | Sidewalk: Curb side : | Tree | Private 2 | 09/15/2010 12:00:00 AM | Permit Number 53745 | 6005493 | 2110231 | 37.7746027492624 | -122.424459067949 | (37.7746027492624, -122.424459067949) | 7 | 9 | 11 | 28852 | 10 | |||
585 | 75271 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015975.8041 | 2106880.05369 | 37.7659881814233 | -122.387962771269 | (37.7659881814233, -122.387962771269) | 14 | 3 | 9 | 310 | 20 | ||
2007 | 188784 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015979.83831 | 2106803.95395 | 37.7657794514949 | -122.387943506912 | (37.7657794514949, -122.387943506912) | 14 | 3 | 9 | 310 | 20 | |||
4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
5551 | 74240 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015971.85212 | 2106927.76687 | 37.7661189725478 | -122.387979770277 | (37.7661189725478, -122.387979770277) | 14 | 3 | 9 | 310 | 20 | ||
5864 | 189275 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015964.59668 | 2107087.77889 | 37.7665579289401 | -122.388016032733 | (37.7665579289401, -122.388016032733) | 14 | 3 | 9 | 310 | 20 | |||
6900 | 102545 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015962.79104 | 2107111.95809 | 37.7666242197475 | -122.38802396564 | (37.7666242197475, -122.38802396564) | 14 | 3 | 9 | 310 | 20 | ||
7177 | 74026 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015970.5058 | 2106958.46215 | 37.7662031805546 | -122.387986569137 | (37.7662031805546, -122.387986569137) | 14 | 3 | 9 | 310 | 20 | ||
9264 | 188788 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015967.32751 | 2107012.0323 | 37.7663500965054 | -122.388001300914 | (37.7663500965054, -122.388001300914) | 14 | 3 | 9 | 310 | 20 | |||
9465 | 260400 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
9799 | 188783 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015981.68348 | 2106781.73126 | 37.7657185350155 | -122.387935573977 | (37.7657185350155, -122.387935573977) | 14 | 3 | 9 | 310 | 20 | |||
10795 | 188785 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015978.05896 | 2106829.43815 | 37.7658493270204 | -122.38795143981 | (37.7658493270204, -122.38795143981) | 14 | 3 | 9 | 310 | 20 | |||
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 | ||||
13110 | 188782 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015982.12636 | 2106754.96915 | 37.7656450765832 | -122.387932174526 | (37.7656450765832, -122.387932174526) | 14 | 3 | 9 | 310 | 20 | |||
13982 | 189273 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015966.51086 | 2107036.5181 | 37.7664172839651 | -122.388005834417 | (37.7664172839651, -122.388005834417) | 14 | 3 | 9 | 310 | 20 | |||
14181 | 188787 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015968.04519 | 2106982.6549 | 37.7662694722874 | -122.387996768362 | (37.7662694722874, -122.387996768362) | 14 | 3 | 9 | 310 | 20 | |||
17556 | 75105 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015973.99843 | 2106904.23323 | 37.7660544731729 | -122.387970704195 | (37.7660544731729, -122.387970704195) | 14 | 3 | 9 | 310 | 20 | ||
17659 | 188786 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015977.25571 | 2106854.57611 | 37.7659183059205 | -122.387955972402 | (37.7659183059205, -122.387955972402) | 14 | 3 | 9 | 310 | 20 | |||
18169 | 189274 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015965.43281 | 2107064.27168 | 37.7664934295578 | -122.388011500129 | (37.7664934295578, -122.388011500129) | 14 | 3 | 9 | 310 | 20 | |||
18936 | 260399 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
41193 | 16883 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
47945 | 16888 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
68363 | 16887 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
69117 | 16884 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
106383 | 122643 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
133992 | 16886 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
136268 | 122644 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
144187 | 16882 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
172318 | 122641 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
176217 | 122642 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
180187 | 112262 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | 2 | 7 | 7 | 28859 | 2 | |||
184134 | 16885 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
154591 | 112948 | Property Tree 8 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.422639431486 | (37.7280608613968, -122.422639431486) | 9 | 7 | 7 | 309 | 5 | ||
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 | ||
733 | 218511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43359 | 5996829.51445 | 2089654.64111 | 37.7176120972009 | -122.45294206803 | (37.7176120972009, -122.45294206803) | 9 | 8 | 6 | 28861 | 24 | |
1112 | 8732 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3210 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1996 12:00:00 AM | 6 | 3X3 | 5997102.31429 | 2113088.26659 | 37.7819706522719 | -122.453690315182 | (37.7819706522719, -122.453690315182) | 11 | 6 | 1 | 54 | 31 | ||
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 | |||
1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
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 | ||||
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 | ||
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 | ||
3012 | 15898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.15292 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | |||
5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
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 | ||||
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 | |||
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 | ||||||||||||||
8819 | 218630 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 823 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777479 | 5990637.31518 | 2099027.3446 | 37.7429903745186 | -122.475029277203 | (37.7429903745186, -122.475029277203) | 1 | 8 | 4 | 29491 | 40 | |
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 | |
9274 | 218494 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 772989 | 5994534.17979 | 2089038.5715 | 37.7157887100619 | -122.460831317629 | (37.7157887100619, -122.460831317629) | 9 | 8 | 6 | 28861 | 24 | |
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 | ||
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 | ||
10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
10508 | 220252 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002022.45837 | 2099900.18777 | 37.7460402480521 | -122.435725060979 | (37.7460402480521, -122.435725060979) | 2 | 7 | 5 | 63 | 22 | |
10638 | 15720 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4357X Mission St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/1995 12:00:00 AM | 6 | 3x3 | 6002851.16985 | 2093165.53011 | 37.7275954613369 | -122.432378570152 | (37.7275954613369, -122.432378570152) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
10847 | 17720 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |
11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
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 | |||
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 | ||
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 | |||
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 | ||||||||||||||
14294 | 220251 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002021.86814 | 2099888.44032 | 37.746007958796 | -122.435726261582 | (37.746007958796, -122.435726261582) | 2 | 7 | 5 | 63 | 22 | |
14317 | 38265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 711 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | 6 | 3x3 | Permit Number 40366 | 6015782.17100529 | 2103924.24418542 | 37.7578614341223 | -122.388426186906 | (37.7578614341223, -122.388426186906) | 10 | 3 | 8 | 28856 | 29 |
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 | ||
15581 | 46699 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 8 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 |
15987 | 87029 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775743 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | 8 | 2 | 9 | 28853 | 19 | |
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 | ||
16251 | 28441 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2301 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992413.94145 | 2094015.73092 | 37.7293325470846 | -122.468521689844 | (37.7293325470846, -122.468521689844) | 9 | 8 | 4 | 59 | 40 | ||
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 | |||
17243 | 218510 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Lakeview Ave | 1 | : | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43360 | 5996781.43157 | 2089689.53525 | 37.7177051527504 | -122.453110785357 | (37.7177051527504, -122.453110785357) | 9 | 8 | 6 | 28861 | 24 | |
17490 | 255503 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 335 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781972 | 5997864.63144 | 2093785.59571 | 37.729013998385 | -122.449661668302 | (37.729013998385, -122.449661668302) | 9 | 7 | 4 | 28861 | 40 |
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 | |||
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 | ||||||||||||||
18527 | 217598 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5995477.9337 | 2092057.9786 | 37.7241335428618 | -122.457787649757 | (37.7241335428618, -122.457787649757) | 9 | 8 | 4 | 28861 | 24 | ||
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 | ||
19007 | 216971 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991715.0131 | 2104457.47271 | 37.7579624956851 | -122.471698563334 | (37.7579624956851, -122.471698563334) | 1 | 8 | 4 | 56 | 12 |
19722 | 28629 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | 9 | 8 | 4 | 28861 | 24 | ||
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 | ||||
20046 | 216968 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991682.07127 | 2104398.96183 | 37.7577999342364 | -122.471808224875 | (37.7577999342364, -122.471808224875) | 1 | 8 | 4 | 56 | 12 |
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) );