Street_Tree_List

Data source: data.sfgov.org

287 rows where SiteOrder = 2 and qSpecies = 54 sorted by PlotSize

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

SiteOrder

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
10128 173868 Permitted Site 1 :: 54 808 Capitol Ave 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
20493 31189 Permitted Site 1 :: 54 744 Shields St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572)
30528 36517 Permitted Site 1 :: 54 430 Crescent Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
77581 33407 Permitted Site 1 :: 54 100 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
78529 43025 Permitted Site 1 :: 54 430 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM     Permit Number 42886 6004125.6708626 2110297.9605007 37.774709297051004 -122.429193705112 (37.774709297051, -122.429193705112)
81650 45785 Permitted Site 1 :: 54 355 Granada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/2001 12:00:00 AM     Permit Number 44424 5995605.92038879 2092277.61806963 37.7247439722696 -122.457361104262 (37.7247439722696, -122.457361104262)
83415 114615 Undocumented 2 :: 54 2400X Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
85364 115892 Permitted Site 1 :: 54 1900X Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
85374 114726 Significant Tree 6 :: 54 520 Townsend St 2 Front Yard : Yard 7 Tree 1 Private 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
86204 33463 Permitted Site 1 :: 54 20 Coleridge St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/20/1996 12:00:00 AM     Permit Number 37562 6006978.38557579 2099649.65289984 37.7456325955283 -122.418570316182 (37.7456325955283, -122.418570316182)
88816 115002 Undocumented 2 :: 54 46 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5993155.2 2098864.2 37.742688023212295 -122.46631133896999 (37.7426880232123, -122.46631133897)
89497 30705 Permitted Site 1 :: 54 371 Oak St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1995 12:00:00 AM     Permit Number 34615 6005225.74804899 2110232.43831944 37.7745916029272 -122.425383648395 (37.7745916029272, -122.425383648395)
92236 43021 Permitted Site 1 :: 54 537 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM     Permit Number 42882 6003129.08838274 2110095.37711913 37.7740965863099 -122.432626609315 (37.7740965863099, -122.432626609315)
94877 42090 Permitted Site 1 :: 54 25 Stoneman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42397 6008240.69863747 2099401.70748619 37.7450227780609 -122.414187874949 (37.7450227780609, -122.414187874949)
94995 108989 Undocumented 2 :: 54 2073-2099X Jefferson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501)
98945 116341 Undocumented 2 :: 54 201X Bright St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
99142 116319 Undocumented 2 :: 54 1451 Hampshire St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
100878 108803 Undocumented 2 :: 54 401-499 University St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
104314 105082 Significant Tree 6 :: 54 344 Fulton St 2 Front Yard : Yard 7 Tree 1 Private 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
108795 113997 Undocumented 2 :: 54 58 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5989321.8 2114884.9 37.786454584135704 -122.480738581989 (37.7864545841357, -122.480738581989)
114951 33208 Permitted Site 1 :: 54 80 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.74465070488021 -122.454762009134 (37.7446507048802, -122.454762009134)
118536 36929 Permitted Site 1 :: 54 901 Elizabeth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/27/1998 12:00:00 AM     Permit Number 39571 6000612.32634681 2101962.60570598 37.751622953989205 -122.440749012812 (37.7516229539892, -122.440749012812)
120235 115062 DPW Maintained 3 :: 54 70 Coral Rd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
120864 37457 Permitted Site 1 :: 54 442 Holladay Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1998 12:00:00 AM     Permit Number 39929 6010236.40979486 2098631.79989851 37.743020676259704 -122.40723276795299 (37.7430206762597, -122.407232767953)
123158 36526 Permitted Site 1 :: 54 619 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/18/1998 12:00:00 AM     Permit Number 39400 6007328.0 2097732.0 37.74038682503829 -122.41722553506399 (37.7403868250383, -122.417225535064)
124407 116322 Undocumented 2 :: 54 1400X Potrero Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
127642 36507 Permitted Site 1 :: 54 584 Anderson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/29/2003 12:00:00 AM     Permit Number 39385 6007790.43718065 2096197.35426509 37.736199030760105 -122.41551798135401 (37.7361990307601, -122.415517981354)
129313 117320 Permitted Site 1 :: 54 1935 09th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/07/2016 12:00:00 AM 3   Permit Number 778503 5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401)
141239 116275 Undocumented 2 :: 54 700X Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
143047 115869 Undocumented 2 :: 54 84X Cordova St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         on Athens St frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
145190 33509 Permitted Site 1 :: 54 24 Coleridge St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/1996 12:00:00 AM     Permit Number 37605 6006962.93911675 2099621.40648906 37.745554167617 -122.418621725138 (37.745554167617, -122.418621725138)
145496 108795 Undocumented 2 :: 54 501-599 University St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
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)
126302 109534 Permitted Site 1 :: 54 1234 Filbert St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1 FUF 1 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
97786 109767 Permitted Site 1 :: 54 1801 Scott St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       11.75x1.5+3.6x3.6   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
10104 173847 Permitted Site 1 :: 54 450 Toland St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
91070 105360 Permitted Site 1 :: 54 850 Guerrero St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
125946 109370 Permitted Site 1 :: 54 2061 Hyde St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
118010 109755 Permitted Site 1 :: 54 601 Steiner St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
3639 253517 Permitted Site 1 :: 54 559 24th Ave 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
81163 104152 Permitted Site 1 :: 54 525X Church St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 SFUSD 4 DPW 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
122806 105040 Permitted Site 1 :: 54 2660 Harrison St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
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)
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)
5236 253833 Permitted Site 1 :: 54 607 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4     3x3            
84556 115963 Undocumented 2 :: 54 847 43RD AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/2016 12:00:00 AM 3 3x3   5982585.0 2109998.0 37.7726427311472 -122.50368379034599 (37.7726427311472, -122.503683790346)
88179 105438 Undocumented 2 :: 54 1116 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002483.0 2102334.0 37.75274907025911 -122.43430654109899 (37.7527490702591, -122.434306541099)
95693 117514 Undocumented 2 :: 54 1445 DIAMOND ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002056.0 2099801.0 37.7457698069611 -122.435601983861 (37.7457698069611, -122.435601983861)
96984 121265 Undocumented 2 :: 54 3053 Turk Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996367.0 2111408.0 37.777314902031705 -122.45611263058399 (37.7773149020317, -122.456112630584)
99672 121127 Undocumented 2 :: 54 201 Bemis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
113500 109261 Permitted Site 1 :: 54 3338X Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   5983663.54917 2102222.75157 37.7513574508855 -122.499378353213 (37.7513574508855, -122.499378353213)
138784 116944 Undocumented 2 :: 54 3676 23RD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005238.0 2102584.0 37.753591501312705 -122.424797029407 (37.7535915013127, -122.424797029407)
140860 109571 Permitted Site 1 :: 54 400 Brazil Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   6003029.6 2091527.8 37.7231087370031 -122.43164485974701 (37.7231087370031, -122.431644859747)
142578 105065 Permitted Site 1 :: 54 3177 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006744.0 2099801.7 37.7460368842113 -122.419391572433 (37.7460368842113, -122.419391572433)
91154 109365 Permitted Site 1 :: 54 1205 Filbert St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
1391 251531 Permitted Site 1 :: 54 2100X 20th St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
42994 109343 Permitted Site 1 :: 54 3211 Baker St 2 Sidewalk: Property side : Yard 9 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
113603 104154 Permitted Site 1 :: 54 525X Church St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 SFUSD 4 DPW 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
116050 111759 Permitted Site 1 :: 54 1235 47th Ave 2 Sidewalk: Curb side : Yard 2 Landscaping 2 Private 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
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)
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)
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)
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)
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)
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)
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)
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)
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)
28907 182325 Undocumented 2 :: 54 1500 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985611.7191 2104963.9168 37.758998042021105 -122.492843336234 (37.7589980420211, -122.492843336234)
29815 181758 Undocumented 2 :: 54 1230 36th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984924.8270000005 2106814.5562 37.764039188732205 -122.495355380579 (37.7640391887322, -122.495355380579)
31070 138278 Undocumented 2 :: 54 2181 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001737.3169 2113910.2795 37.784492318138106 -122.437714255164 (37.7844923181381, -122.437714255164)
31222 182419 Undocumented 2 :: 54 1548 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985308.8008 2104684.9478 37.7582143519431 -122.493870396795 (37.7582143519431, -122.493870396795)
32319 138821 Undocumented 2 :: 54 745 BUCHANAN ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6004449.5065 2111116.3546 37.776974733592205 -122.428131826933 (37.7769747335922, -122.428131826933)
32403 182450 Undocumented 2 :: 54 1566 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5988103.6039 2104651.3921 37.75828533821571 -122.484202411136 (37.7582853382157, -122.484202411136)
32483 182444 Undocumented 2 :: 54 1530 34th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985615.2362 2104790.3432 37.758521662620296 -122.49281838798099 (37.7585216626203, -122.492818387981)
33271 184161 Undocumented 2 :: 54 3540 Lawton St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5983209.359 2104274.4825 37.7569642726582 -122.501100703383 (37.7569642726582, -122.501100703383)
33938 182209 Undocumented 2 :: 54 1590 34th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985630.9934 2104420.723 37.75750770910879 -122.492736670044 (37.7575077091088, -122.492736670044)
34038 140392 Undocumented 2 :: 54 1460 Steiner St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6002728.4059 2113323.2276 37.782936725289204 -122.434243446651 (37.7829367252892, -122.434243446651)
34444 139926 Undocumented 2 :: 54 1001 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005215.378 2112666.1069 37.78127327564229 -122.425592763682 (37.7812732756423, -122.425592763682)
34634 183835 Undocumented 2 :: 54 2210 32nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5986395.4815 2100173.9333 37.7458918514691 -122.489780482903 (37.7458918514691, -122.489780482903)
34796 138319 Undocumented 2 :: 54 1915 PIERCE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001944.4165 2115111.5373 37.7878024384193 -122.437083797069 (37.7878024384193, -122.437083797069)
36590 182200 Undocumented 2 :: 54 1591 32nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5986205.3811 2104418.9832 37.757536502339704 -122.490750106029 (37.7575365023397, -122.490750106029)
37240 182497 Undocumented 2 :: 54 1567 33rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985891.0491 2104555.5597 37.7578931366951 -122.491847232012 (37.7578931366951, -122.491847232012)
38023 183701 Undocumented 2 :: 54 1349 37th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5984598.3295 2105986.1027 37.7617453659671 -122.49642348771098 (37.7617453659671, -122.496423487711)
38433 181714 Undocumented 2 :: 54 1215 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5987051.5149 2106949.2334 37.764533265698 -122.488009786224 (37.764533265698, -122.488009786224)
38904 182360 Undocumented 2 :: 54 1507 33rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985877.3228 2104935.7779 37.7589363086434 -122.491922694782 (37.7589363086434, -122.491922694782)
39107 139604 Undocumented 2 :: 54 1173 SCOTT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6001838.238 2112425.6952 37.7804217645564 -122.437258767268 (37.7804217645564, -122.437258767268)
39530 184555 Undocumented 2 :: 54 3601 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5983107.8094 2103539.071 37.754939075681705 -122.50139749571501 (37.7549390756817, -122.501397495715)
39826 183322 Undocumented 2 :: 54 3927 Lincoln Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5983510.9139 2106953.643 37.764338193887504 -122.50025589533001 (37.7643381938875, -122.50025589533)
39979 185836 Undocumented 2 :: 54 2000 35th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5985432.8989 2101036.5759 37.748204183826395 -122.4931724505 (37.7482041838264, -122.4931724505)
40775 138003 Undocumented 2 :: 54 1670 Laguna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6004492.797 2114606.7181 37.7865608551259 -122.428230885205 (37.7865608551259, -122.428230885205)
41261 184673 Undocumented 2 :: 54 1683 38th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984368.1401 2103732.6021 37.755544395128105 -122.49705326703999 (37.7555443951281, -122.49705326704)
41266 140561 Undocumented 2 :: 54 50 FRIENDSHIP CT 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6003695.7169 2111697.8997 37.7785288350927 -122.43078092716401 (37.7785288350927, -122.430780927164)
41764 183600 Undocumented 2 :: 54 2639 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5989549.7171 2097348.9516 37.738318851123 -122.47866713334 (37.738318851123, -122.47866713334)
41978 184524 Undocumented 2 :: 54 1984 Lower Great Hwy 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5981181.0558 2101584.0989 37.7494579320564 -122.50791555821199 (37.7494579320564, -122.507915558212)
42137 186840 Undocumented 2 :: 54 1201 36th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5984884.6409 2106758.5555 37.763883073514 -122.495490239842 (37.763883073514, -122.495490239842)
42563 139441 Undocumented 2 :: 54 501 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6005361.8674 2111299.9206 37.7775303390293 -122.424988750303 (37.7775303390293, -122.424988750303)
44907 182397 Undocumented 2 :: 54 1522 33rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5985924.4899 2104853.8684 37.7587141646 -122.49175354130301 (37.7587141646, -122.491753541303)
44995 183721 Undocumented 2 :: 54 2263 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   5987911.8967 2099894.633 37.7452133904635 -122.484516511954 (37.7452133904635, -122.484516511954)
46023 183740 Undocumented 2 :: 54 2280 31st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   5986718.9493 2099755.7296 37.7447624573869 -122.48863125822099 (37.7447624573869, -122.488631258221)

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 923.307ms · Data source: data.sfgov.org