trees
27,746 rows where qCaretaker_id = 1 sorted by qSpecies_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9180 | 26891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1593X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1999 12:00:00 AM | 6 | 3X3 | 6015736.99422 | 2097371.34935 | 37.7398660478734 | -122.388125132194 | (37.7398660478734, -122.388125132194) | 10 | 3 | 8 | 58 | 1 | ||
9244 | 26780 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1752 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004614.5411634 | 2098679.9368788 | 37.7428366133046 | -122.426675095663 | (37.7428366133046, -122.426675095663) | 2 | 7 | 5 | 63 | 22 | |||
9281 | 89492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4400 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984994.02618 | 2111806.48395 | 37.7777496555849 | -122.49548424387 | (37.7777496555849, -122.49548424387) | 11 | 6 | 2 | 55 | 26 | ||
9522 | 90194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1908 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989627.83997 | 2111294.57572 | 37.7766143400047 | -122.47941700634 | (37.7766143400047, -122.47941700634) | 11 | 6 | 2 | 55 | 26 | ||
9659 | 6018 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1768 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 3 | 4X4 | 6001988.67291 | 2112609.68299 | 37.7809354990687 | -122.43675151758 | (37.7809354990687, -122.43675151758) | 15 | 5 | 11 | 29490 | 41 | ||
10316 | 142205 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | DPW for City Agency | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.444030632037 | (37.774143230926, -122.444030632037) | 15 | 5 | 11 | 29492 | 16 | |
10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
10594 | 93463 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1739 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 01:05:00 PM | 3 | 3x3 | 5987772.1588 | 2098929.0107 | 37.7425539090053 | -122.484928867121 | (37.7425539090053, -122.484928867121) | 1 | 8 | 3 | 29491 | 35 | ||
10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
10928 | 180374 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4285 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2016 01:59:00 PM | 7 | Width 3ft | 6003261.88043 | 2093636.25678 | 37.7289112513313 | -122.430992322031 | (37.7289112513313, -122.430992322031) | 9 | 7 | 6 | 28861 | 5 | ||
10961 | 90312 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2251X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988536.8932 | 2111197.08848 | 37.7762832409434 | -122.483183715962 | (37.7762832409434, -122.483183715962) | 11 | 6 | 2 | 55 | 26 | ||
11066 | 96252 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.74069 | 37.7237927195289 | -122.455113909949 | (37.7237927195289, -122.455113909949) | 9 | 7 | 4 | 28861 | 40 | |||
11149 | 26450 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 402 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/07/1997 12:00:00 AM | 3 | 3X3 | 5994319.8227 | 2111463.09621 | 37.7773484614969 | -122.463198425137 | (37.7773484614969, -122.463198425137) | 11 | 6 | 2 | 54 | 11 | ||
11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
11563 | 259753 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1229 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013525 | 2101361 | 37.7506979810533 | -122.396052856578 | (37.7506979810533, -122.396052856578) | 10 | 3 | 8 | 28856 | 1 | ||||
11571 | 258104 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Circular Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5x3 | 6001282.24432 | 2094484.29682 | 37.7311274034584 | -122.437896768674 | (37.7311274034584, -122.437896768674) | 9 | 7 | 4 | 63 | 40 | ||||
11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
11708 | 86525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1427 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987718.830744 | 2105574.527974 | 37.7607976071546 | -122.4856008555 | (37.7607976071546, -122.4856008555) | 1 | 8 | 3 | 56 | 35 | ||
11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
12001 | 19526 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 139X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6000543 | 2112633 | 37.7809172556433 | -122.441754472162 | (37.7809172556433, -122.441754472162) | 15 | 5 | 1 | 29490 | 16 | |||
12011 | 122860 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:54:00 PM | 3 | 3x3 | 5996471.0085 | 2087171.23277 | 37.7107726837747 | -122.454001999105 | (37.7107726837747, -122.454001999105) | 9 | 7 | 6 | 28861 | 25 | ||
12014 | 26328 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1857 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000421.70721 | 2093270.90592 | 37.7277467399142 | -122.440784780799 | (37.7277467399142, -122.440784780799) | 9 | 7 | 6 | 28861 | 25 | |||
12342 | 25 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 736 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/1995 12:00:00 AM | 0 | 6003903.5250844 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | 7 | 9 | 5 | 28862 | 3 | |||
12352 | 89489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4300 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985343.483835 | 2111809.619888 | 37.7777787222019 | -122.494275598426 | (37.7777787222019, -122.494275598426) | 11 | 6 | 2 | 55 | 26 | |
12353 | 832 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1396 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 12:18:00 PM | 3 | 3X3 | 5981551.7086 | 2105613.8347 | 37.7605442750604 | -122.506932728621 | (37.7605442750604, -122.506932728621) | 1 | 8 | 3 | 56 | 35 | ||
12385 | 122862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:57:00 PM | 3 | 3x3 | 5996396.11182 | 2087134.53614 | 37.7106676285689 | -122.454258208753 | (37.7106676285689, -122.454258208753) | 9 | 7 | 6 | 28861 | 25 | ||
12678 | 122858 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:48:00 PM | 3 | 3x3 | 5996534.89567 | 2087209.02318 | 37.7108801104978 | -122.453783918887 | (37.7108801104978, -122.453783918887) | 9 | 7 | 6 | 28861 | 25 | ||
12715 | 258164 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008206.68769 | 2093529.18425 | 37.7288962013592 | -122.413890143037 | (37.7288962013592, -122.413890143037) | 9 | 3 | 7 | 309 | 28 | ||
12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
12852 | 122855 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:30:00 PM | 3 | 3x3 | 5996643.89456 | 2087275.27333 | 37.7110682666487 | -122.453411975491 | (37.7110682666487, -122.453411975491) | 9 | 7 | 6 | 28861 | 25 | ||
13025 | 258109 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 737 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x5 | 6009616.36663 | 2091549.37053 | 37.7235391182911 | -122.408877136022 | (37.7235391182911, -122.408877136022) | 9 | 3 | 7 | 309 | 28 | ||||
13084 | 98064 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5235 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | ||
13129 | 26381 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2613 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 3 | 3X3 | 5997700.4675682 | 2089269.1279115 | 37.7166034405512 | -122.449903824315 | (37.7166034405512, -122.449903824315) | 9 | 8 | 6 | 28861 | 24 | ||
13273 | 4537 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/1994 12:00:00 AM | 12 | 3X3 | 6004884.4780546 | 2113657.3543136 | 37.7839762927328 | -122.426808129214 | (37.7839762927328, -122.426808129214) | 7 | 9 | 11 | 28858 | 41 | ||
13447 | 6878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/28/1994 12:00:00 AM | 6 | 3X3 | 6006200.5661 | 2110766.80377 | 37.7761138687045 | -122.422049524766 | (37.7761138687045, -122.422049524766) | 7 | 9 | 11 | 28852 | 10 | ||
13842 | 180297 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500x Alemany Blvd | 12 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001879.66047 | 2093045.23881 | 37.7272100325946 | -122.435728480197 | (37.7272100325946, -122.435728480197) | 9 | 7 | 6 | 28861 | 25 | |||
13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
14058 | 260595 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3116x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | 6013747 | 2090444 | 37.7207345013838 | -122.394520802284 | (37.7207345013838, -122.394520802284) | 10 | 3 | 8 | 58 | 1 | ||
14072 | 10189 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1153 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2017 12:00:00 AM | 3 | 6x3 | 6005799.04863 | 2102230.07657 | 37.7526513820654 | -122.42283164627 | (37.7526513820654, -122.42283164627) | 2 | 4 | 5 | 28859 | 19 | ||
14125 | 258397 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x4 | 6002678.8614 | 2090971.0772 | 37.7215602134912 | -122.432817540406 | (37.7215602134912, -122.432817540406) | 9 | 7 | 6 | 28861 | 5 | |||
14598 | 25257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1630 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2007 12:00:00 AM | 4 | 3X3 | 5994958.9037 | 2092277.5617 | 37.724706633679 | -122.459597742396 | (37.724706633679, -122.459597742396) | 9 | 8 | 4 | 28861 | 40 | ||
14642 | 12098 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1281X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2011 12:00:00 AM | 3 | 3x3 | 6017033.141006 | 2094557.4754692 | 37.7322114406026 | -122.383447721977 | (37.7322114406026, -122.383447721977) | 10 | 3 | 8 | 58 | 1 | ||
14683 | 228433 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:18:00 AM | 1 | Width 3ft | 6004139.02513 | 2107107.02985 | 37.7659485330168 | -122.4289199675 | (37.7659485330168, -122.4289199675) | 8 | 4 | 5 | 28862 | 3 | ||
14695 | 29937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2013 12:00:00 AM | 3 | 3x3 | 5995508.03584321 | 2088095.49688455 | 37.7132552348519 | -122.457397054893 | (37.7132552348519, -122.457397054893) | 9 | 8 | 6 | 28861 | 24 | ||
14726 | 4826 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 77 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/15/2015 12:00:00 AM | 3 | 4x4 | 6006160.37974 | 2097776.41085 | 37.7404430088465 | -122.421265864553 | (37.7404430088465, -122.421265864553) | 2 | 7 | 7 | 28859 | 2 | ||
14826 | 28744 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 759X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005606.56213 | 2098654.88944 | 37.7428238740223 | -122.423243181422 | (37.7428238740223, -122.423243181422) | 2 | 7 | 5 | 28859 | 22 | |||
15152 | 17033 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1160X OAK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2014 01:45:00 PM | 3 | 3X3 | 6001440.70617 | 2109752.64881 | 37.7730596462622 | -122.438442445109 | (37.7730596462622, -122.438442445109) | 15 | 5 | 11 | 29492 | 10 | ||
15209 | 12164 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1439X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.385876260938 | (37.7340798748876, -122.385876260938) | 10 | 3 | 8 | 58 | 1 | ||
15255 | 259404 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1443 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015439.42332 | 2092015.64337 | 37.7251438663465 | -122.388780227503 | (37.7251438663465, -122.388780227503) | 10 | 3 | 8 | 58 | 1 | ||
15329 | 264906 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
15347 | 26319 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2021 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999671.6195 | 2092116.9094 | 37.7245353858939 | -122.443294987371 | (37.7245353858939, -122.443294987371) | 9 | 7 | 6 | 28861 | 25 | |||
15623 | 180096 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2200x Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5999764.69095 | 2089543.44622 | 37.7174745512817 | -122.442788546764 | (37.7174745512817, -122.442788546764) | 9 | 7 | 6 | 28861 | 25 | |||
15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16051 | 259371 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1483 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015539.17512 | 2093687.83967 | 37.729740913102 | -122.388552062738 | (37.729740913102, -122.388552062738) | 10 | 3 | 8 | 58 | 1 | ||
16379 | 22378 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5545 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6014125.8203 | 2092742.8788 | 37.7270678150826 | -122.393372120942 | (37.7270678150826, -122.393372120942) | 10 | 3 | 8 | 58 | 1 | ||
16640 | 258165 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008206.68769 | 2093529.18425 | 37.7288962013592 | -122.413890143037 | (37.7288962013592, -122.413890143037) | 9 | 3 | 7 | 309 | 28 | |||
16681 | 15918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5688X Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 5997918.76709 | 2086907.8121 | 37.7101322964969 | -122.448979274378 | (37.7101322964969, -122.448979274378) | 9 | 7 | 6 | 28861 | 25 | |||
16771 | 12133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1400X La Salle Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2015 07:34:00 AM | 3 | 3X3 | 6016420.28727 | 2095262.82518 | 37.7341142997293 | -122.385615655843 | (37.7341142997293, -122.385615655843) | 10 | 3 | 8 | 58 | 1 | ||
16829 | 122857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:17:00 PM | 3 | 3x3 | 5996573.59778 | 2087230.46324 | 37.7109411987475 | -122.453651703257 | (37.7109411987475, -122.453651703257) | 9 | 7 | 6 | 28861 | 25 | ||
16976 | 180093 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2200x Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5999825.21966 | 2089601.03419 | 37.7176361252942 | -122.442583459968 | (37.7176361252942, -122.442583459968) | 9 | 7 | 6 | 28861 | 25 | |||
17309 | 15759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4723 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2019 12:00:00 AM | 1 | 3x3 | 6001700.9491 | 2091384.4332 | 37.7226396835373 | -122.436227479777 | (37.7226396835373, -122.436227479777) | 9 | 7 | 6 | 28861 | 5 | ||
17651 | 258163 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008206.68769 | 2093529.18425 | 37.7288962013592 | -122.413890143037 | (37.7288962013592, -122.413890143037) | 9 | 3 | 7 | 309 | 28 | ||
17655 | 259373 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1526 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015316.17509 | 2093903.39119 | 37.7303204136401 | -122.389338051321 | (37.7303204136401, -122.389338051321) | 10 | 3 | 8 | 58 | 1 | ||
17690 | 145365 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 550 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x4 | 5993166.59106 | 2111717.83288 | 37.7779813972691 | -122.467206321123 | (37.7779813972691, -122.467206321123) | 11 | 6 | 2 | 54 | 11 | ||
17785 | 254823 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2700x San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5997075 | 2088509 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | 9 | 8 | 6 | 28861 | 24 | ||
17933 | 264904 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
18005 | 172037 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 337 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6009708.87267 | 2093980.68359 | 37.7302201732017 | -122.4087287999 | (37.7302201732017, -122.4087287999) | 10 | 3 | 7 | 309 | 28 | ||
18115 | 259375 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1562 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015131.96015 | 2094040.00388 | 37.7306853098384 | -122.389984452411 | (37.7306853098384, -122.389984452411) | 10 | 3 | 8 | 58 | 1 | ||
18476 | 25245 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5996422.718 | 2091856.0732 | 37.7236333904646 | -122.454507112763 | (37.7236333904646, -122.454507112763) | 9 | 8 | 4 | 28861 | 40 | ||
18554 | 180300 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500x Alemany Blvd | 15 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001840.86779 | 2092960.98026 | 37.7269764741671 | -122.43585655983 | (37.7269764741671, -122.43585655983) | 9 | 7 | 6 | 28861 | 25 | |||
18563 | 259805 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1249 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011760.82557 | 2089103.97372 | 37.71694444304 | -122.401292315923 | (37.71694444304, -122.401292315923) | 10 | 7 | 8 | 309 | 39 | |||
18567 | 259345 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 556 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010214.99357 | 2091959.52642 | 37.724698834453 | -122.406836672699 | (37.724698834453, -122.406836672699) | 10 | 3 | 7 | 309 | 28 | ||
18585 | 27533 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
18629 | 89501 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4500 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984616.79689 | 2111792.82529 | 37.7776900570307 | -122.49678818172 | (37.7776900570307, -122.49678818172) | 11 | 6 | 2 | 55 | 26 | ||
18753 | 258180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 323 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6009841.50945 | 2094023.89021 | 37.7303462375071 | -122.408273301169 | (37.7303462375071, -122.408273301169) | 10 | 3 | 7 | 309 | 28 | ||
18906 | 258110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 639 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 6009897.96561 | 2091634.59657 | 37.723788900764 | -122.407909701204 | (37.723788900764, -122.407909701204) | 10 | 3 | 7 | 309 | 28 | ||||
19199 | 258106 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3400 California St | 2 | Sidewalk: Curb side : | Tree | DPW 1 | 5998152.86517 | 2114854.93765 | 37.7868816373151 | -122.45018328933 | (37.7868816373151, -122.45018328933) | 11 | 6 | 1 | 54 | 31 | |||||
19280 | 85899 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2318 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988279.9607 | 2099513.9728 | 37.7441896248499 | -122.483215927322 | (37.7441896248499, -122.483215927322) | 1 | 8 | 3 | 29491 | 35 | ||
19490 | 171734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007506.81416 | 2093353.39604 | 37.7283741942089 | -122.416297216361 | (37.7283741942089, -122.416297216361) | 9 | 3 | 7 | 309 | 5 | ||
19496 | 25276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1914 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1997 12:00:00 AM | 5 | 3X3 | 5994117.7673 | 2092581.6996 | 37.725493319329 | -122.462527475518 | (37.725493319329, -122.462527475518) | 9 | 8 | 4 | 59 | 40 | ||
19826 | 4242 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4024 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6003700.62714 | 2100425.74142 | 37.7475784763835 | -122.429959658411 | (37.7475784763835, -122.429959658411) | 2 | 4 | 5 | 63 | 22 | |||
20190 | 90411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | 8 | 2 | 9 | 28853 | 19 | ||
20360 | 98049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5285 Diamond Heights Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | 2 | 7 | 5 | 63 | 22 | ||
20393 | 90920 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5500 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 09:52:00 AM | 3 | 3x3 | 5981566.35935 | 2111684.48442 | 37.7772133782314 | -122.507332461007 | (37.7772133782314, -122.507332461007) | 11 | 6 | 2 | 55 | 26 | ||
20502 | 85886 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2554 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988334.5039 | 2097925.2606 | 37.7398306126335 | -122.482910918699 | (37.7398306126335, -122.482910918699) | 1 | 8 | 3 | 29491 | 35 | ||
20707 | 90412 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101X McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006026.109844 | 2109104.410168 | 37.7715394953365 | -122.422534862848 | (37.7715394953365, -122.422534862848) | 8 | 2 | 9 | 28853 | 19 | ||
20877 | 26287 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900X San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/20/1997 12:00:00 AM | 3 | 3X3 | 5999929.74898 | 2092596.23954 | 37.7258662323354 | -122.442437067416 | (37.7258662323354, -122.442437067416) | 9 | 7 | 6 | 28861 | 25 | ||
21043 | 140012 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 830 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2018 02:43:00 PM | 3 | Width 0ft | 6004895.2399 | 2111747.232 | 37.7787321771615 | -122.426634832347 | (37.7787321771615, -122.426634832347) | 7 | 9 | 11 | 28852 | 41 | ||
21325 | 90408 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | 8 | 2 | 9 | 28853 | 19 | ||
21388 | 180034 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1800x Alemany Blvd | 25 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 6001097.83369 | 2091228.63345 | 37.7221776071819 | -122.438301156396 | (37.7221776071819, -122.438301156396) | 9 | 7 | 6 | 28861 | 25 | |||
21665 | 385 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3721X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | ||
22304 | 26236 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 657 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/1998 12:00:00 AM | 6 | 3X3 | 6005952.86183 | 2099468.26826 | 37.7450767656787 | -122.422103544342 | (37.7450767656787, -122.422103544342) | 2 | 7 | 5 | 28859 | 2 | ||
22464 | 2497 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016766.5915 | 2098782.95362 | 37.7437990179202 | -122.384663486948 | (37.7437990179202, -122.384663486948) | 10 | 3 | 8 | 58 | 1 | |||
22512 | 182666 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2840 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | FUF | 0 | Width 0ft | 5985172.5458 | 2102302.8402 | 37.7516657686175 | -122.494166047002 | (37.7516657686175, -122.494166047002) | 1 | 8 | 3 | 56 | 35 | ||
22589 | 90398 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 90X McCoppin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 02:35:00 PM | 3 | 3x3 | 6006087.612034 | 2109147.850555 | 37.7716622416587 | -122.42232521005 | (37.7716622416587, -122.42232521005) | 8 | 2 | 9 | 28853 | 19 | ||
23164 | 1369 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/1997 12:00:00 AM | 3 | 5999059.98844 | 2100047.12811 | 37.7462749917943 | -122.445979419622 | (37.7462749917943, -122.445979419622) | 2 | 7 | 5 | 63 | 22 | |||
23309 | 266 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3201X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1999 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | ||
23371 | 86529 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1495 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987733.4428 | 2105147.1779 | 37.7596250718264 | -122.485518957406 | (37.7596250718264, -122.485518957406) | 1 | 8 | 3 | 56 | 35 | ||
23512 | 6017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1768 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 3 | 4X4 | 6001988.67291 | 2112609.68299 | 37.7809354990687 | -122.43675151758 | (37.7809354990687, -122.43675151758) | 15 | 5 | 11 | 29490 | 41 | ||
23523 | 341 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3590X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2013 12:00:00 AM | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );