trees

Custom SQL query returning 41 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4119 179884 1 86 675 Sweeny St 1 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6007440.99847 2094010.17739 37.7301738725104 -122.416571250581 (37.7301738725104, -122.416571250581) 9 3 7 309 28
4496 74361 1 86 299 Madison St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   9     6005755.65434 2092345.08491 37.7255069657486 -122.422279456248 (37.7255069657486, -122.422279456248) 9 7 7 309 5
12690 179887 1 86 675 Sweeny St 4 Sidewalk: Property side : Yard Tree 2     12 Width 2ft   6007462.62751 2094011.80961 37.7301795706263 -122.416496591546 (37.7301795706263, -122.416496591546) 9 3 7 309 28
14557 179896 1 86 1039 Woolsey St 3 Sidewalk: Property side : Yard Tree 2     3 Width 4ft   6008623.46871 2091235.83896 37.7226225602776 -122.412287269767 (37.7226225602776, -122.412287269767) 9 3 7 309 28
27327 179900 1 86 1039 Woolsey St 7 Sidewalk: Property side : Yard Tree 2     6 Width 4ft   6008639.8841 2091240.95748 37.7226375357801 -122.412230886773 (37.7226375357801, -122.412230886773) 9 3 7 309 28
32212 179898 1 86 1039 Woolsey St 5 Sidewalk: Property side : Yard Tree 2     4 Width 4ft   6008631.84124 2091237.77549 37.7226283473964 -122.412258464481 (37.7226283473964, -122.412258464481) 9 3 7 309 28
33199 179907 1 86 600 Somerset St 3 Sidewalk: Property side : Yard Tree 2     6 Width 3ft   6010281.08553 2091712.86969 37.7240252643514 -122.406590826309 (37.7240252643514, -122.406590826309) 10 3 7 309 28
39011 179881 1 86 1151 Felton St 2 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6007539.25103 2092829.10153 37.7269364183715 -122.416147963965 (37.7269364183715, -122.416147963965) 9 3 7 309 28
39108 179880 1 86 1151 Felton St 1 Sidewalk: Property side : Yard Tree 2     8 Width 2ft   6007526.36673 2092824.84352 37.7269240023301 -122.416192203412 (37.7269240023301, -122.416192203412) 9 3 7 309 28
44005 179893 1 86 101 Dartmouth St 10 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6008518.11565 2093559.33094 37.7289964630154 -122.412815641254 (37.7289964630154, -122.412815641254) 9 3 7 309 28
49054 179903 1 86 1039 Woolsey St 10 Sidewalk: Property side : Yard Tree 2     5 Width 4ft   6008647.44016 2091243.13146 37.7226439290591 -122.412204920617 (37.7226439290591, -122.412204920617) 9 3 7 309 28
54391 179886 1 86 675 Sweeny St 3 Sidewalk: Property side : Yard Tree 2     9 Width 2ft   6007455.79909 2094011.3835 37.7301780166028 -122.416520168176 (37.7301780166028, -122.416520168176) 9 3 7 309 28
57951 179814 1 86 522 Sunnydale Ave 1 Sidewalk: Curb side : Pot Tree 2     8     6010066.66697 2086413.12079 37.7094612429124 -122.406958677794 (37.7094612429124, -122.406958677794) 9 7 8 309 39
64911 179899 1 86 1039 Woolsey St 6 Sidewalk: Property side : Yard Tree 2     4 Width 4ft   6008635.8472 2091239.23923 37.7226325913056 -122.412244720114 (37.7226325913056, -122.412244720114) 9 3 7 309 28
70544 179889 1 86 9 Dartmouth St 2 Sidewalk: Property side : Yard Tree 2     7 Width 4ft   6008314.8677 2094310.92324 37.7310487635727 -122.41357142338 (37.7310487635727, -122.41357142338) 9 3 7 309 28
79418 179867 1 86 985 Avalon Ave 1 Sidewalk: Property side : Yard Tree 2     6 Width 6ft   6005404.97601 2092232.73416 37.7251786880381 -122.423483738408 (37.7251786880381, -122.423483738408) 9 7 6 309 5
80852 54662 1 86 353 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree 2   07/27/1972 12:00:00 AM 18   Permit Number 10486 6012290.80379 2086856.89359 37.7108039630942 -122.39930277173 (37.7108039630942, -122.39930277173) 10 3 8 309 1
81457 179891 1 86 101 Dartmouth St 7 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6008528.33324 2093531.3526 37.7289202139869 -122.41277834095 (37.7289202139869, -122.41277834095) 9 3 7 309 28
94276 179895 1 86 1039 Woolsey St 2 Sidewalk: Property side : Yard Tree 2     3 Width 4ft   6008618.46635 2091234.88491 37.7226196599519 -122.412304494484 (37.7226196599519, -122.412304494484) 9 3 7 309 28
105096 179885 1 86 675 Sweeny St 2 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6007447.44417 2094010.42268 37.7301749085276 -122.416548984266 (37.7301749085276, -122.416548984266) 9 3 7 309 28
105223 179902 1 86 1039 Woolsey St 9 Sidewalk: Property side : Yard Tree 2     7 Width 4ft   6008644.61497 2091242.09558 37.7226409262237 -122.412214613536 (37.7226409262237, -122.412214613536) 9 3 7 309 28
106736 179905 1 86 1216 Silver Ave 1 Sidewalk: Property side : Yard Tree 2     22 Width 3ft   6008780.07198 2094033.26413 37.7303124823168 -122.411943512893 (37.7303124823168, -122.411943512893) 9 3 7 309 28
107371 179874 1 86 590 Cambridge St 2 Sidewalk: Property side : Yard Tree 2     8 Width 3ft   6007111.06937 2091808.8773 37.7241110173924 -122.4175559066 (37.7241110173924, -122.4175559066) 9 7 7 309 28
112107 179897 1 86 1039 Woolsey St 4 Sidewalk: Property side : Yard Tree 2     3 Width 4ft   6008627.84918 2091236.6223 37.7226249569704 -122.412272182734 (37.7226249569704, -122.412272182734) 9 3 7 309 28
123638 179876 1 86 590 Cambridge St 4 Sidewalk: Property side : Yard Tree 2     10 Width 3ft   6007115.03067 2091796.72343 37.7240778683719 -122.41754135197 (37.7240778683719, -122.41754135197) 9 7 7 309 28
126177 179892 1 86 101 Dartmouth St 9 Sidewalk: Property side : Yard Tree 2     9 Width 5ft   6008521.95318 2093544.04536 37.728954707483 -122.412801294348 (37.728954707483, -122.412801294348) 9 3 7 309 28
133906 179882 1 86 323 Pioche St 1 Sidewalk: Property side : Yard Tree 2     10 Width 6ft   6005924.81091 2093297.57145 37.7281318260086 -122.421762319978 (37.7281318260086, -122.421762319978) 9 7 7 309 5
141080 179879 1 86 463 Amherst St 1 Sidewalk: Property side : Yard Tree 2     12 Width 4ft   6007835.00514 2091691.6908 37.7238299567678 -122.415045072275 (37.7238299567678, -122.415045072275) 9 3 7 309 28
144877 179883 1 86 39 Amherst St 4 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6007323.05766 2093363.44581 37.7283914539998 -122.416933184515 (37.7283914539998, -122.416933184515) 9 3 7 309 5
148428 179906 1 86 600 Somerset St 2 Sidewalk: Property side : Yard Tree 2     7 Width 3ft   6010277.8918 2091719.16171 37.7240423622482 -122.406602309775 (37.7240423622482, -122.406602309775) 10 3 7 309 28
149317 179894 1 86 1039 Woolsey St 1 Sidewalk: Property side : Yard Tree 2     6 Width 4ft   6008613.89309 2091233.32436 37.7226151183816 -122.412320193042 (37.7226151183816, -122.412320193042) 9 3 7 309 28
155887 179901 1 86 1039 Woolsey St 8 Sidewalk: Property side : Yard Tree 2     6 Width 4ft   6008641.95014 2091241.02596 37.7226378397427 -122.412223749739 (37.7226378397427, -122.412223749739) 9 3 7 309 28
157954 179904 1 86 1039 Woolsey St 11 Sidewalk: Property side : Yard Tree 2     7 Width 4ft   6008652.42423 2091244.38754 37.7226476576547 -122.412187780452 (37.7226476576547, -122.412187780452) 9 3 7 309 28
161620 179873 1 86 590 Cambridge St 1 Sidewalk: Property side : Yard Tree 2     5 Width 3ft   6007108.9711 2091815.95561 37.7241303348443 -122.417563661454 (37.7241303348443, -122.417563661454) 9 7 7 309 28
161950 179870 1 86 743 Peru Ave 1 Sidewalk: Property side : Yard Tree 2     12 Width 3ft   6005435.63394 2092350.08273 37.7255026319158 -122.423386095411 (37.7255026319158, -122.423386095411) 9 7 7 309 5
173401 179888 1 86 9 Dartmouth St 1 Sidewalk: Property side : Yard Tree 2     11 Width 4ft   6008315.20524 2094307.45797 37.7310392676412 -122.413570011448 (37.7310392676412, -122.413570011448) 9 3 7 309 28
175053 179875 1 86 590 Cambridge St 3 Sidewalk: Property side : Yard Tree 2     10 Width 3ft   6007112.5297 2091803.34556 37.7240959105931 -122.417550466576 (37.7240959105931, -122.417550466576) 9 7 7 309 28
175071 179890 1 86 9 Dartmouth St 3 Sidewalk: Property side : Yard Tree 2     10 Width 4ft   6008311.43296 2094322.79302 37.7310811625636 -122.413584137105 (37.7310811625636, -122.413584137105) 9 3 7 309 28
179861 179869 1 86 299 Madison St 2 Sidewalk: Property side : Yard Tree 2     8 Width 2ft   6005754.24665 2092349.7952 37.725519819773 -122.422284657027 (37.725519819773, -122.422284657027) 9 7 7 309 5
179893 179877 1 86 1516 Bacon St 1 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   6007105.23827 2091790.85239 37.7240611967477 -122.417574786965 (37.7240611967477, -122.417574786965) 9 7 7 309 28
189980 179878 1 86 1516 Bacon St 2 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   6007090.65933 2091786.11509 37.7240473687785 -122.417624848631 (37.7240473687785, -122.417624848631) 9 7 7 309 28