Street_Tree_List

Data source: data.sfgov.org

1,729 rows where qSpecies = 54 sorted by PlantDate

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
443 251293 Undocumented 2 :: 54 3789 Market St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
514 251312 Undocumented 2 :: 54 1499 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
518 251314 Planning Code 138.1 required 4 :: 54 1108 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
533 251313 Planning Code 138.1 required 4 :: 54 390 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
631 251294 Property Tree 7 :: 54 7126 Geary Blvd 1 Back Yard : Cutout 16 Tree 1 Private 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
667 251356 Undocumented 2 :: 54 519 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
870 117001 DPW Maintained 3 :: 54 1X Bernal Heights Blvd 1 Front Yard : Yard 7 Tree 1 DPW 2                    
1410 139164 Undocumented 2 :: 54 1975 POST ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6002726.0596 2114048.1262 37.784926980365206 -122.43430340574699 (37.7849269803652, -122.434303405747)
2526 141913 Undocumented 2 :: 54 900 MCALLISTER ST 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004416.1749 2111910.2001 37.779152551854104 -122.42830372330299 (37.7791525518541, -122.428303723303)
2865 253261 Permitted Site 1 :: 54 339 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5990256.0 2113097.0 37.78159976365421 -122.477375802178 (37.7815997636542, -122.477375802178)
2881 253260 Permitted Site 1 :: 54 734 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993234.0 2110465.0 37.7745453462497 -122.46688203122801 (37.7745453462497, -122.466882031228)
3255 253377 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3275 253378 Planning Code 138.1 required 4 :: 54 2 Alpine Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001556.0 2108661.0 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225)
3345 253419 Planning Code 138.1 required 4 :: 54 3499 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997570.0 2115996.0 37.78998131889129 -122.452282225129 (37.7899813188913, -122.452282225129)
3620 139511 Undocumented 2 :: 54 1400 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001017.0 2111110.0 37.776762480662704 -122.440005440059 (37.7767624806627, -122.440005440059)
5050 253762 Planning Code 138.1 required 4 :: 54 520 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993490.0 2111935.0 37.778596343165496 -122.46610332918101 (37.7785963431655, -122.466103329181)
5211 253829 Permitted Site 1 :: 54 869 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 Permitted Site 1 :: 54 651X Polk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5222 253825 Permitted Site 1 :: 54 725 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5224 253827 Permitted Site 1 :: 54 825 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 Permitted Site 1 :: 54 665 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5228 253828 Permitted Site 1 :: 54 825 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 Permitted Site 1 :: 54 747 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 Permitted Site 1 :: 54 701 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5236 253833 Permitted Site 1 :: 54 607 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
5239 253830 Permitted Site 1 :: 54 651X Polk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
6373 138089 Undocumented 2 :: 54 1600 SUTTER ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6004809.7961 2114741.3813 37.7869485378128 -122.427143741054 (37.7869485378128, -122.427143741054)
7654 139157 Undocumented 2 :: 54 1699 FILLMORE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6003069.5459 2114034.3612 37.7849086753549 -122.433114070807 (37.7849086753549, -122.433114070807)
9914 173708 DPW Maintained 3 :: 54 126 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6001214.0 2098705.0 37.7427125900371 -122.438434982469 (37.7427125900371, -122.438434982469)
18412 247322 Undocumented 2 :: 54 218 Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6002795.6845 2109344.9924 37.7720173021936 -122.433726268045 (37.7720173021936, -122.433726268045)
20483 109769 Permitted Site 1 :: 54 2502X Bush St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1.5x12.75   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
22368 183808 Undocumented 2 :: 54 1823 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987517.377 2100286.1656 37.7462654526109 -122.48590940972 (37.7462654526109, -122.48590940972)
22811 185829 Undocumented 2 :: 54 2061 34th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985695.3610000005 2101217.9835 37.7487176270346 -122.49227823369301 (37.7487176270346, -122.492278233693)
22852 138173 Undocumented 2 :: 54 1953 GOLDEN GATE AVE 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     0 Width 0ft   6000211.2401 2111613.6154 37.7780993776744 -122.44282896766 (37.7780993776744, -122.44282896766)
23417 183167 Undocumented 2 :: 54 2422 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5982411.0498 2098597.3573 37.741329561902596 -122.50344114283101 (37.7413295619026, -122.503441142831)
23724 181665 Undocumented 2 :: 54 1275 34th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985511.3315 2106531.7973 37.7632971348656 -122.49330603001499 (37.7632971348656, -122.493306030015)
23777 183752 Undocumented 2 :: 54 2287 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987917.4443 2099749.9687 37.7448165037016 -122.484486720736 (37.7448165037016, -122.484486720736)
23835 182329 Undocumented 2 :: 54 1501 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985565.7361 2104954.3084 37.75896897093661 -122.493001657059 (37.7589689709366, -122.493001657059)
23845 142111 Undocumented 2 :: 54 36 HEMWAY TER 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5998636.7696 2110968.1942 37.7762373313333 -122.448229118378 (37.7762373313333, -122.448229118378)
23926 181820 Undocumented 2 :: 54 2299 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985846.0311 2099546.7997 37.7441378151504 -122.491634223287 (37.7441378151504, -122.491634223287)
24053 181971 Undocumented 2 :: 54 2467 34th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985787.1457 2098434.4072 37.7410800425161 -122.49175595946801 (37.7410800425161, -122.491755959468)
24081 183742 Undocumented 2 :: 54 2278 25th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988578.8889999995 2099828.4885 37.745070593746796 -122.482205348546 (37.7450705937468, -122.482205348546)
24104 248307 Undocumented 2 :: 54 1323 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5999369.7066 2108379.5015 37.7691713129844 -122.44550750940901 (37.7691713129844, -122.445507509409)
24148 182529 Undocumented 2 :: 54 1583 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986203.973999999 2104470.5925 37.7576781250927 -122.490758769583 (37.7576781250927, -122.490758769583)
24206 181982 Undocumented 2 :: 54 2479 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986720.0054 2098392.2737 37.7410188327151 -122.488527415956 (37.7410188327151, -122.488527415956)
24275 184454 Undocumented 2 :: 54 2153 48th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981374.6331 2100381.1786 37.7461664541179 -122.507156946857 (37.7461664541179, -122.507156946857)
24313 184893 Undocumented 2 :: 54 1786 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981952.8719 2102926.7078 37.753189803786896 -122.505346142178 (37.7531898037869, -122.505346142178)
24402 182453 Undocumented 2 :: 54 1500 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986555.3586 2104541.3333 37.7578928802813 -122.489548755928 (37.7578928802813, -122.489548755928)
24496 184100 Undocumented 2 :: 54 1614 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985016.0366 2104172.5195 37.756790232687 -122.494845106619 (37.756790232687, -122.494845106619)
24523 141857 Undocumented 2 :: 54 1100 TURK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004651.3626 2112630.8889 37.781144690344895 -122.42754147050199 (37.7811446903449, -122.427541470502)
24606 181614 Undocumented 2 :: 54 1246 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984927.2833 2106710.1633 37.7637526989564 -122.49533918573601 (37.7637526989564, -122.495339185736)
24662 124715 Undocumented 2 :: 54 599X 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002687.0 2100013.0 37.7463877287793 -122.433435226166 (37.7463877287793, -122.433435226166)
24683 183508 Undocumented 2 :: 54 2547 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5988598.1694 2097978.5588 37.7399922937625 -122.482003188533 (37.7399922937625, -122.482003188533)
24723 181788 Undocumented 2 :: 54 3131 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986265.505 2098198.358 37.740459860841 -122.49008463083 (37.740459860841, -122.49008463083)
24732 141579 Undocumented 2 :: 54 500 BAKER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000650.2876 2110740.0178 37.7757257205697 -122.44124745176501 (37.7757257205697, -122.441247451765)
24890 183769 Undocumented 2 :: 54 2295 28th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987606.9921 2099681.9039 37.7446115325485 -122.48555519813499 (37.7446115325485, -122.485555198135)
25062 247418 Undocumented 2 :: 54 1001 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002608.194 2110213.5869 37.7743916070028 -122.43443692499599 (37.7743916070028, -122.434436924996)
25160 244247 Undocumented 2 :: 54 200 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005673.0642 2110022.6890000002 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378)
25293 182679 Undocumented 2 :: 54 2631 Moraga St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986083.8267 2103639.2241 37.7553883964845 -122.49111310108299 (37.7553883964845, -122.491113101083)
25460 181596 Undocumented 2 :: 54 1683 37th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984674.4393 2103735.9717 37.7555715918184 -122.495994253801 (37.7555715918184, -122.495994253801)
25506 137920 Undocumented 2 :: 54 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002940.7431 2115305.2702 37.788390961736795 -122.433650548643 (37.7883909617368, -122.433650548643)
25583 139608 Undocumented 2 :: 54 1724 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001827.9162 2112238.3787 37.7799068540457 -122.437281058847 (37.7799068540457, -122.437281058847)
25649 182532 Undocumented 2 :: 54 1581 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985581.6988 2104465.1884 37.7576269162189 -122.492910423341 (37.7576269162189, -122.492910423341)
25748 182187 Undocumented 2 :: 54 1622 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5989666.9072 2104289.3052 37.757382042273996 -122.47876940221 (37.757382042274, -122.47876940221)
25969 183335 Undocumented 2 :: 54 1211 43rd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5982706.9565 2106839.0545 37.7639763455704 -122.503028028557 (37.7639763455704, -122.503028028557)
25978 182524 Undocumented 2 :: 54 1579 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985892.4217 2104503.3998 37.757750000215005 -122.491838645138 (37.757750000215, -122.491838645138)
26076 181698 Undocumented 2 :: 54 1809 Lincoln Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5990006.9617 2107176.8497 37.7653302032624 -122.47780444851401 (37.7653302032624, -122.477804448514)
26178 186047 Undocumented 2 :: 54 1900 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984778.2299 2102058.2647 37.7509711496958 -122.495511585412 (37.7509711496958, -122.495511585412)
26182 142482 Undocumented 2 :: 54 1501 GRANT AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6010536.0572 2119686.9897 37.800850136387204 -122.407680928456 (37.8008501363872, -122.407680928456)
26491 184713 Undocumented 2 :: 54 1626 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984397.6244 2104083.8858 37.756510650266705 -122.496977229466 (37.7565106502667, -122.496977229466)
26507 184509 Undocumented 2 :: 54 1886 Lower Great Hwy 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5981125.5546 2102268.3878 37.751333525850896 -122.50815826243401 (37.7513335258509, -122.508158262434)
26576 184709 Undocumented 2 :: 54 1618 40th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983775.4227 2104111.6852 37.7565504997112 -122.499131044219 (37.7565504997112, -122.499131044219)
26632 182608 Undocumented 2 :: 54 1839 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985333.4224 2102688.337 37.7527336497539 -122.493638125681 (37.7527336497539, -122.493638125681)
26700 183825 Undocumented 2 :: 54 2233 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987596.9637 2100067.0354 37.745668416958 -122.48561813299 (37.745668416958, -122.48561813299)
26723 183174 Undocumented 2 :: 54 2400 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984903.1916 2098438.8046 37.7410404135541 -122.494812631239 (37.7410404135541, -122.494812631239)
26774 183705 Undocumented 2 :: 54 3628 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5983226.2116 2105643.5823 37.760724424253205 -122.50114368176399 (37.7607244242532, -122.501143681764)
26822 183837 Undocumented 2 :: 54 2206 35th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985462.2045 2100160.7045 37.745800992601 -122.4930066047 (37.745800992601, -122.4930066047)
26862 245988 Undocumented 2 :: 54 1250 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5999884.6674 2108495.9392 37.76952040656629 -122.44373466044901 (37.7695204065663, -122.443734660449)
26866 182267 Undocumented 2 :: 54 1474 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986846.9486 2105227.058 37.7597927113016 -122.48859072822201 (37.7597927113016, -122.488590728222)
26920 182657 Undocumented 2 :: 54 2630 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985816.7659 2102326.4814 37.75176835729211 -122.491940021962 (37.7517683572921, -122.491940021962)
27047 181865 Undocumented 2 :: 54 2331 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986993.7887 2099395.3559 37.743789001507004 -122.487654458992 (37.743789001507, -122.487654458992)
27065 183718 Undocumented 2 :: 54 2254 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987333.4527 2099922.5844 37.745256435851495 -122.486518698932 (37.7452564358515, -122.486518698932)
27133 183989 Undocumented 2 :: 54 1678 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985337.681 2103783.3365 37.755740466247296 -122.493704080582 (37.7557404662473, -122.493704080582)
27251 184688 Undocumented 2 :: 54 1611 37th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984657.9281 2104207.7196 37.7568659135367 -122.496086155975 (37.7568659135367, -122.496086155975)
27362 137901 Undocumented 2 :: 54 402 Austin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005281.3807 2115310.0743 37.7885366835693 -122.425552653183 (37.7885366835693, -122.425552653183)
27363 141421 Undocumented 2 :: 54 550 IVY ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004561.2684 2111044.0972 37.7767826552211 -122.42774005835501 (37.7767826552211, -122.427740058355)
27390 183785 Undocumented 2 :: 54 2146 Santiago St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986125.7828 2099614.0525 37.744338818609 -122.490671864125 (37.744338818609, -122.490671864125)
27474 183607 Undocumented 2 :: 54 1 Quintara St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989903.61 2101103.2452 37.748647706091596 -122.477717911497 (37.7486477060916, -122.477717911497)
27534 142574 Undocumented 2 :: 54 2251 MASON ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6008922.4097 2120888.3705 37.804058366605894 -122.413349854276 (37.8040583666059, -122.413349854276)
27597 184102 Undocumented 2 :: 54 1623 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985904.0693 2104173.8569 37.7568458469392 -122.491774103994 (37.7568458469392, -122.491774103994)
27770 181987 Undocumented 2 :: 54 2832 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987195.8265 2098292.1009 37.7407715379119 -122.486874867312 (37.7407715379119, -122.486874867312)
27966 184450 Undocumented 2 :: 54 2127 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5982917.6673 2100633.8105 37.7469508716588 -122.501840104956 (37.7469508716588, -122.501840104956)
28027 140087 Undocumented 2 :: 54 1210 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001853.1286 2112643.6389 37.781021029267706 -122.43722286326 (37.7810210292677, -122.43722286326)
28131 200245 Undocumented 2 :: 54 1075 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
28244 184686 Undocumented 2 :: 54 1606 39th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984083.9121 2104208.225 37.7568336628482 -122.498071323375 (37.7568336628482, -122.498071323375)
28310 185781 Undocumented 2 :: 54 2419 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986496.7508 2102292.5013 37.7517147795652 -122.489586075955 (37.7517147795652, -122.489586075955)
28315 182384 Undocumented 2 :: 54 1539 33rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985884.4808 2104746.0177 37.7584156979157 -122.49188396911 (37.7584156979157, -122.49188396911)
28318 182661 Undocumented 2 :: 54 2500 Ortega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986241.1388 2102339.3676 37.7518285352163 -122.490473451437 (37.7518285352163, -122.490473451437)
28319 139084 Undocumented 2 :: 54 2512 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000122.7854 2113741.6890000002 37.7839374779531 -122.443287851631 (37.7839374779531, -122.443287851631)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 997.456ms · Data source: data.sfgov.org