Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 186596 | 186596 | 2255 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 5990660.02895 | 2088282.4204099998 | 37.713488829713796 | -122.474166893001 | (37.7134888297138, -122.474166893001) | ||||
| 185443 | 185443 | 142131 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200x GEARY BLVD | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6000333.6993 | 2113366.7616 | 37.7829200486713 | -122.442531241518 | (37.7829200486713, -122.442531241518) | |||
| 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) | |||
| 184580 | 184580 | 206812 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993679.09704 | 2097560.53952 | 37.739138713068 | -122.464405236026 | (37.739138713068, -122.464405236026) | ||||
| 183462 | 183462 | 206813 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 198x San Anselmo Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993675.924 | 2096312.14772 | 37.7357107573442 | -122.464325594759 | (37.7357107573442, -122.464325594759) | ||||
| 182720 | 182720 | 247577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 300x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.41230921050501 | (37.7338860994661, -122.412309210505) | ||||
| 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) | |||
| 180749 | 180749 | 206822 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994175.83574 | 2101201.51334 | 37.7491645333344 | -122.462951839858 | (37.7491645333344, -122.462951839858) | |||
| 176150 | 176150 | 138268 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | Width 0ft | 5998223.1317 | 2113127.3282 | 37.782142096338795 | -122.449815635357 | (37.7821420963388, -122.449815635357) | |||
| 176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
| 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) | |||
| 171283 | 171283 | 206818 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5993615.2443699995 | 2100968.4802 | 37.748492377339204 | -122.46487343566601 | (37.7484923773392, -122.464873435666) | ||||
| 168306 | 168306 | 206810 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993662.74276 | 2097416.4076799997 | 37.7387420203269 | -122.464451319071 | (37.7387420203269, -122.464451319071) | ||||
| 167137 | 167137 | 206811 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5993507.09013 | 2097468.08947 | 37.738874951811795 | -122.464993240656 | (37.7388749518118, -122.464993240656) | ||||
| 164549 | 164549 | 206889 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1646x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5991480.90681 | 2104023.08965 | 37.7567562467267 | -122.472476526376 | (37.7567562467267, -122.472476526376) | |||
| 164069 | 164069 | 206833 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | Width 8ft | 5994013.170390001 | 2101597.32245 | 37.7502419535254 | -122.463543055991 | (37.7502419535254, -122.463543055991) | |||
| 163128 | 163128 | 247031 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6002334.8025400005 | 2099162.94393 | 37.744033686108395 | -122.43459231090901 | (37.7440336861084, -122.434592310909) | ||||
| 161065 | 161065 | 190992 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016132.65203 | 2096182.1348700002 | 37.7366226195253 | -122.38667419475901 | (37.7366226195253, -122.386674194759) | ||||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 158524 | 158524 | 247030 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6002345.78749 | 2099158.24701 | 37.7440214130592 | -122.4345539917 | (37.7440214130592, -122.4345539917) | ||||
| 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) | ||||
| 157500 | 157500 | 247032 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6002315.33428 | 2099157.14727 | 37.744016664631296 | -122.43465921327 | (37.7440166646313, -122.43465921327) | ||||
| 154424 | 154424 | 206823 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5994172.44276 | 2101206.5296099996 | 37.7491781113008 | -122.46296393663401 | (37.7491781113008, -122.462963936634) | |||
| 153334 | 153334 | 206825 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 5994178.17156 | 2101219.86742 | 37.749215063525895 | -122.462945094061 | (37.7492150635259, -122.462945094061) | |||
| 149883 | 149883 | 2256 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 5990689.72825 | 2088261.00769 | 37.7134317560555 | -122.47406268136801 | (37.7134317560555, -122.474062681368) | ||||
| 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) | |||
| 148418 | 148418 | 206840 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 500x Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5991435.20173 | 2094099.7014 | 37.72950652428771 | -122.47191136721399 | (37.7295065242877, -122.471911367214) | |||
| 146309 | 146309 | 20535 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 146161 | 146161 | 109674 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 145791 | 145791 | 20851 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1892X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 145583 | 145583 | 109651 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 145464 | 145464 | 21109 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
| 144906 | 144906 | 105837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100X SLOAT BLVD | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 144791 | 144791 | 21185 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
| 144625 | 144625 | 13284 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.810330001 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | ||
| 144484 | 144484 | 21412 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2692X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 144280 | 144280 | 21165 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
| 144001 | 144001 | 20991 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 143253 | 143253 | 21006 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 142932 | 142932 | 21174 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985027.9083074005 | 2099542.6271361 | 37.744078511576 | -122.49446276258301 | (37.744078511576, -122.494462762583) | |||
| 142783 | 142783 | 20830 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 142681 | 142681 | 20990 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 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) | |||
| 142503 | 142503 | 20824 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 142353 | 142353 | 21337 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2592X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 142101 | 142101 | 21456 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | ||
| 142047 | 142047 | 109652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X BROTHERHOOD WAY | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.47553203031799 | (37.7142908027957, -122.475532030318) | |||||
| 142008 | 142008 | 20523 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 141866 | 141866 | 21378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 141517 | 141517 | 109677 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 141425 | 141425 | 21022 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 141418 | 141418 | 20916 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 141352 | 141352 | 109893 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1408x SUNSET BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 3x3 | 5984818.0 | 2105324.0 | 37.7599402834086 | -122.49561490918 | (37.7599402834086, -122.49561490918) | |||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 141045 | 141045 | 20825 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 140619 | 140619 | 95331 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 390X Filbert St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 140604 | 140604 | 21009 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 140566 | 140566 | 21049 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 140534 | 140534 | 21007 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2003X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5984964.2584556 | 2101570.8346889 | 37.7496436917689 | -122.49483235574101 | (37.7496436917689, -122.494832355741) | |||
| 140501 | 140501 | 20724 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
| 140332 | 140332 | 20627 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
| 140041 | 140041 | 21483 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2792X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 139430 | 139430 | 20831 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 139360 | 139360 | 21386 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 139297 | 139297 | 20530 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 139158 | 139158 | 20783 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816002 | (37.7552952964732, -122.49524762816) | |||
| 139134 | 139134 | 20893 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
| 138613 | 138613 | 20835 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 138329 | 138329 | 115329 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
| 138314 | 138314 | 21461 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 138302 | 138302 | 113064 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
| 138140 | 138140 | 206890 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651x 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 3ft | 5991488.45245 | 2104026.5026700003 | 37.756766054720295 | -122.47245067984801 | (37.7567660547203, -122.472450679848) | |||
| 135958 | 135958 | 206827 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5994178.983990001 | 2101248.80101 | 37.7492945546186 | -122.462944383584 | (37.7492945546186, -122.462944383584) | |||
| 135721 | 135721 | 190993 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x Cashmere St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016127.05832 | 2096176.4700900002 | 37.7366067554984 | -122.386693139892 | (37.7366067554984, -122.386693139892) | ||||
| 133767 | 133767 | 206824 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 8ft | 5994175.40211 | 2101215.70395 | 37.7492034721717 | -122.462954368764 | (37.7492034721717, -122.462954368764) | |||
| 132074 | 132074 | 206817 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5993586.72405 | 2100922.72435 | 37.7483650989873 | -122.464968735031 | (37.7483650989873, -122.464968735031) | ||||
| 130519 | 130519 | 142132 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6000134.3689 | 2113338.3342 | 37.7828306302801 | -122.443218797439 | (37.7828306302801, -122.443218797439) | |||
| 129499 | 129499 | 138267 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5998264.7576 | 2113134.0967 | 37.782163062403704 | -122.44967211707899 | (37.7821630624037, -122.449672117079) | |||
| 129401 | 129401 | 20638 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1492X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984803.7392562 | 2105036.6950477003 | 37.759150589029495 | -122.495643037613 | (37.7591505890295, -122.495643037613) | |||
| 129301 | 129301 | 20746 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1692X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
| 129063 | 129063 | 21469 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 128934 | 128934 | 20841 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | |||
| 128803 | 128803 | 112187 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 301x CORBETT AVE | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 128781 | 128781 | 21410 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2692X SUNSET BLVD | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5985045.0 | 2096882.0 | 37.736774145777 | -122.494207597342 | (37.736774145777, -122.494207597342) | |||
| 128730 | 128730 | 21222 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2392X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984971.116957701 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | |||
| 128605 | 128605 | 90814 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3101X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985939.530040001 | 2110416.22532 | 37.773987719434096 | -122.492111077157 | (37.7739877194341, -122.492111077157) | ||
| 128547 | 128547 | 21085 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2192X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 128207 | 128207 | 21382 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 127927 | 127927 | 5011 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5300 Diamond Heights Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 127885 | 127885 | 20927 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1992X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 127741 | 127741 | 20875 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1892X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 127701 | 127701 | 21512 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985158.491992299 | 2096224.0649069 | 37.7349742721437 | -122.49376674256901 | (37.7349742721437, -122.493766742569) | |||
| 127544 | 127544 | 20911 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984934.4009631 | 2102260.4913733 | 37.75153555211671 | -122.494986448304 | (37.7515355521167, -122.494986448304) | |||
| 127519 | 127519 | 20547 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 127498 | 127498 | 11191 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 148 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 5995624.0655798 | 2099382.6906533 | 37.7442538125131 | -122.457812277707 | (37.7442538125131, -122.457812277707) | |||
| 127490 | 127490 | 20723 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
| 126145 | 126145 | 21153 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2292X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | CENTER8 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) |
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");