trees
3,587 rows where qSpecies_id = 28 sorted by Police Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
4470 | 19187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 125 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003528.70248 | 2107586.69801 | 37.7672310211182 | -122.431065186025 | (37.7672310211182, -122.431065186025) | 7 | 9 | 5 | 28862 | 3 | |||
5305 | 5766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 414 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003770.1384677 | 2108392.97573 | 37.769458541933 | -122.430287624255 | (37.769458541933, -122.430287624255) | 15 | 9 | 5 | 29492 | 10 | |||
6987 | 249466 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | 7 | 9 | 11 | 28858 | 36 | ||||
7199 | 5759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6003976.63728 | 2108405.62354 | 37.7695049641016 | -122.42957425574 | (37.7695049641016, -122.42957425574) | 7 | 9 | 5 | 29492 | 10 | |||
8104 | 140395 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1270 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6004643.5766 | 2113229.4094 | 37.7827876389021 | -122.427611060911 | (37.7827876389021, -122.427611060911) | 7 | 9 | 11 | 29490 | 41 | |||
8782 | 22575 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006314.95978 | 2112814.99848 | 37.7817441651975 | -122.421799324385 | (37.7817441651975, -122.421799324385) | 7 | 9 | 11 | 28852 | 41 | |||
9240 | 126178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2413 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6000282.738 | 2119543.98555 | 37.7998781830919 | -122.44315133689 | (37.7998781830919, -122.44315133689) | 13 | 9 | 1 | 57 | 17 | |||
9867 | 18856 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2201 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004191.66186 | 2115995.22985 | 37.79035631503 | -122.429371791378 | (37.79035631503, -122.429371791378) | 13 | 9 | 1 | 29490 | 27 | |||
10989 | 254569 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6004613 | 2113717 | 37.7841247118733 | -122.427751595484 | (37.7841247118733, -122.427751595484) | 13 | 9 | 11 | 28858 | 41 | |||
11636 | 249410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 698 Polk St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6007114.55441 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | 7 | 9 | 9 | 28852 | 36 | |||
11714 | 24315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006566.61253 | 2112551.64159 | 37.7810352395317 | -122.420910018978 | (37.7810352395317, -122.420910018978) | 7 | 9 | 11 | 28852 | 41 | |||
12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
12133 | 133687 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
14179 | 257990 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1299x Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004575 | 2113275 | 37.7829089401984 | -122.427851556708 | (37.7829089401984, -122.427851556708) | 7 | 9 | 11 | 29490 | 41 | ||||
15339 | 222951 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6003922.8139 | 2108399.31131 | 37.7694845845646 | -122.429759978361 | (37.7694845845646, -122.429759978361) | 7 | 9 | 5 | 29492 | 10 | |||
15622 | 126182 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003859 | 2120749 | 37.803390106055 | -122.430862178125 | (37.803390106055, -122.430862178125) | 13 | 9 | 1 | 28858 | 17 | |||
15721 | 126288 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500x Van Ness Ave | 7 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6005772.33142 | 2119211.18315 | 37.7992758747311 | -122.424131583019 | (37.7992758747311, -122.424131583019) | 13 | 9 | 1 | 28858 | 32 | |||
15846 | 75161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6005585.43876 | 2119632.07302 | 37.8004209769936 | -122.42480825631 | (37.8004209769936, -122.42480825631) | 13 | 9 | 1 | 57 | 17 | |||
16677 | 12369 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
17347 | 12370 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004408.00965 | 2113459.2839 | 37.7834054897746 | -122.428442413333 | (37.7834054897746, -122.428442413333) | 7 | 9 | 11 | 29490 | 41 | |||
18822 | 65766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | 13 | 9 | 1 | 57 | 17 | |
19241 | 26162 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999090.09548 | 2119848.96049 | 37.8006474865597 | -122.447300272802 | (37.8006474865597, -122.447300272802) | 13 | 9 | 1 | 57 | 17 | |||
19805 | 126225 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2137 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003795.94873 | 2115803.8767 | 37.7898084966014 | -122.430727270273 | (37.7898084966014, -122.430727270273) | 13 | 9 | 1 | 29490 | 27 | |||
20251 | 126264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1333 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007187.34034 | 2115852.63803 | 37.7901339378778 | -122.418996808454 | (37.7901339378778, -122.418996808454) | 13 | 9 | 10 | 28858 | 21 | |||
20449 | 12388 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1450 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
20962 | 116910 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 351X HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003606 | 2108630 | 37.7701000542623 | -122.430872290016 | (37.7701000542623, -122.430872290016) | 15 | 9 | 5 | 29492 | 10 | |||
24587 | 126136 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2722 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6000010.55961 | 2117815.97054 | 37.7951179896682 | -122.443968946536 | (37.7951179896682, -122.443968946536) | 13 | 9 | 1 | 57 | 17 | |||
24768 | 50314 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
25028 | 23944 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2334X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003622.99851 | 2115966.72014 | 37.7902458233354 | -122.431337290596 | (37.7902458233354, -122.431337290596) | 13 | 9 | 1 | 29490 | 27 | |||
25658 | 7812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006212.78826 | 2112695.72596 | 37.7814109097272 | -122.422144314234 | (37.7814109097272, -122.422144314234) | 7 | 9 | 11 | 28852 | 41 | |||
25886 | 126275 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2836 Larkin St | 7 | Side Yard : Yard | Tree | Private 2 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | 5 | 9 | 1 | 28858 | 32 | ||||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
26452 | 249722 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 6 | Front Yard : Yard | Tree | Private 2 | 14 | 6000190.26691 | 2117349.57001 | 37.7938476262185 | -122.443313617731 | (37.7938476262185, -122.443313617731) | 13 | 9 | 1 | 57 | 27 | ||||
27004 | 141435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005366.2195 | 2110950.1956 | 37.776570325295 | -122.424948806725 | (37.776570325295, -122.424948806725) | 7 | 9 | 11 | 28852 | 10 | |||
27861 | 126209 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000795.3234 | 2117174.07818 | 37.7934002557748 | -122.441207473859 | (37.7934002557748, -122.441207473859) | 13 | 9 | 1 | 29490 | 27 | |||
28479 | 126251 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6007028.01622 | 2112773.92137 | 37.7816715629397 | -122.419329563908 | (37.7816715629397, -122.419329563908) | 7 | 9 | 9 | 28852 | 36 | |||
28643 | 2608 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1760 Bush St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005030.51103 | 2115130.79368 | 37.7880302457848 | -122.426407854199 | (37.7880302457848, -122.426407854199) | 13 | 9 | 11 | 28858 | 27 | |||
28914 | 24330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
28970 | 7813 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006213.15076 | 2112713.37247 | 37.7814593831787 | -122.422144314209 | (37.7814593831787, -122.422144314209) | 7 | 9 | 11 | 28852 | 41 | |||
29063 | 22577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006373.00538 | 2112825.19303 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | 7 | 9 | 11 | 28852 | 41 | |||
29328 | 116911 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 351X HERMANN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6003606 | 2108630 | 37.7701000542623 | -122.430872290016 | (37.7701000542623, -122.430872290016) | 15 | 9 | 5 | 29492 | 10 | |||
29506 | 33680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.7770266994083 | -122.425035932953 | (37.7770266994083, -122.425035932953) | 7 | 9 | 11 | 28852 | 10 | ||
29614 | 222947 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 366 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6003535.08021 | 2108659.73976 | 37.7701776938656 | -122.431119723608 | (37.7701776938656, -122.431119723608) | 15 | 9 | 11 | 29492 | 10 | |||
30238 | 137810 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2075 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003825.3493 | 2115561.4198 | 37.7891444370337 | -122.430608239064 | (37.7891444370337, -122.430608239064) | 13 | 9 | 1 | 29490 | 27 | |||
30511 | 103595 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31160 | 7815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006205.55902 | 2112775.31728 | 37.781629040289 | -122.422174980189 | (37.781629040289, -122.422174980189) | 7 | 9 | 11 | 28852 | 41 | |||
31368 | 126148 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1535 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004474.30573 | 2120123.1658 | 37.8017065704734 | -122.428688249077 | (37.8017065704734, -122.428688249077) | 13 | 9 | 1 | 57 | 17 | |||
31425 | 103598 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
32026 | 106549 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2221 LARKIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6006757.8 | 2118838.2 | 37.7983073484274 | -122.420695021037 | (37.7983073484274, -122.420695021037) | 13 | 9 | 10 | 28858 | 32 | |||
32098 | 23170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006871.78386 | 2111296.65749 | 37.7776065535391 | -122.419765202716 | (37.7776065535391, -122.419765202716) | 7 | 9 | 9 | 28852 | 36 | |||
32796 | 126279 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2211 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006770.57975 | 2118843.35526 | 37.7983222237356 | -122.42065116532 | (37.7983222237356, -122.42065116532) | 13 | 9 | 10 | 28858 | 32 | |||
32983 | 38841 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1817 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40670 | 6005665.65244341 | 2115853.93139831 | 37.7900516844756 | -122.42426182602 | (37.7900516844756, -122.42426182602) | 13 | 9 | 1 | 28858 | 41 | ||||
33180 | 37143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Permit Number 39724 | 6003778.52248 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | 13 | 9 | 1 | 29490 | 27 | |||
33381 | 126262 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1590 Larkin St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 3ft | 6007118.63275 | 2116680.98054 | 37.7924044922289 | -122.419293317642 | (37.7924044922289, -122.419293317642) | 5 | 9 | 10 | 28858 | 21 | |||
33959 | 126223 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6003784.13407 | 2115883.06343 | 37.7900252539066 | -122.430773801182 | (37.7900252539066, -122.430773801182) | 13 | 9 | 1 | 29490 | 27 | |||
34671 | 141733 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6003850.579 | 2113561.9176 | 37.7836557366883 | -122.430378229205 | (37.7836557366883, -122.430378229205) | 13 | 9 | 11 | 29490 | 41 | |||
35042 | 249737 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 21 | : | Tree | Private 2 | 31 | Width 3ft | 6000190.59568 | 2117194.08216 | 37.7934207162548 | -122.443301306923 | (37.7934207162548, -122.443301306923) | 13 | 9 | 1 | 57 | 27 | |||
35935 | 24314 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006601.99404 | 2112547.97273 | 37.7810271600142 | -122.420787355977 | (37.7810271600142, -122.420787355977) | 7 | 9 | 11 | 28852 | 41 | |||
37240 | 50313 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
37425 | 126188 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004588.02388 | 2120570.99055 | 37.8029426166745 | -122.428326667653 | (37.8029426166745, -122.428326667653) | 13 | 9 | 1 | 57 | 17 | |||
37955 | 126239 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1047 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005998.3015 | 2113461.40483 | 37.7835011760695 | -122.422940770919 | (37.7835011760695, -122.422940770919) | 7 | 9 | 11 | 28858 | 41 | |||
38501 | 99172 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003312.12208 | 2116110.60344 | 37.7906232670935 | -122.432423180296 | (37.7906232670935, -122.432423180296) | 13 | 9 | 1 | 29490 | 27 | ||
41319 | 126210 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6000809.47478 | 2117175.6594 | 37.7934054034746 | -122.441158622678 | (37.7934054034746, -122.441158622678) | 13 | 9 | 1 | 29490 | 27 | |||
41621 | 98047 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.432146447219 | (37.7927133715759, -122.432146447219) | 13 | 9 | 1 | 29490 | 27 | |||
42032 | 101361 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1303 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007113.6 | 2115829 | 37.7900648810449 | -122.419250267251 | (37.7900648810449, -122.419250267251) | 13 | 9 | 10 | 28858 | 21 | ||||
42257 | 115376 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004637 | 2110246 | 37.7745955592359 | -122.427421211008 | (37.7745955592359, -122.427421211008) | 7 | 9 | 11 | 28852 | 10 | ||||
42300 | 126281 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2211 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006773.78418 | 2118812.34159 | 37.7982372486056 | -122.420637874239 | (37.7982372486056, -122.420637874239) | 13 | 9 | 10 | 28858 | 32 | |||
42309 | 24332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | 7 | 9 | 11 | 28852 | 41 | |||
42596 | 103592 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
42756 | 126211 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6000823.62641 | 2117177.24031 | 37.7934105503173 | -122.441109770604 | (37.7934105503173, -122.441109770604) | 13 | 9 | 1 | 29490 | 27 | |||
43371 | 126171 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2901 Divisadero St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 6000513.1495 | 2118370.57781 | 37.7966694514978 | -122.442269746748 | (37.7966694514978, -122.442269746748) | 13 | 9 | 1 | 57 | 17 | |||
44019 | 249723 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 7 | Front Yard : Yard | Tree | Private 2 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) | 13 | 9 | 1 | 57 | 27 | ||||
44167 | 141431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.7765854191309 | -122.424815713066 | (37.7765854191309, -122.424815713066) | 7 | 9 | 11 | 28852 | 10 | |
44305 | 126250 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 611 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006607.01339 | 2112503.55173 | 37.7809054736589 | -122.420766837016 | (37.7809054736589, -122.420766837016) | 7 | 9 | 11 | 28852 | 41 | |||
45512 | 126187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3201 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6004586.52234 | 2120587.15972 | 37.8029869280666 | -122.428333016857 | (37.8029869280666, -122.428333016857) | 13 | 9 | 1 | 57 | 17 | |||
45812 | 115344 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2265 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006750.95279 | 2119001.45265 | 37.7987552131524 | -122.420730310163 | (37.7987552131524, -122.420730310163) | 5 | 9 | 10 | 28858 | 32 | |||
47322 | 248672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004845.3119 | 2108840.52494 | 37.7707482453776 | -122.426600516098 | (37.7707482453776, -122.426600516098) | 7 | 9 | 5 | 28852 | 10 | |||
47482 | 22584 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006566.74341 | 2112845.87169 | 37.7818431310978 | -122.420930462379 | (37.7818431310978, -122.420930462379) | 7 | 9 | 11 | 28852 | 41 | |||
47532 | 16737 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003776.6871065 | 2113549.9348865 | 37.7836186493065 | -122.430633011597 | (37.7836186493065, -122.430633011597) | 13 | 9 | 11 | 29490 | 41 | |||
50291 | 140343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1335 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004611.4415 | 2113462.04 | 37.7834245669976 | -122.427738815188 | (37.7834245669976, -122.427738815188) | 7 | 9 | 11 | 29490 | 41 | |||
50422 | 121422 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2466 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999524 | 2119846 | 37.8006641419807 | -122.445798577396 | (37.8006641419807, -122.445798577396) | 13 | 9 | 1 | 57 | 17 | ||||
50684 | 113185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2400 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x6 | 6002293.64076 | 2116461.76409 | 37.791529658706 | -122.435972200979 | (37.791529658706, -122.435972200979) | 13 | 9 | 1 | 29490 | 27 | |||
50941 | 24317 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006479.1525 | 2112537.25416 | 37.7809908049215 | -122.421211565287 | (37.7809908049215, -122.421211565287) | 7 | 9 | 11 | 28852 | 41 | |||
51485 | 12363 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1305 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004583.86888 | 2113510.41962 | 37.7835558456566 | -122.427837654062 | (37.7835558456566, -122.427837654062) | 7 | 9 | 11 | 29490 | 41 | |||
51675 | 140326 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1435 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6004565.6838 | 2113797.014 | 37.7843417337067 | -122.427920996094 | (37.7843417337067, -122.427920996094) | 13 | 9 | 11 | 29490 | 41 | |||
54643 | 258523 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
54789 | 126249 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 611 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006560.14321 | 2112498.86101 | 37.7808899522457 | -122.420928651146 | (37.7808899522457, -122.420928651146) | 7 | 9 | 11 | 28852 | 41 | |||
54958 | 126172 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2901 Divisadero St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6000514.61681 | 2118336.13924 | 37.7965749759056 | -122.442262196039 | (37.7965749759056, -122.442262196039) | 13 | 9 | 1 | 57 | 17 | |||
55071 | 23367 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1356X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 18 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | |||
55548 | 248673 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6005207.14412 | 2108888.77574 | 37.7709011795763 | -122.425352365033 | (37.7709011795763, -122.425352365033) | 7 | 9 | 5 | 28852 | 10 | |||
55644 | 126174 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2901 Divisadero St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 6000528.45838 | 2118255.9071 | 37.7963554684918 | -122.442208538896 | (37.7963554684918, -122.442208538896) | 13 | 9 | 1 | 57 | 17 | |||
55825 | 19161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6003505.74356 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | 7 | 9 | 5 | 28862 | 3 | |||
55990 | 126216 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2749 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002083.11634 | 2117618.54182 | 37.7946939089613 | -122.4367834551 | (37.7946939089613, -122.4367834551) | 13 | 9 | 1 | 57 | 27 | |||
56021 | 24324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006305.76929 | 2112511.39113 | 37.7809100152295 | -122.421809546989 | (37.7809100152295, -122.421809546989) | 7 | 9 | 11 | 28852 | 41 | |||
56140 | 248668 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6004619.27289 | 2110222.43512 | 37.7745298532048 | -122.427480853466 | (37.7745298532048, -122.427480853466) | 7 | 9 | 11 | 28852 | 10 | |||
56824 | 249742 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Broderick St | 26 | Front Yard : Yard | Tree | Private 2 | 15 | 6000223.59296 | 2117195.73646 | 37.7934271400971 | -122.443187253112 | (37.7934271400971, -122.443187253112) | 13 | 9 | 1 | 57 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );