trees
619 rows where Fire Prevention Districts = 2 and qSpecies_id = 50 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543 | 100400 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x3 | 6008223 | 2099495 | 37.7452779444232 | -122.414255673266 | (37.7452779444232, -122.414255673266) | 2 | 7 | 7 | 28859 | 2 | |||
571 | 91075 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858 | 2104570 | 37.7591922359052 | -122.415877090614 | (37.7591922359052, -122.415877090614) | 2 | 4 | 7 | 28859 | 19 | ||
685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
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 | ||
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 | |||
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 | |||
4647 | 36593 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
8746 | 37676 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40072 | 6008031 | 2104525 | 37.7590784006599 | -122.415275586184 | (37.7590784006599, -122.415275586184) | 2 | 4 | 7 | 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 | ||||
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 | |||
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 | |||
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 | |||
12676 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 50 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 782183 | 6009049 | 2099828 | 37.7462386522881 | -122.411423013741 | (37.7462386522881, -122.411423013741) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
13037 | 152668 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 811 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777381 | 6008574.99769 | 2103713.14234 | 37.7568797829862 | -122.413336764205 | (37.7568797829862, -122.413336764205) | 2 | 4 | 7 | 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 | |
13239 | 35575 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.423142532595 | (37.7559036789868, -122.423142532595) | 2 | 4 | 5 | 28859 | 19 | |
13806 | 36597 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
14210 | 85214 | - 12 | Jacaranda mimosifolia :: Jacaranda 50 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.7526413233918 | -122.409722943913 | (37.7526413233918, -122.409722943913) | 2 | 4 | 7 | 28859 | 19 |
14306 | 35546 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
14333 | 68480 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32350 | 6010273.43286101 | 2102111.66598921 | 37.7525776974999 | -122.407350018785 | (37.7525776974999, -122.407350018785) | 2 | 4 | 7 | 28859 | 19 | ||
14521 | 259145 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007403 | 2097606 | 37.7400450761075 | -122.416957288885 | (37.7400450761075, -122.416957288885) | 2 | 7 | 7 | 28859 | 2 | ||||
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
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 | |||
17101 | 36665 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1361 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39471 | 6010110.56144118 | 2101283.13510395 | 37.750293617943 | -122.407854839546 | (37.750293617943, -122.407854839546) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
18066 | 220829 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 147 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2019 12:00:00 AM | 3 | 4x4 | Permit Number 784791 | 6008911.9321 | 2099119.05037 | 37.7442843442566 | -122.411846891528 | (37.7442843442566, -122.411846891528) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
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 | |||
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 | |||
19970 | 42662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42694 | 6006739.09438078 | 2102580.17039633 | 37.7536656552896 | -122.419605633092 | (37.7536656552896, -122.419605633092) | 2 | 4 | 7 | 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 | |||
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 | |||
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 | ||||
21766 | 36029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39176 | 6008256.82211369 | 2099693.24167493 | 37.7458241717762 | -122.414152744353 | (37.7458241717762, -122.414152744353) | 2 | 7 | 7 | 28859 | 2 | ||
22460 | 65976 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 59 & 1/2 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 8 | 6x6 | Permit Number 31847 | 6008257.4720065 | 2099681.55363989 | 37.7457921155362 | -122.414149670347 | (37.7457921155362, -122.414149670347) | 2 | 7 | 7 | 28859 | 2 |
23163 | 35804 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 233 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39048 | 6006716.02273257 | 2104761.27467675 | 37.7596531643404 | -122.41984017695 | (37.7596531643404, -122.41984017695) | 2 | 4 | 7 | 28859 | 19 | ||
23830 | 34752 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 667 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 38399 | 6007930.97034241 | 2104052.78354238 | 37.7577761801817 | -122.415588103657 | (37.7577761801817, -122.415588103657) | 2 | 4 | 7 | 28859 | 19 | ||
23886 | 37758 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.7512141902983 | -122.40794259966 | (37.7512141902983, -122.40794259966) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
24866 | 255162 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 598 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007652.9891 | 2096583.60222 | 37.7372518561065 | -122.416020541778 | (37.7372518561065, -122.416020541778) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
25581 | 36604 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1449 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39457 | 6009591.69172547 | 2100806.68710724 | 37.748956335196 | -122.409615508849 | (37.748956335196, -122.409615508849) | 2 | 4 | 7 | 28859 | 19 | ||
25857 | 43125 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42943 | 6006014.62206932 | 2098348.860336 | 37.7420066078017 | -122.421810489884 | (37.7420066078017, -122.421810489884) | 2 | 7 | 7 | 28859 | 2 | ||
25889 | 52052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48254 | 6005362.31259493 | 2099645.76538508 | 37.7455308063117 | -122.424158182307 | (37.7455308063117, -122.424158182307) | 2 | 7 | 5 | 28859 | 22 | |||
26703 | 101946 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.7564675147494 | -122.41647145397 | (37.7564675147494, -122.41647145397) | 2 | 4 | 7 | 28859 | 19 | |||
26785 | 33029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
26942 | 37739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
27597 | 34735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851 | (37.7509115908716, -122.41496434851) | 2 | 4 | 7 | 28859 | 19 | ||
28096 | 35326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 239 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38793 | 6006717.55595043 | 2104727.62386215 | 37.7595608533974 | -122.41983248648 | (37.7595608533974, -122.41983248648) | 2 | 4 | 7 | 28859 | 19 | ||
28301 | 226433 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.419902738742 | (37.7550875384663, -122.419902738742) | 2 | 4 | 7 | 28859 | 19 | |||
28580 | 10084 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 649 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2012 12:00:00 AM | 3 | 3X3 | 6005635.92874 | 2105201.33874 | 37.7608005699125 | -122.423606976082 | (37.7608005699125, -122.423606976082) | 2 | 4 | 5 | 28859 | 19 | ||
28612 | 226325 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 825 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007984.60499 | 2102879.52609 | 37.7545576974837 | -122.415319557045 | (37.7545576974837, -122.415319557045) | 2 | 4 | 7 | 28859 | 19 | |||
28755 | 226347 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008486.7284 | 2101525.46437 | 37.7508679571961 | -122.413487316996 | (37.7508679571961, -122.413487316996) | 2 | 4 | 7 | 28859 | 19 | |||
28782 | 81873 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1312 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52224 | 6010043.81301103 | 2101548.7849116 | 37.7510192965024 | -122.408104393789 | (37.7510192965024, -122.408104393789) | 2 | 4 | 7 | 28859 | 19 | ||
28827 | 229891 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008240.95046 | 2099813.74948 | 37.7461541678773 | -122.414216150953 | (37.7461541678773, -122.414216150953) | 2 | 7 | 7 | 28859 | 2 | |||
28887 | 37673 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40071 | 6008076 | 2104474 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | 2 | 4 | 7 | 28859 | 19 |
29003 | 40334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1359 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 3x3 | Permit Number 41465 | 6007740.61181979 | 2101748.78645974 | 37.7514392269717 | -122.416083278537 | (37.7514392269717, -122.416083278537) | 2 | 4 | 7 | 28859 | 19 | |
29233 | 226388 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006749.9144 | 2099207.72209 | 37.7444062878286 | -122.41932899196 | (37.7444062878286, -122.41932899196) | 2 | 7 | 7 | 28859 | 2 | |||
29253 | 226437 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006735.95617 | 2102521.24604 | 37.7535036857516 | -122.419612305359 | (37.7535036857516, -122.419612305359) | 2 | 4 | 7 | 28859 | 19 | |||
29462 | 226390 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006633.7821 | 2097989.5025 | 37.7410547888452 | -122.419644136891 | (37.7410547888452, -122.419644136891) | 2 | 7 | 7 | 28859 | 2 | |||
29877 | 39158 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
30307 | 37730 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1466X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40094 | 6009550 | 2100728 | 37.7487379414946 | -122.409754126164 | (37.7487379414946, -122.409754126164) | 2 | 4 | 7 | 28859 | 19 | |
30369 | 226440 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 501 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006828.67283 | 2100820.93756 | 37.7488402485934 | -122.419171070095 | (37.7488402485934, -122.419171070095) | 2 | 4 | 7 | 28859 | 19 | |||
30569 | 44068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 43592 | 6006646.88740951 | 2098034.91768842 | 37.741180227012 | -122.419602044821 | (37.741180227012, -122.419602044821) | 2 | 7 | 7 | 28859 | 2 | ||
30844 | 36599 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39452 | 6009585.61659215 | 2100916.70354088 | 37.7492580755485 | -122.409644280871 | (37.7492580755485, -122.409644280871) | 2 | 4 | 7 | 28859 | 19 | ||
31962 | 33030 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
32766 | 226392 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1441 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008026.30666 | 2099772.03767 | 37.7460275775108 | -122.414955412565 | (37.7460275775108, -122.414955412565) | 2 | 7 | 7 | 28859 | 2 | |||
32997 | 40317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.421030150349 | (37.7569313744996, -122.421030150349) | 2 | 4 | 7 | 28859 | 19 | ||
33217 | 229842 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3731 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005435.33161 | 2104281.13131 | 37.7582625715808 | -122.424235305437 | (37.7582625715808, -122.424235305437) | 2 | 4 | 5 | 28859 | 19 | |||
33298 | 229847 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6005127.97551 | 2103724.2468 | 37.7567161378508 | -122.42525865119 | (37.7567161378508, -122.42525865119) | 2 | 4 | 5 | 28859 | 19 | |||
33353 | 229895 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1429 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008018.20821 | 2099852.67897 | 37.7462485454514 | -122.414989122751 | (37.7462485454514, -122.414989122751) | 2 | 7 | 7 | 28859 | 2 | |||
33380 | 226305 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 84 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006137.34667 | 2097561.46022 | 37.7398515040311 | -122.421330243406 | (37.7398515040311, -122.421330243406) | 2 | 7 | 7 | 28859 | 2 | |||
34432 | 229750 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005497.63156 | 2101589.27142 | 37.7508748675982 | -122.423828439536 | (37.7508748675982, -122.423828439536) | 2 | 4 | 5 | 28859 | 19 | |||
35141 | 32262 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | 2 | 7 | 5 | 28859 | 22 | |
35462 | 50281 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2890 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46985 | 6009507.79940806 | 2102799.18720578 | 37.7544225953783 | -122.410046254665 | (37.7544225953783, -122.410046254665) | 2 | 4 | 7 | 28859 | 19 | ||
35536 | 34771 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1112 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 11 | Permit Number 38413 | 6008023.83866277 | 2101437.17080746 | 37.7505995211504 | -122.415081788574 | (37.7505995211504, -122.415081788574) | 2 | 4 | 7 | 28859 | 19 | |
35623 | 52402 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 92@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48522 | 6006139.57045617 | 2097557.41563242 | 37.7398405238756 | -122.421322267329 | (37.7398405238756, -122.421322267329) | 2 | 7 | 7 | 28859 | 2 | ||
35946 | 68105 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.7454673885178 | -122.414298897694 | (37.7454673885178, -122.414298897694) | 2 | 7 | 7 | 28859 | 2 | ||
36827 | 37740 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
37084 | 71739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.7456277058322 | -122.41488645052 | (37.7456277058322, -122.41488645052) | 2 | 7 | 7 | 28859 | 2 | ||
37473 | 37697 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
38719 | 226320 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1237 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009255.59412 | 2102037.09938 | 37.7523159340399 | -122.410864628624 | (37.7523159340399, -122.410864628624) | 2 | 4 | 7 | 28859 | 19 | |||
39039 | 35325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38792 | 6006662.54340548 | 2104792.55869269 | 37.7597360500369 | -122.42002735576 | (37.7597360500369, -122.42002735576) | 2 | 4 | 7 | 28859 | 19 | ||
39052 | 229883 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008413.69404 | 2097282.59684 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | 2 | 7 | 7 | 28859 | 2 | |||
39438 | 229804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 10 Crescent Ave | 7 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | 2 | 7 | 7 | 28859 | 2 | |||
39886 | 37737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 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) );