trees
301 rows where qLegalStatus_id = 1 and qSpecies_id = 47 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181949 | 218284 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50x Junipero Serra Frontage West | 0 | Median : Yard | Tree | DPW 1 | 28 | 5991438.8932 | 2095398.77837 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | 1 | 8 | 4 | 64 | 40 | ||||
93 | 260525 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3437x Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
929 | 257972 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5982601.27724 | 2100898.28737 | 37.7476584613609 | -122.502953711343 | (37.7476584613609, -122.502953711343) | 1 | 8 | 3 | 29491 | 35 | ||||
2561 | 50575 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1347 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | 0 | Permit Number 47190 | 5983353.97136461 | 2105974.76120709 | 37.7616412492229 | -122.50072631562 | (37.7616412492229, -122.50072631562) | 1 | 8 | 3 | 56 | 35 | |
4229 | 80358 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6011201.39619 | 2088230.44969 | 37.7145146953757 | -122.403164591892 | (37.7145146953757, -122.403164591892) | 10 | 7 | 8 | 309 | 39 | |||
4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
8913 | 50707 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1658 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 5 | Permit Number 47266 | 5983788.66504778 | 2103867.70402192 | 37.75588137239 | -122.499067221884 | (37.75588137239, -122.499067221884) | 1 | 8 | 3 | 56 | 35 | |
9810 | 257975 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2151 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5981994.87893 | 2100458.26928 | 37.7464146351308 | -122.505017963467 | (37.7464146351308, -122.505017963467) | 1 | 8 | 3 | 29491 | 35 | |||
9903 | 257976 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2518 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982121.52259 | 2097949.45155 | 37.7395335660245 | -122.504394221806 | (37.7395335660245, -122.504394221806) | 1 | 8 | 3 | 29491 | 35 | |||
11025 | 257974 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2442 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982413.68522 | 2098481.44408 | 37.7410114510299 | -122.503423449602 | (37.7410114510299, -122.503423449602) | 1 | 8 | 3 | 29491 | 35 | |||
13168 | 48530 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2251 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | 6 | Permit Number 45852 | 5988214.95937948 | 2099991.18132471 | 37.7454961303111 | -122.483475662249 | (37.7454961303111, -122.483475662249) | 1 | 8 | 3 | 29491 | 35 | |
13580 | 260528 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2079 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982908.95776 | 2100987.30444 | 37.7479209564484 | -122.501896372368 | (37.7479209564484, -122.501896372368) | 1 | 8 | 3 | 29491 | 35 | ||
18160 | 79486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | 1 | 8 | 3 | 29491 | 35 | |
18824 | 257973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1527 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5982781.38466 | 2104724.90462 | 37.7581758647866 | -122.502614113501 | (37.7581758647866, -122.502614113501) | 1 | 8 | 3 | 56 | 35 | |||
19152 | 257977 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1675 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 5984366.45643 | 2103783.81819 | 37.7556849216133 | -122.497062869805 | (37.7556849216133, -122.497062869805) | 1 | 8 | 3 | 56 | 35 | |||
19390 | 47850 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1342 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 7 | Permit Number 45609 | 5983405.04544412 | 2106002.56953842 | 37.7617206013965 | -122.500551730195 | (37.7617206013965, -122.500551730195) | 1 | 8 | 3 | 56 | 35 | |
21677 | 51414 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1531 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 0 | Permit Number 47738 | 5988357.88494646 | 2104888.81015522 | 37.7589520258954 | -122.48334041038 | (37.7589520258954, -122.48334041038) | 1 | 8 | 3 | 56 | 35 | |
24415 | 119095 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | 11 | 6 | 2 | 55 | 26 | |||
28693 | 191372 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011446.77315 | 2104664.66226 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | 10 | 3 | 8 | 28856 | 29 | |||
29184 | 176980 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5999548.76247 | 2089280.82364 | 37.7167411370713 | -122.443516055124 | (37.7167411370713, -122.443516055124) | 9 | 7 | 6 | 28861 | 25 | |||
30568 | 129464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | 13 | 9 | 1 | 28858 | 27 | |||
30997 | 1213 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3411 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5993897.04108 | 2087339.7447 | 37.7110874546042 | -122.462910367622 | (37.7110874546042, -122.462910367622) | 9 | 8 | 4 | 64 | 24 | |||
34278 | 181438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | 1 | 8 | 3 | 56 | 35 | |||
36662 | 121603 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | 10 | 3 | 8 | 28856 | 29 | |||
37486 | 46399 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2110 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 5 | Permit Number 44629 | 5981721.80383178 | 2100709.75793181 | 37.7470890826019 | -122.505980852245 | (37.7470890826019, -122.505980852245) | 1 | 8 | 3 | 29491 | 35 | |
40263 | 227676 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 427 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | 2 | 7 | 5 | 63 | 22 | ||||
42527 | 207128 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991324.62806 | 2095649.61894 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | 1 | 8 | 4 | 64 | 40 | |||
43157 | 227687 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.451424345184 | (37.7653509793933, -122.451424345184) | 15 | 5 | 11 | 29492 | 9 | |||
43896 | 38348 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1607 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 0 | Permit Number 40415 | 5981863.96536039 | 2104143.69244361 | 37.7565260672017 | -122.505743805317 | (37.7565260672017, -122.505743805317) | 1 | 8 | 3 | 56 | 35 | |
43944 | 184307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | 1 | 8 | 3 | 56 | 35 | |||
46544 | 183430 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | 1 | 8 | 3 | 29491 | 35 | |||
46607 | 176987 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 5ft | 6002815.8897 | 2094148.38707 | 37.7302921639516 | -122.432570708688 | (37.7302921639516, -122.432570708688) | 9 | 7 | 5 | 28861 | 25 | |||
46709 | 191390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | 10 | 3 | 8 | 28856 | 29 | ||||
47089 | 12917 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | 9 | 7 | 6 | 28861 | 25 | |||
47837 | 227688 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.7407809344798 | -122.41570987722 | (37.7407809344798, -122.41570987722) | 2 | 7 | 7 | 28859 | 2 | |||
49514 | 227681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5997959.25406 | 2106183.43699 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | 15 | 5 | 11 | 29492 | 9 | |||
50593 | 83239 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
56036 | 909 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003163.68633 | 2094174.89484 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | 9 | 7 | 6 | 28861 | 25 | |||
56832 | 227680 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1541 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003988.60954 | 2099295.31119 | 37.7444908816604 | -122.428883253577 | (37.7444908816604, -122.428883253577) | 2 | 7 | 5 | 63 | 22 | |||
58446 | 183252 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5980914.4873 | 2106074.217 | 37.7617708050911 | -122.509170734828 | (37.7617708050911, -122.509170734828) | 1 | 8 | 3 | 56 | 35 | |||
58452 | 101254 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3700X Cesar Chavez St | 1 | Front Yard : Yard | Tree | DPW 1 | 6005840.6 | 2100555.6 | 37.7480559984104 | -122.422568977073 | (37.7480559984104, -122.422568977073) | 2 | 4 | 5 | 28859 | 19 | |||||
58696 | 119085 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5982037.396 | 2109722.65545 | 37.7718545033558 | -122.505557564286 | (37.7718545033558, -122.505557564286) | 11 | 6 | 2 | 55 | 26 | |||
59598 | 191367 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 548 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6011194.69766 | 2105791.52689 | 37.7627332975312 | -122.404423107658 | (37.7627332975312, -122.404423107658) | 8 | 3 | 8 | 28856 | 29 | |||
61805 | 47082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.7783138890322 | -122.45454486672 | (37.7783138890322, -122.45454486672) | 15 | 6 | 2 | 54 | 16 | |
63319 | 207110 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | 9 | 8 | 6 | 64 | 24 | ||||
63526 | 882 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.97393 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | 9 | 7 | 5 | 28861 | 25 | ||
63902 | 46390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2447 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 7 | Permit Number 44623 | 5982678.99712077 | 2098464.70885711 | 37.7409810943186 | -122.502504874921 | (37.7409810943186, -122.502504874921) | 1 | 8 | 3 | 29491 | 35 | |
64416 | 183208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.7401199309313 | -122.501448961428 | (37.7401199309313, -122.501448961428) | 1 | 8 | 3 | 29491 | 35 | |||
68936 | 13417 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 400 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 70 | 5 | 5999553.15658 | 2097034.91654 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | 9 | 7 | 4 | 59 | 40 | |||
76454 | 227670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005513.92482 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | 2 | 4 | 5 | 28859 | 19 | |||
77195 | 237551 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.7604095509682 | -122.430689380017 | (37.7604095509682, -122.430689380017) | 2 | 4 | 5 | 28862 | 3 | |
77625 | 32594 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1379 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 1 | Permit Number 37062 | 5985531.05347187 | 2105840.85496484 | 37.7614011533067 | -122.49318691517 | (37.7614011533067, -122.49318691517) | 1 | 8 | 3 | 56 | 35 | |
77789 | 201278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 28 Lydia Ave | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | 10 | 3 | 8 | 58 | 1 | |||
80406 | 247869 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 394 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | 10 | 7 | 7 | 28859 | 2 | ||||
84866 | 227691 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006868.92044 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | 2 | 7 | 7 | 28859 | 2 | |||
89012 | 227683 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 923 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007409.88053 | 2101914.88747 | 37.7518767015549 | -122.417238758882 | (37.7518767015549, -122.417238758882) | 2 | 4 | 7 | 28859 | 19 | |||
89095 | 46395 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.7475625528023 | -122.505118527994 | (37.7475625528023, -122.505118527994) | 1 | 8 | 3 | 29491 | 35 | |
90219 | 41465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2000 12:00:00 AM | 24 | Permit Number 42050 | 5983633.32729372 | 2103553.20607522 | 37.755008735539 | -122.499581179885 | (37.755008735539, -122.499581179885) | 1 | 8 | 3 | 56 | 35 | ||
93238 | 129477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.400872298239 | (37.8024687881724, -122.400872298239) | 3 | 1 | 10 | 28860 | 6 | ||||
93754 | 227689 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008214.29979 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | 2 | 7 | 7 | 28859 | 2 | |||
97332 | 83208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | 1 | 8 | 3 | 29491 | 35 | |
98973 | 250332 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 141 27th Ave | 1 | : | Tree | Private 2 | 05/08/2002 12:00:00 AM | 4 | Width 3ft | Permit Number 45150 | 5987387.77846 | 2115003.34197 | 37.7866671925889 | -122.487438428541 | (37.7866671925889, -122.487438428541) | 11 | 6 | 1 | 55 | 33 | |
99585 | 59481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2019 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | 11 | 6 | 2 | 54 | 11 | ||
100650 | 78557 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | 1 | 8 | 3 | 29491 | 35 | |
100968 | 1262 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | |||
102436 | 184168 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3732 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5982616.4158 | 2104253.9424 | 37.7568730399942 | -122.503149769389 | (37.7568730399942, -122.503149769389) | 1 | 8 | 3 | 56 | 35 | |||
102767 | 109138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.40132 | 2110729.9835 | 37.7748156320332 | -122.494120186241 | (37.7748156320332, -122.494120186241) | 11 | 6 | 2 | 55 | 26 |
102941 | 227682 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008186.7931 | 2096476.12564 | 37.7369867469298 | -122.41416732858 | (37.7369867469298, -122.41416732858) | 2 | 7 | 7 | 28859 | 2 | |||
103582 | 83279 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.4490102 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | 1 | 8 | 3 | 29491 | 35 | |
107125 | 84447 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.7443211838051 | -122.503635505549 | (37.7443211838051, -122.503635505549) | 1 | 8 | 3 | 29491 | 35 | |
107383 | 54526 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.92324 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | 11 | 6 | 2 | 55 | 26 | ||
107721 | 23670 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 317 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006937.9415449 | 2098264.8464559 | 37.7418279505329 | -122.41861198258 | (37.7418279505329, -122.41861198258) | 2 | 7 | 7 | 28859 | 2 | |||
108342 | 35388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.15832 | 2104840.46729 | 37.7601281288176 | -122.403970671318 | (37.7601281288176, -122.403970671318) | 10 | 3 | 8 | 28856 | 29 | |
113945 | 50219 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2726 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2004 12:00:00 AM | 8 | 3x3 | Permit Number 46926 | 5987073.25597 | 2111201.47184 | 37.776209992885 | -122.488247096133 | (37.776209992885, -122.488247096133) | 11 | 6 | 2 | 55 | 26 |
114789 | 207103 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.7260456803487 | -122.457364540844 | (37.7260456803487, -122.457364540844) | 9 | 7 | 4 | 28861 | 40 | |||
115683 | 129467 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6006504.31748 | 2119710.78815 | 37.8006889650949 | -122.421634156713 | (37.8006889650949, -122.421634156713) | 13 | 9 | 1 | 28858 | 32 | |||
118542 | 138270 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.449227076582 | (37.7809154323836, -122.449227076582) | 15 | 6 | 2 | 54 | 16 | |||
122107 | 46973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 7 | Permit Number 44992 | 5982214.0178657 | 2102979.50871383 | 37.7533501437558 | -122.504446973742 | (37.7533501437558, -122.504446973742) | 1 | 8 | 3 | 56 | 35 | |
123108 | 227677 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003907.02908 | 2099270.15617 | 37.7444171939021 | -122.429163548878 | (37.7444171939021, -122.429163548878) | 2 | 7 | 5 | 63 | 22 | |||
123946 | 83251 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | 1 | 8 | 3 | 29491 | 35 | |
127819 | 227694 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999877.66163 | 2104769.07166 | 37.7592869569347 | -122.443491144794 | (37.7592869569347, -122.443491144794) | 2 | 4 | 5 | 28862 | 3 | |||
128532 | 52554 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1719 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 8 | Permit Number 48649 | 5984370.92860727 | 2103469.2332855 | 37.754821420905 | -122.497024185091 | (37.754821420905, -122.497024185091) | 1 | 8 | 3 | 56 | 35 | |
128589 | 18878 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6003659.52132 | 2115878.15996 | 37.7900047293604 | -122.431204600475 | (37.7900047293604, -122.431204600475) | 13 | 9 | 1 | 29490 | 27 | |||
131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 | ||||
132662 | 176986 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.432060704959 | (37.7170867510327, -122.432060704959) | 9 | 7 | 6 | 28861 | 5 | |||
134083 | 24808 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.495623106999 | (37.7794670623637, -122.495623106999) | 11 | 6 | 2 | 55 | 26 | ||
134621 | 227679 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 361 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003556.92712 | 2099495.03666 | 37.7450148383554 | -122.430390170187 | (37.7450148383554, -122.430390170187) | 2 | 7 | 5 | 63 | 22 | |||
136029 | 186000 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | 1 | 8 | 3 | 56 | 35 | |||
137873 | 227692 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006684.36987 | 2096973.81613 | 37.7382687898828 | -122.419397184857 | (37.7382687898828, -122.419397184857) | 2 | 7 | 7 | 28859 | 2 | |||
142493 | 227693 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002979.94012 | 2100929.17253 | 37.7489199393117 | -122.432487701248 | (37.7489199393117, -122.432487701248) | 2 | 4 | 5 | 28862 | 22 | |||
145811 | 129483 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012307.75016 | 2120551.40866 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | 3 | 1 | 10 | 28860 | 6 | ||||
145982 | 227697 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | 15 | 9 | 11 | 29492 | 10 | |||
146162 | 207104 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | 9 | 8 | 4 | 28861 | 24 | |||
147419 | 227696 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003774.74871 | 2108065.24722 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | 7 | 9 | 5 | 28862 | 3 | |||
148288 | 30756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.7297880302088 | -122.390362726863 | (37.7297880302088, -122.390362726863) | 10 | 3 | 8 | 58 | 1 | |
149652 | 183373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.7365485996681 | -122.492356136884 | (37.7365485996681, -122.492356136884) | 1 | 8 | 3 | 29491 | 35 | |||
150862 | 234 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | 1 | 8 | 4 | 64 | 40 | |||
155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
158350 | 37082 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.7629344086854 | -122.504939947841 | (37.7629344086854, -122.504939947841) | 1 | 8 | 3 | 56 | 35 | |
159025 | 253462 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );