trees

Custom SQL query returning 62 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2580 222021 1 238 499X Ogden Ave 4 Sidewalk: Curb side : Yard Tree 2     6 Width 4ft   6008284.08114 2096093.57167 37.7359418012563 -122.413803907119 (37.7359418012563, -122.413803907119) 2 7 7 28859 2
4378 264740 11 238 2040 Sutter St 1 Back Yard : Yard Tree 2       3x3   6002718 2114518 37.7862166771353 -122.434364894821 (37.7862166771353, -122.434364894821) 13 9 11 29490 27
5683 222022 1 238 499X Ogden Ave 5 Sidewalk: Curb side : Yard Tree 2     6 Width 4ft   6008277.82449 2096093.47725 37.7359411906319 -122.413825532246 (37.7359411906319, -122.413825532246) 2 7 7 28859 2
8573 264725 6 238 136 Addison St 1 Front Yard : Cutout Tree 2       3x3   6002996 2096937 37.7379592717499 -122.432147110586 (37.7379592717499, -122.432147110586) 2 7 5 63 7
11191 204763 1 238 15 Mesa Ave 1 Sidewalk: Curb side : Yard Tree 2     32 Width 3ft   5993655.2243 2100726.83229 37.7478311786791 -122.464717641619 (37.7478311786791, -122.464717641619) 1 8 4 29491 40
11470 222020 1 238 499X Ogden Ave 2 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   6008297.46428 2096092.63045 37.7359399684425 -122.413757569564 (37.7359399684425, -122.413757569564) 2 7 7 28859 2
13873 19810 1 238 100 STAIRWAY24 1 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
17197 19812 1 238 100 STAIRWAY24 3 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
21936 204760 1 238 2 Mesa Ave 1 Sidewalk: Curb side : Yard Tree 2     29 Width 4ft   5993716.16346 2100737.36398 37.7478636091272 -122.464507683208 (37.7478636091272, -122.464507683208) 1 8 4 29491 40
24033 183953 1 238 2100 Sunset Blvd 41 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985069.1522 2100584.5154 37.7469416676011 -122.49439693858 (37.7469416676011, -122.49439693858) 1 8 3 29491 35
25545 204762 1 238 514 Arch St 1 Sidewalk: Property side : Yard Tree 2     5 Width 8ft   5992759.51953 2090548.27442 37.7198317175461 -122.467075007517 (37.7198317175461, -122.467075007517) 9 8 6 64 24
29152 258066 1 238 1000X Jamestown Ave 1 Sidewalk: Property side : Cutout Tree 1       3x3   6014011 2089680 37.7186513820216 -122.393554786163 (37.7186513820216, -122.393554786163) 10 3 8 58 1
30271 181429 1 238 1500 Sunset Blvd 62 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984933.5007 2104844.5838 37.7586307029356 -122.495180100301 (37.7586307029356, -122.495180100301) 1 8 3 56 35
31211 222028 1 238 190 Storrie St 9 Front Yard : Yard Tree 2     3 Width 3ft   6000755.51268 2105304.82476 37.7608080280015 -122.440493543449 (37.7608080280015, -122.440493543449) 15 4 5 28862 3
32670 85929 1 238 1706 26th Ave 1 Sidewalk: Curb side : Cutout Tree 1   12/20/2006 12:00:00 AM 3 3x3   5988139.8339 2103656.0542 37.7555545188612 -122.484004126341 (37.7555545188612, -122.484004126341) 1 8 3 56 35
33122 184085 1 238 1600 Sunset Blvd 86 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984928.3026 2104071.5069 37.7565077440746 -122.495141070042 (37.7565077440746, -122.495141070042) 1 8 3 56 35
34717 105836 1 238 2100X SLOAT BLVD 1 Median : Yard Tree 1     2     5984309 2095832 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772) 1 8 3 64 35
35984 97396 1 238 1203X Sunset Blvd 15 Median : Yard Tree 1           5989104.6 2108557.5 37.7690686805765 -122.481026569546 (37.7690686805765, -122.481026569546) 11 6 2 55 8
36567 222029 1 238 144 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6002834.60405 2107464.25398 37.7668554642406 -122.433457218072 (37.7668554642406, -122.433457218072) 15 5 5 28862 3
42149 186313 1 238 1800 Sunset Blvd 51 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984992.9477 2102798.4858 37.7530161640862 -122.494823651515 (37.7530161640862, -122.494823651515) 1 8 3 56 35
44567 204764 1 238 281 Joost Ave 1 Sidewalk: Property side : Yard Tree 2     21 Width 10ft   6000236.12204 2094924.05091 37.73227532195 -122.441544930949 (37.73227532195, -122.441544930949) 9 7 4 63 40
45430 30424 1 238 225 Wheeler Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/04/1972 12:00:00 AM 25   Permit Number 10489 6012257.47083 2087577.3317 37.7127802853635 -122.399468524874 (37.7127802853635, -122.399468524874) 10 3 8 309 1
47275 44101 1 238 2900 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2   11/07/2000 12:00:00 AM 33   Permit Number 43613 5999651.42803 2117418.51494 37.794006189279 -122.445183003418 (37.794006189279, -122.445183003418) 13 9 1 57 27
54033 187150 1 238 2301 Sunset Blvd 12 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984947.2414 2099450.3955 37.7438205471232 -122.494734888113 (37.7438205471232, -122.494734888113) 1 8 3 29491 35
58949 222027 1 238 310 Liberty St 60 Sidewalk: Curb side : Yard Tree 2     4 Width 3ft   6003716.89096 2103932.15667 37.7572071892775 -122.430153527076 (37.7572071892775, -122.430153527076) 2 4 5 28862 3
59097 186314 1 238 1800 Sunset Blvd 52 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984957.5078 2102814.9976 37.7530594263796 -122.494947425095 (37.7530594263796, -122.494947425095) 1 8 3 56 35
59630 222030 1 238 35 Mars St 1 Sidewalk: Property side : Yard Tree 2     13 Width 3ft   5999601.42077 2105598.42745 37.7615484047597 -122.444506122353 (37.7615484047597, -122.444506122353) 15 5 5 28862 3
60310 125575 1 238 1931 Lyon St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5999445.84158 2115532.33491 37.7888154993698 -122.445758639673 (37.7888154993698, -122.445758639673) 13 6 1 29490 31
63525 204761 1 238 179 Ashton Ave 2 Sidewalk: Property side : Yard Tree 2     24     5994134.44181 2091130.30428 37.7215090988363 -122.462364611361 (37.7215090988363, -122.462364611361) 9 8 6 28861 24
73989 186280 1 238 1800 Sunset Blvd 18 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985011.8758 2102500.8713 37.7522001044765 -122.494736255211 (37.7522001044765, -122.494736255211) 1 8 3 56 35
80419 110144 4 238 129 DE SOTO ST 1 Sidewalk: Property side : Cutout Tree 2     15 10x10   5993256.9 2092045.6 37.7239717071557 -122.465464466989 (37.7239717071557, -122.465464466989) 9 8 4 59 40
82227 222019 1 238 241 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6006672.98133 2095813.6352 37.7350825485248 -122.419354279976 (37.7350825485248, -122.419354279976) 2 7 7 28859 2
84168 222026 1 238 47 Seward St 1 Sidewalk: Property side : Yard Tree 2     6 Width 3ft   6000832.93244 2104328.85596 37.7581326645179 -122.440155795856 (37.7581326645179, -122.440155795856) 2 4 5 28862 38
84595 185893 1 238 2000 Sunset Blvd 36 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985001.2813 2101166.1106 37.7485345971557 -122.494674497174 (37.7485345971557, -122.494674497174) 1 8 3 29491 35
91567 186279 1 238 1800 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984978.0469 2102499.6631 37.752194806922 -122.494853149984 (37.752194806922, -122.494853149984) 1 8 3 56 35
92586 233897 1 238 1021 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6003182.00508 2102290.73647 37.7526699296738 -122.431886168108 (37.7526699296738, -122.431886168108) 2 4 5 28862 22
101243 222025 1 238 562 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6007847.71054 2104641.63316 37.7593883456249 -122.415917749222 (37.7593883456249, -122.415917749222) 2 4 7 28859 19
108443 121475 4 238 705 Victoria St 1 Sidewalk: Curb side : Cutout Tree 2       10x10   5993498 2091842 37.7234265734559 -122.464616252006 (37.7234265734559, -122.464616252006) 9 8 4 59 40
113758 204758 1 238 1696 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2     25 Width 4ft   5993741.97321 2103977.3015 37.7567611354409 -122.464653666529 (37.7567611354409, -122.464653666529) 1 8 4 56 12
116305 117535 4 238 278 JUANITA WAY 1 Sidewalk: Property side : Yard Tree 2     22 6x3   5995559 2097690 37.7396023643565 -122.457914790839 (37.7396023643565, -122.457914790839) 9 7 4 59 40
119364 187161 1 238 2301 Sunset Blvd 23 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984952.2414 2099389.4695 37.7436535534966 -122.494713108664 (37.7436535534966, -122.494713108664) 1 8 3 29491 35
120792 184014 1 238 1600 Sunset Blvd 14 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984965.7137 2103757.8086 37.7556486055443 -122.494988561115 (37.7556486055443, -122.494988561115) 1 8 3 56 35
124365 116951 6 238 299 Tara St 1 Front Yard : Yard Tree 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
125509 254393 6 238 150 Granville Way 1 Front Yard : Yard Tree 2       10x10   5994538 2098550 37.7419049979895 -122.461507275162 (37.7419049979895, -122.461507275162) 1 8 4 59 40
127422 86830 7 238 144 Noe St 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3 unpermitted private planting on DPW-maintained street 6002845 2107418 37.7667290519071 -122.43341795454 (37.7667290519071, -122.43341795454) 15 5 5 28862 3
127643 222024 1 238 1000 Jarboe Ave 3 Sidewalk: Curb side : Yard Tree 2     4 Width 3ft   6009378.65021 2096845.36529 37.7380674730247 -122.410072588498 (37.7380674730247, -122.410072588498) 10 7 7 28859 2
132771 112955 6 238 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree 2           5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
134637 186176 1 238 1700 Sunset Blvd 61 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984967.0954 2103538.8321 37.755047437501 -122.49496763736 (37.755047437501, -122.49496763736) 1 8 3 56 35
139325 185395 1 238 2300 Sunset Blvd 7 unknown : Yard Tree 2     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815) 1 8 3 29491 35
146489 111205 11 238 46 COOK ST   Back Yard : Yard Tree 2     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514 2113392 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469) 15 6 1 54 31
148896 204759 1 238 2 Mesa Ave 2 Sidewalk: Curb side : Yard Tree 2     26 Width 4ft   5993698.72815 2100745.29899 37.7478843915522 -122.4645685493 (37.7478843915522, -122.4645685493) 1 8 4 29491 40
152725 187142 1 238 2301 Sunset Blvd 4 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984897.1125 2099461.8744 37.7438491307401 -122.494909065698 (37.7438491307401, -122.494909065698) 1 8 3 29491 35
152873 185423 1 238 2300 Sunset Blvd 39 unknown : Yard Tree 2     1 Width 0ft   5985071.644 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743) 1 8 3 29491 35
154526 183954 1 238 2100 Sunset Blvd 42 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985054.4746 2100602.91 37.7469913151738 -122.494449047407 (37.7469913151738, -122.494449047407) 1 8 3 29491 35
156330 222023 1 238 1000 Jarboe Ave 4 Sidewalk: Curb side : Yard Tree 2     2 Width 3ft   6009382.55591 2096845.28557 37.7380674730416 -122.410059078869 (37.7380674730416, -122.410059078869) 10 7 7 28859 2
158147 185895 1 238 2000 Sunset Blvd 38 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985036.6346 2101201.464 37.7486337371523 -122.494554853688 (37.7486337371523, -122.494554853688) 1 8 3 29491 35
171942 183955 1 238 2100 Sunset Blvd 43 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985033.6446 2100586.6805 37.746945534293 -122.494519878447 (37.746945534293, -122.494519878447) 1 8 3 29491 35
172915 248932 11 238 46 Cook St 1 Front Yard : Yard Tree 2         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514 2113392 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469) 15 6 1 54 31
175192 187153 1 238 2301 Sunset Blvd 15 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984906.5006 2099427.4325 37.7437551121762 -122.494874065391 (37.7437551121762, -122.494874065391) 1 8 3 29491 35
178229 181401 1 238 1500 Sunset Blvd 34 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984931.8298 2104672.7619 37.758158829946 -122.495173208442 (37.758158829946, -122.495173208442) 1 8 3 56 35
182090 97395 1 238 1203X Sunset Blvd 14 Median : Yard Tree 1           5989104.6 2108557.5 37.7690686805765 -122.481026569546 (37.7690686805765, -122.481026569546) 11 6 2 55 8
189484 186055 1 238 1901 Sunset Blvd 1 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984800.4513 2102206.1385 37.751378471683 -122.495445647673 (37.751378471683, -122.495445647673) 1 8 3 29491 35