trees
176 rows where qSpecies_id = 204 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 7401 | 223827 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6006190.11427 | 2097485.70732 | 37.7396464784009 | -122.421142417311 | (37.7396464784009, -122.421142417311) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |
| 22810 | 70611 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 1355 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2013 12:00:00 AM | Permit Number 770302 | 6007018.06454335 | 2115342.51032554 | 37.7887237195829 | -122.419546283037 | (37.7887237195829, -122.419546283037) | 13 | 9 | 10 | 28858 | 21 | |||
| 23484 | 247139 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 500 27th St | 9 | Front Yard : Yard | Tree | Private 2 | 4 | 6003171.19627 | 2100066.51011 | 37.7465621138595 | -122.43176475244 | (37.7465621138595, -122.43176475244) | 2 | 7 | 5 | 63 | 22 | ||||
| 24029 | 66561 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2750 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | 2 | Permit Number 29749 | 5998574.90625 | 2113241.231 | 37.7824749641808 | -122.448606865428 | (37.7824749641808, -122.448606865428) | 15 | 6 | 1 | 54 | 31 | |
| 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 | |||||
| 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 | ||||
| 31981 | 223830 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 6006171.8374 | 2097486.11107 | 37.7396465566502 | -122.421205639651 | (37.7396465566502, -122.421205639651) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 71699 | 94469 | 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 | |||||
| 80618 | 247145 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 500 27th St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | 6003145.29919 | 2100074.31823 | 37.7465820851075 | -122.431854859126 | (37.7465820851075, -122.431854859126) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | |
| 104809 | 94487 | 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 | |||||
| 111661 | 223828 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6006183.12873 | 2097474.29354 | 37.7396147449106 | -122.421165760098 | (37.7396147449106, -122.421165760098) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||
| 117555 | 32714 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1105 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 14 | Permit Number 37110 | 6007282.5299 | 2115198.67905 | 37.7883436871578 | -122.418621065405 | (37.7883436871578, -122.418621065405) | 13 | 9 | 10 | 28858 | 21 | |
| 127634 | 247140 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 500 27th St | 10 | Front Yard : Yard | Tree | Private 2 | 4 | 6003166.93075 | 2100089.40149 | 37.7466247264498 | -122.431781136306 | (37.7466247264498, -122.431781136306) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | ||||
| 158129 | 223831 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6006175.86532 | 2097493.16654 | 37.7396661564679 | -122.421192213677 | (37.7396661564679, -122.421192213677) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||
| 167110 | 223829 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 6006166.57618 | 2097475.41226 | 37.739616883506 | -122.421223071201 | (37.739616883506, -122.421223071201) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||||
| 175849 | 247135 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 500 27th St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6003187.16887 | 2100075.22315 | 37.7465869432374 | -122.431710142923 | (37.7465869432374, -122.431710142923) | 2 | 7 | 5 | 63 | 22 | ||||
| 177725 | 223832 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 100 Santa Marina St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6006182.73872 | 2097507.89721 | 37.7397069910787 | -122.421169494081 | (37.7397069910787, -122.421169494081) | 2 | 7 | 7 | 28859 | 2 | ||||
| 85820 | 26415 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 34 Maple St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.7901031363132 | -122.455752999345 | (37.7901031363132, -122.455752999345) | 11 | 6 | 1 | 54 | 31 | |||
| 99496 | 26413 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 34 Maple St | 10 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.7901031363132 | -122.455752999345 | (37.7901031363132, -122.455752999345) | 11 | 6 | 1 | 54 | 31 | |||
| 131267 | 26414 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 34 Maple St | 11 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.7901031363132 | -122.455752999345 | (37.7901031363132, -122.455752999345) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | ||||
| 127620 | 98316 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 1800X Clay St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6006008.9 | 2116666.9 | 37.7923032687502 | -122.423132026439 | (37.7923032687502, -122.423132026439) | 13 | 9 | 1 | 28858 | 27 | ||||
| 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 | ||||
| 136735 | 5743 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1760 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 6005273.48821 | 2098170.50351 | 37.7414750573209 | -122.424360413724 | (37.7414750573209, -122.424360413724) | 2 | 7 | 5 | 63 | 7 | |||
| 188701 | 26380 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 5997625.2697268 | 2089162.8567299 | 37.7163073414789 | -122.45015608882 | (37.7163073414789, -122.45015608882) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 17160 | 254708 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 2500X Market St | 2 | Median : Yard | Tree | Private 2 | 3x3 | ||||||||||||||
| 48758 | 112741 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 2514 CLAY ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002696 | 2116178 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | 13 | 9 | 1 | 29490 | 27 | ||||
| 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 | ||
| 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 | ||||
| 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 | |
| 83974 | 109404 | Undocumented 4 | Cupressus sempervirens :: Italian Cypress 204 | 355 CHRISTOPHER DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995347.2 | 2103110.3 | 37.7544729812167 | -122.459039464903 | (37.7544729812167, -122.459039464903) | 1 | 5 | 4 | 63 | 12 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 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 | ||||
| 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 | |
| 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 | ||
| 180491 | 251124 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 120 Saint Germain Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998052 | 2104136 | 37.7574444146042 | -122.449759516473 | (37.7574444146042, -122.449759516473) | 15 | 5 | 4 | 28862 | 38 | ||||
| 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 | |
| 183639 | 92230 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 565 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52673 | 6000270.5 | 2121584.5 | 37.8054801915973 | -122.443340329465 | (37.8054801915973, -122.443340329465) | 13 | 9 | 1 | 57 | 17 | ||
| 187832 | 251125 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 120 Saint Germain Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998052 | 2104136 | 37.7574444146042 | -122.449759516473 | (37.7574444146042, -122.449759516473) | 15 | 5 | 4 | 28862 | 38 | ||||
| 188954 | 92231 | Permitted Site 7 | Cupressus sempervirens :: Italian Cypress 204 | 565 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52673 | 6000270.5 | 2121584.5 | 37.8054801915973 | -122.443340329465 | (37.8054801915973, -122.443340329465) | 13 | 9 | 1 | 57 | 17 | ||
| 73024 | 105967 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2878 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 4x6 | Permit Number 772750 | 5999833.56214 | 2117445.14774 | 37.7940897102319 | -122.44455471813 | (37.7940897102319, -122.44455471813) | 13 | 9 | 1 | 57 | 27 | |
| 108922 | 105968 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2878 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5x6 | Permit Number 772750 | 5999819.97417 | 2117444.58508 | 37.7940873899718 | -122.444601693316 | (37.7940873899718, -122.444601693316) | 13 | 9 | 1 | 57 | 27 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 112856 | 185276 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2601 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 75 | Width 0ft | 5984954.4921 | 2097458.3645 | 37.7383513915158 | -122.494562994936 | (37.7383513915158, -122.494562994936) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 4322 | 176167 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 240 Hahn St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 9 | Width 10ft | 6007417.45559 | 2087310.83088 | 37.7117775673588 | -122.416178356572 | (37.7117775673588, -122.416178356572) | 9 | 7 | 8 | 309 | 39 | |||
| 114770 | 223840 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2145 Castro St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 10ft | 6002711.92837 | 2099262.74028 | 37.7443291052999 | -122.433295425556 | (37.7443291052999, -122.433295425556) | 2 | 7 | 5 | 63 | 22 | |||
| 27970 | 126431 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2750 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998558.23476 | 2113238.75223 | 37.782467204845 | -122.448664362682 | (37.782467204845, -122.448664362682) | 15 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | |||
| 57069 | 117819 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 3936 Balboa St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 1ft | 5983305.90457 | 2111075.09338 | 37.7756424773924 | -122.501269829965 | (37.7756424773924, -122.501269829965) | 11 | 6 | 2 | 55 | 26 | |||
| 57919 | 126430 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2750 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998566.60506 | 2113239.86578 | 37.7824707409821 | -122.448635485446 | (37.7824707409821, -122.448635485446) | 15 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 69477 | 126432 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2750 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998549.737 | 2113237.17296 | 37.7824623826667 | -122.448693647316 | (37.7824623826667, -122.448693647316) | 15 | 6 | 1 | 54 | 31 | |||
| 98152 | 124237 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 285 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5996676.38035 | 2110910.45447 | 37.7759665258119 | -122.455006429336 | (37.7759665258119, -122.455006429336) | 11 | 6 | 2 | 54 | 16 | |||
| 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 | |||
| 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 | |||
| 145380 | 124238 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 285 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5996678.45691 | 2110896.56425 | 37.7759285060276 | -122.454998242108 | (37.7759285060276, -122.454998242108) | 11 | 6 | 2 | 54 | 16 | |||
| 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 | |||
| 4168 | 176179 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 445 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003347.6645 | 2090993.45154 | 37.7216595581304 | -122.430507265493 | (37.7216595581304, -122.430507265493) | 9 | 7 | 6 | 28861 | 5 | |||
| 13780 | 176174 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 89 Ottawa Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 5998957.51819 | 2088637.0202 | 37.7149396628061 | -122.445513418834 | (37.7149396628061, -122.445513418834) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 45865 | 176172 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 89 Ottawa Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 5998934.49429 | 2088660.58419 | 37.7150030497132 | -122.445594692335 | (37.7150030497132, -122.445594692335) | 9 | 7 | 6 | 28861 | 25 | |||
| 58833 | 223818 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1760 Dolores St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6005274.68264 | 2098157.05024 | 37.7414381851378 | -122.424355327149 | (37.7414381851378, -122.424355327149) | 2 | 7 | 5 | 63 | 7 | |||
| 62182 | 176173 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 89 Ottawa Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 5998945.18552 | 2088649.14892 | 37.7149722614393 | -122.44555691723 | (37.7149722614393, -122.44555691723) | 9 | 7 | 6 | 28861 | 25 | |||
| 88296 | 223841 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1548 Noe St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6003280.5948 | 2099265.14761 | 37.7443679596294 | -122.43132927013 | (37.7443679596294, -122.43132927013) | 2 | 7 | 5 | 63 | 22 |
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) );