trees
176 rows where qSpecies_id = 204 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17160 | 254708 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 2500X Market St | 2 | Median : Yard | Tree | Private 2 | 3x3 | ||||||||||||||
20051 | 142994 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 39 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008184.8344 | 2120832.3766 | 37.8038631828496 | -122.415898325017 | (37.8038631828496, -122.415898325017) | 5 | 1 | 10 | 308 | 32 | |||
56387 | 142995 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 29 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008216.7367 | 2120837.5372 | 37.8038791460389 | -122.415788290484 | (37.8038791460389, -122.415788290484) | 5 | 1 | 10 | 308 | 32 | |||
99486 | 142996 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 19 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008239.0804 | 2120841.4658 | 37.8038911890406 | -122.415711246845 | (37.8038911890406, -122.415711246845) | 5 | 1 | 10 | 308 | 32 | |||
145805 | 142997 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 9 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008266.826 | 2120846.8676 | 37.8039075806775 | -122.415615613882 | (37.8039075806775, -122.415615613882) | 5 | 1 | 10 | 308 | 32 | |||
19036 | 47608 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1301 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009600.55558 | 2109308.88574 | 37.7723019402269 | -122.410185046001 | (37.7723019402269, -122.410185046001) | 8 | 2 | 9 | 28853 | 34 | |
32195 | 110920 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 77 FEDERAL ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x1 | 6014792 | 2113102 | 37.7830066040332 | -122.392492594241 | (37.7830066040332, -122.392492594241) | 6 | 2 | 9 | 28856 | 6 | ||||
57527 | 98528 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 428 11th St | 1 | Front Yard : Cutout | Tree | Private 2 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030 | 2108561 | 37.7702164230423 | -122.412105792177 | (37.7702164230423, -122.412105792177) | 8 | 2 | 9 | 28853 | 19 | ||
68090 | 47607 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1301 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009584.68368 | 2109294.10241 | 37.7722604589743 | -122.410238904622 | (37.7722604589743, -122.410238904622) | 8 | 2 | 9 | 28853 | 34 | |
76813 | 52845 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 11X Guy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
85061 | 255144 | Significant Tree 6 | Cupressus sempervirens :: Italian Cypress 204 | 101x Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013362 | 2113756 | 37.7847228211314 | -122.3974857221 | (37.7847228211314, -122.3974857221) | 6 | 2 | 9 | 28856 | 6 | ||||
103670 | 47609 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1301 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009613.5529 | 2109319.75218 | 37.7723325054634 | -122.410140854217 | (37.7723325054634, -122.410140854217) | 8 | 2 | 9 | 28853 | 34 | |
106766 | 52849 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
119685 | 102811 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | 6 | 2 | 9 | 28855 | 6 | ||
123170 | 102813 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | 6 | 2 | 9 | 28855 | 6 | ||
132404 | 52847 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 11X Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
136613 | 190996 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1301 Harrison St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6009624.08267 | 2109327.09074 | 37.7723532456398 | -122.41010494881 | (37.7723532456398, -122.41010494881) | 8 | 2 | 9 | 28853 | 34 | |||
154148 | 52846 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 11X Guy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
160866 | 98529 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 428 11th St | 2 | Front Yard : Cutout | Tree | Private 2 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030 | 2108561 | 37.7702164230423 | -122.412105792177 | (37.7702164230423, -122.412105792177) | 8 | 2 | 9 | 28853 | 19 | ||
161607 | 52848 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
165370 | 102814 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | 6 | 2 | 9 | 28855 | 6 | ||
166026 | 102812 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 50 Lansing St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | 6 | 2 | 9 | 28855 | 6 | ||
183371 | 52843 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 11X Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | 6 | 2 | 9 | 28855 | 6 | |
3834 | 191005 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1429 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6012034.37519 | 2101693.56903 | 37.7515280955639 | -122.401230962264 | (37.7515280955639, -122.401230962264) | 10 | 3 | 8 | 28856 | 29 | ||||
4316 | 67675 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1729 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 5 | Permit Number 31278 | 6014381.83684 | 2094894.16422 | 37.732989030203 | -122.39263749313 | (37.732989030203, -122.39263749313) | 10 | 3 | 8 | 58 | 1 | |
8939 | 191015 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2701 Phelps St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011786.47472 | 2093252.28188 | 37.7283362805753 | -122.401495039187 | (37.7283362805753, -122.401495039187) | 10 | 3 | 8 | 58 | 1 | |||
17577 | 200493 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3239 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013517.2414 | 2090039.3064 | 37.7196105178737 | -122.395286677972 | (37.7196105178737, -122.395286677972) | 10 | 3 | 8 | 58 | 1 | |||
21789 | 191016 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Bay Shore Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6010877.37489 | 2095138.84126 | 37.7334656088485 | -122.404770616467 | (37.7334656088485, -122.404770616467) | 10 | 3 | 8 | 58 | 1 | |||
28080 | 201357 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1 Bitting Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012930.10323 | 2092562.90102 | 37.7265071269946 | -122.397493109117 | (37.7265071269946, -122.397493109117) | 10 | 3 | 8 | 58 | 1 | ||||
29883 | 190998 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Minnesota St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6015256.25071 | 2104772.25868 | 37.7601607427304 | -122.390304301926 | (37.7601607427304, -122.390304301926) | 10 | 3 | 8 | 28856 | 29 | |||
34306 | 191001 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 900 Tennessee St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015462.33524 | 2104739.93407 | 37.7600834154452 | -122.389589289637 | (37.7600834154452, -122.389589289637) | 10 | 3 | 8 | 28856 | 29 | |||
35588 | 191019 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1751 Silver Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6011288.24464 | 2095271.1885 | 37.7338519630013 | -122.403359422808 | (37.7338519630013, -122.403359422808) | 10 | 3 | 8 | 58 | 1 | |||
43627 | 200491 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1090 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6013533.8773 | 2090002.5687 | 37.719510568674 | -122.395226601179 | (37.719510568674, -122.395226601179) | 10 | 3 | 8 | 58 | 1 | |||
48326 | 191007 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1429 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6012039.8637 | 2101705.15061 | 37.7515602022655 | -122.401212795961 | (37.7515602022655, -122.401212795961) | 10 | 3 | 8 | 28856 | 29 | ||||
51803 | 191006 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1429 Rhode Island St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6012039.74497 | 2101699.30663 | 37.7515441493432 | -122.40121279593 | (37.7515441493432, -122.40121279593) | 10 | 3 | 8 | 28856 | 29 | ||||
52731 | 191020 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2019 Palou Ave | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6012619.01947 | 2096888.03059 | 37.7383657107066 | -122.398871940681 | (37.7383657107066, -122.398871940681) | 10 | 3 | 8 | 58 | 1 | |||
54210 | 46248 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 1675 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | Permit Number 44536 | 6016787.6752368 | 2092188.79463336 | 37.7256939401069 | -122.384131467798 | (37.7256939401069, -122.384131467798) | 10 | 3 | 8 | 58 | 1 | |||
63620 | 191021 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1951 Revere Ave | 8 | Front Yard : Yard | Tree | Private 2 | 7 | 6013036.60828 | 2095880.65863 | 37.7356229367385 | -122.397357487761 | (37.7356229367385, -122.397357487761) | 10 | 3 | 8 | 58 | 1 | ||||
71674 | 200495 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3239 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013536.65 | 2090071.192 | 37.7196991487764 | -122.39522182132 | (37.7196991487764, -122.39522182132) | 10 | 3 | 8 | 58 | 1 | |||
78308 | 176180 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 314 Tocoloma Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012557.69703 | 2086963.50527 | 37.7111115690056 | -122.398387796956 | (37.7111115690056, -122.398387796956) | 10 | 3 | 8 | 309 | 1 | |||
92607 | 191017 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Bay Shore Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6010875.9229 | 2095145.90873 | 37.733484933471 | -122.404776133825 | (37.733484933471, -122.404776133825) | 10 | 3 | 8 | 58 | 1 | |||
97444 | 191018 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Bay Shore Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6010873.51773 | 2095150.95249 | 37.7334986481358 | -122.404784804195 | (37.7334986481358, -122.404784804195) | 10 | 3 | 8 | 58 | 1 | |||
107849 | 191011 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1540 Newhall St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6014228.97917 | 2095505.16644 | 37.7346582268008 | -122.393208705617 | (37.7346582268008, -122.393208705617) | 10 | 3 | 8 | 58 | 1 | |||
116663 | 57854 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | 3 | Permit Number 16796 | 6011320.98942 | 2104586.65108 | 37.7594320346834 | -122.403901516137 | (37.7594320346834, -122.403901516137) | 10 | 3 | 8 | 28856 | 29 | ||
121849 | 202080 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 52 Gould St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012726.46882 | 2090908.80886 | 37.7219539853837 | -122.398081078675 | (37.7219539853837, -122.398081078675) | 10 | 3 | 8 | 58 | 1 | |||
133080 | 176181 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 324 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012548.63257 | 2086934.28388 | 37.7110308278852 | -122.398417077096 | (37.7110308278852, -122.398417077096) | 10 | 3 | 8 | 309 | 1 | |||
135316 | 191013 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1540 Newhall St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6014211.22756 | 2095480.93913 | 37.7345907173738 | -122.393268384633 | (37.7345907173738, -122.393268384633) | 10 | 3 | 8 | 58 | 1 | |||
136496 | 191012 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1540 Newhall St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6014220.67359 | 2095494.23787 | 37.7346277577708 | -122.393236656563 | (37.7346277577708, -122.393236656563) | 10 | 3 | 8 | 58 | 1 | |||
143558 | 200247 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3225 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013551.8996 | 2090073.2715 | 37.7197057067439 | -122.395169254095 | (37.7197057067439, -122.395169254095) | 10 | 3 | 8 | 58 | 1 | |||
144223 | 201356 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1 Bitting Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012930.00772 | 2092558.19115 | 37.7264941893332 | -122.397493109122 | (37.7264941893332, -122.397493109122) | 10 | 3 | 8 | 58 | 1 | ||||
147829 | 190999 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 900 Tennessee St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015461.30451 | 2104782.94295 | 37.7602014514497 | -122.389595858288 | (37.7602014514497, -122.389595858288) | 10 | 3 | 8 | 28856 | 29 | |||
159829 | 191000 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 900 Tennessee St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015461.00601 | 2104768.16108 | 37.7601608470553 | -122.389595858273 | (37.7601608470553, -122.389595858273) | 10 | 3 | 8 | 28856 | 29 | |||
161522 | 191014 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2701 Phelps St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011783.11668 | 2093247.60163 | 37.728323242206 | -122.401506319354 | (37.728323242206, -122.401506319354) | 10 | 3 | 8 | 58 | 1 | |||
165012 | 200492 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1092 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013522.7867 | 2090014.3525 | 37.7195423078427 | -122.395265762628 | (37.7195423078427, -122.395265762628) | 10 | 3 | 8 | 58 | 1 | |||
165023 | 51794 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 308 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 5 | Permit Number 48043 | 6012078.06039 | 2087170.76392 | 37.7116539294676 | -122.400060094404 | (37.7116539294676, -122.400060094404) | 10 | 3 | 8 | 309 | 1 | ||
166854 | 191002 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1200 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014292.84021 | 2104834.71715 | 37.7602787535777 | -122.393640678782 | (37.7602787535777, -122.393640678782) | 10 | 3 | 8 | 28856 | 29 | |||
170344 | 201355 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1 Bitting Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012932.38695 | 2092554.18507 | 37.7264833219297 | -122.397484603332 | (37.7264833219297, -122.397484603332) | 10 | 3 | 8 | 58 | 1 | ||||
171712 | 190997 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 801 Minnesota St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6015256.7715 | 2104755.60023 | 37.7601150310956 | -122.390301336853 | (37.7601150310956, -122.390301336853) | 10 | 3 | 8 | 28856 | 29 | |||
172844 | 200257 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1084 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 6013566.4561 | 2089983.1601 | 37.7194590883037 | -122.395112628607 | (37.7194590883037, -122.395112628607) | 10 | 3 | 8 | 58 | 1 | |||
173292 | 191010 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1540 Newhall St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6014248.56136 | 2095533.49076 | 37.7347370874406 | -122.393142984083 | (37.7347370874406, -122.393142984083) | 10 | 3 | 8 | 58 | 1 | |||
175088 | 191009 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1350 Rankin St | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6012766.95212 | 2096886.79992 | 37.7383705733355 | -122.398360372158 | (37.7383705733355, -122.398360372158) | 10 | 3 | 8 | 58 | 1 | |||
185114 | 191004 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1200 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014284.50499 | 2104834.6903 | 37.7602782166872 | -122.39366950474 | (37.7602782166872, -122.39366950474) | 10 | 3 | 8 | 28856 | 29 | |||
185399 | 191008 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1350 Rankin St | 3 | Side Yard : Yard | Tree | Private 2 | 6 | Width 2ft | 6012780.96774 | 2096905.12701 | 37.7384216764219 | -122.398313198195 | (37.7384216764219, -122.398313198195) | 10 | 3 | 8 | 58 | 1 | |||
190148 | 17461 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2019 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6012621.10335 | 2096891.20561 | 37.7383745447599 | -122.398864958367 | (37.7383745447599, -122.398864958367) | 10 | 3 | 8 | 58 | 1 | |||
191743 | 191003 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1200 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6014288.23164 | 2104834.71281 | 37.7602784855758 | -122.393656617482 | (37.7602784855758, -122.393656617482) | 10 | 3 | 8 | 28856 | 29 | |||
13945 | 223850 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 6 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000602.6654 | 2104289.54137 | 37.7580116040773 | -122.440949336057 | (37.7580116040773, -122.440949336057) | 2 | 4 | 5 | 28862 | 38 | |||
18539 | 223849 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 5 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000601.16124 | 2104292.97169 | 37.7580209372281 | -122.440954784152 | (37.7580209372281, -122.440954784152) | 2 | 4 | 5 | 28862 | 38 | |||
31485 | 223842 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3922 22nd St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6002306.42247 | 2102988.7945 | 37.7545369555235 | -122.434964002506 | (37.7545369555235, -122.434964002506) | 2 | 4 | 5 | 28862 | 22 | |||
36582 | 223823 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3101 17th St | 1 | : | Tree | Private 2 | 2 | Width 1ft | 6008008.73592 | 2106169.28223 | 37.7635919693097 | -122.415468996495 | (37.7635919693097, -122.415468996495) | 8 | 4 | 7 | 28859 | 19 | |||
36848 | 121579 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 742X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x1 | 6004940 | 2104032 | 37.7575505344573 | -122.425930645849 | (37.7575505344573, -122.425930645849) | 2 | 4 | 5 | 28862 | 3 | |||
43177 | 223824 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3101 17th St | 2 | : | Tree | Private 2 | 5 | Width 1ft | 6008016.50496 | 2106169.76352 | 37.7635937274947 | -122.415442159828 | (37.7635937274947, -122.415442159828) | 8 | 4 | 7 | 28859 | 19 | |||
49034 | 223822 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1315 Utah St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6010905.48348 | 2102095.73052 | 37.7525692973405 | -122.405163145389 | (37.7525692973405, -122.405163145389) | 10 | 4 | 8 | 28859 | 19 | |||
57333 | 223847 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 3 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000596.08551 | 2104301.4441 | 37.7580439113049 | -122.440972945939 | (37.7580439113049, -122.440972945939) | 2 | 4 | 5 | 28862 | 38 | |||
62930 | 223835 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2100 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6008066.57958 | 2106159.15106 | 37.7635674025314 | -122.415268215666 | (37.7635674025314, -122.415268215666) | 8 | 4 | 7 | 28859 | 19 | |||
64961 | 223848 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 4 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000598.61266 | 2104296.68505 | 37.758030988052 | -122.440963864593 | (37.758030988052, -122.440963864593) | 2 | 4 | 5 | 28862 | 38 | |||
67136 | 223844 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 198 Hancock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003058.19031 | 2105071.09534 | 37.7602971123288 | -122.432512916434 | (37.7602971123288, -122.432512916434) | 2 | 4 | 5 | 28862 | 3 | |||
79729 | 223852 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3710 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003652.42128 | 2103638.06127 | 37.7563960214646 | -122.430355505816 | (37.7563960214646, -122.430355505816) | 2 | 4 | 5 | 28862 | 3 | |||
89432 | 251464 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3440 16th St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003947 | 2106622 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | 8 | 4 | 5 | 28862 | 3 | ||||
93149 | 223851 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 310 Liberty St | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003941.73153 | 2103931.65904 | 37.7572185549154 | -122.429375905766 | (37.7572185549154, -122.429375905766) | 2 | 4 | 5 | 28862 | 3 | |||
97293 | 223819 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1201 Vermont St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011464.41366 | 2102201.65675 | 37.75289137874 | -122.40323770855 | (37.75289137874, -122.40323770855) | 10 | 4 | 8 | 28859 | 19 | |||
102449 | 223834 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2100 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6008066.72851 | 2106165.04225 | 37.7635835867453 | -122.415268117623 | (37.7635835867453, -122.415268117623) | 8 | 4 | 7 | 28859 | 19 | |||
102616 | 251462 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3440 16th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003947 | 2106622 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | 8 | 4 | 5 | 28862 | 3 | ||||
107839 | 251463 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3440 16th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003947 | 2106622 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | 8 | 4 | 5 | 28862 | 3 | ||||
111315 | 101698 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 2700 18th St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x3 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | 8 | 4 | 8 | 28859 | 19 | ||||
112773 | 223836 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2100 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6008066.44955 | 2106150.296 | 37.7635430812786 | -122.415268038516 | (37.7635430812786, -122.415268038516) | 8 | 4 | 7 | 28859 | 19 | |||
123824 | 223843 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1336 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009254.1321 | 2101336.70744 | 37.7503927320375 | -122.410820223693 | (37.7503927320375, -122.410820223693) | 2 | 4 | 7 | 28859 | 19 | |||
125941 | 223845 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000588.98082 | 2104313.3574 | 37.7580762176596 | -122.440998371578 | (37.7580762176596, -122.440998371578) | 2 | 4 | 5 | 28862 | 38 | |||
127588 | 223833 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2700 18th St | 3 | : | Tree | Private 2 | 8 | Width 2ft | 6009765.40934 | 2105513.79393 | 37.7618907290033 | -122.409346929127 | (37.7618907290033, -122.409346929127) | 8 | 4 | 8 | 28859 | 19 | |||
146131 | 223820 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1201 Vermont St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011461.07467 | 2102226.45341 | 37.7529592784527 | -122.403250999655 | (37.7529592784527, -122.403250999655) | 10 | 4 | 8 | 28859 | 19 | |||
148528 | 223837 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1201 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6001376.71765 | 2100230.22226 | 37.7469097440832 | -122.437981578698 | (37.7469097440832, -122.437981578698) | 2 | 4 | 5 | 63 | 22 | |||
160570 | 223821 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1315 Utah St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6010905.03625 | 2102087.35489 | 37.7525462747028 | -122.405164102267 | (37.7525462747028, -122.405164102267) | 10 | 4 | 8 | 28859 | 19 | |||
171586 | 223839 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1201 Douglass St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6001375.46533 | 2100241.14483 | 37.7469396636504 | -122.437986691344 | (37.7469396636504, -122.437986691344) | 2 | 4 | 5 | 63 | 22 | |||
181762 | 223825 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3101 17th St | 3 | : | Tree | Private 2 | 2 | Width 1ft | 6008027.95935 | 2106170.28892 | 37.7635958139266 | -122.41540257978 | (37.7635958139266, -122.41540257978) | 8 | 4 | 7 | 28859 | 19 | |||
185681 | 223826 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3101 17th St | 4 | : | Tree | Private 2 | 2 | Width 1ft | 6008033.82154 | 2106170.92846 | 37.7635978994403 | -122.415382349527 | (37.7635978994403, -122.415382349527) | 8 | 4 | 7 | 28859 | 19 | |||
186601 | 223817 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 742 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6004960.84188 | 2104040.81027 | 37.7575759032313 | -122.425859193273 | (37.7575759032313, -122.425859193273) | 2 | 4 | 5 | 28862 | 3 | |||
189201 | 223838 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1201 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6001376.54401 | 2100236.11585 | 37.7469259166077 | -122.437982601211 | (37.7469259166077, -122.437982601211) | 2 | 4 | 5 | 63 | 22 | |||
191473 | 223846 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 163 Corwin St | 2 | Back Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000593.0444 | 2104306.73656 | 37.7580582698975 | -122.440983843043 | (37.7580582698975, -122.440983843043) | 2 | 4 | 5 | 28862 | 38 | |||
24750 | 94468 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
28817 | 223857 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 4136 17th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6001443.19254 | 2105860.10776 | 37.7623718330075 | -122.438154948197 | (37.7623718330075, -122.438154948197) | 15 | 5 | 5 | 28862 | 3 | |||
66673 | 251126 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 120 Saint Germain Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998052 | 2104136 | 37.7574444146042 | -122.449759516473 | (37.7574444146042, -122.449759516473) | 15 | 5 | 4 | 28862 | 38 |
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) );