Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▲ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
152523 152523 223698 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 1 Front Yard : Yard 7 Tree 1 Private 1     151     6004903.42732 2096771.39372 37.7376125150086 -122.42554040785801 (37.7376125150086, -122.425540407858)
148568 148568 176105 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700x Mansell St 29 Median : Cutout 11 Tree 1 DPW 2     105 Width 0ft   6009225.48687 2089982.90412 37.7192160263732 -122.41011780460899 (37.7192160263732, -122.410117804609)
118710 118710 105850 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44 MENDOSA AVE 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372)
23770 23770 186402 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984820.6527 2102319.266 37.7516902715465 -122.495384132242 (37.7516902715465, -122.495384132242)
24028 24028 186361 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984795.4735 2102590.7965 37.752434345234 -122.495491228463 (37.752434345234, -122.495491228463)
25740 25740 187008 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984967.4388 2098043.05 37.739957538540295 -122.49456132318899 (37.7399575385403, -122.494561323189)
152584 152584 184346 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1251 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984686.7384 2106407.7493 37.7629082680796 -122.49614883097901 (37.7629082680796, -122.496148830979)
153184 153184 185035 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5985023.8956 2096287.7176 37.7351411700064 -122.49423677323401 (37.7351411700064, -122.494236773234)
155847 155847 186256 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984812.6153 2103003.1364 37.7535675206606 -122.49546235883498 (37.7535675206606, -122.495462358835)
163766 163766 185074 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2801 Sunset Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984997.7254 2096135.7209 37.7347222961152 -122.49431605154301 (37.7347222961152, -122.494316051543)
167561 167561 186155 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1700 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984957.7478 2103324.5301 37.7544584761874 -122.494984162752 (37.7544584761874, -122.494984162752)
171399 171399 184735 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     99 Width 0ft   5984680.1977 2106291.6891 37.7625892162308 -122.496162889393 (37.7625892162308, -122.496162889393)
149618 149618 185710 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     95 Width 0ft   5984848.6658 2100421.3565 37.7464807716884 -122.495147319794 (37.7464807716884, -122.495147319794)
156364 156364 185965 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     90 Width 0ft   5984859.6467 2101291.1753 37.748869699536904 -122.49517348139999 (37.7488696995369, -122.4951734814)
179874 179874 186060 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     90 Width 0ft   5984837.0831 2102159.5408 37.7512526720721 -122.49531553640101 (37.7512526720721, -122.495315536401)
149016 149016 185997 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 56 Sidewalk: Property side : Yard 9 Tree 1 Private 1     87 Width 0ft   5984874.4912 2100963.0377 37.7479695924465 -122.495097956423 (37.7479695924465, -122.495097956423)
183441 183441 185627 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2100 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     87 Width 0ft   5985046.4186 2100324.9202 37.7462275593372 -122.494456414967 (37.7462275593372, -122.494456414967)
34443 34443 186561 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     85 Width 0ft   5984740.943 2104715.6846 37.758265506246296 -122.495836533834 (37.7582655062463, -122.495836533834)
69733 69733 186694 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1401 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     85 Width 0ft   5984719.2741 2105229.7727 37.75967577978221 -122.495949397724 (37.7596757797822, -122.495949397724)
76772 76772 185977 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     85 Width 0ft   5984864.6841 2101097.7224 37.7483388256863 -122.495141798808 (37.7483388256863, -122.495141798808)
148127 148127 185306 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     85 Width 0ft   5984983.5934 2097312.6487 37.7379529982098 -122.49445163979401 (37.7379529982098, -122.494451639794)
55181 55181 187225 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2401 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     81 Width 0ft   5984926.1909 2098694.4361 37.741743654922296 -122.494751951574 (37.7417436549223, -122.494751951574)
70399 70399 185574 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     81 Width 0ft   5984904.9127 2099653.9265 37.744376910333 -122.494896252369 (37.744376910333, -122.494896252369)
26684 26684 185578 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     80 Width 0ft   5984888.727999999 2099615.9854 37.744271786934796 -122.49494941784201 (37.7442717869348, -122.494949417842)
29091 29091 186379 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     80 Width 0ft   5984812.5721 2102477.6444 37.7521246619181 -122.495423755128 (37.7521246619181, -122.495423755128)
55565 55565 185944 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     80 Width 0ft   5984848.1796 2101522.6398 37.7495045663334 -122.49523020096001 (37.7495045663334, -122.49523020096)
108351 108351 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 101 URBANO DR 1 Front Yard : Yard 7 Tree 1 Private 1     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025)
162604 162604 186094 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     79 Width 0ft   5984804.2595 2101775.159 37.7501953433109 -122.49540069682199 (37.7501953433109, -122.495400696822)
71097 71097 184768 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     78 Width 0ft   5984699.3735 2106071.8316 37.761986672397 -122.496080347248 (37.761986672397, -122.496080347248)
75065 75065 186159 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1700 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     77 Width 0ft   5984932.8209 2103361.228 37.7545577792255 -122.495073071066 (37.7545577792255, -122.495073071066)
162400 162400 187357 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2200 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     77 Width 0ft   5985072.2445 2099793.5247 37.7447700029853 -122.494327950417 (37.7447700029853, -122.494327950417)
55184 55184 187026 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     76 Width 0ft   5984957.5185 2097874.0689 37.7394929812704 -122.49458316876199 (37.7394929812704, -122.494583168762)
163901 163901 186063 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     75 Width 0ft   5984824.1542 2102129.3734 37.7511690836835 -122.49535802071101 (37.7511690836835, -122.495358020711)
50830 50830 187240 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2401 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     74 Width 0ft   5984922.9229999995 2098555.1433 37.741361003208795 -122.494752983477 (37.7413610032088, -122.494752983477)
28097 28097 184746 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     73 Width 0ft   5984670.325 2106153.0915 37.7622080878104 -122.49618680876499 (37.7622080878104, -122.496186808765)
28570 28570 187221 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2401 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     73 Width 0ft   5984920.4721 2098768.3716 37.7419463270938 -122.494777174832 (37.7419463270938, -122.494777174832)
133818 133818 186243 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 54 Sidewalk: Property side : Yard 9 Tree 1 Private 1     73 Width 0ft   5984798.9554 2103218.7477 37.7541587299008 -122.495525498398 (37.7541587299008, -122.495525498398)
25090 25090 223699 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1100 San Jose Ave 2 Front Yard : Yard 7 Tree 1 Private 1     72     6004901.063490001 2096745.81285 37.737542142145706 -122.425546760699 (37.7375421421457, -122.425546760699)
151754 151754 185361 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     72 Width 0ft   5985015.9398 2096870.9998 37.7367422415889 -122.49430725909599 (37.7367422415889, -122.494307259096)
180772 180772 186089 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     72 Width 0ft   5984838.8917 2101823.6441 37.750330497842995 -122.49528451351001 (37.750330497843, -122.49528451351)
77263 77263 185735 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     71 Width 0ft   5984891.8172 2100271.961 37.7460730985326 -122.49498709535801 (37.7460730985326, -122.494987095358)
146474 146474 186043 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1900 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     71 Width 0ft   5984987.6927 2102184.5017 37.751330024914395 -122.49479655955 (37.7513300249144, -122.49479655955)
176904 176904 185257 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2570 33rd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     71 Width 0ft   5986168.5104 2097746.1262 37.739212488149796 -122.490386735185 (37.7392124881498, -122.490386735185)
26145 26145 185549 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     70 Width 0ft   5984904.1167 2099896.1658 37.745041987094396 -122.49491686223999 (37.7450419870944, -122.49491686224)
74975 74975 185009 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     70 Width 0ft   5984987.4666 2096476.9807 37.7356587041277 -122.494376666271 (37.7356587041277, -122.494376666271)
84029 84029 21328 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2501X Sunset Blvd 28 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
113104 113104 21228 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2392X Sunset Blvd 31 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70     5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
184555 184555 186200 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     70 Width 0ft   5984778.3318 2103452.7061 37.754799907325605 -122.49561407416701 (37.7547999073256, -122.495614074167)
164893 164893 184780 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     69 Width 0ft   5984672.982999999 2105911.7799 37.7615456694917 -122.496159811415 (37.7615456694917, -122.496159811415)
185648 185648 185953 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     69 Width 0ft   5984818.0255 2101428.1429 37.7492433382305 -122.49532750509199 (37.7492433382305, -122.495327505092)
98923 98923 185985 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     68 Width 0ft   5984835.0992 2101040.6776 37.7481804641628 -122.495239894977 (37.7481804641628, -122.495239894977)
152630 152630 185951 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     68 Width 0ft   5984852.8514 2101465.7293 37.749348579206796 -122.495209849718 (37.7493485792068, -122.495209849718)
46888 46888 223710 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 San Jose Ave 13 Front Yard : Yard 7 Tree 1 Private 1     67     6004258.36813 2095937.1689 37.735285453551604 -122.427711264267 (37.7352854535516, -122.427711264267)
60814 60814 186596 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     67 Width 0ft   5984749.6315 2104462.0427 37.757569584992396 -122.495787775902 (37.7575695849924, -122.495787775902)
73768 73768 185673 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2101 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     67 Width 0ft   5984881.5197 2100790.5954 37.747496524434396 -122.495060938811 (37.7474965244344, -122.495060938811)
135127 135127 122185 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2 14th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     67     5991491.733030001 2115080.7655 37.787118258390606 -122.473245521028 (37.7871182583906, -122.473245521028)
29069 29069 186197 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     66 Width 0ft   5984786.367000001 2103519.1304 37.7549827606067 -122.49559118568399 (37.7549827606067, -122.495591185684)
67961 67961 206836 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 14 Median : Yard 3 Tree 1 DPW 2     66 Width 9ft   5995604.17085 2099350.4744700002 37.7441642119029 -122.45787873812799 (37.7441642119029, -122.457878738128)
71307 71307 223724 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 190 Belgrave Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     66 Width 2ft   5997664.737000001 2104901.53877 37.7595242277824 -122.451154026041 (37.7595242277824, -122.451154026041)
55074 55074 185341 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     65 Width 0ft   5984987.4666 2096984.4739 37.7370521447921 -122.49441406407699 (37.7370521447921, -122.494414064077)
132735 132735 223694 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1001 San Jose Ave 8 Front Yard : Yard 7 Tree 1 Private 1     65     6005104.45792 2096735.8383799999 37.7375262448502 -122.424842819945 (37.7375262448502, -122.424842819945)
131940 131940 187018 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984958.1911 2097916.1040000003 37.739608437718395 -122.494583941282 (37.7396084377184, -122.494583941282)
152560 152560 186239 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984787.4383 2103338.7401 37.754487521465 -122.49557417650298 (37.754487521465, -122.495574176503)
168435 168435 176111 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 520 Carter St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     64     6005239.18473 2086329.3019599998 37.7089597755375 -122.423637326411 (37.7089597755375, -122.423637326411)
186276 186276 186413 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1601 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984739.2681 2104238.7582 37.75695590087879 -122.495807145737 (37.7569559008788, -122.495807145737)
186424 186424 184800 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     64 Width 0ft   5984686.2732 2105775.8403 37.76117319587821 -122.496103817218 (37.7611731958782, -122.496103817218)
62963 62963 186357 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1801 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     63 Width 0ft   5984799.4911 2102657.2208 37.7526169633154 -122.49548223376001 (37.7526169633154, -122.49548223376)
147554 147554 181434 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1500 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     63 Width 0ft   5984896.7414 2104905.8493 37.758796768768704 -122.495311746922 (37.7587967687687, -122.495311746922)
166336 166336 185565 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     63 Width 0ft   5984901.9941 2099754.2184 37.7446521138241 -122.494913737481 (37.7446521138241, -122.494913737481)
187642 187642 206837 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 25 Median : Yard 3 Tree 1 DPW 2     63 Width 9ft   5995840.17489 2099294.03492 37.7440227989188 -122.45705861128401 (37.7440227989188, -122.457058611284)
40549 40549 185571 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     62 Width 0ft   5984908.6272 2099694.7862 37.744489317421205 -122.494886420663 (37.7444893174212, -122.494886420663)
73778 73778 185284 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2601 Sunset Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984980.0343 2097412.7236 37.738227568753 -122.49447132025601 (37.738227568753, -122.494471320256)
109936 109936 114056 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700X LAKE MERCED BLVD 2 Median : Cutout 11 Tree 1 Private 1     61     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
149256 149256 184738 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1301 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984659.3131 2106254.4766 37.7624858178148 -122.496232374853 (37.7624858178148, -122.496232374853)
153477 153477 185020 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2701 Sunset Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984996.6786 2096354.7134 37.7353235298613 -122.494335807629 (37.7353235298613, -122.494335807629)
166337 166337 186697 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1401 Sunset Blvd 54 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984719.6928 2105196.6935 37.75958497805411 -122.495945509363 (37.7595849780541, -122.495945509363)
181646 181646 187045 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     61 Width 0ft   5984969.2884 2097687.4331 37.7389812183872 -122.494528719258 (37.7389812183872, -122.494528719258)
184827 184827 176107 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 700x Mansell St 46 Median : Cutout 11 Tree 1 DPW 2     61 Width 0ft   6008982.60232 2089910.3513099998 37.7190031946297 -122.41095224595699 (37.7190031946297, -122.410952245957)
20392 20392 106278 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 200X VIDAL DR 2 Median : Cutout 11 Tree 1 DPW 2     60     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
44967 44967 176143 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Lake Merced Blvd 4 : 4 Tree 1 Private 1     60 Width 0ft   5987585.53383 2089941.9294099999 37.7178668382624 -122.48491497676201 (37.7178668382624, -122.484914976762)
62802 62802 186013 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1900 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     60 Width 0ft   5985009.4701 2101751.3734 37.7501420480542 -122.49468932302 (37.7501420480542, -122.49468932302)
77466 77466 110865 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 838 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 6x9   5985433.60853 2110167.44818 37.7732750611072 -122.49384278286699 (37.7732750611072, -122.493842782867)
90842 90842 21470 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2701X Sunset Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 40   5985119.006821499 2096832.7848434 37.73664334454379 -122.49394810120701 (37.7366433445438, -122.493948101207)
98176 98176 105497 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3929 19TH ST 1 Front Yard : Yard 7 Tree 1 Private 1     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429)
98520 98520 114060 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700X LAKE MERCED BLVD 6 Median : Cutout 11 Tree 1 Private 1     60     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
121496 121496 21457 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2701X Sunset Blvd 10 Median : Cutout 11 Tree 1 DPW 2     60 40   5985119.006821499 2096832.7848434 37.73664334454379 -122.49394810120701 (37.7366433445438, -122.493948101207)
128772 128772 104998 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 286X CASTENADA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 4x18   5993881.0 2100258.0 37.746556897942 -122.463902900317 (37.746556897942, -122.463902900317)
132304 132304 185523 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2201 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     60 Width 0ft   5984870.0228 2100148.4874 37.7457327977456 -122.49505335332199 (37.7457327977456, -122.495053353322)
155430 155430 187147 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2301 Sunset Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     60 Width 0ft   5984894.352000001 2099426.4136 37.743751603399794 -122.49491599662501 (37.7437516033998, -122.494915996625)
53546 53546 223712 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1201 San Jose Ave 75 Front Yard : Yard 7 Tree 1 Private 1     59     6004557.86024 2096180.22234 37.7359697602838 -122.426693112116 (37.7359697602838, -122.426693112116)
66755 66755 186227 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     59 Width 0ft   5984787.1705 2103373.8271 37.754583844985 -122.49557769038 (37.754583844985, -122.49557769038)
158656 158656 186246 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1701 Sunset Blvd 57 Sidewalk: Property side : Yard 9 Tree 1 Private 1     59 Width 0ft   5984800.2947 2103186.8747 37.7540712938714 -122.49551851619199 (37.7540712938714, -122.495518516192)
118992 118992 114058 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 700X LAKE MERCED BLVD 4 Median : Cutout 11 Tree 1 Private 1     58     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
149666 149666 176149 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Lake Merced Blvd 10 : 4 Tree 1 Private 1     58 Width 0ft   5987588.89275 2090533.04242 37.7194900803794 -122.48494670933998 (37.7194900803794, -122.48494670934)
45321 45321 187047 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2501 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984983.7484 2097658.1766 37.738901734187294 -122.49447656785601 (37.7389017341873, -122.494476567856)
47567 47567 186662 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1401 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984707.1311 2105554.3882 37.7605663720512 -122.496015341954 (37.7605663720512, -122.496015341954)
62075 62075 186467 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1601 Sunset Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984746.8052 2103766.8566 37.755660631401604 -122.495746271784 (37.7556606314016, -122.495746271784)
75039 75039 185983 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2001 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984867.1359 2101046.2349 37.748197598621104 -122.495129524484 (37.7481975986211, -122.495129524484)
117667 117667 186416 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1601 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984766.0664 2104199.8169 37.7568505482742 -122.495711596199 (37.7568505482742, -122.495711596199)
150297 150297 186095 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1901 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     57 Width 0ft   5984840.151000001 2101765.7139 37.7501715111334 -122.495275887194 (37.7501715111334, -122.495275887194)

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