trees
1,650 rows where qSpecies_id = 64 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
683 | 38304 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
1193 | 63195 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 492 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 7 | Permit Number 23736 | 5984412.04288 | 2112531.45624 | 37.7797061246547 | -122.497551031954 | (37.7797061246547, -122.497551031954) | 11 | 6 | 2 | 55 | 26 | |
1443 | 68991 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1882 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 2 | Permit Number 32984 | 5981356.0199 | 2102264.6652 | 37.7513368825607 | -122.507361024926 | (37.7513368825607, -122.507361024926) | 1 | 8 | 3 | 56 | 35 | |
3002 | 43637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43287 | 6006770.36235207 | 2101076.15554315 | 37.7495377351989 | -122.419390811234 | (37.7495377351989, -122.419390811234) | 2 | 4 | 7 | 28859 | 19 | ||
3234 | 41216 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1920 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/2019 12:00:00 AM | 3 | Permit Number 41924 | 5999991.94061 | 2121282.68763 | 37.8046356075044 | -122.444282616557 | (37.8046356075044, -122.444282616557) | 13 | 9 | 1 | 57 | 17 | |
3380 | 261217 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3400 Vicente St | : Cutout | Tree | Private 2 | FUF | 3x3 | 5982420.06104 | 2097439.60235 | 37.738151214353 | -122.503324281602 | (37.738151214353, -122.503324281602) | 1 | 8 | 3 | 29491 | 35 | ||||
3547 | 71714 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3725 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 3x6 | Permit Number 771233 | 5984016.25098 | 2111031.53375 | 37.7755645644081 | -122.498809386612 | (37.7755645644081, -122.498809386612) | 11 | 6 | 2 | 55 | 26 | |
3550 | 80000 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981404.80446 | 2112378.67743 | 37.7791099097712 | -122.507942852748 | (37.7791099097712, -122.507942852748) | 11 | 6 | 2 | 55 | 26 | |||
3918 | 71637 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3735 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983967.42692 | 2111030.60647 | 37.7755591545959 | -122.498978209698 | (37.7755591545959, -122.498978209698) | 11 | 6 | 2 | 55 | 26 | |||
3945 | 70009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1815 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005608.75345 | 2092244.69483 | 37.725223029103 | -122.422780149308 | (37.725223029103, -122.422780149308) | 9 | 7 | 7 | 309 | 5 | |||
4394 | 261156 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4221 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/2020 12:00:00 AM | 3 | 3x3 | 5981166 | 2103448 | 37.7545747897022 | -122.508105942328 | (37.7545747897022, -122.508105942328) | 1 | 8 | 3 | 56 | 35 | |
4501 | 81295 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2274 45th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982376.5473 | 2099668.9758 | 37.7442699020827 | -122.503639778557 | (37.7442699020827, -122.503639778557) | 1 | 8 | 3 | 29491 | 35 | |||
5334 | 83255 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2020 12:00:00 AM | 3 | 5983253.61867 | 2110435.38712 | 37.7738829587872 | -122.501403365431 | (37.7738829587872, -122.501403365431) | 11 | 6 | 2 | 55 | 26 | ||
5738 | 78347 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3301 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5985324.51094 | 2111082.60279 | 37.7757814311217 | -122.49428762949 | (37.7757814311217, -122.49428762949) | 11 | 6 | 2 | 55 | 26 | |||
6124 | 72278 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 716 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983237.15085 | 2110912.93675 | 37.7751932045665 | -122.501495663732 | (37.7751932045665, -122.501495663732) | 11 | 6 | 2 | 55 | 26 | |||
8100 | 60138 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3643 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1982 12:00:00 AM | 4 | Permit Number 19668 | 5984225.13965 | 2111041.08493 | 37.7756030388028 | -122.498087506758 | (37.7756030388028, -122.498087506758) | 11 | 6 | 2 | 55 | 26 | |
8141 | 54006 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3300 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/1972 12:00:00 AM | 2 | Permit Number 9725 | 5985332.63941 | 2111140.64831 | 37.7759412831996 | -122.494263790905 | (37.7759412831996, -122.494263790905) | 11 | 6 | 2 | 55 | 26 | |
8187 | 37494 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39963 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.471942379719 | (37.7601232248942, -122.471942379719) | 1 | 8 | 4 | 56 | 12 | ||
8653 | 254419 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3400X Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781063 | ||||||||||
9317 | 69488 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 425 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 20 | Permit Number 33610 | 6002125.08495 | 2093879.83517 | 37.7295155822594 | -122.434939712705 | (37.7295155822594, -122.434939712705) | 9 | 7 | 6 | 28861 | 25 | |
10351 | 71636 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3710 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x6 | Permit Number 771232 | 5984058.85171 | 2111091.8464 | 37.7757326640871 | -122.498666479041 | (37.7757326640871, -122.498666479041) | 11 | 6 | 2 | 55 | 26 | |
10665 | 70444 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3933 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982611.2212 | 2104882.7837 | 37.758599355062 | -122.503214291779 | (37.758599355062, -122.503214291779) | 1 | 8 | 3 | 56 | 35 | |||
11155 | 71173 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2275 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987604.645 | 2099825.288 | 37.7450050904406 | -122.485573834432 | (37.7450050904406, -122.485573834432) | 1 | 8 | 3 | 29491 | 35 | |||
11211 | 256751 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1858 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5985068.08912 | 2102552.26769 | 37.7523445150231 | -122.494545652262 | (37.7523445150231, -122.494545652262) | 1 | 8 | 3 | 56 | 35 | ||
12509 | 260552 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1822 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/27/2019 12:00:00 AM | 3 | 5983200.28736 | 2102724.03033 | 37.752706632515 | -122.501017410169 | (37.752706632515, -122.501017410169) | 1 | 8 | 3 | 56 | 35 | ||
12789 | 109729 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 4534 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774273 | 6000926.1 | 2104675 | 37.7590883953394 | -122.439858400707 | (37.7590883953394, -122.439858400707) | 2 | 4 | 5 | 28862 | 3 |
13094 | 73612 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3634 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984240.51587 | 2111098.24499 | 37.7757608853724 | -122.498038539599 | (37.7757608853724, -122.498038539599) | 11 | 6 | 2 | 55 | 26 | |||
13776 | 79417 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 195 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6003642.56153 | 2094609.00455 | 37.7316037612939 | -122.429745633281 | (37.7316037612939, -122.429745633281) | 9 | 7 | 5 | 28861 | 25 | |||
13857 | 260533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1514 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982198.3547 | 2104783.64712 | 37.7583028764812 | -122.504634801553 | (37.7583028764812, -122.504634801553) | 1 | 8 | 3 | 56 | 35 | ||
13865 | 69043 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1411 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 3 | Permit Number 33050 | 5983994.9059 | 2105527.4427 | 37.7604506461086 | -122.498476575537 | (37.7604506461086, -122.498476575537) | 1 | 8 | 3 | 56 | 35 | |
13910 | 62589 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3608 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1986 12:00:00 AM | 5 | Permit Number 22895 | 5984370.96748 | 2111102.16317 | 37.7757792910517 | -122.497587570945 | (37.7757792910517, -122.497587570945) | 11 | 6 | 2 | 55 | 26 | |
18838 | 73634 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3729 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x6 | Permit Number 771233 | 5983991.83207 | 2111030.74195 | 37.775560958096 | -122.498893797707 | (37.775560958096, -122.498893797707) | 11 | 6 | 2 | 55 | 26 | |
19348 | 72159 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 141 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000647.86105 | 2092393.26967 | 37.7253498290121 | -122.439940063787 | (37.7253498290121, -122.439940063787) | 9 | 7 | 6 | 28861 | 25 | |||
19369 | 62036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1985 12:00:00 AM | 8 | Permit Number 22111 | 6004501.59533 | 2092915.26272 | 37.7270017298275 | -122.426655215587 | (37.7270017298275, -122.426655215587) | 9 | 7 | 6 | 28861 | 5 | |
20914 | 37196 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1651 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39763 | 5986529.3031 | 2104010.0255 | 37.7564325334524 | -122.489599795635 | (37.7564325334524, -122.489599795635) | 1 | 8 | 3 | 56 | 35 | |
22498 | 92364 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1910 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52777 | 5986038.6 | 2102202.7 | 37.7514414512274 | -122.491163791724 | (37.7514414512274, -122.491163791724) | 1 | 8 | 3 | 29491 | 35 | |
24636 | 48634 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | 1 | 8 | 4 | 56 | 12 | ||
24823 | 38314 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
25592 | 68394 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 252 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | 4 | Permit Number 32222 | 6001581.94485 | 2093980.34457 | 37.7297607041954 | -122.436824590994 | (37.7297607041954, -122.436824590994) | 9 | 7 | 6 | 28861 | 25 | |
26211 | 31637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2550 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767125 | 5981518.05011446 | 2097722.76963447 | 37.7388756474124 | -122.506463924771 | (37.7388756474124, -122.506463924771) | 1 | 8 | 3 | 29491 | 35 | |
27224 | 95764 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 425 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767500 | 6004118.7 | 2090668.4 | 37.7208106862046 | -122.427818850767 | (37.7208106862046, -122.427818850767) | 9 | 7 | 6 | 28861 | 5 | |
27907 | 108600 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
29838 | 258507 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1929 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784311 | 5981324.28824 | 2101940.12469 | 37.7504439167515 | -122.507446677579 | (37.7504439167515, -122.507446677579) | 1 | 8 | 3 | 29491 | 35 | |
29866 | 114323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4425 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776770 | 5981108.5 | 2104807.9 | 37.7583052986358 | -122.508405730376 | (37.7583052986358, -122.508405730376) | 1 | 8 | 3 | 56 | 35 |
31661 | 34649 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1735 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 40399 | 5987784.82467276 | 2103483.81569075 | 37.7550609240819 | -122.485219205847 | (37.7550609240819, -122.485219205847) | 1 | 8 | 3 | 56 | 35 | ||
33188 | 39188 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1189 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.416343098068 | (37.7541746987817, -122.416343098068) | 2 | 4 | 7 | 28859 | 19 | ||
36282 | 38313 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
36865 | 182904 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2958 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782760 | 5981700.1948 | 2096535.1841 | 37.7356255864855 | -122.505746148403 | (37.7356255864855, -122.505746148403) | 1 | 8 | 3 | 29491 | 35 |
39159 | 258206 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1747 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783176 | 5982832.36667 | 2103232.01834 | 37.7540798150651 | -122.502327315989 | (37.7540798150651, -122.502327315989) | 1 | 8 | 3 | 56 | 35 | |
39702 | 39841 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3151 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
43673 | 50397 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 126 Springfield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 3 | Permit Number 47048 | 5986815.96523 | 2095005.27155 | 37.7317246157805 | -122.487946825187 | (37.7317246157805, -122.487946825187) | 1 | 8 | 4 | 64 | 35 | |
43795 | 31943 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1300 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767126 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807627 | (37.761983899941, -122.50916807627) | 1 | 8 | 3 | 56 | 35 | |
43857 | 43115 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 200 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
44967 | 258209 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1843 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783178 | 5982854.24861 | 2102581.60774 | 37.7522952553397 | -122.50220351552 | (37.7522952553397, -122.50220351552) | 1 | 8 | 3 | 56 | 35 | |
46089 | 44437 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 518 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43770 | 6002524.70573 | 2087459.34052 | 37.711909015872 | -122.433099632359 | (37.711909015872, -122.433099632359) | 9 | 7 | 6 | 28861 | 5 | |
46489 | 43221 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 47 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 12 | Permit Number 43010 | 6008377.13505 | 2094049.0426 | 37.7303331919052 | -122.413337641019 | (37.7303331919052, -122.413337641019) | 9 | 3 | 7 | 309 | 28 | |
47345 | 64887 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2516 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | 5 | Permit Number 25913 | 5989259.2592 | 2098145.5523 | 37.7404892410979 | -122.479729655172 | (37.7404892410979, -122.479729655172) | 1 | 8 | 3 | 29491 | 35 | |
47721 | 102066 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 229 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769725 | 6006956.6 | 2097728.3 | 37.7403557640328 | -122.418509430253 | (37.7403557640328, -122.418509430253) | 2 | 7 | 7 | 28859 | 2 |
47743 | 254574 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2343 42nd Ave | : | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781480 | 5983281.30564 | 2099193.73405 | 37.7430181719151 | -122.500476236571 | (37.7430181719151, -122.500476236571) | 1 | 8 | 3 | 29491 | 35 | |
48630 | 45274 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 635 Crescent Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44117 | 6007835.54663504 | 2095717.89639114 | 37.734885079654 | -122.415328087742 | (37.734885079654, -122.415328087742) | 2 | 7 | 7 | 28859 | 2 | ||
50937 | 95708 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392 | 2091652 | 37.7235268927559 | -122.426944152742 | (37.7235268927559, -122.426944152742) | 9 | 7 | 6 | 28861 | 5 | ||
52099 | 258207 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1747 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783176 | 5982832.36667 | 2103232.01834 | 37.7540798150651 | -122.502327315989 | (37.7540798150651, -122.502327315989) | 1 | 8 | 3 | 56 | 35 | |
56843 | 38343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1642 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 6 | Permit Number 40410 | 5982231.0624 | 2103923.0719 | 37.755941904631 | -122.504457930287 | (37.755941904631, -122.504457930287) | 1 | 8 | 3 | 56 | 35 | |
57046 | 46842 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 94 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 5 | Permit Number 44913 | 6004547.7325 | 2093002.72302 | 37.7272444847441 | -122.426501945015 | (37.7272444847441, -122.426501945015) | 9 | 7 | 6 | 28861 | 5 | |
57287 | 65389 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1337 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767119 | 5982116.3204 | 2105935.2005 | 37.7614598881311 | -122.50500384323 | (37.7614598881311, -122.50500384323) | 1 | 8 | 3 | 56 | 35 |
63246 | 31442 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4052 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 5 | Permit Number 35017 | 6002805.98391 | 2102425.30208 | 37.7530180914283 | -122.433196128705 | (37.7530180914283, -122.433196128705) | 2 | 4 | 5 | 28862 | 22 | |
63476 | 62185 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 197 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1985 12:00:00 AM | 76 | Permit Number 22303 | 6000217.71423 | 2092424.50852 | 37.7254111079318 | -122.441429277242 | (37.7254111079318, -122.441429277242) | 9 | 7 | 6 | 28861 | 25 | |
63846 | 92402 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1535 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52802 | 5985244 | 2104754.6 | 37.7584018060121 | -122.494099636368 | (37.7584018060121, -122.494099636368) | 1 | 8 | 3 | 56 | 35 |
68447 | 34722 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3619 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38377 | 5984323.32216 | 2111043.9635 | 37.7756166985977 | -122.497748087301 | (37.7756166985977, -122.497748087301) | 11 | 6 | 2 | 55 | 26 | |
70945 | 48635 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | 1 | 8 | 4 | 56 | 12 | ||
71187 | 34375 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38127 | 6003918.97921609 | 2097483.80532691 | 37.7395129612854 | -122.428994891637 | (37.7395129612854, -122.428994891637) | 2 | 7 | 5 | 63 | 7 | ||
72188 | 108602 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
72417 | 92418 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1242 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52811 | 5984306.481 | 2106711.5777 | 37.7637202145355 | -122.497486421461 | (37.7637202145355, -122.497486421461) | 1 | 8 | 3 | 56 | 35 |
72870 | 258210 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1847 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783179 | 5982855.14026 | 2102555.50761 | 37.7522236440653 | -122.502198500813 | (37.7522236440653, -122.502198500813) | 1 | 8 | 3 | 56 | 35 | |
76551 | 108603 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
78359 | 254250 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 501 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781266 | 5994595.83604 | 2099849.32017 | 37.7454759348774 | -122.461401470121 | (37.7454759348774, -122.461401470121) | 1 | 8 | 4 | 59 | 40 |
79452 | 37197 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1657 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39764 | 5986531.3092 | 2103982.6089 | 37.7563573720907 | -122.489590841888 | (37.7563573720907, -122.489590841888) | 1 | 8 | 3 | 56 | 35 | |
80340 | 95710 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767467 | 6004400.77828 | 2091660.5114 | 37.7235507595459 | -122.426914413678 | (37.7235507595459, -122.426914413678) | 9 | 7 | 6 | 28861 | 5 |
84130 | 109272 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 93X Inverness Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769587 | 5988310.67762 | 2095565.25326 | 37.7333492603097 | -122.482820388184 | (37.7333492603097, -122.482820388184) | 1 | 8 | 4 | 64 | 35 |
84819 | 92433 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2367 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52823 | 5983266.6 | 2099037.7 | 37.7425888819276 | -122.500515549194 | (37.7425888819276, -122.500515549194) | 1 | 8 | 3 | 29491 | 35 | |
85384 | 92427 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1601 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52817 | 5984021 | 2104223.4 | 37.7568716403648 | -122.498290014097 | (37.7568716403648, -122.498290014097) | 1 | 8 | 3 | 56 | 35 | |
88354 | 39743 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3944 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41110 | 6002294.13129656 | 2103577.97626079 | 37.7561540096169 | -122.435048644634 | (37.7561540096169, -122.435048644634) | 2 | 4 | 5 | 28862 | 3 | ||
92810 | 41227 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 82 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 6 | Permit Number 41933 | 6001259.46454 | 2121509.87595 | 37.805331639599 | -122.439912537334 | (37.805331639599, -122.439912537334) | 13 | 9 | 1 | 57 | 17 | |
93049 | 52308 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464@ NOE 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48468 | 6003585.05710238 | 2098376.65012733 | 37.7419456008039 | -122.430213129043 | (37.7419456008039, -122.430213129043) | 2 | 7 | 5 | 63 | 22 | ||
94357 | 92495 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3626 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52865 | 5981730 | 2097424 | 37.7380677850415 | -122.505708970967 | (37.7380677850415, -122.505708970967) | 1 | 8 | 3 | 29491 | 35 | |
97807 | 39840 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3151 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41160 | 5984281.43555925 | 2102217.56111428 | 37.7513794309419 | -122.49724128025 | (37.7513794309419, -122.49724128025) | 1 | 8 | 3 | 29491 | 35 | ||
98714 | 109257 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1529 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773445 | 5982142.3 | 2104666.9 | 37.7579790245493 | -122.504820009244 | (37.7579790245493, -122.504820009244) | 1 | 8 | 3 | 56 | 35 |
101855 | 78576 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 574 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | Permit Number 781441 | 6009888.44286 | 2088699.06024 | 37.7157279923247 | -122.407735729826 | (37.7157279923247, -122.407735729826) | 9 | 7 | 8 | 309 | 39 | |
103931 | 34376 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 159 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38128 | 6003933.5588278 | 2097472.84374368 | 37.7394836885423 | -122.42894370039 | (37.7394836885423, -122.42894370039) | 2 | 7 | 5 | 63 | 7 | ||
104306 | 95232 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1337 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767119 | 5982117.2717 | 2105915.2232 | 37.7614050921406 | -122.504999072655 | (37.7614050921406, -122.504999072655) | 1 | 8 | 3 | 56 | 35 |
107889 | 38373 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3741 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2014 12:00:00 AM | Permit Number 40432 | 5982426.74388672 | 2102835.76429046 | 37.7529679717779 | -122.503700690636 | (37.7529679717779, -122.503700690636) | 1 | 8 | 3 | 56 | 35 | ||
109633 | 37495 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1050 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42243 | 5991661.12122197 | 2105245.54821547 | 37.7601232248942 | -122.471942379719 | (37.7601232248942, -122.471942379719) | 1 | 8 | 4 | 56 | 12 | ||
116665 | 38307 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
119223 | 103416 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394 | 2098432 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | 1 | 8 | 4 | 29491 | 40 | |
123422 | 52483 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 650MAYFLOWER Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48593 | 6009757.2999459 | 2098381.34570201 | 37.7423061581468 | -122.408871740084 | (37.7423061581468, -122.408871740084) | 10 | 7 | 7 | 28859 | 2 | ||
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
124208 | 47894 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 463 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2002 12:00:00 AM | 2 | Permit Number 45638 | 6001143.6139 | 2110345.6912 | 37.774671088282 | -122.439512642863 | (37.774671088282, -122.439512642863) | 15 | 5 | 11 | 29492 | 10 | |
125371 | 92405 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1549 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52804 | 5985246.8 | 2104672.6 | 37.7581768205908 | -122.494083909336 | (37.7581768205908, -122.494083909336) | 1 | 8 | 3 | 56 | 35 | |
125459 | 83542 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 5980747.69672 | 2109761.67142 | 37.7718856460039 | -122.510021541764 | (37.7718856460039, -122.510021541764) | 11 | 6 | 2 | 55 | 26 | ||
128324 | 258505 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1478 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784309 | 5981260.22939 | 2105014.83778 | 37.7588824314433 | -122.507896350106 | (37.7588824314433, -122.507896350106) | 1 | 8 | 3 | 56 | 35 |
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) );