trees
3,965 rows where qSpecies_id = 70 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23222 | 53937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 174 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 12 | 3x4 | Permit Number 9651 | 5993070.40109 | 2114326.65829 | 37.7851389689099 | -122.467728857293 | (37.7851389689099, -122.467728857293) | 11 | 6 | 2 | 54 | 11 | |
1631 | 30310 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
14545 | 30309 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
194294 | 111846 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785307 | 6000128.0406 | 2117924.83666 | 37.7954236080649 | -122.443570269862 | (37.7954236080649, -122.443570269862) | 13 | 9 | 1 | 57 | 17 | |
194295 | 111848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.46619 | 2117938.95057 | 37.7954623283723 | -122.443573271789 | (37.7954623283723, -122.443573271789) | 13 | 9 | 1 | 57 | 17 | ||
194303 | 111847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.3505 | 2117932.29224 | 37.7954440397598 | -122.443573193555 | (37.7954440397598, -122.443573193555) | 13 | 9 | 1 | 57 | 17 | ||
194313 | 111849 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 785307 | 6000127.71624 | 2117950.98913 | 37.7954953973371 | -122.443573271798 | (37.7954953973371, -122.443573271798) | 13 | 9 | 1 | 57 | 17 | ||
194273 | 263629 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1985X Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 785142 | 6000955 | 2090559 | 37.7203308201534 | -122.438746936552 | (37.7203308201534, -122.438746936552) | 9 | 7 | 6 | 28861 | 25 | |||
8988 | 125125 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2921 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | Permit Number 784827 | 5999533.93344 | 2117358.43143 | 37.7938345087112 | -122.445585222496 | (37.7938345087112, -122.445585222496) | 13 | 9 | 1 | 57 | 27 | ||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
183780 | 218318 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 407 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/07/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782718 | 5993261.50766 | 2099931.86652 | 37.7456256983858 | -122.466021325821 | (37.7456256983858, -122.466021325821) | 1 | 8 | 4 | 29491 | 40 | |
99095 | 125118 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3170 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | Permit Number 782127 | 5999016.80534 | 2116307.34293 | 37.7909189615014 | -122.447298841085 | (37.7909189615014, -122.447298841085) | 13 | 6 | 1 | 29490 | 31 | ||
165444 | 120228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 172 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781953 | 5988061.30942 | 2114851.82661 | 37.7862904310499 | -122.485097081718 | (37.7862904310499, -122.485097081718) | 11 | 6 | 1 | 55 | 33 | |
31117 | 204006 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1347 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | Permit Number 781782 | 5993496.82475 | 2097739.91918 | 37.7396207362118 | -122.465048470705 | (37.7396207362118, -122.465048470705) | 1 | 8 | 4 | 59 | 40 | ||
173722 | 250672 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781557 | 5986349.68151 | 2114864.86182 | 37.7862263710027 | -122.491019750162 | (37.7862263710027, -122.491019750162) | 11 | 6 | 1 | 55 | 33 | |
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 | |||
68079 | 203280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 59 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | Permit Number 781025 | 5999721.17343 | 2095479.15955 | 37.7337701687542 | -122.443365077855 | (37.7337701687542, -122.443365077855) | 9 | 7 | 4 | 63 | 40 | ||
182107 | 251542 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 50 Vista Ln | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 780127 | 5999350 | 2102347 | 37.7526064375926 | -122.445141915929 | (37.7526064375926, -122.445141915929) | 2 | 5 | 5 | 63 | 38 | ||||
65102 | 124801 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2898 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | Permit Number 780062 | 5999229.08983 | 2118053.40815 | 37.7957253216105 | -122.446690033314 | (37.7957253216105, -122.446690033314) | 13 | 9 | 1 | 57 | 17 | ||
34056 | 64237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.7787939955639 | -122.487946016766 | (37.7787939955639, -122.487946016766) | 11 | 6 | 2 | 55 | 26 | |
140302 | 124755 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2040 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | Permit Number 779873 | 6003722.50351 | 2117641.05418 | 37.794848756005 | -122.431112566798 | (37.794848756005, -122.431112566798) | 13 | 9 | 1 | 29490 | 27 | ||
143678 | 68937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847409 | (37.7784180283155, -122.46938847409) | 11 | 6 | 2 | 54 | 11 | |
69249 | 121575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 57-59 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2017 12:00:00 AM | 3 | 6x8 | Permit Number 779439 | 5991428 | 2114866 | 37.786524881607 | -122.473450350287 | (37.786524881607, -122.473450350287) | 11 | 6 | 1 | 54 | 33 | |
53811 | 121152 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
87130 | 122739 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
146860 | 122740 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 4300 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779217 | 6001168 | 2102360 | 37.7527457326892 | -122.438855901364 | (37.7527457326892, -122.438855901364) | 2 | 4 | 5 | 28862 | 22 | |
153666 | 122576 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1910 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 779012 | 5986951.5849 | 2102234.0134 | 37.7515807312502 | -122.488008923136 | (37.7515807312502, -122.488008923136) | 1 | 8 | 3 | 29491 | 35 | ||
132464 | 121203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3041 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | Permit Number 778902 | 5999408.34577 | 2119299.99025 | 37.7991583414361 | -122.446159489987 | (37.7991583414361, -122.446159489987) | 13 | 9 | 1 | 57 | 17 | ||
43680 | 203910 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 544 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 24 | Width 4ft | Permit Number 778778 | 5992548.72144 | 2104598.67457 | 37.7583983997918 | -122.468825547757 | (37.7583983997918, -122.468825547757) | 1 | 8 | 4 | 56 | 12 | |
57608 | 110848 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | 13 | 9 | 1 | 57 | 27 | ||
73770 | 110847 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2668 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778643 | 6000834.0024 | 2117585.61695 | 37.7945324365719 | -122.441103181276 | (37.7945324365719, -122.441103181276) | 13 | 9 | 1 | 57 | 27 | |
172734 | 115358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 353 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778572 | 6001795.91538 | 2087927.53278 | 37.7131532009313 | -122.435652007258 | (37.7131532009313, -122.435652007258) | 9 | 7 | 6 | 28861 | 5 | |
101045 | 116781 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778230 | 5997601.12717 | 2115625.0178 | 37.7889644837841 | -122.452147749912 | (37.7889644837841, -122.452147749912) | 11 | 6 | 1 | 54 | 31 | |
112086 | 95360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
141758 | 95359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 12 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
142765 | 95361 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 10 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
148170 | 95362 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | ||
157769 | 95358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 25 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
73787 | 116455 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2728 GREEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | Permit Number 778010 | 5999979 | 2117809 | 37.7950970500966 | -122.444077646155 | (37.7950970500966, -122.444077646155) | 13 | 9 | 1 | 57 | 17 | ||
83887 | 110557 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987235.91404 | 2111803.79765 | 37.7778732980336 | -122.487728686455 | (37.7778732980336, -122.487728686455) | 11 | 6 | 2 | 55 | 26 | |
73455 | 51704 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2016 12:00:00 AM | 3 | Permit Number 777735 | 6001742.29918465 | 2107821.21142041 | 37.7677735488102 | -122.437260877297 | (37.7677735488102, -122.437260877297) | 15 | 5 | 5 | 29492 | 3 | ||
176729 | 15277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1563X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.56082 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | 8 | 2 | 9 | 28853 | 19 | |
2457 | 115561 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4x10 | Permit Number 777606 | 5989293.97789 | 2114922.2794 | 37.7865556002814 | -122.480837576069 | (37.7865556002814, -122.480837576069) | 11 | 6 | 1 | 55 | 33 | ||
184376 | 46251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.443148536401 | (37.7950986884031, -122.443148536401) | 13 | 9 | 1 | 57 | 27 | ||
69992 | 112618 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | 13 | 9 | 1 | 29490 | 27 | |
130936 | 114571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3633 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777013 | 5997417 | 2115685 | 37.7891186297883 | -122.452789133032 | (37.7891186297883, -122.452789133032) | 11 | 6 | 1 | 54 | 31 | ||
78793 | 115073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2263 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 24 | 3x3 | Permit Number 777001 | 6003883.69661 | 2116609.10432 | 37.7920244180358 | -122.430481149195 | (37.7920244180358, -122.430481149195) | 13 | 9 | 1 | 29490 | 27 | |
120624 | 113660 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Permit Number 776720 | 5999534 | 2116404 | 37.7912138957856 | -122.445516329339 | (37.7912138957856, -122.445516329339) | 13 | 6 | 1 | 29490 | 27 | |||
68058 | 112042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2418 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 17 | 3x3 | Permit Number 776583 | 6002409.60423 | 2117108.01013 | 37.7933106707057 | -122.435617223266 | (37.7933106707057, -122.435617223266) | 13 | 9 | 1 | 29490 | 27 | |
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
122110 | 113061 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2775 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776016 | 6000301.4 | 2117440.5 | 37.7941036326689 | -122.442935620895 | (37.7941036326689, -122.442935620895) | 13 | 9 | 1 | 57 | 27 | |||
13976 | 1368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.7461879050589 | -122.445863385507 | (37.7461879050589, -122.445863385507) | 2 | 7 | 5 | 63 | 22 | ||
169502 | 1367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.22991 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | 2 | 7 | 5 | 63 | 22 | ||
99826 | 67295 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | 13 | 6 | 1 | 29490 | 27 | ||
192441 | 98513 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 775766 | 5995016.6 | 2091971.4 | 37.7238693046984 | -122.459376132933 | (37.7238693046984, -122.459376132933) | 9 | 8 | 4 | 28861 | 24 | ||
114168 | 115175 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1899X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x20 | Permit Number 775764 | 5993756.36006 | 2102907.65397 | 37.7538249882276 | -122.464526247261 | (37.7538249882276, -122.464526247261) | 1 | 8 | 4 | 56 | 12 | |||
153919 | 111044 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1635 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x10 | Permit Number 775721 | 5995557 | 2094802 | 37.7316725070779 | -122.457712790279 | (37.7316725070779, -122.457712790279) | 9 | 7 | 4 | 59 | 40 | |||
140352 | 111337 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.473689301 | (37.7473430166558, -122.473689301) | 1 | 8 | 4 | 29491 | 40 | |
162685 | 103476 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | 13 | 9 | 1 | 57 | 17 | |||
171881 | 55211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.7812686237346 | -122.443721790146 | (37.7812686237346, -122.443721790146) | 15 | 5 | 1 | 29490 | 16 | |||
168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
34135 | 106832 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 138 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 774880 | 5997571.74884 | 2115814.60363 | 37.7894833530272 | -122.452263079899 | (37.7894833530272, -122.452263079899) | 11 | 6 | 1 | 54 | 31 | |||
131261 | 104547 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 156 MADRONE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774728 | 5992588 | 2098182 | 37.7407821316344 | -122.468222919411 | (37.7407821316344, -122.468222919411) | 1 | 8 | 4 | 59 | 40 | |
166824 | 104548 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 156 MADRONE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x10 | Permit Number 774728 | 5992588 | 2098182 | 37.7407821316344 | -122.468222919411 | (37.7407821316344, -122.468222919411) | 1 | 8 | 4 | 59 | 40 | ||
180863 | 109131 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 156 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774728 | 5992631.8 | 2098170.8 | 37.740753908855 | -122.468070662321 | (37.740753908855, -122.468070662321) | 1 | 8 | 4 | 59 | 40 | |
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
151507 | 112490 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | ||
67303 | 109049 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
119649 | 109048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
164247 | 105787 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 67- 69 CASA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 9x3 | Permit Number 773990 | 6001454.5 | 2121609.5 | 37.8056162809509 | -122.439244738513 | (37.8056162809509, -122.439244738513) | 13 | 9 | 1 | 57 | 17 | ||
145350 | 107354 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 34 Princeton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029479 | (37.7297306299075, -122.41634029479) | 9 | 3 | 7 | 309 | 28 | ||||
130547 | 98318 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
134464 | 98317 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
34078 | 106506 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
131481 | 106505 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
112586 | 106503 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3974 22nd St | 1 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773286 | 6002049 | 2102947 | 37.754407578182 | -122.435851245675 | (37.754407578182, -122.435851245675) | 2 | 4 | 5 | 28862 | 22 | ||||
130598 | 106504 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3974 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773286 | 6002049 | 2102947 | 37.754407578182 | -122.435851245675 | (37.754407578182, -122.435851245675) | 2 | 4 | 5 | 28862 | 22 | ||||
117611 | 104976 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | 9 | 8 | 4 | 64 | 40 | |||
153430 | 104809 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 685 Marina Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | 13 | 9 | 1 | 57 | 17 | ||||
31746 | 104753 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2328 12TH AVE | Front Yard : Cutout | Tree | Private 2 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | 1 | 8 | 4 | 29491 | 40 | ||||
155560 | 203734 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2328 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | Permit Number 770921 | 5992653.8964 | 2099572.36715 | 37.7446035325326 | -122.468096189498 | (37.7446035325326, -122.468096189498) | 1 | 8 | 4 | 29491 | 40 | ||
32089 | 106242 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | 8 | 3 | 8 | 28856 | 29 | |||
70795 | 106249 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 770844 | 6012059.45728 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | 8 | 3 | 8 | 28856 | 29 | |||
157924 | 106248 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 770844 | 6012033.91664 | 2105711.77198 | 37.7625611708892 | -122.401514924078 | (37.7625611708892, -122.401514924078) | 8 | 3 | 8 | 28856 | 29 | |||
163150 | 106241 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | 8 | 3 | 8 | 28856 | 29 | |||
61043 | 68013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.95817 | 2120820.40604 | 37.8033370269329 | -122.446024564694 | (37.8033370269329, -122.446024564694) | 13 | 9 | 1 | 57 | 17 | ||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
87061 | 104723 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X Juan Bautista Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770293 | 5989605.82194 | 2089746.43988 | 37.7174475379801 | -122.477917527277 | (37.7174475379801, -122.477917527277) | 1 | 8 | 4 | 64 | 14 | ||||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
48043 | 102629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | 11 | 6 | 1 | 55 | 33 | |||
125951 | 59324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750287 | -122.500533768842 | (37.761245750287, -122.500533768842) | 1 | 8 | 3 | 56 | 35 | ||
178622 | 100392 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
104052 | 99855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
162549 | 99856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
14158 | 99903 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
22295 | 99908 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
23492 | 99901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
80066 | 99897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Permit Number 768908 | 6004409.82631 | 2116680.57597 | 37.7922504509529 | -122.428665832574 | (37.7922504509529, -122.428665832574) | 13 | 9 | 1 | 28858 | 27 |
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) );