trees
365 rows where qSpecies_id = 103 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
421 | 65202 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 415 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 29 | Permit Number 27188 | 6004121.81538 | 2090701.65991 | 37.7209021868562 | -122.4278104505 | (37.7209021868562, -122.4278104505) | 9 | 7 | 6 | 28861 | 5 | |
559 | 65188 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 259 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | 3x3 | Permit Number 27172 | 6002967.27009 | 2091905.51259 | 37.7241423183013 | -122.431887278791 | (37.7241423183013, -122.431887278791) | 9 | 7 | 6 | 28861 | 5 |
1293 | 72151 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 209 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 6001102.51971 | 2093339.22374 | 37.7279730740759 | -122.438436097863 | (37.7279730740759, -122.438436097863) | 9 | 7 | 6 | 28861 | 25 | |||
1433 | 232017 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 115 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006704 | 2103106 | 37.7551074856341 | -122.419764305464 | (37.7551074856341, -122.419764305464) | 2 | 4 | 7 | 28859 | 19 | |||
1718 | 70538 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1377 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6001235.1822 | 2110724.6326 | 37.7757167770031 | -122.439223056717 | (37.7757167770031, -122.439223056717) | 15 | 5 | 11 | 29492 | 10 | |||
2099 | 159210 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 221 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:02:00 PM | 3 | Width 0ft | 5998496.56077 | 2088461.79166 | 37.71443219875 | -122.447094072659 | (37.71443219875, -122.447094072659) | 9 | 7 | 6 | 28861 | 25 | ||
3165 | 78290 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 955 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000834.42443 | 2091470.61538 | 37.7228270490011 | -122.439229031908 | (37.7228270490011, -122.439229031908) | 9 | 7 | 6 | 28861 | 25 | |||
3469 | 72161 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 362 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 29 | 6002558.54368 | 2091345.46237 | 37.7225813668208 | -122.433260183829 | (37.7225813668208, -122.433260183829) | 9 | 7 | 6 | 28861 | 5 | |||
3722 | 173585 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6016282.86523 | 2096963.46615 | 37.7387763123884 | -122.386209292923 | (37.7387763123884, -122.386209292923) | 10 | 3 | 8 | 58 | 1 | |||
3773 | 258127 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6009416.09812 | 2091494.49671 | 37.7233772263446 | -122.409565560368 | (37.7233772263446, -122.409565560368) | 9 | 3 | 7 | 309 | 28 | |||
3899 | 70539 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1381 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6001216.8952 | 2110720.8677 | 37.7757053989126 | -122.439286045952 | (37.7757053989126, -122.439286045952) | 15 | 5 | 11 | 29492 | 10 | |||
5455 | 65184 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 233 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 17 | Permit Number 27168 | 6003041.22151 | 2092024.75933 | 37.7244739352114 | -122.43164014959 | (37.7244739352114, -122.43164014959) | 9 | 7 | 6 | 28861 | 5 | |
5475 | 70537 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1347 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6001345.9795 | 2110739.1546 | 37.7757629549659 | -122.438840822928 | (37.7757629549659, -122.438840822928) | 15 | 5 | 11 | 29492 | 10 | |||
5575 | 62208 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 271 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 16 | Permit Number 22330 | 6000800.08235 | 2093553.46638 | 37.7285441273917 | -122.439496981309 | (37.7285441273917, -122.439496981309) | 9 | 7 | 6 | 28861 | 25 | |
5969 | 258129 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Bowdoin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009416.09812 | 2091494.49671 | 37.7233772263446 | -122.409565560368 | (37.7233772263446, -122.409565560368) | 9 | 3 | 7 | 309 | 28 | ||
6551 | 73721 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 169 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6001384.47149 | 2093138.99338 | 37.7274393210434 | -122.437447052238 | (37.7274393210434, -122.437447052238) | 9 | 7 | 6 | 28861 | 25 | |||
6770 | 62211 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 161 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 17 | Permit Number 22333 | 6001411.76056 | 2093118.78018 | 37.7273853716221 | -122.437351267256 | (37.7273853716221, -122.437351267256) | 9 | 7 | 6 | 28861 | 25 | |
7070 | 65206 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 459 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 21 | 9x12 | Permit Number 27192 | 6003301.10322 | 2090923.4573 | 37.7214647316905 | -122.430663223222 | (37.7214647316905, -122.430663223222) | 9 | 7 | 6 | 28861 | 5 |
7162 | 72156 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 275 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000789.13565 | 2093562.05414 | 37.7285670843939 | -122.439535439929 | (37.7285670843939, -122.439535439929) | 9 | 7 | 6 | 28861 | 25 | |||
7903 | 65191 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 367 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 20 | Permit Number 27175 | 6002591.90693 | 2091314.82578 | 37.7224991382206 | -122.433142666707 | (37.7224991382206, -122.433142666707) | 9 | 7 | 6 | 28861 | 5 | |
8192 | 258125 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 731 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009632.88512 | 2091554.43402 | 37.7235539468335 | -122.408820391364 | (37.7235539468335, -122.408820391364) | 9 | 3 | 7 | 309 | 28 | |||
9468 | 22650 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1251 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2014 12:00:00 AM | 30 | 5x6 | Permit Number 771274 | 6003965.2704 | 2112486.0639 | 37.7807082067095 | -122.429904674104 | (37.7807082067095, -122.429904674104) | 7 | 9 | 11 | 29490 | 41 | |
10463 | 73720 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 157 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 3x3 | 6001432.84153 | 2093102.8758 | 37.7273429002463 | -122.437277252154 | (37.7273429002463, -122.437277252154) | 9 | 7 | 6 | 28861 | 25 | ||
10750 | 70535 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1364 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001296.3816 | 2110780.432 | 37.7758734704185 | -122.43901535307 | (37.7758734704185, -122.43901535307) | 15 | 5 | 11 | 29492 | 10 | |||
10836 | 72162 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 342 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 25 | 6002176.04158 | 2091749.35017 | 37.7236686453727 | -122.434611272212 | (37.7236686453727, -122.434611272212) | 9 | 7 | 6 | 28861 | 5 | |||
10884 | 62205 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 220 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 24 | Permit Number 22327 | 6001113.38576 | 2093381.72459 | 37.7280903897473 | -122.438401577384 | (37.7280903897473, -122.438401577384) | 9 | 7 | 6 | 28861 | 25 | |
11002 | 210063 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997079 | 2090516 | 37.7199914819232 | -122.452141828575 | (37.7199914819232, -122.452141828575) | 9 | 8 | 6 | 28861 | 24 | |||
12046 | 78113 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 955 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000841.06544 | 2091483.71454 | 37.7228633942216 | -122.439207013809 | (37.7228633942216, -122.439207013809) | 9 | 7 | 6 | 28861 | 25 | |||
13235 | 141835 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1123 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004591.1835 | 2112575.0826 | 37.780988056061 | -122.427745682877 | (37.780988056061, -122.427745682877) | 7 | 9 | 11 | 29490 | 41 | |||
13638 | 65187 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 255 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 27171 | 6002982.8034 | 2091932.08237 | 37.7242161535455 | -122.43183547875 | (37.7242161535455, -122.43183547875) | 9 | 7 | 6 | 28861 | 5 | |
14144 | 75133 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.432160858845 | (37.7256104849218, -122.432160858845) | 9 | 7 | 6 | 28861 | 5 | ||
14589 | 32799 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1798 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 16 | Permit Number 37162 | 5999260.9625 | 2110496.5962 | 37.7749781082682 | -122.446035944061 | (37.7749781082682, -122.446035944061) | 15 | 5 | 11 | 29492 | 16 | |
15730 | 258373 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007882.23453 | 2093465.09674 | 37.7287020037839 | -122.415007269683 | (37.7287020037839, -122.415007269683) | 9 | 3 | 7 | 309 | 5 | |||
15731 | 11480 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 10X Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 1 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | 10 | 3 | 8 | 58 | 1 | ||
16099 | 258126 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 839 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009323.9018 | 2091459.72013 | 37.7232765705422 | -122.409881813505 | (37.7232765705422, -122.409881813505) | 9 | 3 | 7 | 309 | 28 | |||
16150 | 70536 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1371 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6001264.764 | 2110727.8598 | 37.775727321365 | -122.439120957465 | (37.775727321365, -122.439120957465) | 15 | 5 | 11 | 29492 | 10 | |||
17163 | 70909 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 8 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6000778.87542 | 2088453.96135 | 37.7145408359612 | -122.439204941777 | (37.7145408359612, -122.439204941777) | 9 | 7 | 6 | 28861 | 5 | |||
17275 | 65194 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 275 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 19 | Permit Number 27178 | 6002912.43487 | 2091820.06668 | 37.723904594192 | -122.432070736891 | (37.723904594192, -122.432070736891) | 9 | 7 | 6 | 28861 | 5 | |
17558 | 258128 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1000 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009416.09812 | 2091494.49671 | 37.7233772263446 | -122.409565560368 | (37.7233772263446, -122.409565560368) | 9 | 3 | 7 | 309 | 28 | ||
17723 | 65192 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 271 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 16 | Permit Number 27176 | 6002926.25519 | 2091846.82738 | 37.7239788566282 | -122.432024872357 | (37.7239788566282, -122.432024872357) | 9 | 7 | 6 | 28861 | 5 | |
17813 | 72154 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 251 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 6000880.62926 | 2093500.16908 | 37.7284023690599 | -122.439214708412 | (37.7284023690599, -122.439214708412) | 9 | 7 | 6 | 28861 | 25 | |||
18423 | 258374 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1009 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007871.84523 | 2093420.07444 | 37.7285777984137 | -122.415040000813 | (37.7285777984137, -122.415040000813) | 9 | 3 | 7 | 309 | 5 | ||||
18565 | 207021 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 400 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 07:38:00 AM | 3 | Width 3ft | 5995575.22962 | 2090581.47857 | 37.7200850143019 | -122.457344548018 | (37.7200850143019, -122.457344548018) | 9 | 8 | 6 | 28861 | 24 | ||
19511 | 72149 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 157 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 3x3 | 6001449.82558 | 2093091.86406 | 37.7273136300059 | -122.437217750315 | (37.7273136300059, -122.437217750315) | 9 | 7 | 6 | 28861 | 25 | ||
20015 | 117461 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 309 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 3x3 | 6013787.30766 | 2105629.81161 | 37.7624338053071 | -122.395444794344 | (37.7624338053071, -122.395444794344) | 10 | 3 | 8 | 28856 | 29 | |||
20254 | 232027 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 3532 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006676.81852 | 2104392.68394 | 37.7586388911 | -122.419949608686 | (37.7586388911, -122.419949608686) | 2 | 4 | 7 | 28859 | 19 | |||
21680 | 131207 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 12 Greenwich St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012263.47251 | 2120560.44048 | 37.803344967053 | -122.401764739574 | (37.803344967053, -122.401764739574) | 3 | 1 | 10 | 28860 | 6 | ||||
23355 | 131204 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2658 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006602.37077 | 2120389.87169 | 37.802559084587 | -122.421343102819 | (37.802559084587, -122.421343102819) | 5 | 9 | 1 | 28858 | 32 | |||
23420 | 210067 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 281 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992187.12648 | 2089819.02124 | 37.717796309821 | -122.469000508175 | (37.717796309821, -122.469000508175) | 9 | 8 | 6 | 64 | 24 | |||
25481 | 231996 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 16 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005802.3623 | 2105947.60955 | 37.7628590470378 | -122.423084400718 | (37.7628590470378, -122.423084400718) | 8 | 4 | 5 | 28859 | 19 | |||
26292 | 25580 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1511 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6016141.48149 | 2097069.66658 | 37.7390600907376 | -122.386705539738 | (37.7390600907376, -122.386705539738) | 10 | 3 | 8 | 58 | 1 | |||
26737 | 177527 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 280 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6000766.09435 | 2093627.21139 | 37.728744679818 | -122.439619763966 | (37.728744679818, -122.439619763966) | 9 | 7 | 6 | 28861 | 25 | |||
28260 | 177526 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 158 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001537.68532 | 2093082.54579 | 37.7272930382249 | -122.436913353185 | (37.7272930382249, -122.436913353185) | 9 | 7 | 6 | 28861 | 25 | |||
28476 | 209296 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1325 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5990483.47401 | 2106394.89344 | 37.7632108051556 | -122.476099204218 | (37.7632108051556, -122.476099204218) | 1 | 8 | 3 | 56 | 12 | |||
28639 | 210077 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1440 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994855.31786 | 2105355.78909 | 37.7606102301954 | -122.460903243615 | (37.7606102301954, -122.460903243615) | 15 | 5 | 11 | 56 | 12 | |||
29580 | 232010 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 310 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6007506.59323 | 2097104.55184 | 37.7386740369729 | -122.416563592842 | (37.7386740369729, -122.416563592842) | 2 | 7 | 7 | 28859 | 2 | |||
30085 | 232025 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 228 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006366.90017 | 2098508.58753 | 37.7424650427233 | -122.420603758454 | (37.7424650427233, -122.420603758454) | 2 | 7 | 7 | 28859 | 2 | |||
30364 | 210073 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1690 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992505.6305 | 2103938.05386 | 37.7565820183654 | -122.468926499369 | (37.7565820183654, -122.468926499369) | 1 | 8 | 4 | 56 | 12 | |||
31139 | 232015 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 168 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007561.22256 | 2097879.40075 | 37.7408046729896 | -122.416429579474 | (37.7408046729896, -122.416429579474) | 2 | 7 | 7 | 28859 | 2 | |||
31423 | 232021 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 718 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6001840.14171 | 2099739.76426 | 37.7455894053298 | -122.436344007671 | (37.7455894053298, -122.436344007671) | 2 | 7 | 5 | 63 | 22 | |||
31911 | 232030 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 12 Buena Vista Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6001421.38641 | 2108085.24944 | 37.7684802837737 | -122.438389792656 | (37.7684802837737, -122.438389792656) | 15 | 5 | 5 | 29492 | 3 | |||
33685 | 210087 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 311 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000737.19251 | 2095127.86019 | 37.732863469569 | -122.439827227651 | (37.732863469569, -122.439827227651) | 9 | 7 | 5 | 63 | 40 | |||
33692 | 131205 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 12 Greenwich St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012278.60501 | 2120557.19628 | 37.8033369037238 | -122.401712144524 | (37.8033369037238, -122.401712144524) | 3 | 1 | 10 | 28860 | 6 | ||||
34321 | 232020 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 614 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6001886.29499 | 2099446.50514 | 37.7447868071673 | -122.43616343459 | (37.7447868071673, -122.43616343459) | 2 | 7 | 5 | 63 | 22 | |||
35199 | 231982 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 100 Rose St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005944.33041 | 2109848.96827 | 37.7735792590093 | -122.422870667843 | (37.7735792590093, -122.422870667843) | 7 | 9 | 11 | 28852 | 10 | |||
36121 | 17869 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2132 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6003712.3639 | 2115281.4031 | 37.7883691806823 | -122.430979161307 | (37.7883691806823, -122.430979161307) | 13 | 9 | 1 | 29490 | 27 | ||
38848 | 210072 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1594 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5992788.19455 | 2104665.87937 | 37.7585967587562 | -122.468002239107 | (37.7585967587562, -122.468002239107) | 1 | 8 | 4 | 56 | 12 | |||
39662 | 210076 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1440 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994809.58975 | 2105354.50414 | 37.7606040707341 | -122.461061302133 | (37.7606040707341, -122.461061302133) | 15 | 5 | 11 | 56 | 12 | |||
41246 | 123939 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 127 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 5993323.01496 | 2114646.41295 | 37.786031510503 | -122.466878152703 | (37.786031510503, -122.466878152703) | 11 | 6 | 2 | 54 | 11 | |||
41736 | 11479 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 10X Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | 10 | 3 | 8 | 58 | 1 | ||
43479 | 193534 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 243 Texas St | 1 | : | Tree | Private 2 | 26 | Width 3ft | 6013767.79609 | 2105950.44315 | 37.7633131039273 | -122.395534742736 | (37.7633131039273, -122.395534742736) | 14 | 3 | 8 | 28856 | 29 | |||
43745 | 131208 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 12 Greenwich St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012252.03872 | 2120555.92923 | 37.8033319421894 | -122.401803989565 | (37.8033319421894, -122.401803989565) | 3 | 1 | 10 | 28860 | 6 | ||||
45876 | 244120 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1727 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998297.7039 | 2108923.1313 | 37.7706027242734 | -122.449254662385 | (37.7706027242734, -122.449254662385) | 15 | 5 | 11 | 29492 | 9 | |||
46262 | 231983 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 120 Rose St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005871.58997 | 2109840.06306 | 37.7735507028441 | -122.423121655159 | (37.7735507028441, -122.423121655159) | 7 | 9 | 11 | 28852 | 10 | |||
47452 | 131199 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1847 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008657.5896 | 2119259.89568 | 37.7995721096252 | -122.414151004059 | (37.7995721096252, -122.414151004059) | 5 | 1 | 10 | 308 | 32 | |||
49132 | 68215 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 186 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 17 | Permit Number 32002 | 5991199.59843 | 2114189.41379 | 37.7846539350905 | -122.474191168534 | (37.7846539350905, -122.474191168534) | 11 | 6 | 2 | 54 | 26 | |
53409 | 123937 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 115 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5993319.808 | 2114705.06208 | 37.7861923598582 | -122.466893513014 | (37.7861923598582, -122.466893513014) | 11 | 6 | 2 | 54 | 11 | |||
53945 | 232032 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 129 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6002694.48476 | 2096747.17708 | 37.737420962116 | -122.433176036939 | (37.737420962116, -122.433176036939) | 2 | 7 | 5 | 63 | 7 | |||
55487 | 244296 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 250 Hickory St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6005711.4099 | 2110512.9234 | 37.7753891740707 | -122.423723593584 | (37.7753891740707, -122.423723593584) | 7 | 9 | 11 | 28852 | 10 | |||
55495 | 210060 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 54 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5995643.81316 | 2090256.27948 | 37.7191960335366 | -122.457083968543 | (37.7191960335366, -122.457083968543) | 9 | 8 | 6 | 28861 | 24 | |||
56037 | 232023 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007377.78001 | 2095243.94386 | 37.7335579710053 | -122.416877182829 | (37.7335579710053, -122.416877182829) | 2 | 7 | 7 | 28859 | 2 | |||
57317 | 11476 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 10X Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 6 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | 10 | 3 | 8 | 58 | 1 | ||
58123 | 231997 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 16 Dearborn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005803.22708 | 2105927.09883 | 37.7628027782384 | -122.423079951801 | (37.7628027782384, -122.423079951801) | 8 | 4 | 5 | 28859 | 19 | |||
58278 | 75214 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.80856 | 37.7256614422973 | -122.432268027453 | (37.7256614422973, -122.432268027453) | 9 | 7 | 6 | 28861 | 5 | |
59313 | 193537 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2x Dukes Ct | 6 | Median : Yard | Tree | DPW 1 | 13 | 6016137.54157 | 2096287.17103 | 37.7369112983054 | -122.386664611588 | (37.7369112983054, -122.386664611588) | 10 | 3 | 8 | 58 | 1 | ||||
59363 | 66078 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1839 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 13 | Permit Number 29122 | 6008662.81422 | 2119229.31619 | 37.7994884394025 | -122.414130760324 | (37.7994884394025, -122.414130760324) | 5 | 1 | 10 | 308 | 32 | |
60966 | 232022 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 281 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5999002.37396 | 2106518.0038 | 37.7640391320235 | -122.446644136426 | (37.7640391320235, -122.446644136426) | 15 | 5 | 11 | 29492 | 9 | |||
61411 | 232011 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 256 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007526.68217 | 2097469.23849 | 37.7396765157486 | -122.416519960439 | (37.7396765157486, -122.416519960439) | 2 | 7 | 7 | 28859 | 2 | |||
61456 | 210066 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 281 Ralston St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5992186.75081 | 2089801.16852 | 37.7177472688886 | -122.469000508172 | (37.7177472688886, -122.469000508172) | 9 | 8 | 6 | 64 | 24 | |||
61765 | 32796 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1762 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 13 | 6x9 | Permit Number 37159 | 5999381.3452 | 2110511.5654 | 37.7750260834738 | -122.445620592615 | (37.7750260834738, -122.445620592615) | 15 | 5 | 11 | 29492 | 16 |
61952 | 210084 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997718.18355 | 2098102.12679 | 37.740857779758 | -122.450479003921 | (37.740857779758, -122.450479003921) | 9 | 7 | 4 | 59 | 40 | |||
62459 | 231993 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 140 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6005880.97153 | 2106406.67849 | 37.7641239776661 | -122.422845145987 | (37.7641239776661, -122.422845145987) | 8 | 4 | 5 | 28859 | 19 | |||
62860 | 32726 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 |
63383 | 210090 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 131 Mangels Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000546.30943 | 2095204.53698 | 37.7330631388516 | -122.440492654935 | (37.7330631388516, -122.440492654935) | 9 | 7 | 5 | 63 | 40 | |||
64536 | 231984 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 120 Rose St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6005851.75347 | 2109837.7339 | 37.7735431881033 | -122.423190107055 | (37.7735431881033, -122.423190107055) | 7 | 9 | 11 | 28852 | 10 | |||
65726 | 193536 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 215 Texas St | 1 | : | Tree | Private 2 | 29 | Width 3ft | 6013762.48015 | 2106057.65111 | 37.7636071777473 | -122.395560640522 | (37.7636071777473, -122.395560640522) | 14 | 3 | 8 | 28856 | 29 | |||
66840 | 232016 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 160 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007564.92722 | 2097906.25235 | 37.7408786098676 | -122.416418671604 | (37.7408786098676, -122.416418671604) | 2 | 7 | 7 | 28859 | 2 | |||
67461 | 232002 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 180 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6005391.62932 | 2102781.68627 | 37.754142977841 | -122.424279803873 | (37.754142977841, -122.424279803873) | 2 | 4 | 5 | 28859 | 19 | |||
68262 | 210062 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 224 Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994777.61707 | 2088417.56963 | 37.7140975898175 | -122.459944932339 | (37.7140975898175, -122.459944932339) | 9 | 8 | 6 | 28861 | 24 | |||
68707 | 32729 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 |
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) );