trees
3,247 rows where qSpecies_id = 22 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29415 | 108948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) | 9 | 7 | 6 | 28861 | 5 |
| 129543 | 109045 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773398 | 6004900.57284 | 2093457.84722 | 37.7285140954416 | -122.425314550348 | (37.7285140954416, -122.425314550348) | 9 | 7 | 6 | 28861 | 5 | |
| 69929 | 109058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.19022 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) | 9 | 7 | 6 | 28861 | 5 |
| 25414 | 109115 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 21125 | 109116 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 109575 | 109117 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 182184 | 109118 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 6989 | 109119 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 89702 | 109120 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 20563 | 109121 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 126583 | 109122 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 57202 | 109123 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 92107 | 109124 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 154013 | 109319 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 190x WOOL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007302 | 2097312 | 37.7392321353456 | -122.417285677558 | (37.7392321353456, -122.417285677558) | 2 | 7 | 7 | 28859 | 2 | ||||
| 47051 | 109519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 4801X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
| 69431 | 109609 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | |||
| 99915 | 109610 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 88483 | 109611 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 41338 | 109613 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 137959 | 109614 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 88306 | 109615 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 146733 | 109616 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | |||
| 103285 | 109617 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 91518 | 109618 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 105119 | 109619 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 144820 | 109620 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 181565 | 109621 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 94722 | 109622 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 20200 | 109784 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 85608 | 109785 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 66352 | 109786 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 35944 | 109787 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 55490 | 109788 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 179319 | 109789 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 380 FULTON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6005937 | 2111766 | 37.7788425501417 | -122.423032307462 | (37.7788425501417, -122.423032307462) | 7 | 9 | 11 | 28852 | 10 | ||
| 149561 | 109862 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 411 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6002642.5 | 2110010.2 | 37.7738351043091 | -122.434303710481 | (37.7738351043091, -122.434303710481) | 15 | 5 | 11 | 29492 | 10 | |||
| 89030 | 109863 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 411 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6002642.5 | 2110010.2 | 37.7738351043091 | -122.434303710481 | (37.7738351043091, -122.434303710481) | 15 | 5 | 11 | 29492 | 10 | |||
| 54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
| 144153 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | ||
| 166253 | 110046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | 14 | 10 | 9 | 28852 | 36 | ||||
| 177985 | 110155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.7968411050867 | -122.414334635748 | (37.7968411050867, -122.414334635748) | 5 | 1 | 10 | 308 | 21 | |
| 130087 | 110156 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.414291819036 | (37.7968393702849, -122.414291819036) | 5 | 1 | 10 | 308 | 21 | |
| 142053 | 110157 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.414436727676 | (37.7968272906045, -122.414436727676) | 5 | 1 | 10 | 308 | 21 | ||
| 37837 | 110158 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.414560246865 | (37.7968116091339, -122.414560246865) | 5 | 1 | 10 | 308 | 21 | ||
| 94974 | 110194 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2123 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774924 | 6001844.69538 | 2115843.7088 | 37.7898071242475 | -122.437481264255 | (37.7898071242475, -122.437481264255) | 13 | 6 | 1 | 29490 | 27 | |
| 181771 | 110480 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002112.3456 | 2110445.7265 | 37.7750008457371 | -122.436168770849 | (37.7750008457371, -122.436168770849) | 15 | 5 | 11 | 29492 | 10 | |||
| 192972 | 110481 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | 15 | 5 | 11 | 29492 | 10 | |
| 139612 | 110517 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 149801 | 110518 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 136878 | 110521 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 150794 | 110522 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
| 84958 | 110935 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | |||
| 188520 | 110936 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 46282 | 110937 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 153970 | 110938 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 158439 | 111017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90x DOWNEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 110917 | 111020 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90x DOWNEY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
| 177071 | 111815 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 292 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5993105.14930812 | 2113535.88816838 | 37.7829697365941 | -122.467551113949 | (37.7829697365941, -122.467551113949) | 11 | 6 | 2 | 54 | 11 | ||||
| 140157 | 111816 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 296 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5993097.86718 | 2113570.40653 | 37.7830640941608 | -122.467578817969 | (37.7830640941608, -122.467578817969) | 11 | 6 | 2 | 54 | 11 | |||
| 172055 | 112127 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 121936 | 112128 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 174435 | 112129 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 79505 | 112131 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 7043 | 112197 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.7921756543416 | -122.437399303646 | (37.7921756543416, -122.437399303646) | 13 | 6 | 1 | 29490 | 27 | ||
| 175873 | 112198 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771994 | 6001873.5131 | 2116702.41623 | 37.7921665513862 | -122.437443074554 | (37.7921665513862, -122.437443074554) | 13 | 6 | 1 | 29490 | 27 | |
| 88390 | 112784 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 671 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774332 | 5992812.5 | 2110899.4 | 37.7757137554499 | -122.468371679237 | (37.7757137554499, -122.468371679237) | 11 | 6 | 2 | 54 | 11 | |||
| 124196 | 112801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009421.02251 | 2118738.48661 | 37.7981833000696 | -122.411472383257 | (37.7981833000696, -122.411472383257) | 3 | 1 | 10 | 308 | 4 | |||
| 66587 | 112802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009439.76342 | 2118739.20101 | 37.798186312791 | -122.411407584406 | (37.798186312791, -122.411407584406) | 3 | 1 | 10 | 308 | 4 | |||
| 104375 | 113266 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 1 | Permit Number 774770 | 6012949.27071 | 2090610.02044 | 37.7211459795788 | -122.397289961272 | (37.7211459795788, -122.397289961272) | 10 | 3 | 8 | 58 | 1 | ||
| 192233 | 113841 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6014543.41524 | 2094775.25043 | 37.7326714894988 | -122.392070556938 | (37.7326714894988, -122.392070556938) | 10 | 3 | 8 | 58 | 1 | |||
| 103633 | 113842 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6014555.91727 | 2094766.75575 | 37.7326488589531 | -122.392026740166 | (37.7326488589531, -122.392026740166) | 10 | 3 | 8 | 58 | 1 | |||
| 121803 | 113844 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6014584.73732 | 2094746.59806 | 37.7325951100749 | -122.391925692318 | (37.7325951100749, -122.391925692318) | 10 | 3 | 8 | 58 | 1 | |||
| 46120 | 113845 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 5x5 | 6014593.86588 | 2094702.19868 | 37.7324737051814 | -122.391891028864 | (37.7324737051814, -122.391891028864) | 10 | 3 | 8 | 58 | 1 | |||
| 66231 | 113846 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 REVERE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6014548 | 2094736 | 37.7325639703463 | -122.392051962294 | (37.7325639703463, -122.392051962294) | 10 | 3 | 8 | 58 | 1 | ||||
| 132490 | 113847 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6014575.04616 | 2094706.38407 | 37.7324841526011 | -122.391956386193 | (37.7324841526011, -122.391956386193) | 10 | 3 | 8 | 58 | 1 | |||
| 129940 | 113848 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6014558.02731 | 2094710.13283 | 37.7324935010709 | -122.392015486932 | (37.7324935010709, -122.392015486932) | 10 | 3 | 8 | 58 | 1 | |||
| 5109 | 113849 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6014539.79844 | 2094713.70561 | 37.7325022991238 | -122.392078758744 | (37.7325022991238, -122.392078758744) | 10 | 3 | 8 | 58 | 1 | |||
| 57177 | 113850 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6014522.16473 | 2094716.86581 | 37.732509997327 | -122.392139944101 | (37.732509997327, -122.392139944101) | 10 | 3 | 8 | 58 | 1 | |||
| 112486 | 113851 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Bay View St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6014504.33786 | 2094720.43082 | 37.7325187962993 | -122.392201825578 | (37.7325187962993, -122.392201825578) | 10 | 3 | 8 | 58 | 1 | |||
| 123829 | 113852 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x REVERE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6014672 | 2094788 | 37.7327136355619 | -122.391626895226 | (37.7327136355619, -122.391626895226) | 10 | 3 | 8 | 58 | 1 | ||||
| 66447 | 113853 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6014630.01977 | 2094781.38525 | 37.7326931424693 | -122.391771570129 | (37.7326931424693, -122.391771570129) | 10 | 3 | 8 | 58 | 1 | |||
| 141738 | 113854 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6014619.79287 | 2094788.95809 | 37.7327133682248 | -122.391807456662 | (37.7327133682248, -122.391807456662) | 10 | 3 | 8 | 58 | 1 | |||
| 159727 | 113855 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700x Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6014596.64898 | 2094806.77216 | 37.7327609972174 | -122.391888716698 | (37.7327609972174, -122.391888716698) | 10 | 3 | 8 | 58 | 1 | |||
| 53747 | 113998 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 1110 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 3 | 3x3 | 6007591 | 2103152 | 37.7552837189859 | -122.416700052453 | (37.7552837189859, -122.416700052453) | 2 | 4 | 7 | 28859 | 19 | ||
| 133765 | 114295 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
| 34228 | 114296 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
| 65810 | 114297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | ||||
| 100090 | 11432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1994 12:00:00 AM | 6 | 3X3 | 6012526.0110026 | 2118137.4589098 | 37.796706690547 | -122.400685892184 | (37.796706690547, -122.400685892184) | 3 | 1 | 10 | 28860 | 4 | ||
| 63028 | 114489 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 740 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x3 | 6009285 | 2110275 | 37.7749369712978 | -122.411344848489 | (37.7749369712978, -122.411344848489) | 8 | 2 | 9 | 28853 | 34 | |||
| 158146 | 114548 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015820.59236 | 2106259.92484 | 37.7642768417202 | -122.38845633359 | (37.7642768417202, -122.38845633359) | 14 | 3 | 8 | 28856 | 29 | ||
| 133722 | 114549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015846.45477 | 2106262.10927 | 37.7642842728198 | -122.388367034517 | (37.7642842728198, -122.388367034517) | 14 | 3 | 8 | 28856 | 29 | ||
| 167912 | 114550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015870.34934 | 2106264.23944 | 37.764291445828 | -122.388284537902 | (37.764291445828, -122.388284537902) | 14 | 3 | 8 | 28856 | 29 | ||
| 142427 | 114668 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 176X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||
| 74435 | 114689 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 229 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001466.35447253 | 2104493.12773322 | 37.7586197563696 | -122.437976920317 | (37.7586197563696, -122.437976920317) | 2 | 4 | 5 | 28862 | 3 | ||||
| 147257 | 114690 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774716 | 6010597.60785 | 2093917.85298 | 37.7300973914745 | -122.405651885519 | (37.7300973914745, -122.405651885519) | 10 | 3 | 7 | 309 | 28 | ||
| 175575 | 115255 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 345 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772821 | 5995728.7 | 2090517.8 | 37.7199189816113 | -122.456809453119 | (37.7199189816113, -122.456809453119) | 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) );