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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18304 | 18304 | 122653 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18306 | 18306 | 122645 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18307 | 18307 | 122655 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18312 | 18312 | 122646 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18314 | 18314 | 122661 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18321 | 18321 | 122657 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18419 | 18419 | 852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008391.48003 | 2095227.15251 | 37.7335688330362 | -122.413371331432 | (37.7335688330362, -122.413371331432) | ||
| 18469 | 18469 | 28373 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1008X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/14/2003 12:00:00 AM | 3 | 3X3 | 6004368.57651 | 2102993.46907 | 37.7546666629566 | -122.42783286161001 | (37.7546666629566, -122.42783286161) | ||
| 18574 | 18574 | 2384 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2603 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6009796.778530001 | 2102081.51983 | 37.752468233345496 | -122.408996251977 | (37.7524682333455, -122.408996251977) | ||
| 18687 | 18687 | 49144 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.714977603179705 | -122.45935873857901 | (37.7149776031797, -122.459358738579) | |||
| 18757 | 18757 | 25477 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009744.3885699995 | 2103075.41158 | 37.7551943032962 | -122.40924755584999 | (37.7551943032962, -122.40924755585) | ||
| 18833 | 18833 | 2391 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2647 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009810.4696 | 2101915.90023 | 37.7520142456811 | -122.40893722139799 | (37.7520142456811, -122.408937221398) | ||
| 19003 | 19003 | 658 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3266 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007255.021480001 | 2102083.69856 | 37.7523315048963 | -122.417786249056 | (37.7523315048963, -122.417786249056) | ||
| 19852 | 19852 | 2400 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2705 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 7 | 3X3 | 6009830.21758 | 2101529.52797 | 37.750954459389895 | -122.40884167290301 | (37.7509544593899, -122.408841672903) | ||
| 19947 | 19947 | 28120 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006506.93128 | 2099856.40454 | 37.746173735321705 | -122.42021520818199 | (37.7461737353217, -122.420215208182) | ||
| 20022 | 20022 | 28121 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 3 | 3X3 | 6006509.11519 | 2099833.54238 | 37.7461110840596 | -122.42020603418699 | (37.7461110840596, -122.420206034187) | ||
| 20255 | 20255 | 854 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008336.69687 | 2095197.2977599998 | 37.7334837823442 | -122.41355862243499 | (37.7334837823442, -122.413558622435) | ||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 20757 | 20757 | 28118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006504.064130001 | 2099904.7396 | 37.7463062909014 | -122.42022855233101 | (37.7463062909014, -122.420228552331) | ||
| 20896 | 20896 | 523 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2813 24th St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777511 | 6009929.7366 | 2102188.669 | 37.752769888235704 | -122.408544016423 | (37.7527698882357, -122.408544016423) | |
| 21229 | 21229 | 2361 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009745.3225 | 2103030.00614 | 37.7550696824471 | -122.409241122079 | (37.7550696824471, -122.409241122079) | ||
| 21317 | 21317 | 862 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008011.36344 | 2095005.6880599998 | 37.732939390338004 | -122.414669840947 | (37.732939390338, -122.414669840947) | |||
| 21413 | 21413 | 860 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2003 12:00:00 AM | 9 | 3x3 | 6008061.902000001 | 2095033.6674400002 | 37.7330190549875 | -122.41449709467501 | (37.7330190549875, -122.414497094675) | ||
| 21457 | 21457 | 28119 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006505.97749 | 2099880.4421900003 | 37.7462396835255 | -122.42022021199301 | (37.7462396835255, -122.420220211993) | ||
| 21659 | 21659 | 853 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 370 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008364.22406 | 2095210.3079400002 | 37.7335210511394 | -122.4134643726 | (37.7335210511394, -122.4134643726) | ||
| 21770 | 21770 | 2424 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2843 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1994 12:00:00 AM | 3 | 3X3 | 6009873.38674 | 2100822.7763099996 | 37.7490162935621 | -122.408642536922 | (37.7490162935621, -122.408642536922) | ||
| 21890 | 21890 | 4154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3718 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 6 | 3X3 | 6005698.2411400005 | 2100539.02617 | 37.748002458148 | -122.423060071381 | (37.748002458148, -122.423060071381) | ||
| 21927 | 21927 | 861 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.41458540809799 | (37.7329747750588, -122.414585408098) | ||
| 21941 | 21941 | 28285 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1010 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2003 12:00:00 AM | 3 | 3x3 | 6004371.7708 | 2102969.95862 | 37.7546022894831 | -122.427820139789 | (37.7546022894831, -122.427820139789) | ||
| 22140 | 22140 | 2381 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2599X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2016 12:00:00 AM | 6 | 3X3 | 6009783.37246 | 2102329.05064 | 37.753147146843794 | -122.409060076881 | (37.7531471468438, -122.409060076881) | ||
| 22267 | 22267 | 2366 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.754276171914704 | -122.40935049224501 | (37.7542761719147, -122.409350492245) | |||
| 23108 | 23108 | 2426 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6009874.246230001 | 2100776.83629 | 37.748890200541 | -122.408636324408 | (37.748890200541, -122.408636324408) | |||
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 23350 | 23350 | 14857 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 3x3 | 6002635.4903 | 2111607.9304 | 37.7782216761893 | -122.43444221569099 | (37.7782216761893, -122.434442215691) | ||
| 24181 | 24181 | 125409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005915.1308699995 | 2112115.06535 | 37.7797997643918 | -122.42313277978 | (37.7797997643918, -122.42313277978) | |||
| 24244 | 24244 | 187915 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | |||
| 24424 | 24424 | 84888 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) | |||
| 25058 | 25058 | 141590 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.776541006446706 | -122.438124278141 | (37.7765410064467, -122.438124278141) | |||
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 26254 | 26254 | 116994 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 600M Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6001630.0135 | 2110553.7073 | 37.775269918649705 | -122.43784499428999 | (37.7752699186497, -122.43784499429) | ||||
| 26724 | 26724 | 220414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009485.691930001 | 2106956.65454 | 37.76583681834921 | -122.410416250032 | (37.7658368183492, -122.410416250032) | |||
| 27237 | 27237 | 141321 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | |||
| 27763 | 27763 | 187876 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015130.16483 | 2100787.65085 | 37.749212862006296 | -122.39046195666701 | (37.7492128620063, -122.390461956667) | |||
| 28198 | 28198 | 220487 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.44063269105499 | (37.7503157923525, -122.440632691055) | |||
| 28247 | 28247 | 187919 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | |||
| 28374 | 28374 | 175143 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009125.76929 | 2093634.7983 | 37.729237769091505 | -122.41072025595 | (37.7292377690915, -122.41072025595) | |||
| 28822 | 28822 | 220469 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009645.3794 | 2103705.18616 | 37.756917975403205 | -122.40963440819701 | (37.7569179754032, -122.409634408197) | |||
| 29247 | 29247 | 125411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005845.66481 | 2112104.7354 | 37.7797674805156 | -122.423372359172 | (37.7797674805156, -122.423372359172) | |||
| 29539 | 29539 | 38792 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2001 12:00:00 AM | 3 | Permit Number 43810 | 6012704.44378 | 2111400.47389 | 37.778218455863296 | -122.399595224034 | (37.7782184558633, -122.399595224034) | |
| 29587 | 29587 | 139865 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 752 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005530.836 | 2112064.5728 | 37.7796394301742 | -122.42445863354601 | (37.7796394301742, -122.424458633546) | |||
| 29636 | 29636 | 189067 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013772.20207 | 2112425.8554700003 | 37.781093380699296 | -122.395973304322 | (37.7810933806993, -122.395973304322) | |||
| 29792 | 29792 | 112595 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.781176707308504 | -122.43904854399099 | (37.7811767073085, -122.439048543991) | |||
| 30082 | 30082 | 141368 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001677.0206 | 2110226.585 | 37.774374395633394 | -122.43765895363701 | (37.7743743956334, -122.437658953637) | |||
| 30101 | 30101 | 189093 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016095.6448 | 2097530.53643 | 37.74032300780279 | -122.38689615645399 | (37.7403230078028, -122.386896156454) | |||
| 30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
| 30804 | 30804 | 141336 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001660.0118 | 2110350.0832 | 37.7747125236659 | -122.437726636856 | (37.7747125236659, -122.437726636856) | |||
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 31078 | 31078 | 141345 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001662.4769 | 2110310.1497 | 37.7746030164406 | -122.437715248986 | (37.7746030164406, -122.437715248986) | |||
| 31263 | 31263 | 137681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001487.0408 | 2111552.8208 | 37.7780051017696 | -122.438411165508 | (37.7780051017696, -122.438411165508) | |||
| 31410 | 31410 | 203402 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | |||
| 31777 | 31777 | 247369 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.773380649478504 | -122.437460131244 | (37.7733806494785, -122.437460131244) | |||
| 31984 | 31984 | 137765 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | |||
| 32027 | 32027 | 187962 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | |||
| 32037 | 32037 | 187942 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015080.74918 | 2115307.92538 | 37.789079602378294 | -122.391647913344 | (37.7890796023783, -122.391647913344) | ||||
| 32188 | 32188 | 141618 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001576.0331 | 2110923.0014 | 37.77628083782329 | -122.438058183449 | (37.7762808378233, -122.438058183449) | |||
| 32405 | 32405 | 203412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | |||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 32664 | 32664 | 247514 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.43733941693701 | (37.7729707390414, -122.437339416937) | |||
| 32741 | 32741 | 220423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009450.02537 | 2107605.87811 | 37.7676174373262 | -122.41058546376699 | (37.7676174373262, -122.410585463767) | |||
| 33159 | 33159 | 220430 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009429.13636 | 2107984.68576 | 37.7686563845084 | -122.410684471035 | (37.7686563845084, -122.410684471035) | |||
| 33720 | 33720 | 42228 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 66 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42484 | 6014289.84402 | 2114150.2532200003 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | |
| 33887 | 33887 | 187873 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | |||
| 33913 | 33913 | 96284 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | |
| 34143 | 34143 | 88173 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011687.76515 | 2112550.16033 | 37.781318504386604 | -122.40319320113001 | (37.7813185043866, -122.40319320113) | |
| 34402 | 34402 | 203409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993779.2225 | 2102246.7483099997 | 37.7520116286371 | -122.46439920245399 | (37.7520116286371, -122.464399202454) | |||
| 34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
| 34534 | 34534 | 220499 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.23781 | 2108216.38247 | 37.768937280547796 | -122.432495314901 | (37.7689372805478, -122.432495314901) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 35323 | 35323 | 187923 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013066.988580001 | 2115014.97781 | 37.7881632507911 | -122.398594748068 | (37.7881632507911, -122.398594748068) | |||
| 35436 | 35436 | 220439 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009873.7476699995 | 2100752.39413 | 37.7488230598385 | -122.408636324412 | (37.7488230598385, -122.408636324412) | |||
| 35502 | 35502 | 203417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993769.4905900005 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | |||
| 35513 | 35513 | 220479 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.53272 | 2097501.66791 | 37.7398382390396 | -122.41204865353501 | (37.7398382390396, -122.412048653535) | |||
| 35576 | 35576 | 175135 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 144 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000350.62933 | 2092307.6786599997 | 37.7250978911274 | -122.440961425642 | (37.7250978911274, -122.440961425642) | |||
| 36136 | 36136 | 125413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005987.46942 | 2112075.6403900003 | 37.7796955950146 | -122.42287972583999 | (37.7796955950146, -122.42287972584) | |||
| 36568 | 36568 | 125406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.794476515841495 | -122.43825574691799 | (37.7944765158415, -122.438255746918) | |||
| 36889 | 36889 | 220442 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009796.152509999 | 2102134.77376 | 37.752614421718505 | -122.40900217402799 | (37.7526144217185, -122.409002174028) | |||
| 37536 | 37536 | 220503 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 203 States St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001063.95053 | 2106312.4258 | 37.7635922112288 | -122.43949902816799 | (37.7635922112288, -122.439499028168) | |||
| 37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
| 38131 | 38131 | 140748 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001272.3122 | 2113103.8079 | 37.782251502236704 | -122.439265184087 | (37.7822515022367, -122.439265184087) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 38184 | 38184 | 187958 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 43 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014361.38404 | 2114182.65198 | 37.7859499041048 | -122.394058036143 | (37.7859499041048, -122.394058036143) | |||
| 38232 | 38232 | 175141 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009144.52669 | 2093573.47642 | 37.7290704439367 | -122.410651080984 | (37.7290704439367, -122.410651080984) | |||
| 38296 | 38296 | 220467 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.05061 | 2104932.28838 | 37.7602814740251 | -122.41008184609699 | (37.7602814740251, -122.410081846097) | |||
| 38415 | 38415 | 187922 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013074.697930001 | 2115022.06537 | 37.7881831410762 | -122.398568572402 | (37.7881831410762, -122.398568572402) | |||
| 38969 | 38969 | 203414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993945.5640199995 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | |||
| 39100 | 39100 | 189065 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013721.13353 | 2112372.28155 | 37.78094343761921 | -122.396146221471 | (37.7809434376192, -122.396146221471) | |||
| 39146 | 39146 | 199868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016299.0692 | 2093761.868 | 37.729986262675396 | -122.385930158914 | (37.7299862626754, -122.385930158914) | |||
| 39249 | 39249 | 175137 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) |
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");