Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35718 | 35718 | 223696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230911999 | (37.7376608688401, -122.42482230912) | ||||
58052 | 58052 | 223695 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005104.91543 | 2096758.07935 | 37.73758733938811 | -122.42484281995701 | (37.7375873393881, -122.424842819957) | ||||
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) | ||||
146111 | 146111 | 223697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6005304.12461 | 2097202.65687 | 37.738819299062904 | -122.424185667341 | (37.7388192990629, -122.424185667341) | ||||
549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
10255 | 10255 | 112606 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5999003.0 | 2105766.0 | 37.761974353511896 | -122.446587863076 | (37.7619743535119, -122.446587863076) | ||||
9172 | 9172 | 173599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995367.0 | 2102770.0 | 37.7535397418859 | -122.458946354326 | (37.7535397418859, -122.458946354326) | |||
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) | |||
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) | |||
83377 | 83377 | 87064 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2007 12:00:00 AM | Permit Number 50006 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |||
84753 | 84753 | 108074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 BUENA VISTA AVE EAST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
2151 | 2151 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001472.0 | 2098865.0 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | ||||
145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
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) | ||||
102194 | 102194 | 101037 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1010X Portola Dr | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
6006 | 6006 | 20312 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
7548 | 7548 | 20317 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 101X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
64824 | 64824 | 205899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 106 Miraloma Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994504.976530001 | 2097169.62353 | 37.7381129265739 | -122.461521406103 | (37.7381129265739, -122.461521406103) | |||
186232 | 186232 | 205900 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 106 Miraloma Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5994506.11445 | 2097146.60332 | 37.7380497842769 | -122.461515803309 | (37.7380497842769, -122.461515803309) | |||
155412 | 155412 | 223726 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 107 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 7ft | 6007259.15325 | 2098682.1985299997 | 37.742991985195104 | -122.41753090725 | (37.7429919851951, -122.41753090725) | |||
66371 | 66371 | 223725 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 109 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 10ft | 6007250.83201 | 2098665.28415 | 37.742945073859794 | -122.417558481357 | (37.7429450738598, -122.417558481357) | |||
32031 | 32031 | 190995 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 10x Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6017237.22965 | 2095860.87095 | 37.7358015834667 | -122.38283280631599 | (37.7358015834667, -122.382832806316) | ||||
76030 | 76030 | 206838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 11 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | 5994833.8129199995 | 2099043.81007 | 37.7432778994565 | -122.460520231332 | (37.7432778994565, -122.460520231332) | ||||
185755 | 185755 | 205895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995734.854669999 | 2096206.24435 | 37.7355384364582 | -122.457199459482 | (37.7355384364582, -122.457199459482) | |||
142607 | 142607 | 11185 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995900.4612004 | 2099322.604417 | 37.744104705607704 | -122.45685222203001 | (37.7441047056077, -122.45685222203) | |||
165726 | 165726 | 205902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994974.56869 | 2098324.33345 | 37.741310492185605 | -122.45998142862699 | (37.7413104921856, -122.459981428627) | |||
180949 | 180949 | 205903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994961.52752 | 2098342.73028 | 37.7413602552605 | -122.460027852509 | (37.7413602552605, -122.460027852509) | |||
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) | ||||
33033 | 33033 | 223700 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.42593738210199 | (37.7372797190785, -122.425937382102) | ||||
49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
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) | ||||
152844 | 152844 | 223706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004536.52923 | 2096375.8684900003 | 37.736505754442504 | -122.42678079059999 | (37.7365057544425, -122.4267807906) | ||||
159461 | 159461 | 223702 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004596.80195 | 2096429.4382 | 37.7366562523786 | -122.426576215516 | (37.7366562523786, -122.426576215516) | ||||
176054 | 176054 | 223701 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 6004786.9856 | 2096684.12369 | 37.7373663112035 | -122.425936792158 | (37.7373663112035, -122.425936792158) | |||
181738 | 181738 | 223705 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004537.44257 | 2096386.8120900001 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | ||||
34710 | 34710 | 223715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004750.57812 | 2096360.89303 | 37.736476735096296 | -122.426039666491 | (37.7364767350963, -122.426039666491) | ||||
47893 | 47893 | 223716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.42600151366399 | (37.7365030690611, -122.426001513664) | ||||
137779 | 137779 | 223717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6005027.45143 | 2096662.24212 | 37.737319816266705 | -122.425103832873 | (37.7373198162667, -122.425103832873) | ||||
166767 | 166767 | 223718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005036.8773300005 | 2096676.581 | 37.7373597200698 | -122.42507226308999 | (37.7373597200698, -122.42507226309) | ||||
41442 | 41442 | 205894 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5998252.60091 | 2095669.89095 | 37.7342100154709 | -122.44845607881099 | (37.7342100154709, -122.448456078811) | |||
175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) | |||
139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
64573 | 64573 | 206839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 112 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5998729.31623 | 2093223.3736599998 | 37.7275196997604 | -122.446631964111 | (37.7275196997604, -122.446631964111) | ||||
22926 | 22926 | 251147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 113x Gladeview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997915.0 | 2102038.0 | 37.7516759885035 | -122.450082102397 | (37.7516759885035, -122.450082102397) | ||||
122672 | 122672 | 102060 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 115 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994908.3 | 2098325.8 | 37.741310707397396 | -122.460210667073 | (37.7413107073974, -122.460210667073) | |||||
7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
155152 | 155152 | 190988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 119 Lindsay Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 5ft | 6016552.3921 | 2095641.6616099998 | 37.7351618174613 | -122.385185311358 | (37.7351618174613, -122.385185311358) | |||
24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
158032 | 158032 | 206808 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5991782.03455 | 2095997.5477200001 | 37.734737597362205 | -122.470850534124 | (37.7347375973622, -122.470850534124) | ||||
53725 | 53725 | 223707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004449.31264 | 2096325.41802 | 37.7363622972844 | -122.42707874320699 | (37.7363622972844, -122.427078743207) | ||||
36628 | 36628 | 186839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 83 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984830.1212 | 2106502.1656 | 37.7631759062792 | -122.49565989156099 | (37.7631759062792, -122.495659891561) | |||
40531 | 40531 | 186763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5984864.2659 | 2106722.4222 | 37.7637826685387 | -122.49555804452801 | (37.7637826685387, -122.495558044528) | |||
172361 | 172361 | 186738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984873.2407 | 2106599.9288 | 37.7634468615844 | -122.495517968799 | (37.7634468615844, -122.495517968799) | |||
188957 | 188957 | 186755 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984869.1172 | 2106699.1363 | 37.763719016073104 | -122.495539548031 | (37.7637190160731, -122.495539548031) | |||
9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9666 | 9666 | 114127 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9669 | 9669 | 114126 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9671 | 9671 | 114132 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
77993 | 77993 | 12500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
90329 | 90329 | 12501 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
91431 | 91431 | 12502 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | |||
10904 | 10904 | 19431 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.48490645815501 | (37.7343051218756, -122.484906458155) | ||
173128 | 173128 | 185117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sloat Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5987506.2336 | 2095918.1597 | 37.7342714110431 | -122.485627430105 | (37.7342714110431, -122.485627430105) | |||
181042 | 181042 | 186841 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sunset Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 5984746.1314 | 2106971.8455 | 37.764460596444295 | -122.495985031222 | (37.7644605964443, -122.495985031222) | |||
30126 | 30126 | 223714 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 82 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6004606.42672 | 2096213.68372 | 37.736064383369396 | -122.42652758019699 | (37.7360643833694, -122.426527580197) | ||||
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) | ||||
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) | ||||
77269 | 77269 | 223713 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6004590.4575 | 2096203.6023099998 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | ||||
131336 | 131336 | 223709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004249.02504 | 2095933.99045 | 37.7352761977326 | -122.42774334037901 | (37.7352761977326, -122.427743340379) | ||||
153445 | 153445 | 223711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004453.96026 | 2096061.62765 | 37.7356382512944 | -122.42704389176201 | (37.7356382512944, -122.427043891762) | ||||
39649 | 39649 | 184824 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984678.6788 | 2106921.0739 | 37.7643172410191 | -122.496214581481 | (37.7643172410191, -122.496214581481) | |||
72988 | 72988 | 184885 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984635.3908 | 2106778.1095 | 37.763922165271104 | -122.496353750703 | (37.7639221652711, -122.496353750703) | |||
132952 | 132952 | 184826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5984631.5936 | 2106918.0361 | 37.7643061418827 | -122.49637720932199 | (37.7643061418827, -122.496377209322) | |||
164533 | 164533 | 184823 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984679.4382 | 2106925.6305 | 37.7643297966428 | -122.496212291183 | (37.7643297966428, -122.496212291183) | |||
165920 | 165920 | 184816 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984628.5558 | 2106956.7675 | 37.7644123094409 | -122.49639057415199 | (37.7644123094409, -122.496390574152) | |||
81048 | 81048 | 20479 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
82157 | 82157 | 20474 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
91646 | 91646 | 20468 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
93970 | 93970 | 20470 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
24419 | 24419 | 20488 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
101420 | 101420 | 20496 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
141644 | 141644 | 20495 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1204 Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
133209 | 133209 | 183349 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1210 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5981200.6659 | 2106791.7999 | 37.763757948803 | -122.508234239743 | (37.763757948803, -122.508234239743) | |||
185035 | 185035 | 183344 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1210 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5981199.4113 | 2106812.2909 | 37.763814137238896 | -122.50824009998999 | (37.7638141372389, -122.50824009999) | |||
43485 | 43485 | 20515 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1211X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
92266 | 92266 | 20513 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1211X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
93789 | 93789 | 20514 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1211X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
148452 | 148452 | 247988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 124 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | Width 10ft | 6009878.9446 | 2099816.70211 | 37.746254146420796 | -122.40855235741199 | (37.7462541464208, -122.408552357412) | |||
185428 | 185428 | 205905 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 125 Hamerton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 4ft | 6001385.86644 | 2095459.79202 | 37.7338117803923 | -122.437608363645 | (37.7338117803923, -122.437608363645) | |||
75050 | 75050 | 184344 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1251 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984661.1293 | 2106390.2273 | 37.7628586575157 | -122.496236109768 | (37.7628586575157, -122.496236109768) | |||
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) |
JSON shape: default, array, newline-delimited
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");