sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
42249 105036 1 30 1550 04th St 11 1 1 1     2 6x6 Permit Number 771181 6015089.32821 2107914.09587 37.7687782840212 -122.39110121906201 (37.7687782840212, -122.391101219062)
29379 105035 1 30 1550 04th St 10 1 1 1     4 6x6   6015087.4436800005 2107939.01173 37.768846592924 -122.391109479333 (37.768846592924, -122.391109479333)
177608 191346 2 30 1550 04th St 9 1 1 1     4 Width 5ft   6015085.76507 2107965.02098 37.768917915461294 -122.391117103785 (37.7689179154613, -122.391117103785)
51298 200113 2 30 1566 Yosemite Ave 1 1 1 1     1 Width 0ft   6014774.445 2092572.7944 37.7266368132033 -122.391117932915 (37.7266368132033, -122.391117932915)
136667 191345 2 30 1550 04th St 8 1 1 1     4 Width 5ft   6015084.02733 2107988.1043 37.7689812007549 -122.391124728238 (37.7689812007549, -122.391124728238)
53758 191344 2 30 1550 04th St 7 1 1 1     4 Width 5ft   6015083.2703599995 2108014.27768 37.769053025099105 -122.39112917626998 (37.7690530250991, -122.39112917627)
66308 105031 1 30 1550 04th St 6 1 1 1     4 6x6   6015081.19497 2108038.83155 37.7691203294602 -122.391138071471 (37.7691203294602, -122.391138071471)
137702 105030 1 30 1550 04th St 5 1 1 1     4 6x6   6015079.85403 2108063.37025 37.769187632923604 -122.391144425184 (37.7691876329236, -122.391144425184)
59549 105029 1 30 1550 04th St 4 1 1 1     4 6x6   6015077.74883 2108086.46133 37.769250919128 -122.391153321267 (37.769250919128, -122.391153321267)
170367 105028 1 30 1550 04th St 3 1 1 1     4 6x6   6015077.92484 2108113.3475599997 37.7693247525719 -122.391154592016 (37.7693247525719, -122.391154592016)
70706 105027 1 30 1550 04th St 2 1 1 1     3 6x6   6015075.4785400005 2108137.72551 37.7693915533068 -122.391164757946 (37.7693915533068, -122.391164757946)
49942 105026 1 30 1550 04th St 1 1 1 1     3 6x6   6015072.88546 2108163.93601 37.7694633776739 -122.39117555971599 (37.7694633776739, -122.391175559716)
173859 191343 2 30 1450 04th St 8 1 1 1     3 Width 5ft   6015066.17772 2108313.11356 37.769872614151396 -122.39120919074499 (37.7698726141514, -122.391209190745)
53688 191342 2 30 1450 04th St 7 1 1 1     3 Width 5ft   6015064.99922 2108338.84414 37.769943199256794 -122.391215066031 (37.7699431992568, -122.391215066031)
70045 191341 2 30 1450 04th St 6 1 1 1     3 Width 5ft   6015063.13507 2108364.25056 37.770012856238395 -122.391223290338 (37.7700128562384, -122.391223290338)
53819 191340 2 30 1450 04th St 5 1 1 1     3 Width 5ft   6015061.94317 2108389.30473 37.7700815833249 -122.39122916471001 (37.7700815833249, -122.39122916471)
186532 191339 2 30 1450 04th St 4 1 1 1     3 Width 5ft   6015062.12286 2108415.00786 37.7701521684295 -122.391230340108 (37.7701521684295, -122.391230340108)
174040 191338 2 30 1450 04th St 3 1 1 1     3 Width 5ft   6015059.91247 2108440.08294 37.770220896405704 -122.39123973893899 (37.7702208964057, -122.391239738939)
180428 191337 2 30 1450 04th St 2 1 1 1     3 Width 5ft   6015057.64715 2108462.45276 37.7702821932842 -122.39124913866002 (37.7702821932842, -122.39124913866)
35192 191336 2 30 1450 04th St 1 1 1 1     3 Width 5ft   6015056.82202 2108488.85287 37.7703546363753 -122.391253838509 (37.7703546363753, -122.391253838509)
155770 191267 2 30 538 Delancey St 3 9 1 1     7     6015157.461180001 2113744.4936599997 37.7847910341296 -122.391273164948 (37.7847910341296, -122.391273164948)
66851 191268 2 30 538 Delancey St 5 9 1 1     4     6015150.51675 2113731.33336 37.7847545135408 -122.391296270324 (37.7847545135408, -122.391296270324)
22918 191269 2 30 538 Delancey St 6 9 1 1     8     6015147.69888 2113724.07494 37.7847344271845 -122.391305511737 (37.7847344271845, -122.391305511737)
131178 66298 1 30 2920 Hawes St 1 1 1 1   11/27/1990 12:00:00 AM 6 3x3 Permit Number 29409 6014606.2975 2089345.5816 37.7177661944335 -122.391473700889 (37.7177661944335, -122.391473700889)
154442 191335 2 30 1108 04th St 6 1 1 1     5 Width 5ft   6014898.40719 2110003.75259 37.774505422222 -122.391907747266 (37.774505422222, -122.391907747266)
155061 191334 2 30 1108 04th St 5 1 1 1     5 Width 5ft   6014881.31548 2110022.28226 37.7745553516884 -122.391968167293 (37.7745553516884, -122.391968167293)
28729 191333 2 30 1108 04th St 4 1 1 1     5 Width 5ft   6014865.84277 2110042.3598599997 37.7746096212801 -122.392023095184 (37.7746096212801, -122.392023095184)
73709 191332 2 30 1108 04th St 3 1 1 1     4 Width 5ft   6014847.27565 2110066.45331 37.774674745668996 -122.392089008326 (37.774674745669, -122.392089008326)
179838 191331 2 30 1108 04th St 2 1 1 1     4 Width 5ft   6014830.54088 2110082.99883 37.77471924682621 -122.392148055082 (37.7747192468262, -122.392148055082)
60304 191330 2 30 1108 04th St 1 1 1 1     2 Width 5ft   6014815.79386 2110104.2477700002 37.7747767728644 -122.392200554832 (37.7747767728644, -122.392200554832)
156796 191266 2 30 1721 Revere Ave 1 4 1 1     25 Width 9ft   6014437.69224 2094855.17275 37.7328850694924 -122.39244165855499 (37.7328850694924, -122.392441658555)
61026 191297 2 30 740 04th St 7 1 1 1     3 Width 2ft   6014617.26494 2110308.92783 37.7753277532976 -122.39290163570101 (37.7753277532976, -122.392901635701)
39185 191296 2 30 740 04th St 6 1 1 1     4 Width 2ft   6014597.305819999 2110326.98215 37.7753762177666 -122.392971942918 (37.7753762177666, -122.392971942918)
44145 191295 2 30 740 04th St 5 1 1 1     4 Width 2ft   6014582.55786 2110345.63689 37.7754266202868 -122.393024265473 (37.7754266202868, -122.393024265473)
167148 191294 2 30 740 04th St 4 1 1 1     4 Width 2ft   6014564.69623 2110362.23682 37.775471207769606 -122.393087215303 (37.7754712077696, -122.393087215303)
149339 191293 2 30 740 04th St 3 1 1 1     6 Width 2ft   6014546.37169 2110379.31646 37.775517086679 -122.393151800112 (37.775517086679, -122.393151800112)
163250 191292 2 30 740 04th St 2 1 1 1     5 Width 2ft   6014526.81372 2110393.83261 37.7755558582611 -122.393220472347 (37.7755558582611, -122.393220472347)
44547 191291 2 30 740 04th St 1 1 1 1     5 Width 2ft   6014507.50601 2110409.04953 37.7755965678638 -122.39328832798701 (37.7755965678638, -122.393288327987)
172373 191279 2 30 751 04th St 1 1 1 1     7 Width 2ft   6014488.651430001 2110553.2747 37.7759915303161 -122.393363646226 (37.7759915303161, -122.393363646226)
173577 191280 2 30 751 04th St 2 1 1 1     6 Width 2ft   6014475.48285 2110565.8320299997 37.776025278288294 -122.393410079138 (37.7760252782883, -122.393410079138)
65427 191281 2 30 751 04th St 3 1 1 1     6 Width 2ft   6014459.12873 2110582.79031 37.776070933269 -122.39346783987301 (37.776070933269, -122.393467839873)
64760 191282 2 30 751 04th St 4 1 1 1     6 Width 2ft   6014441.41184 2110601.16162 37.77612039236389 -122.393530413818 (37.7761203923639, -122.393530413818)
134094 191283 2 30 751 04th St 5 1 1 1     4 Width 2ft   6014423.24539 2110620.23478 37.7761717535676 -122.39359459213999 (37.7761717535676, -122.39359459214)
74191 191290 2 30 720 04th St 6 1 1 1     6 Width 2ft   6014418.027919999 2110488.47672 37.7758096856109 -122.393603417186 (37.7758096856109, -122.393603417186)
173431 191284 2 30 751 04th St 6 1 1 1     5 Width 2ft   6014408.26812 2110636.4725 37.7762155064684 -122.39364753972201 (37.7762155064684, -122.393647539722)
179903 191289 2 30 720 04th St 5 1 1 1     6 Width 2ft   6014403.282380001 2110504.70975 37.7758534385095 -122.393655562567 (37.7758534385095, -122.393655562567)
166600 191288 2 30 720 04th St 4 1 1 1     5 Width 2ft   6014381.59657 2110521.77598 37.7758990935001 -122.39373177471 (37.7758990935001, -122.39373177471)
27568 191287 2 30 720 04th St 3 1 1 1     6 Width 2ft   6014360.2734 2110545.30097 37.7759625028975 -122.393807184665 (37.7759625028975, -122.393807184665)
177153 191286 2 30 720 04th St 2 1 1 1     5 Width 2ft   6014348.90708 2110556.6159200002 37.7759929395558 -122.39384729623801 (37.7759929395558, -122.393847296238)
67551 191285 2 30 720 04th St 1 1 1 1     6 Width 2ft   6014337.49405 2110565.62241 37.776017035092 -122.39388740780001 (37.776017035092, -122.3938874078)
162297 191270 2 30 659 04th St 1 1 1 1     8 Width 3ft   6014244.47605 2110787.29844 37.7766205377503 -122.39422470752899 (37.7766205377503, -122.394224707529)
37043 191271 2 30 659 04th St 2 1 1 1     6 Width 3ft   6014227.23158 2110805.88928 37.776670625478395 -122.394285663563 (37.7766706254784, -122.394285663563)
62414 191272 2 30 659 04th St 3 1 1 1     6 Width 3ft   6014208.1321 2110827.64494 37.776729299941394 -122.394353258399 (37.7767292999414, -122.394353258399)
168646 191273 2 30 659 04th St 4 1 1 1     6 Width 3ft   6014193.41583 2110841.8415900003 37.7767674626879 -122.394405160994 (37.7767674626879, -122.394405160994)
64764 191274 2 30 659 04th St 5 1 1 1     6 Width 3ft   6014170.53603 2110866.45323 37.7768337688053 -122.394486033405 (37.7768337688053, -122.394486033405)
178335 191275 2 30 659 04th St 6 1 1 1     5 Width 3ft   6014152.76855 2110885.05471 37.7768838565355 -122.394548799799 (37.7768838565355, -122.394548799799)
71984 191276 2 30 659 04th St 7 1 1 1     6 Width 3ft   6014137.59227 2110902.38763 37.776930605110394 -122.394602513603 (37.7769306051104, -122.394602513603)
72025 191277 2 30 659 04th St 8 1 1 1     7 Width 3ft   6014120.49796 2110919.7593900003 37.7769773536703 -122.394662865301 (37.7769773536703, -122.394662865301)
169237 191278 2 30 659 04th St 9 1 1 1     3 Width 3ft   6014098.280590001 2110942.62046 37.777038889768896 -122.39474132397801 (37.7770388897689, -122.394741323978)
34497 191363 2 30 955 Key Ave 1 2 1 1     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222)
62074 94211 1 30 465 Missouri St 6 1 1 1   06/22/2010 12:00:00 AM 3 3x3 Permit Number 53589 6013546.79092 2104912.40006 37.760450569952205 -122.39622637625799 (37.7604505699522, -122.396226376258)
172150 94214 1 30 465 Missouri St 9 1 1 1   06/22/2010 12:00:00 AM 3 3x3 Permit Number 53589 6013545.016969999 2104957.62874 37.7605746593094 -122.396235681545 (37.7605746593094, -122.396235681545)
62932 108753 2 30 200x Hester Ave 1 1 1 1     4 3x3   6012766.4768 2087726.3545799998 37.713217830719294 -122.397719670851 (37.7132178307193, -122.397719670851)
29524 108754 2 30 200x Hester Ave 2 1 1 1     4 3x3   6012760.63999 2087707.7823400002 37.7131665099896 -122.397738543111 (37.7131665099896, -122.397738543111)
182528 176929 2 30 110 Hester Ave 2 1 1 1     4 Width 2ft   6012755.76956 2087791.93581 37.7133973075252 -122.397761276185 (37.7133973075252, -122.397761276185)
148773 176956 2 30 99 Lois Ln 1 1 1 1     3 Width 2ft   6012750.523080001 2087747.4076 37.713274749713605 -122.39777628854799 (37.7132747497136, -122.397776288548)
169093 176928 2 30 110 Hester Ave 1 1 1 1     4 Width 2ft   6012745.689669999 2087817.6299700001 37.713467297259996 -122.397797917233 (37.71346729726, -122.397797917233)
43531 191264 2 30 801 Arkansas St 30 9 1 1     19     6013055.03201 2103799.19748 37.7573665842245 -122.39784906707399 (37.7573665842245, -122.397849067074)
179315 176955 2 30 95 Lois Ln 2 1 1 1     4 Width 2ft   6012720.393999999 2087742.5814099999 37.7132598200564 -122.397880087391 (37.7132598200564, -122.397880087391)
138206 176957 2 30 208 Hester Ave 1 1 1 1     4 Width 2ft   6012704.399540001 2087660.6669400001 37.7130340083786 -122.397929627449 (37.7130340083786, -122.397929627449)
169089 176954 2 30 95 Lois Ln 1 1 1 1     4 Width 2ft   6012699.50978 2087739.26695 37.713249556105104 -122.397952038554 (37.7132495561051, -122.397952038554)
45505 176953 2 30 79 Lois Ln 1 1 1 1     4 Width 2ft   6012671.13481 2087736.7840599997 37.713241158228705 -122.39804993876999 (37.7132411582287, -122.39804993877)
78926 112621 2 30 226x HESTER AVE 1 1 1 1       3x3   6012667.0 2087636.0 37.712964194877294 -122.398057164184 (37.7129641948773, -122.398057164184)
177180 176930 2 30 78 Lois Ln 1 1 1 1     7 Width 2ft   6012665.081590001 2087756.9566900001 37.7132962111247 -122.39807227523501 (37.7132962111247, -122.398072275235)
38656 176952 2 30 75 Lois Ln 1 1 1 1     7 Width 2ft   6012648.82319 2087733.77895 37.713231664082706 -122.39812684519698 (37.7132316640827, -122.398126845197)
148062 176958 2 30 214 Hester Ave 1 1 1 1     4 Width 2ft   6012631.12356 2087648.5603099999 37.7129966847253 -122.39818204648701 (37.7129966847253, -122.398182046487)
69520 176931 2 30 68 Lois Ln 1 1 1 1     5 Width 2ft   6012597.15839 2087748.03583 37.713267932833794 -122.398306417307 (37.7132679328338, -122.398306417307)
35610 176951 2 30 63 Lois Ln 1 1 1 1     7 Width 2ft   6012562.34064 2087723.35892 37.7131982353775 -122.398425029786 (37.7131982353775, -122.398425029786)
186617 176959 2 30 228 Hester Ave 2 1 1 1     4 Width 2ft   6012551.8348 2087659.68415 37.7130228118314 -122.398456876593 (37.7130228118314, -122.398456876593)
64660 176932 2 30 56 Lois Ln 1 1 1 1     8 Width 2ft   6012552.9526 2087748.4178 37.7132665190974 -122.39845923552299 (37.7132665190974, -122.398459235523)
44632 176950 2 30 59 Lois Ln 2 1 1 1     7 Width 2ft   6012544.33708 2087727.46225 37.7132084993531 -122.398487544387 (37.7132084993531, -122.398487544387)
150169 176933 2 30 56 Lois Ln 2 1 1 1     3 Width 2ft   6012542.43425 2087752.49307 37.7132771230101 -122.398495876584 (37.7132771230101, -122.398495876584)
94418 112623 2 30 228 HESTER AVE 1 1 1 1       3x2   6012539.0 2087662.0 37.7130284556779 -122.398501400627 (37.7130284556779, -122.398501400627)
177487 176949 2 30 59 Lois Ln 1 1 1 1     8 Width 2ft   6012531.85348 2087734.51235 37.7132271620641 -122.39853118666201 (37.7132271620641, -122.398531186662)
171606 176934 2 30 52 Lois Ln 1 1 1 1     3 Width 2ft   6012523.28008 2087764.2105 37.7133082296521 -122.398562902163 (37.7133082296521, -122.398562902163)
52561 114222 2 30 55 Lois Ln 1 1 1 1     7 2x2   6012512.59554 2087744.0784200002 37.713252355697605 -122.398598420002 (37.7132523556976, -122.398598420002)
169932 176948 2 30 43 Lois Ln 1 1 1 1     7 Width 2ft   6012470.82697 2087771.0926700002 37.7133242043273 -122.39874468213101 (37.7133242043273, -122.398744682131)
181722 176935 2 30 38 Lois Ln 1 1 1 1     2 Width 2ft   6012462.52056 2087802.51935 37.7134100329326 -122.398775596322 (37.7134100329326, -122.398775596322)
26316 176960 2 30 242 Hester Ave 1 1 1 1     7 Width 2ft   6012452.5611 2087695.0016599998 37.7131142557927 -122.39880247885701 (37.7131142557927, -122.398802478857)
183903 176947 2 30 39 Lois Ln 1 1 1 1     7 Width 2ft   6012433.06951 2087793.9478900002 37.713384856409 -122.398876788934 (37.713384856409, -122.398876788934)
133916 176946 2 30 33 Lois Ln 1 1 1 1     6 Width 2ft   6012391.32203 2087821.98143 37.7134595046344 -122.39902305019699 (37.7134595046344, -122.399023050197)
132161 176945 2 30 31 Lois Ln 3 1 1 1     7 Width 2ft   6012378.545530001 2087831.41605 37.7134846982415 -122.399067872395 (37.7134846982415, -122.399067872395)
182745 114221 2 30 28 Lois Ln 1 1 1 1     2 3x3   6012377.24762 2087856.00195 37.7135521339029 -122.39907408311599 (37.7135521339029, -122.399074083116)
131733 191263 2 30 728 Wisconsin St 2 4 1 1     13 Width 3ft   6012693.0382199995 2104091.70249 37.7581495726586 -122.399121524154 (37.7581495726586, -122.399121524154)
14017 104025 2 30 716 Wisconsin St 1 1 1 1     16 3x3   6012687.87968 2104149.7182 37.7583085835989 -122.399143437016 (37.7583085835989, -122.399143437016)
161305 114220 2 30 31 Lois Ln 2 1 1 1     5 3x3   6012353.592019999 2087846.1951099997 37.713523887993105 -122.39915515788799 (37.7135238879931, -122.399155157888)
46965 176936 2 30 20 Lois Ln 1 1 1 1     5 Width 2ft   6012351.49393 2087873.7751200001 37.713599500286 -122.399164344459 (37.713599500286, -122.399164344459)
149495 114219 2 30 31 Lois Ln 1 1 1 1     4 3x3   6012347.17965 2087849.72367 37.713533219358396 -122.399177569 (37.7135332193584, -122.399177569)
56561 191262 2 30 690 Wisconsin St 5 4 1 1     15 Width 3ft   6012676.19431 2104276.36771 37.7586556841436 -122.399192740559 (37.7586556841436, -122.399192740559)
177184 191261 2 30 690 Wisconsin St 3 4 1 1     18 Width 3ft   6012675.54577 2104288.99957 37.7586903323146 -122.399195870217 (37.7586903323146, -122.399195870217)
151835 176944 2 30 19 Lois Ln 4 1 1 1     6 Width 2ft   6012329.67576 2087861.6330900001 37.7135649447506 -122.39923890456801 (37.7135649447506, -122.399238904568)
Powered by Datasette · Query took 10.995ms · Data source: data.sfgov.org