trees
3,965 rows where qSpecies_id = 70 sorted by Longitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5572 | 250632 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 161 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2020 12:00:00 AM | 3 | Width 4ft | 5987122.25317 | 2114703.48842 | 37.7858283922212 | -122.488335025649 | (37.7858283922212, -122.488335025649) | 11 | 6 | 1 | 55 | 33 | ||
176243 | 120031 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5250 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5987022.08125 | 2109836.66026 | 37.7724596185968 | -122.48832379876 | (37.7724596185968, -122.48832379876) | 11 | 6 | 2 | 55 | 26 | |||
64813 | 184114 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986907.3806 | 2104346.5993 | 37.7573787390227 | -122.488317021639 | (37.7573787390227, -122.488317021639) | 1 | 8 | 3 | 56 | 35 | |||
188104 | 181917 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986799.7038 | 2098962.0068 | 37.742587818431 | -122.488293710215 | (37.742587818431, -122.488293710215) | 1 | 8 | 3 | 29491 | 35 | |||
81290 | 184115 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986923.9656 | 2104348.9686 | 37.7573862121067 | -122.488259839014 | (37.7573862121067, -122.488259839014) | 1 | 8 | 3 | 56 | 35 | |||
191678 | 250948 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987141.62407 | 2114456.19432 | 37.7851505237326 | -122.488249829271 | (37.7851505237326, -122.488249829271) | 11 | 6 | 1 | 55 | 33 | |||
140151 | 250947 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987142.15773 | 2114445.06147 | 37.7851199872528 | -122.488247164595 | (37.7851199872528, -122.488247164595) | 11 | 6 | 1 | 55 | 33 | |||
116700 | 181916 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986816.6249 | 2098962.0068 | 37.7425888056646 | -122.488235202776 | (37.7425888056646, -122.488235202776) | 1 | 8 | 3 | 29491 | 35 | |||
173094 | 250936 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 242 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987145.66978 | 2114320.34633 | 37.7847777601171 | -122.488225846157 | (37.7847777601171, -122.488225846157) | 11 | 6 | 1 | 55 | 33 | |||
159823 | 120029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5250 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5987050.66926 | 2109837.22224 | 37.7724628295561 | -122.488224952649 | (37.7724628295561, -122.488224952649) | 11 | 6 | 2 | 55 | 26 | |||
12631 | 184116 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986935.2197 | 2104347.7839 | 37.7573836158365 | -122.488220831337 | (37.7573836158365, -122.488220831337) | 1 | 8 | 3 | 56 | 35 | |||
97362 | 181915 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2048 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5986837.2686 | 2098963.0221 | 37.7425927977912 | -122.488163898435 | (37.7425927977912, -122.488163898435) | 1 | 8 | 3 | 29491 | 35 | |||
39521 | 107816 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 28TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x20 | 5987167.1 | 2114462.1 | 37.7851682253333 | -122.488162125765 | (37.7851682253333, -122.488162125765) | 11 | 6 | 1 | 55 | 33 | |||
153060 | 107823 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 398X 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987151.97458 | 2113602.02096 | 37.7828058118879 | -122.488151230918 | (37.7828058118879, -122.488151230918) | 11 | 6 | 2 | 55 | 26 | |||||
118024 | 120026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5250 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5987096.14835 | 2109840.54395 | 37.7724746032715 | -122.488067882219 | (37.7724746032715, -122.488067882219) | 11 | 6 | 2 | 55 | 26 | |||
170966 | 119958 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 390 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 5987178.70631 | 2113353.98643 | 37.7821263392946 | -122.488040520452 | (37.7821263392946, -122.488040520452) | 11 | 6 | 2 | 55 | 26 | |||
73508 | 185850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2043 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5986926.729 | 2101352.0698 | 37.7491577020716 | -122.488030079433 | (37.7491577020716, -122.488030079433) | 1 | 8 | 3 | 29491 | 35 | |||
116856 | 122577 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1910 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5986950.4943 | 2102242.1927 | 37.7516031257756 | -122.488013295456 | (37.7516031257756, -122.488013295456) | 1 | 8 | 3 | 29491 | 35 | |||
153666 | 122576 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1910 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 779012 | 5986951.5849 | 2102234.0134 | 37.7515807312502 | -122.488008923136 | (37.7515807312502, -122.488008923136) | 1 | 8 | 3 | 29491 | 35 | ||
146109 | 122575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1910 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5986952.1301 | 2102222.5625 | 37.7515493219791 | -122.48800619649 | (37.7515493219791, -122.48800619649) | 1 | 8 | 3 | 29491 | 35 | |||
34056 | 64237 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.7787939955639 | -122.487946016766 | (37.7787939955639, -122.487946016766) | 11 | 6 | 2 | 55 | 26 | |
95642 | 181662 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1291 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5987065.688 | 2106524.6306 | 37.7633682504544 | -122.487929566047 | (37.7633682504544, -122.487929566047) | 1 | 8 | 3 | 56 | 35 | |||
139753 | 181663 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1291 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5987066.8691 | 2106497.4655 | 37.7632937314808 | -122.487923485 | (37.7632937314808, -122.487923485) | 1 | 8 | 3 | 56 | 35 | |||
111113 | 122608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | 1 | 8 | 3 | 56 | 35 | |||
135977 | 122607 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1214 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5987094.0342 | 2106930.3359 | 37.7644838586853 | -122.487861336886 | (37.7644838586853, -122.487861336886) | 1 | 8 | 3 | 56 | 35 | |||
101570 | 181749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1222 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5987094.6248 | 2106906.7141 | 37.7644190342007 | -122.487857558517 | (37.7644190342007, -122.487857558517) | 1 | 8 | 3 | 56 | 35 | |||
147478 | 181651 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1276 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5987105.2546 | 2106601.9922 | 37.76358297204 | -122.487798403936 | (37.76358297204, -122.487798403936) | 1 | 8 | 3 | 56 | 35 | |||
179748 | 181664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1292 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5987108.2073 | 2106527.5834 | 37.7633788382288 | -122.48778272451 | (37.7633788382288, -122.48778272451) | 1 | 8 | 3 | 56 | 35 | |||
83887 | 110557 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987235.91404 | 2111803.79765 | 37.7778732980336 | -122.487728686455 | (37.7778732980336, -122.487728686455) | 11 | 6 | 2 | 55 | 26 | |
49237 | 250322 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 27th Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5987406.48872 | 2114540.6222 | 37.785397787832 | -122.487339695585 | (37.785397787832, -122.487339695585) | 11 | 6 | 1 | 55 | 33 | |||
190379 | 182719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1704 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5987209.8948 | 2103643.7982 | 37.7554666839422 | -122.487219202852 | (37.7554666839422, -122.487219202852) | 1 | 8 | 3 | 56 | 35 | |||
160960 | 182720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1702 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5987211.5197 | 2103658.0161 | 37.7555058171847 | -122.487214627754 | (37.7555058171847, -122.487214627754) | 1 | 8 | 3 | 56 | 35 | |||
75468 | 182717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1708 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5987211.1135 | 2103616.1749 | 37.75539090893 | -122.487212959481 | (37.75539090893, -122.487212959481) | 1 | 8 | 3 | 56 | 35 | |||
167078 | 182718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1706 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5987211.5197 | 2103626.3305 | 37.7554188171353 | -122.487212300611 | (37.7554188171353, -122.487212300611) | 1 | 8 | 3 | 56 | 35 | |||
66883 | 181726 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2701 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987306.6309 | 2107085.0591 | 37.7649210846351 | -122.487137397154 | (37.7649210846351, -122.487137397154) | 1 | 8 | 3 | 56 | 35 | |||
70582 | 181725 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1213 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5987358.0084 | 2107002.6779 | 37.7646978842844 | -122.486953647238 | (37.7646978842844, -122.486953647238) | 1 | 8 | 3 | 56 | 35 | |||
38763 | 181771 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1249 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 5987360.9611 | 2106759.0775 | 37.764029196909 | -122.486925543944 | (37.764029196909, -122.486925543944) | 1 | 8 | 3 | 56 | 35 | |||
134746 | 181772 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5987362.7328 | 2106740.7706 | 37.7639790345028 | -122.486918071733 | (37.7639790345028, -122.486918071733) | 1 | 8 | 3 | 56 | 35 | |||
171949 | 181720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1212 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987401.7088 | 2107010.6502 | 37.7647223218617 | -122.486803086498 | (37.7647223218617, -122.486803086498) | 1 | 8 | 3 | 56 | 35 | |||
125698 | 182049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1335 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987388.6798 | 2106170.4352 | 37.7624145631588 | -122.486786445953 | (37.7624145631588, -122.486786445953) | 1 | 8 | 3 | 56 | 35 | |||
53839 | 182048 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1335 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987389.1636 | 2106183.4986 | 37.7624504598719 | -122.486785732011 | (37.7624504598719, -122.486785732011) | 1 | 8 | 3 | 56 | 35 | |||
147233 | 51789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | 1 | 8 | 3 | 56 | 35 | ||
128374 | 105220 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1443 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5987410.3461 | 2105455.8349 | 37.7604537297774 | -122.486659037253 | (37.7604537297774, -122.486659037253) | 1 | 8 | 3 | 56 | 35 | |||
151512 | 182041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 13427 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987431.7408 | 2106123.9873 | 37.762289540332 | -122.486634105115 | (37.762289540332, -122.486634105115) | 1 | 8 | 3 | 56 | 35 | |||
12035 | 182056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1338 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5987434.16 | 2106158.3393 | 37.7623840025198 | -122.486628260583 | (37.7623840025198, -122.486628260583) | 1 | 8 | 3 | 56 | 35 | |||
102880 | 120066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987632.04577 | 2115290.91646 | 37.7874710320346 | -122.486614456615 | (37.7874710320346, -122.486614456615) | 11 | 6 | 1 | 55 | 33 | |||
160477 | 120067 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987646.00495 | 2115291.68795 | 37.7874739640581 | -122.486566217974 | (37.7874739640581, -122.486566217974) | 11 | 6 | 1 | 55 | 33 | |||
135465 | 182050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1342 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987455 | 2106133 | 37.7623156426071 | -122.486554323091 | (37.7623156426071, -122.486554323091) | 1 | 8 | 3 | 56 | 35 | |||
179897 | 120068 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5987657.80478 | 2115291.79347 | 37.7874749416269 | -122.486525401231 | (37.7874749416269, -122.486525401231) | 11 | 6 | 1 | 55 | 33 | |||
108388 | 120069 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301 El Camino Del Mar | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987671.41415 | 2115292.92868 | 37.7874788518943 | -122.486478399556 | (37.7874788518943, -122.486478399556) | 11 | 6 | 1 | 55 | 33 | |||
139431 | 120071 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987688.6545 | 2115263.01404 | 37.7873977198016 | -122.486416555063 | (37.7873977198016, -122.486416555063) | 11 | 6 | 1 | 55 | 33 | |||
146062 | 120072 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987688.32967 | 2115247.71242 | 37.7873556870051 | -122.486416555037 | (37.7873556870051, -122.486416555037) | 11 | 6 | 1 | 55 | 33 | |||
138086 | 120073 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 26th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5987689.48695 | 2115234.87158 | 37.787320497195 | -122.486411608023 | (37.787320497195, -122.486411608023) | 11 | 6 | 1 | 55 | 33 | |||
109603 | 106122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 163 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5987700.63122 | 2114917.78588 | 37.7864505202379 | -122.486349763522 | (37.7864505202379, -122.486349763522) | 11 | 6 | 1 | 55 | 33 | ||||
67163 | 106123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 163 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5987700.35927 | 2114904.97497 | 37.7864153292934 | -122.486349763511 | (37.7864153292934, -122.486349763511) | 11 | 6 | 1 | 55 | 33 | ||||
155803 | 61642 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 275 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1987 12:00:00 AM | 13 | Permit Number 24615 | 5987729.03906 | 2114139.72181 | 37.7843158342142 | -122.486194341479 | (37.7843158342142, -122.486194341479) | 11 | 6 | 1 | 55 | 26 | ||
123098 | 112590 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1899x VICENTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5987396 | 2097538 | 37.7387126443172 | -122.486127408072 | (37.7387126443172, -122.486127408072) | 1 | 8 | 3 | 29491 | 35 | |||
162928 | 248978 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987396 | 2097538 | 37.7387126443172 | -122.486127408072 | (37.7387126443172, -122.486127408072) | 1 | 8 | 3 | 29491 | 35 | ||||
53944 | 119925 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3500 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5987749.19895 | 2111901.68542 | 37.7781719954093 | -122.485960263892 | (37.7781719954093, -122.485960263892) | 11 | 6 | 2 | 55 | 26 | |||
26794 | 181716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1213 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5987666.2736 | 2107069.7049 | 37.7648998904527 | -122.485892372819 | (37.7648998904527, -122.485892372819) | 1 | 8 | 3 | 56 | 35 | |||
115451 | 181323 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1213 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5987666.8641 | 2107043.7208 | 37.7648285796785 | -122.485888423088 | (37.7648285796785, -122.485888423088) | 1 | 8 | 3 | 56 | 35 | |||
175572 | 89458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.87116 | 37.7781711994801 | -122.485874733482 | (37.7781711994801, -122.485874733482) | 11 | 6 | 2 | 55 | 26 | ||
52371 | 181744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1225 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987668.6357 | 2106917.9345 | 37.7644833083532 | -122.485873062375 | (37.7644833083532, -122.485873062375) | 1 | 8 | 3 | 56 | 35 | |||
14017 | 181325 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1229 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5987669.8168 | 2106894.9032 | 37.7644201395656 | -122.485867286736 | (37.7644201395656, -122.485867286736) | 1 | 8 | 3 | 56 | 35 | |||
56189 | 181763 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1233 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5987669.8168 | 2106871.8719 | 37.7643569019511 | -122.48586559615 | (37.7643569019511, -122.48586559615) | 1 | 8 | 3 | 56 | 35 | |||
36060 | 102802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.7641413829477 | -122.485851660773 | (37.7641413829477, -122.485851660773) | 1 | 8 | 3 | 56 | 35 | |||
168777 | 181315 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1253 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5987674.5412 | 2106741.3611 | 37.7639988304821 | -122.485839676117 | (37.7639988304821, -122.485839676117) | 1 | 8 | 3 | 56 | 35 | |||
62596 | 181656 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1285 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5987682.8089 | 2106547.6619 | 37.7634674674642 | -122.48579686326 | (37.7634674674642, -122.48579686326) | 1 | 8 | 3 | 56 | 35 | |||
151168 | 106648 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1293 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5987685.171 | 2106501.0088 | 37.7633395085014 | -122.485785269283 | (37.7633395085014, -122.485785269283) | 1 | 8 | 3 | 56 | 35 | ||||
85035 | 38476 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 19 | Permit Number 40477 | 5987961.29875 | 2115305.89755 | 37.7875313539503 | -122.485476422304 | (37.7875313539503, -122.485476422304) | 11 | 6 | 1 | 55 | 33 | ||
174908 | 94796 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 5987953.6 | 2114461.6 | 37.7852127054212 | -122.485441077382 | (37.7852127054212, -122.485441077382) | 11 | 6 | 2 | 55 | 26 | ||||
45267 | 38477 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 12 | Permit Number 40477 | 5987973.38245 | 2115305.78698 | 37.7875317543588 | -122.48543460753 | (37.7875317543588, -122.48543460753) | 11 | 6 | 1 | 55 | 33 | ||
22416 | 38478 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 21 | Permit Number 40477 | 5987978.37889 | 2115306.2666 | 37.7875333623487 | -122.485417356275 | (37.7875333623487, -122.485417356275) | 11 | 6 | 1 | 55 | 33 | ||
88901 | 250545 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 5ft | 5987996.34438 | 2115386.34239 | 37.7877542741995 | -122.485361078263 | (37.7877542741995, -122.485361078263) | 11 | 6 | 1 | 55 | 33 | |||
96918 | 120378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5987994.968 | 2115215.60018 | 37.7872853847458 | -122.485353306378 | (37.7872853847458, -122.485353306378) | 11 | 6 | 1 | 55 | 33 | |||
6793 | 106402 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 163 25TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | 5987994.2 | 2114906.9 | 37.7864377375077 | -122.485333302781 | (37.7864377375077, -122.485333302781) | 11 | 6 | 1 | 55 | 33 | ||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
16802 | 52926 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 48909 | 5988008.14773 | 2114828.39565 | 37.7862229995097 | -122.485279285217 | (37.7862229995097, -122.485279285217) | 11 | 6 | 1 | 55 | 33 | |
114544 | 94795 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 223 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | 12 | 2x2 | Permit Number 53893 | 5988023.34122 | 2114443.34668 | 37.7851666498848 | -122.485198457494 | (37.7851666498848, -122.485198457494) | 11 | 6 | 2 | 55 | 26 | |
21042 | 67608 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 261 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31186 | 5988028.8714 | 2114260.18154 | 37.7846640526933 | -122.485165880985 | (37.7846640526933, -122.485165880985) | 11 | 6 | 2 | 55 | 26 | ||
112143 | 115916 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 263 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5988029.82633 | 2114231.08549 | 37.7845842188438 | -122.485160441701 | (37.7845842188438, -122.485160441701) | 11 | 6 | 2 | 55 | 26 | |||
105800 | 183587 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987684.8952 | 2097383.7142 | 37.7383058487898 | -122.485117240602 | (37.7383058487898, -122.485117240602) | 1 | 8 | 3 | 29491 | 35 | |||
182209 | 120229 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5988059.54578 | 2114898.14727 | 37.7864175116346 | -122.485106583196 | (37.7864175116346, -122.485106583196) | 11 | 6 | 1 | 55 | 33 | |||
165444 | 120228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 172 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781953 | 5988061.30942 | 2114851.82661 | 37.7862904310499 | -122.485097081718 | (37.7862904310499, -122.485097081718) | 11 | 6 | 1 | 55 | 33 | |
48043 | 102629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | 11 | 6 | 1 | 55 | 33 | |||
47715 | 183466 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2530 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5987709.9228 | 2098041.7281 | 37.7401140398894 | -122.485078973207 | (37.7401140398894, -122.485078973207) | 1 | 8 | 3 | 29491 | 35 | |||
60364 | 113532 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
101568 | 113533 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
132279 | 113531 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 28 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | |||
170016 | 102630 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988081.5 | 2114873.1 | 37.7863500177909 | -122.485028789744 | (37.7863500177909, -122.485028789744) | 11 | 6 | 1 | 55 | 33 | |||||
149115 | 120227 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5988073.33018 | 2114479.43573 | 37.7852686520197 | -122.485028162067 | (37.7852686520197, -122.485028162067) | 11 | 6 | 2 | 55 | 26 | |||
85864 | 120225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5988079.81961 | 2114446.2354 | 37.785177871359 | -122.485003274246 | (37.785177871359, -122.485003274246) | 11 | 6 | 2 | 55 | 26 | |||
78801 | 120226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5988079.57182 | 2114425.85215 | 37.7851218903234 | -122.485002635535 | (37.7851218903234, -122.485002635535) | 11 | 6 | 2 | 55 | 26 | |||
184348 | 120220 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5988085.02802 | 2114222.2163 | 37.7845630820159 | -122.484968813954 | (37.7845630820159, -122.484968813954) | 11 | 6 | 2 | 55 | 26 | |||
126870 | 250556 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 130 El Camino Del Mar | 4 | : | Tree | Private 2 | 10 | Width 4ft | 5988132.65183 | 2115364.44627 | 37.787702093729 | -122.48488787927 | (37.787702093729, -122.48488787927) | 11 | 6 | 1 | 55 | 33 | |||
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 | |||
148762 | 104745 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 5988152.6 | 2110221.5 | 37.7735821764225 | -122.484441503692 | (37.7735821764225, -122.484441503692) | 11 | 6 | 2 | 55 | 26 | ||||
43618 | 113057 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988174.67863 | 2110213.36174 | 37.7735611166607 | -122.484364534338 | (37.7735611166607, -122.484364534338) | 11 | 6 | 2 | 55 | 26 | |||
148727 | 113056 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5988176.09683 | 2110229.83232 | 37.7736064228649 | -122.48436083687 | (37.7736064228649, -122.48436083687) | 11 | 6 | 2 | 55 | 26 | |||
102879 | 120367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 859 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5988179.32225 | 2110142.47058 | 37.7733667396691 | -122.484343271227 | (37.7733667396691, -122.484343271227) | 11 | 6 | 2 | 55 | 26 |
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) );