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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57099 | 12374 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004618.47022 | 2113718.13203 | 37.784128129581 | -122.427732751165 | (37.784128129581, -122.427732751165) | 13 | 9 | 11 | 28858 | 41 | |||
57242 | 114460 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1462 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005986 | 2118991 | 37.7986833693446 | -122.423376553534 | (37.7986833693446, -122.423376553534) | 13 | 9 | 1 | 28858 | 32 | ||||
57896 | 24322 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006352.81998 | 2112520.5015 | 37.7809376833117 | -122.421647422525 | (37.7809376833117, -122.421647422525) | 7 | 9 | 11 | 28852 | 41 | |||
59115 | 98048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2251 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | 13 | 9 | 1 | 29490 | 27 | |||
60377 | 19179 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 106 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6003475.35494 | 2107644.30442 | 37.767386171248 | -122.431253819727 | (37.767386171248, -122.431253819727) | 15 | 9 | 5 | 28862 | 3 | |||
60934 | 258521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
62274 | 258513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
62482 | 126207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6000770.45736 | 2117170.22017 | 37.7933882462337 | -122.441293235 | (37.7933882462337, -122.441293235) | 13 | 9 | 1 | 29490 | 27 | |||
64623 | 141433 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005339.4079 | 2110947.8437 | 37.7765623530515 | -122.425041388509 | (37.7765623530515, -122.425041388509) | 7 | 9 | 11 | 28852 | 10 | |||
64658 | 126232 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6003840.75526 | 2115801.97814 | 37.7898058220382 | -122.43057210842 | (37.7898058220382, -122.43057210842) | 13 | 9 | 1 | 29490 | 27 | |||
65316 | 50979 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 201 Richardson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
65764 | 103594 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 3 | 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 | ||||
66059 | 99085 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2801 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000131.22442 | 2117083.23739 | 37.7931129799394 | -122.443498769248 | (37.7931129799394, -122.443498769248) | 13 | 9 | 1 | 29490 | 27 | |||
66843 | 126229 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6003851.17867 | 2115730.08253 | 37.7896090053998 | -122.430530912278 | (37.7896090053998, -122.430530912278) | 13 | 9 | 1 | 29490 | 27 | |||
67087 | 126138 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6000495.78192 | 2118185.16591 | 37.796159369518 | -122.442316525005 | (37.796159369518, -122.442316525005) | 13 | 9 | 1 | 57 | 17 | |||
67710 | 249480 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 18 | 6006341.46577 | 2115150.70304 | 37.7881589304427 | -122.421873590397 | (37.7881589304427, -122.421873590397) | 13 | 9 | 1 | 28858 | 21 | ||||
67924 | 126135 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2722 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6000022.33122 | 2117817.30011 | 37.7951223117994 | -122.44392831067 | (37.7951223117994, -122.44392831067) | 13 | 9 | 1 | 57 | 17 | |||
68480 | 5767 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 449 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6003822.19897 | 2108336.65808 | 37.7693068560416 | -122.430103531057 | (37.7693068560416, -122.430103531057) | 7 | 9 | 5 | 28862 | 3 | |||
70227 | 137804 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2050 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003888.0281 | 2115499.8395 | 37.7889789037482 | -122.430386982886 | (37.7889789037482, -122.430386982886) | 13 | 9 | 11 | 29490 | 27 | |||
70364 | 126224 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 6003785.24399 | 2115868.23867 | 37.7899846117614 | -122.430768902581 | (37.7899846117614, -122.430768902581) | 13 | 9 | 1 | 29490 | 27 | |||
70651 | 140376 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6002707.9491 | 2113461.5978 | 37.7833154938117 | -122.434324114419 | (37.7833154938117, -122.434324114419) | 13 | 9 | 11 | 29490 | 41 | |||
70820 | 138840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 451 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005172.3876 | 2111107.6921 | 37.7769918216657 | -122.425630539914 | (37.7769918216657, -122.425630539914) | 7 | 9 | 11 | 28852 | 10 | |||
71025 | 126240 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700 Van Ness Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6006641.75911 | 2112973.79327 | 37.7821986007353 | -122.42068002636 | (37.7821986007353, -122.42068002636) | 7 | 9 | 9 | 28852 | 36 | |||
72622 | 141735 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1550 O'Farrell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6003743.654 | 2113548.9741 | 37.7836141397788 | -122.430747224883 | (37.7836141397788, -122.430747224883) | 13 | 9 | 11 | 29490 | 41 | |||
73622 | 24333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 9 | 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 | ||||
73970 | 23177 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
74481 | 66033 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1990 12:00:00 AM | 18 | 5x5 | Permit Number 29070 | 6005715.54101004 | 2110005.55330132 | 37.7739962917294 | -122.423673221036 | (37.7739962917294, -122.423673221036) | 7 | 9 | 11 | 28852 | 10 |
74741 | 23407 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1748X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006159.63822 | 2116414.10982 | 37.7916176753558 | -122.422592496742 | (37.7916176753558, -122.422592496742) | 13 | 9 | 10 | 28858 | 21 | |||
75034 | 126238 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1047 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005838.30611 | 2113438.12618 | 37.7834282293678 | -122.423492638073 | (37.7834282293678, -122.423492638073) | 7 | 9 | 11 | 28858 | 41 | |||
75483 | 126173 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2901 Divisadero St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 6ft | 6000518.25938 | 2118317.08271 | 37.7965228593064 | -122.442248223283 | (37.7965228593064, -122.442248223283) | 13 | 9 | 1 | 57 | 17 | |||
76494 | 126235 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2110 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6003827.18581 | 2115878.7891 | 37.7900159567313 | -122.430624540699 | (37.7900159567313, -122.430624540699) | 13 | 9 | 1 | 29490 | 27 | |||
78292 | 126147 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1535 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004454.32167 | 2120122.09726 | 37.8017025055244 | -122.428757326909 | (37.8017025055244, -122.428757326909) | 13 | 9 | 1 | 57 | 17 | |||
78660 | 126245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006341.80281 | 2112471.00109 | 37.7808011460043 | -122.421682019523 | (37.7808011460043, -122.421682019523) | 7 | 9 | 11 | 28852 | 41 | |||
79192 | 139764 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1304 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6004666.6223 | 2113372.1166 | 37.7831807809518 | -122.42754150263 | (37.7831807809518, -122.42754150263) | 7 | 9 | 11 | 28858 | 41 | |||
79292 | 140340 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1355 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6004589.0866 | 2113621.3186 | 37.783860641823 | -122.42782750733 | (37.783860641823, -122.42782750733) | 13 | 9 | 11 | 29490 | 41 | |||
79439 | 141803 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1320 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004236.5829 | 2112987.3667 | 37.782100020548 | -122.429001825257 | (37.782100020548, -122.429001825257) | 7 | 9 | 11 | 29490 | 41 | |||
79926 | 52113 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.424658112662 | (37.7765968250138, -122.424658112662) | 7 | 9 | 11 | 28852 | 10 | |
80097 | 53212 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 132 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2006 12:00:00 AM | Permit Number 49185 | 6004089.5020644 | 2108196.64307491 | 37.7689375443291 | -122.42916895785 | (37.7689375443291, -122.42916895785) | 7 | 9 | 5 | 28862 | 3 | |||
80263 | 115343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2265 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006749.63624 | 2119018.06822 | 37.7988007611158 | -122.420736046057 | (37.7988007611158, -122.420736046057) | 5 | 9 | 10 | 28858 | 32 | |||
81117 | 141436 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005378.4493 | 2110951.6067 | 37.7765748906289 | -122.424906600688 | (37.7765748906289, -122.424906600688) | 7 | 9 | 11 | 28852 | 10 | |||
81326 | 2606 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1760 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005030.51103 | 2115130.79368 | 37.7880302457848 | -122.426407854199 | (37.7880302457848, -122.426407854199) | 13 | 9 | 11 | 28858 | 27 | |||
82924 | 47042 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 6x9 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | 7 | 9 | 11 | 28852 | 10 | |
83214 | 19185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 113 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 6003523.98986 | 2107648.07805 | 37.7673992887615 | -122.431085867714 | (37.7673992887615, -122.431085867714) | 7 | 9 | 5 | 28862 | 3 | |||
83927 | 117355 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005443.21862963 | 2111009.61442816 | 37.7767378239513 | -122.424686672119 | (37.7767378239513, -122.424686672119) | 7 | 9 | 11 | 28852 | 10 | |||
84823 | 33683 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
85342 | 6180 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1075 Ellis St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
85438 | 141839 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1215 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004681.7421 | 2113034.4481 | 37.7822544822304 | -122.427465130761 | (37.7822544822304, -122.427465130761) | 7 | 9 | 11 | 29490 | 41 | |||
86434 | 222948 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 347 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6003592.17521 | 2108620.37819 | 37.770072851809 | -122.430919422987 | (37.770072851809, -122.430919422987) | 15 | 9 | 5 | 29492 | 10 | |||
87014 | 122572 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2018 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6003913 | 2115452 | 37.7888489630778 | -122.430297168966 | (37.7888489630778, -122.430297168966) | 13 | 9 | 11 | 29490 | 27 | |||
87435 | 248671 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6004331.06987 | 2108798.07115 | 37.7706025920658 | -122.428376262559 | (37.7706025920658, -122.428376262559) | 7 | 9 | 11 | 28852 | 10 | |||
87506 | 249488 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1500x Van Ness Ave | 2 | Median : Yard | Tree | DPW 1 | 28 | 6006252.33767 | 2115769.39606 | 37.7898526811986 | -122.422225932188 | (37.7898526811986, -122.422225932188) | 13 | 9 | 1 | 28858 | 21 | ||||
87538 | 103597 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 6 | 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 | ||||
87896 | 126267 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1454 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6006000.00875 | 2119001.3122 | 37.79871247466 | -122.423328812183 | (37.79871247466, -122.423328812183) | 13 | 9 | 1 | 28858 | 32 | |||
88141 | 139744 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1310 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004655.8452 | 2113492.9826 | 37.7835120393755 | -122.427587400945 | (37.7835120393755, -122.427587400945) | 7 | 9 | 11 | 28858 | 41 | |||
89043 | 126146 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 41 Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6003510.16046 | 2119826.75465 | 37.8008380897709 | -122.432003455008 | (37.8008380897709, -122.432003455008) | 13 | 9 | 1 | 57 | 17 | |||
92796 | 244245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005740.1233 | 2110010.337 | 37.7740108141999 | -122.423588526804 | (37.7740108141999, -122.423588526804) | 7 | 9 | 11 | 28852 | 10 | |||
93162 | 126243 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006291.93692 | 2112463.21725 | 37.7807769614403 | -122.421853977089 | (37.7807769614403, -122.421853977089) | 7 | 9 | 11 | 28852 | 41 | |||
93311 | 126176 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3529 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999701.32515 | 2120694.15268 | 37.8030030646038 | -122.445245975747 | (37.8030030646038, -122.445245975747) | 13 | 9 | 1 | 57 | 17 | |||
93339 | 99166 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 25928 | 6003335.03609 | 2115969.16201 | 37.7902362042855 | -122.432333793087 | (37.7902362042855, -122.432333793087) | 13 | 9 | 1 | 29490 | 27 | ||
93713 | 19166 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 93 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003516.9621827 | 2107776.3737946 | 37.7677511594735 | -122.431119333657 | (37.7677511594735, -122.431119333657) | 7 | 9 | 5 | 28862 | 3 | |||
94423 | 12391 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1450 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
94818 | 222941 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 411 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6004041.55964 | 2108350.73998 | 37.7693579429357 | -122.429345777602 | (37.7693579429357, -122.429345777602) | 7 | 9 | 5 | 28862 | 3 | |||
95196 | 222939 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 85 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003502.67516 | 2107807.88628 | 37.7678368754914 | -122.431171000251 | (37.7678368754914, -122.431171000251) | 15 | 9 | 5 | 28862 | 3 | |||
95244 | 22579 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006429.75961 | 2112830.68466 | 37.7817937088462 | -122.421403284548 | (37.7817937088462, -122.421403284548) | 7 | 9 | 11 | 28852 | 41 | |||
95468 | 126280 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2211 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006771.32346 | 2118830.10572 | 37.7982858857502 | -122.420647650793 | (37.7982858857502, -122.420647650793) | 13 | 9 | 10 | 28858 | 32 | |||
96227 | 22583 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006548.99233 | 2112844.76483 | 37.7818390913318 | -122.420991794355 | (37.7818390913318, -122.420991794355) | 7 | 9 | 11 | 28852 | 41 | |||
96233 | 140345 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1315 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004624.7147 | 2113371.2233 | 37.7831759577321 | -122.42768642242 | (37.7831759577321, -122.42768642242) | 7 | 9 | 11 | 29490 | 41 | |||
96784 | 126143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3233 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000856.10571 | 2119467.95657 | 37.7997021039237 | -122.441161817058 | (37.7997021039237, -122.441161817058) | 13 | 9 | 1 | 57 | 17 | |||
97634 | 5765 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 412 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1990 12:00:00 AM | 12 | 3X3 | 6003796.50672 | 2108397.52526 | 37.7694725273523 | -122.430196742212 | (37.7694725273523, -122.430196742212) | 15 | 9 | 5 | 29492 | 10 | ||
98074 | 19162 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 85 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003517.76355 | 2107824.4837 | 37.7678833029889 | -122.431119996093 | (37.7678833029889, -122.431119996093) | 7 | 9 | 5 | 28862 | 3 | |||
98369 | 7809 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006235.14399 | 2112561.39045 | 37.7810433181208 | -122.422057428004 | (37.7810433181208, -122.422057428004) | 7 | 9 | 11 | 28852 | 41 | |||
98426 | 50312 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 7 | 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 | |||
98709 | 51158 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2663DIVISADERO Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 47563 | 6000913.18019234 | 2117191.80900567 | 37.7934556526619 | -122.440800954263 | (37.7934556526619, -122.440800954263) | 13 | 9 | 1 | 29490 | 27 | |||
98970 | 139745 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6004649.9283 | 2113520.9897 | 37.7835886052305 | -122.427609867175 | (37.7835886052305, -122.427609867175) | 7 | 9 | 11 | 28858 | 41 | |||
99561 | 99168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2100 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | Permit Number 25928 | 6003328.674 | 2116003.83043 | 37.7903310341863 | -122.432358282529 | (37.7903310341863, -122.432358282529) | 13 | 9 | 1 | 29490 | 27 | ||
99804 | 141432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005324.8262 | 2110946.4325 | 37.7765576545373 | -122.425091730432 | (37.7765576545373, -122.425091730432) | 7 | 9 | 11 | 28852 | 10 | |||
100143 | 126139 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2601 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6000513.56408 | 2118189.44647 | 37.7961721362795 | -122.442255302765 | (37.7961721362795, -122.442255302765) | 13 | 9 | 1 | 57 | 17 | |||
100668 | 24327 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | |||
100689 | 126247 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 649 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6006451.94637 | 2112482.08949 | 37.7808378023715 | -122.421301766381 | (37.7808378023715, -122.421301766381) | 7 | 9 | 11 | 28852 | 41 | |||
101461 | 140346 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1315 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 0ft | 6004627.5091 | 2113346.7726 | 37.7831089802521 | -122.427675012288 | (37.7831089802521, -122.427675012288) | 7 | 9 | 11 | 29490 | 41 | |||
101607 | 249678 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2400 Baker St | 10 | Front Yard : Yard | Tree | Private 2 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | 13 | 9 | 1 | 57 | 27 | ||||
101679 | 126218 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2342 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6003446.9989 | 2115941.12306 | 37.7901655643334 | -122.431944407331 | (37.7901655643334, -122.431944407331) | 13 | 9 | 1 | 29490 | 27 | |||
101989 | 126212 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2692 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6000838.11727 | 2117180.06405 | 37.7934191289474 | -122.44105983397 | (37.7934191289474, -122.44105983397) | 13 | 9 | 1 | 29490 | 27 | |||
103271 | 12360 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1295X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004630.57692 | 2113279.75219 | 37.7829251323869 | -122.427659622288 | (37.7829251323869, -122.427659622288) | 7 | 9 | 11 | 29490 | 41 | |||
104203 | 112629 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 1303 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007113.6 | 2115829 | 37.7900648810449 | -122.419250267251 | (37.7900648810449, -122.419250267251) | 13 | 9 | 10 | 28858 | 21 | ||||
104617 | 126177 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3529 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999703.19672 | 2120677.23394 | 37.802956717127 | -122.445238282035 | (37.802956717127, -122.445238282035) | 13 | 9 | 1 | 57 | 17 | |||
105886 | 33710 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 107 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37778 | 6003699.03578605 | 2108805.33287927 | 37.7705867464666 | -122.430562993164 | (37.7705867464666, -122.430562993164) | 15 | 9 | 11 | 29492 | 10 | |||
105910 | 126284 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1442 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006671.09359 | 2118051.10155 | 37.7961412868369 | -122.420939139047 | (37.7961412868369, -122.420939139047) | 13 | 9 | 10 | 28858 | 32 | |||
106321 | 12385 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1445 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004345.46385 | 2113763.00934 | 37.7842359045501 | -122.428680455521 | (37.7842359045501, -122.428680455521) | 13 | 9 | 11 | 29490 | 41 | |||
107918 | 142012 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 749 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004871.6299 | 2111553.6762 | 37.7781993856574 | -122.426702721407 | (37.7781993856574, -122.426702721407) | 7 | 9 | 11 | 28852 | 10 | |||
107994 | 24335 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
108047 | 57553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 18 | 3x3 | Permit Number 16416 | 6004949.77312 | 2110889.41028 | 37.7763798917414 | -122.426385087108 | (37.7763798917414, -122.426385087108) | 7 | 9 | 11 | 28852 | 10 | |
108348 | 23178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
108400 | 24320 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006433.20726 | 2112530.1062 | 37.7809685880643 | -122.421370005128 | (37.7809685880643, -122.421370005128) | 7 | 9 | 11 | 28852 | 41 | |||
108456 | 126185 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3235 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6004573.69518 | 2120676.94649 | 37.8032327334623 | -122.428383808781 | (37.8032327334623, -122.428383808781) | 13 | 9 | 1 | 28858 | 17 | |||
108843 | 253969 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
108997 | 126180 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1451 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1985 12:00:00 AM | 10 | Width 3ft | Permit Number 22077 | 6003710.0609 | 2120692.32566 | 37.8032260532978 | -122.431373539285 | (37.8032260532978, -122.431373539285) | 13 | 9 | 1 | 57 | 17 | |
109055 | 126226 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2105 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6003810.46501 | 2115684.10566 | 37.7894804580966 | -122.430668495081 | (37.7894804580966, -122.430668495081) | 13 | 9 | 1 | 29490 | 27 | |||
109132 | 222938 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003520.45561 | 2107781.71115 | 37.7677660125137 | -122.43110763132 | (37.7677660125137, -122.43110763132) | 7 | 9 | 5 | 28862 | 3 | |||
110249 | 12362 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1295X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004630.57692 | 2113279.75219 | 37.7829251323869 | -122.427659622288 | (37.7829251323869, -122.427659622288) | 7 | 9 | 11 | 29490 | 41 |
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) );