trees
862 rows where qCareAssistant = "" and qSpecies_id = 50 sorted by qLegalStatus_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114 | 251458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
938 | 167297 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3500 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004922.20627 | 2103712.53255 | 37.7566723462619 | -122.425969442941 | (37.7566723462619, -122.425969442941) | 2 | 4 | 5 | 28862 | 3 | |||
1084 | 229775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.403338920978 | (37.7538928862632, -122.403338920978) | 10 | 4 | 8 | 28859 | 19 | |||
1652 | 243315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 40 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006628.53628 | 2105662.75814 | 37.7621234987325 | -122.420206730272 | (37.7621234987325, -122.420206730272) | 8 | 4 | 7 | 28859 | 19 | |||
1698 | 244767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2500 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:35:00 PM | 3 | Width 3ft | 6008837.10491 | 2103758.81421 | 37.7570199000752 | -122.412433524704 | (37.7570199000752, -122.412433524704) | 2 | 4 | 7 | 28859 | 19 | ||
1823 | 162258 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011414.80687 | 2091110.91102 | 37.7224357728692 | -122.402629394533 | (37.7224357728692, -122.402629394533) | 10 | 3 | 7 | 309 | 28 | ||
1963 | 229848 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6005112.08271 | 2103723.92824 | 37.7567143652889 | -122.425313591669 | (37.7567143652889, -122.425313591669) | 2 | 4 | 5 | 28859 | 19 | |||
1985 | 47 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1998 12:00:00 AM | 6 | 3x3 | 6003389.55254 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | 15 | 5 | 5 | 28862 | 3 | ||
2273 | 228542 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1465 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6009587.77635 | 2100703.29886 | 37.7486722345333 | -122.409621752043 | (37.7486722345333, -122.409621752043) | 2 | 4 | 7 | 28859 | 19 | |||
2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 3 | 8 | 28856 | 29 | |||
2363 | 243655 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4140 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002213.79042 | 2102389.84201 | 37.7528871150509 | -122.435241509003 | (37.7528871150509, -122.435241509003) | 2 | 4 | 5 | 28862 | 22 | |||
2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
2489 | 224583 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008562.45401 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | 8 | 4 | 7 | 28859 | 19 | |
2827 | 253039 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 531 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 13x6.5 | 6003687 | 2105184 | 37.7606427596565 | -122.43034621439 | (37.7606427596565, -122.43034621439) | 2 | 4 | 5 | 28862 | 3 | ||
3670 | 229792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | 8 | 4 | 7 | 28853 | 19 | |||
3767 | 226772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002600.09968 | 2103291.61408 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | 2 | 4 | 5 | 28862 | 22 | |||
3860 | 106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 927 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | 15 | 5 | 5 | 28862 | 3 | |||
4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
4829 | 158177 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6003950.61422 | 2096725.29328 | 37.7374320507564 | -122.42883145083 | (37.7374320507564, -122.42883145083) | 2 | 7 | 5 | 63 | 7 | |||
5058 | 228531 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009451.25319 | 2106552.40785 | 37.7647249190387 | -122.410506818932 | (37.7647249190387, -122.410506818932) | 8 | 4 | 7 | 28859 | 19 | |||
5083 | 229812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3000 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009519.76237 | 2101043.00477 | 37.7496011802691 | -122.409880921395 | (37.7496011802691, -122.409880921395) | 2 | 4 | 7 | 28859 | 19 | |||
5157 | 43 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 797 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003580.94003 | 2107704.34561 | 37.7675570127652 | -122.4308929011 | (37.7675570127652, -122.4308929011) | 7 | 9 | 5 | 28862 | 3 | |||
6306 | 237343 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
6465 | 261249 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007038 | 2095471 | 37.7341622992343 | -122.418067993983 | (37.7341622992343, -122.418067993983) | 2 | 7 | 7 | 28859 | 2 | ||||
6567 | 45 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1990 12:00:00 AM | 12 | 3x3 | 6003436.52432 | 2107742.06145 | 37.7676523876611 | -122.431395108624 | (37.7676523876611, -122.431395108624) | 15 | 5 | 5 | 28862 | 3 | ||
6669 | 229888 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008255.19246 | 2099602.19695 | 37.7455740916772 | -122.414151939365 | (37.7455740916772, -122.414151939365) | 2 | 7 | 7 | 28859 | 2 | |||
6734 | 226402 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008216.93199 | 2099535.32688 | 37.7453883322157 | -122.414279508218 | (37.7453883322157, -122.414279508218) | 2 | 7 | 7 | 28859 | 2 | |||
7478 | 226407 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006002.53632 | 2097682.69863 | 37.7401767960293 | -122.421804971219 | (37.7401767960293, -122.421804971219) | 2 | 7 | 7 | 28859 | 2 | |||
7683 | 38 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 775 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.7675715008638 | -122.430573990716 | (37.7675715008638, -122.430573990716) | 7 | 9 | 5 | 28862 | 3 | |||
7834 | 229823 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 972 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6009935.37362 | 2103568.4929 | 37.7565588922846 | -122.408621852536 | (37.7565588922846, -122.408621852536) | 2 | 4 | 7 | 28859 | 19 | |||
8056 | 224581 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008597.08192 | 2106800.15076 | 37.7653572404576 | -122.413478706001 | (37.7653572404576, -122.413478706001) | 8 | 4 | 7 | 28859 | 19 | |
8083 | 261467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | ||||
8554 | 229854 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005450.52958 | 2101809.91595 | 37.7514780473814 | -122.424007011614 | (37.7514780473814, -122.424007011614) | 2 | 4 | 5 | 28859 | 19 | |||
9095 | 256124 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250X Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
9289 | 260836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1536 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015652 | 2095724 | 37.7353380520345 | -122.388304065218 | (37.7353380520345, -122.388304065218) | 10 | 3 | 8 | 58 | 1 | ||||
9376 | 237344 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 99x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
9391 | 149875 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015583.80084 | 2102690.13073 | 37.7544618261772 | -122.38902607571 | (37.7544618261772, -122.38902607571) | 10 | 3 | 8 | 28856 | 29 | |||
9710 | 239955 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3448 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | 2x3 | Permit Number 50576 | 6006541.34834 | 2105555.19292 | 37.7618232366876 | -122.420500644884 | (37.7618232366876, -122.420500644884) | 8 | 4 | 7 | 28859 | 19 | |
10934 | 226371 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 626 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002431.85737 | 2098894.22226 | 37.7433013483718 | -122.43423751036 | (37.7433013483718, -122.43423751036) | 2 | 7 | 5 | 63 | 22 | |||
11124 | 230876 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 241 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 01:31:00 PM | 3 | Width 4ft | 6004420.76549 | 2097018.25838 | 37.7382630656916 | -122.427226779685 | (37.7382630656916, -122.427226779685) | 2 | 7 | 5 | 63 | 7 | ||
11201 | 226438 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006736.74676 | 2102507.29113 | 37.7534654133023 | -122.419608581296 | (37.7534654133023, -122.419608581296) | 2 | 4 | 7 | 28859 | 19 | |||
12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
12595 | 229844 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3676 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6005793.11557 | 2104343.58039 | 37.7584542377953 | -122.423002369088 | (37.7584542377953, -122.423002369088) | 2 | 4 | 5 | 28859 | 19 | |||
12723 | 229788 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1799 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005571.35245 | 2107231.70655 | 37.7663718340174 | -122.423974702579 | (37.7663718340174, -122.423974702579) | 8 | 4 | 5 | 28853 | 19 | |||
12973 | 226464 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2670 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008878.67119 | 2102975.76915 | 37.7548721679187 | -122.412234430081 | (37.7548721679187, -122.412234430081) | 2 | 4 | 7 | 28859 | 19 | |||
13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
13095 | 226377 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 267 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785520 | 6007909.30084 | 2097390.1768 | 37.739480940202 | -122.415191429754 | (37.739480940202, -122.415191429754) | 2 | 7 | 7 | 28859 | 2 | |
13157 | 253697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 865 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003091 | 2107654 | 37.7673910038901 | -122.432583941874 | (37.7673910038901, -122.432583941874) | 15 | 5 | 5 | 28862 | 3 | ||||
13347 | 231129 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 821 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | 15 | 5 | 5 | 28862 | 3 | |||
13592 | 162301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 238 Olmstead St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 0ft | 6010941.2062 | 2091035.49966 | 37.7222022558199 | -122.404261226995 | (37.7222022558199, -122.404261226995) | 10 | 3 | 7 | 309 | 28 | ||
14147 | 219232 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 393 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994163.921 | 2092422.70166 | 37.7250594073463 | -122.462356400531 | (37.7250594073463, -122.462356400531) | 9 | 8 | 4 | 28861 | 40 | |||
14543 | 48 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | |||
14632 | 224584 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008542.99689 | 2106795.22797 | 37.76534068665 | -122.413665425938 | (37.76534068665, -122.413665425938) | 8 | 4 | 7 | 28859 | 19 | |
15057 | 229773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.65854 | 2102520.54386 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | 10 | 4 | 8 | 28859 | 19 | |||
15488 | 228530 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1736 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6009448.17881 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | 8 | 4 | 7 | 28859 | 19 | |||
15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
15985 | 149873 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.31236 | 2102734.10944 | 37.7545824999013 | -122.389034293714 | (37.7545824999013, -122.389034293714) | 10 | 3 | 8 | 28856 | 29 | |||
16102 | 261110 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014376 | 2094477 | 37.7318432579921 | -122.392628501141 | (37.7318432579921, -122.392628501141) | 10 | 3 | 8 | 58 | 1 | ||
16192 | 50 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 811 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003361.68382 | 2107697.25864 | 37.767525128208 | -122.431650773269 | (37.767525128208, -122.431650773269) | 15 | 5 | 5 | 28862 | 3 | |||
16486 | 150546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012204.80057 | 2103865.42291 | 37.7575010382506 | -122.400794174114 | (37.7575010382506, -122.400794174114) | 10 | 3 | 8 | 28856 | 29 | |||
16490 | 233463 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2598 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008858.41145 | 2103392.91601 | 37.7560164221241 | -122.41233397694 | (37.7560164221241, -122.41233397694) | 2 | 4 | 7 | 28859 | 19 | |||
17504 | 261109 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 20 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6014376 | 2094477 | 37.7318432579921 | -122.392628501141 | (37.7318432579921, -122.392628501141) | 10 | 3 | 8 | 58 | 1 | ||
17882 | 240751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2500 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6008841.50071 | 2103703.05088 | 37.7568670332937 | -122.412414380831 | (37.7568670332937, -122.412414380831) | 2 | 4 | 7 | 28859 | 19 | ||
18156 | 73673 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1020 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 49743 | 6009009.07055 | 2116016.55074 | 37.7906864165824 | -122.412705335782 | (37.7906864165824, -122.412705335782) | 5 | 1 | 10 | 28857 | 21 | ||
18224 | 248227 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 38 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007014.76999 | 2099297.76945 | 37.7446684509831 | -122.418419557911 | (37.7446684509831, -122.418419557911) | 2 | 7 | 7 | 28859 | 2 | |||
18269 | 149874 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1388 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015582.50669 | 2102715.11316 | 37.7545303509079 | -122.389032295422 | (37.7545303509079, -122.389032295422) | 10 | 3 | 8 | 28856 | 29 | |||
18290 | 229761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.7531266009123 | -122.403271446634 | (37.7531266009123, -122.403271446634) | 10 | 4 | 8 | 28859 | 19 | |||
18298 | 41 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 795 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003608.49948 | 2107706.26027 | 37.7675638314322 | -122.430797713246 | (37.7675638314322, -122.430797713246) | 7 | 9 | 5 | 28862 | 3 | |||
18656 | 229861 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1509 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010132.55959 | 2100497.58386 | 37.7481378987515 | -122.407723384842 | (37.7481378987515, -122.407723384842) | 2 | 7 | 7 | 28859 | 2 | |||
18673 | 229819 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 713 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009886.7617 | 2104802.87513 | 37.7599455053009 | -122.408877057635 | (37.7599455053009, -122.408877057635) | 2 | 4 | 8 | 28859 | 19 | |||
18693 | 226764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004212.35359 | 2095476.21584 | 37.7340171774496 | -122.427837519201 | (37.7340171774496, -122.427837519201) | 2 | 7 | 5 | 28861 | 25 | |||
18756 | 166228 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3180 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007809.26595 | 2102700.74025 | 37.7540569360932 | -122.41591326789 | (37.7540569360932, -122.41591326789) | 2 | 4 | 7 | 28859 | 19 | |||
19081 | 231839 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 783 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6003644.59766 | 2107707.78097 | 37.7675700520556 | -122.430672962911 | (37.7675700520556, -122.430672962911) | 7 | 9 | 5 | 28862 | 3 | |||
19119 | 71960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6008996.95317 | 2116013.92959 | 37.7906785394346 | -122.412747076037 | (37.7906785394346, -122.412747076037) | 5 | 1 | 10 | 28857 | 21 | ||||
19464 | 224582 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:45:00 PM | 3 | 6x3 | Permit Number 781047 | 6008579.87348 | 2106797.48808 | 37.7653489631036 | -122.413538037855 | (37.7653489631036, -122.413538037855) | 8 | 4 | 7 | 28859 | 19 | |
19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
20282 | 226409 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 340 Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007041.57099 | 2096614.16719 | 37.7373013855609 | -122.418136666301 | (37.7373013855609, -122.418136666301) | 2 | 7 | 7 | 28859 | 2 | |||
20342 | 226375 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 235 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004677.73219 | 2096935.71561 | 37.7380509507014 | -122.426332439909 | (37.7380509507014, -122.426332439909) | 2 | 7 | 5 | 63 | 7 | |||
20414 | 226318 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1453 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009324.95877 | 2100785.02024 | 37.7488818925933 | -122.410536346369 | (37.7488818925933, -122.410536346369) | 2 | 4 | 7 | 28859 | 19 | |||
20883 | 229739 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | 8 | 4 | 5 | 28859 | 19 | |||
21056 | 38279 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013875.32423 | 2104028.43016 | 37.7580416558018 | -122.395028206788 | (37.7580416558018, -122.395028206788) | 10 | 3 | 8 | 28856 | 29 | ||
21203 | 190740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 168 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010535.58814 | 2107583.98443 | 37.7676181235051 | -122.406829079197 | (37.7676181235051, -122.406829079197) | 8 | 4 | 8 | 28853 | 19 | |||
21276 | 226310 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | 2 | 7 | 7 | 28859 | 2 | |||
21656 | 255546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 209 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006712 | 2104859 | 37.7599212687364 | -122.419861024185 | (37.7599212687364, -122.419861024185) | 2 | 4 | 7 | 28859 | 19 | ||||
22956 | 27142 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1775 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011388.17267 | 2095338.53753 | 37.7340424699754 | -122.403018675074 | (37.7340424699754, -122.403018675074) | 10 | 3 | 8 | 58 | 1 | |||
23234 | 48401 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1170 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50635 | 6011912.33745 | 2102971.80272 | 37.7550310367587 | -122.401742823998 | (37.7550310367587, -122.401742823998) | 10 | 3 | 8 | 28856 | 29 | |
24108 | 226363 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 178 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006046.41496 | 2096344.01449 | 37.7365035429963 | -122.421558204449 | (37.7365035429963, -122.421558204449) | 2 | 7 | 7 | 28859 | 2 | |||
24196 | 226813 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.430288478441 | (37.7690073251557, -122.430288478441) | 7 | 9 | 5 | 28862 | 3 | |||
24224 | 229868 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 248 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6004337.80093 | 2099585.86328 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | 2 | 7 | 5 | 63 | 22 | |||
24333 | 105898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013868.87409 | 2104163.4691 | 37.758412084763 | -122.395059972665 | (37.758412084763, -122.395059972665) | 10 | 3 | 8 | 28856 | 29 | |||
24719 | 226796 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 659 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002418.29753 | 2104403.09617 | 37.7584266402862 | -122.434678235738 | (37.7584266402862, -122.434678235738) | 2 | 4 | 5 | 28862 | 3 | |||
24811 | 80400 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 847 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51000 | 6000427.8652 | 2111924.6617 | 37.7789657789093 | -122.442101918526 | (37.7789657789093, -122.442101918526) | 15 | 5 | 11 | 29490 | 16 | |
24898 | 226454 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3273 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006579.31902 | 2103170.31631 | 37.7552770588978 | -122.420200053701 | (37.7552770588978, -122.420200053701) | 2 | 4 | 7 | 28859 | 19 | |||
26670 | 226355 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2175 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008795.60516 | 2105650.73446 | 37.7622123526471 | -122.412710792894 | (37.7622123526471, -122.412710792894) | 8 | 4 | 7 | 28859 | 19 | |||
26709 | 201517 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.376216835747 | (37.7321368236424, -122.376216835747) | 10 | 3 | 8 | 58 | 1 | |||
26859 | 226803 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4187 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002522.14485 | 2104118.46632 | 37.7576510101026 | -122.434298737121 | (37.7576510101026, -122.434298737121) | 2 | 4 | 5 | 28862 | 3 | |||
27293 | 105894 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 635 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013871.77748 | 2104094.24154 | 37.7582221623537 | -122.395045082568 | (37.7582221623537, -122.395045082568) | 10 | 3 | 8 | 28856 | 29 | |||
27538 | 226448 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3070 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008539 | 2102800 | 37.7543704799177 | -122.41339668212 | (37.7543704799177, -122.41339668212) | 2 | 4 | 7 | 28859 | 19 |
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) );