Street_Tree_List

Data source: data.sfgov.org

396 rows where qSpecies = 38 sorted by qLegalStatus descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus ▲ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
129429 129429 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 38 155 Winston Dr 1 Front Yard : Yard 7 Tree 1 Private 1           5990788.0 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965)
4658 4658 176983 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2935 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 3ft   5996974.67191 2087476.2225099998 37.711638981816 -122.452283225586 (37.711638981816, -122.452283225586)
4683 4683 176984 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2923 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 Width 3ft   5996996.89662 2087496.1826099998 37.7116950608382 -122.452207850721 (37.7116950608382, -122.452207850721)
8136 8136 2477 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2307X Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x4   6003648.68016 2115921.80581 37.790123955413705 -122.43124522668998 (37.7901239554137, -122.43124522669)
11074 11074 882 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1138X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.9739299999 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056)
11690 11690 1262 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 3900 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X5   5992602.03225 2087509.49597 37.7114788737215 -122.467398529617 (37.7114788737215, -122.467398529617)
12496 12496 24276 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 350X Winding Way 14 Median : Cutout 11 Tree 1 DPW 2     6 8   6000825.35085 2086800.6303 37.710003801206796 -122.438925891137 (37.7100038012068, -122.438925891137)
17570 17570 1213 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 3411 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   5993897.04108 2087339.7447 37.711087454604204 -122.46291036762199 (37.7110874546042, -122.462910367622)
18415 18415 13417 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 400 Marietta Dr 1 Median : Cutout 11 Tree 1 DPW 2     70 5   5999553.15658 2097034.9165400001 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717)
21000 21000 29586 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 500X Junipero Serra Blvd 21 Median : Cutout 11 Tree 1 DPW 2     9 3X3   5991342.7865 2093687.81781 37.7283702470744 -122.47220084100901 (37.7283702470744, -122.472200841009)
21489 21489 29601 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900X Junipero Serra Blvd 10 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 3X3   5991172.090009999 2091066.888 37.7211639453471 -122.472599932234 (37.7211639453471, -122.472599932234)
21749 21749 29627 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900X Junipero Serra Blvd 36 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 12 3X3   5991152.87782 2090760.03066 37.7203202787275 -122.472643981031 (37.7203202787275, -122.472643981031)
23148 23148 973 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1599 Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 0   6001917.27172 2093023.46154 37.72715237348 -122.435596901293 (37.72715237348, -122.435596901293)
24818 24818 191371 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900x Carolina St 66 Median : Yard 3 Tree 1 DPW 2     13     6012518.79145 2102845.53786 37.7547181653131 -122.39963665401699 (37.7547181653131, -122.399636654017)
27702 27702 191370 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900x Carolina St 63 Median : Yard 3 Tree 1 DPW 2     15     6012517.15762 2102887.31193 37.75483277672829 -122.399645237162 (37.7548327767283, -122.399645237162)
30866 30866 200618 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 59 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   6016445.2081 2095088.6176 37.733637339432 -122.38551735943399 (37.733637339432, -122.385517359434)
38640 38640 191369 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900x Carolina St 62 Median : Yard 3 Tree 1 DPW 2     15     6012514.91638 2102899.16549 37.7548651990855 -122.399653820263 (37.7548651990855, -122.399653820263)
38728 38728 200604 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 61 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016455.981000001 2095075.886 37.7336029770488 -122.385479227084 (37.7336029770488, -122.385479227084)
72294 72294 200614 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 55 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6016432.4764 2095111.6325 37.73369982930821 -122.385562980445 (37.7336998293082, -122.385562980445)
76333 76333 200612 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 53 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   6016428.558999999 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213)
76733 76733 200616 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 57 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914)
79154 79154 976 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1599 Alemany Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X4   6001942.44101 2093088.0021099998 37.7273310167784 -122.43551450655701 (37.7273310167784, -122.435514506557)
79594 79594 12917 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2935X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915)
84781 84781 101254 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 3700X Cesar Chavez St 1 Front Yard : Yard 7 Tree 1 DPW 2           6005840.6 2100555.6 37.74805599841039 -122.422568977073 (37.7480559984104, -122.422568977073)
94398 94398 116654 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 199x Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95215 95215 116655 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 199x Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95391 95391 113478 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 100x ESMERALDA AVE 5 Unaccepted Street : Yard 14 Tree 1 DPW 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
95944 95944 116681 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 100 Esmeralda Ave 20 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
98542 98542 12918 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2935X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915)
102052 102052 23670 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 317 Virginia Ave 1 Median : Cutout 11 Tree 1 DPW 2     3 12   6006937.941544901 2098264.8464559 37.7418279505329 -122.41861198258002 (37.7418279505329, -122.41861198258)
105136 105136 18878 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2305 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3X3   6003659.521319999 2115878.15996 37.7900047293604 -122.43120460047501 (37.7900047293604, -122.431204600475)
112441 112441 24808 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 7117 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/22/1996 12:00:00 AM 3 3X3   5984967.23631 2112432.54215 37.7794670623637 -122.49562310699899 (37.7794670623637, -122.495623106999)
117712 117712 26830 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 3590X 19th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/18/1999 12:00:00 AM 8 3x18   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
128729 128729 105136 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 175X ESMERALDA AVE 2 unknown : Yard 19 Tree 1 DPW 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
131762 131762 191368 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 900x Carolina St 60 Median : Yard 3 Tree 1 DPW 2     25     6012502.16132 2102909.3105599997 37.7548923442165 -122.399698643387 (37.7548923442165, -122.399698643387)
137132 137132 200619 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1400x La Salle Ave 60 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   6016453.0429 2095085.1899 37.733628361140106 -122.38549003320101 (37.7336283611401, -122.385490033201)
139249 139249 16565 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2305X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   5999593.35864 2089327.05238 37.716870613942795 -122.443365227339 (37.7168706139428, -122.443365227339)
140587 140587 31580 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1841 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM     Permit Number 35119 5989049.89925793 2102807.07383274 37.75327638601021 -122.48079472188999 (37.7532763860102, -122.48079472189)
140815 140815 16566 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 2305X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   5999574.07501 2089304.05837 37.716806377922104 -122.44343023048201 (37.7168063779221, -122.443430230482)
142319 142319 24738 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 7700 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/09/1996 12:00:00 AM 3 3X3   5983089.132019999 2112566.68135 37.7797252106941 -122.502130088809 (37.7797252106941, -122.502130088809)
143078 143078 121420 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1155x Prague St 1 Median : Cutout 11 Tree 1 DPW 2       3x3   6000780.0 2086820.0 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343)
182431 182431 218284 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 50x Junipero Serra Frontage West 0 Median : Yard 3 Tree 1 DPW 2     28     5991438.8932 2095398.7783700002 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523)
1699 1699 237552 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 102 Hancock St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003566.97457 2105097.88602 37.7603995118464 -122.430755182518 (37.7603995118464, -122.430755182518)
1709 1709 237551 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 102 Hancock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003586.068 2105101.14828 37.760409550968205 -122.430689380017 (37.7604095509682, -122.430689380017)
3268 3268 227695 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 4250 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6001245.674269999 2103366.3123 37.7555132424609 -122.43865939052701 (37.7555132424609, -122.438659390527)
3544 3544 253465 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3561 3561 253462 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3567 3567 253463 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3585 3585 253464 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 98X Marston Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
23861 23861 184307 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1553 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982166.1739 2104530.0154 37.7576045827244 -122.50472730219 (37.7576045827244, -122.50472730219)
24102 24102 186759 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984850.1974 2106711.7495 37.7637525404811 -122.495605915184 (37.7637525404811, -122.495605915184)
24466 24466 207106 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 100 Tara St 2 : 4 Tree 1 Private 1     20 Width 0ft   5998100.60654 2090923.0946 37.7211677377768 -122.448639805789 (37.7211677377768, -122.448639805789)
24900 24900 249938 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 339 Filbert St 3 Front Yard : Yard 7 Tree 1 Private 1     8 Width 0ft   6011244.68883 2120032.5219400004 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256)
25429 25429 119085 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 886 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   5982037.396000001 2109722.65545 37.7718545033558 -122.50555756428601 (37.7718545033558, -122.505557564286)
26252 26252 227697 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 109 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6003800.52049 2108768.8119 37.7704922173631 -122.430209350707 (37.7704922173631, -122.430209350707)
29076 29076 227690 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 307 Bocana St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6006885.1558 2097215.40267 37.7389434396991 -122.41872009246299 (37.7389434396991, -122.418720092463)
29234 29234 186513 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 14 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980894.1374 2105147.1675 37.759224194224 -122.509172270667 (37.759224194224, -122.509172270667)
31036 31036 181438 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1319 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5981181.6009 2106068.5638 37.761771027502 -122.508246492496 (37.761771027502, -122.508246492496)
31114 31114 118441 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 5201 Anza St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5982477.73735 2111660.7356 37.7772018111581 -122.504178007129 (37.7772018111581, -122.504178007129)
31147 31147 207112 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 59 Ralston St 4 Back Yard : Yard 13 Tree 1 Private 1     12     5992171.746719999 2088295.8735200001 37.7136132266511 -122.46894288591899 (37.7136132266511, -122.468942885919)
32724 32724 227696 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 50 Belcher St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6003774.74871 2108065.2472200003 37.7685589402651 -122.43024829315 (37.7685589402651, -122.43024829315)
32798 32798 227686 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1001 Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5997629.48637 2107046.8431599997 37.7654126728718 -122.45143067278299 (37.7654126728718, -122.451430672783)
33000 33000 138260 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2600 GEARY BLVD 28 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676)
33669 33669 247869 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 394 Mayflower St 1 Side Yard : Yard 17 Tree 1 Private 1     9     6009720.84865 2098403.35069 37.7423645372013 -122.408999330354 (37.7423645372013, -122.408999330354)
34046 34046 186310 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1800 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984966.7705 2102775.9332 37.7529527085207 -122.49491251324899 (37.7529527085207, -122.494912513249)
35370 35370 248189 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 216 Esmeralda Ave 8 Side Yard : Yard 17 Tree 1 Private 1     11     6007400.67054 2098728.2959 37.7431265201804 -122.417044843446 (37.7431265201804, -122.417044843446)
36322 36322 183431 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2506 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5988944.9633 2098242.4359999998 37.740736995081704 -122.480823446497 (37.7407369950817, -122.480823446497)
36675 36675 186762 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984853.5932 2106716.1156 37.7637647274179 -122.49559449238701 (37.7637647274179, -122.495594492387)
37042 37042 207101 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1325 18th Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5990477.30542 2106226.48097 37.7627480320102 -122.476108237903 (37.7627480320102, -122.476108237903)
37103 37103 207104 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 242 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5995372.52306 2091590.05793 37.7228426882306 -122.458118187099 (37.7228426882306, -122.458118187099)
37269 37269 227675 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1000 San Jose Ave 104 Front Yard : Yard 7 Tree 1 Private 1     27     6005040.407269999 2096975.5643799999 37.7381808604543 -122.425081325568 (37.7381808604543, -122.425081325568)
37604 37604 184574 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1706 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5981029.903 2103411.5484 37.754466683478604 -122.50857388751899 (37.7544666834786, -122.508573887519)
38129 38129 191390 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 845 Vermont St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     6011298.55233 2104376.91383 37.7588548893488 -122.403964355369 (37.7588548893488, -122.403964355369)
39739 39739 129479 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Filbert St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6012506.1322099995 2120230.97584 37.8024538756 -122.400901840066 (37.8024538756, -122.400901840066)
40186 40186 218289 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1 Woodacre Dr 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28     5991265.0261699995 2095485.2551900002 37.7333010580894 -122.472600653515 (37.7333010580894, -122.472600653515)
40391 40391 129467 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1331 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6006504.317480001 2119710.78815 37.8006889650949 -122.42163415671301 (37.8006889650949, -122.421634156713)
41282 41282 227693 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 337 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6002979.940119999 2100929.17253 37.748919939311705 -122.432487701248 (37.7489199393117, -122.432487701248)
41740 41740 183278 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1255 42nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5983028.2339 2106536.9311 37.7631656789881 -122.50189448779601 (37.7631656789881, -122.501894487796)
43299 43299 129476 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1077 Front St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     6012591.305319999 2120127.94056 37.8021757161919 -122.4005998549 (37.8021757161919, -122.4005998549)
43545 43545 129484 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Greenwich St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     6012303.2887699995 2120555.11364 37.8033325627054 -122.401626578498 (37.8033325627054, -122.401626578498)
44170 44170 227687 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1003 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5997630.84664 2107024.34604 37.7653509793933 -122.45142434518401 (37.7653509793933, -122.451424345184)
44625 44625 186760 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984860.8701 2106711.7495 37.7637531654529 -122.495569002148 (37.7637531654529, -122.495569002148)
45882 45882 186748 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984868.1469 2106676.3356 37.7636563549354 -122.495541222153 (37.7636563549354, -122.495541222153)
48955 48955 183430 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2508 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5988945.948 2098228.8968 37.7406998772059 -122.480819050828 (37.7406998772059, -122.480819050828)
49267 49267 191398 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 4 Front Yard : Yard 7 Tree 1 Private 1     14     6010740.07849 2107915.77093 37.768540573414896 -122.406145147482 (37.7685405734149, -122.406145147482)
50006 50006 191374 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6011292.66605 2104334.91271 37.7587392347502 -122.403981757255 (37.7587392347502, -122.403981757255)
50007 50007 186756 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984857.4742 2106702.5322 37.7637276584797 -122.495580067458 (37.7637276584797, -122.495580067458)
50995 50995 186509 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 10 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980901.3856 2105130.6001 37.759179132228 -122.509145973072 (37.759179132228, -122.509145973072)
51787 51787 217831 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22     5991381.66969 2095739.8250799999 37.734006793868 -122.472215938837 (37.734006793868, -122.472215938837)
52773 52773 183252 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1300 La Playa 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5980914.4873 2106074.2169999997 37.761770805091096 -122.50917073482799 (37.7617708050911, -122.509170734828)
53270 53270 207125 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 4 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   5991332.892440001 2095658.5010099998 37.733780675521395 -122.47237864866001 (37.7337806755214, -122.47237864866)
53381 53381 217850 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1 Woodacre Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5991375.86862 2095660.38148 37.7337883260711 -122.47223020566999 (37.7337883260711, -122.47223020567)
53774 53774 129486 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Greenwich St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6012297.60436 2120565.6201 37.803361093695 -122.40164698862199 (37.803361093695, -122.401646988622)
54198 54198 129465 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1974 Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6005261.30695 2116522.05783 37.791863352156 -122.425708403014 (37.791863352156, -122.425708403014)
54994 54994 191408 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Tulare St 5 Front Yard : Yard 7 Tree 1 Private 1     3     6016232.34971 2100308.61772 37.747958617113596 -122.38661714986 (37.7479586171136, -122.38661714986)
55201 55201 218280 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1 Woodacre Dr 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30     5991369.16642 2095649.3447099999 37.7337576340075 -122.47225257269301 (37.7337576340075, -122.472252572693)
56497 56497 118789 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 718 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5981995.4955 2110847.43445 37.7749403522663 -122.505785898051 (37.7749403522663, -122.505785898051)
56665 56665 183655 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 4000 Kirkham St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982394.94 2104929.8732 37.7587159336991 -122.503965765246 (37.7587159336991, -122.503965765246)
57626 57626 129464 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1974 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6005282.18317 2116523.47353 37.7918684189526 -122.425636272008 (37.7918684189526, -122.425636272008)
59085 59085 185502 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2400 Sunset Blvd 56 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985117.0889 2098738.1726 37.7418749156753 -122.494095121998 (37.7418749156753, -122.494095121998)

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