trees
1,650 rows where qSpecies_id = 64 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48128 | 205293 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999807.52736 | 2095794.02146 | 37.7346396297213 | -122.443089132554 | (37.7346396297213, -122.443089132554) | 9 | 7 | 4 | 63 | 40 | ||||
48459 | 245795 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6002841.82377 | 2098354.17483 | 37.7418417639849 | -122.432781382956 | (37.7418417639849, -122.432781382956) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
48702 | 189322 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 31 | Median : Yard | Tree | DPW 1 | 2 | 6016409.15229 | 2096168.44158 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | 10 | 3 | 8 | 58 | 1 | ||||
48775 | 100847 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
49394 | 205308 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 312 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5999357.46661 | 2094402.70977 | 37.7307937428201 | -122.444545176343 | (37.7307937428201, -122.444545176343) | 9 | 7 | 4 | 59 | 40 | ||||
49709 | 86947 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 283 Athens St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Permit Number 49915 | 6004370.91908 | 2091607.61661 | 37.7234038337052 | -122.427013866101 | (37.7234038337052, -122.427013866101) | 9 | 7 | 6 | 28861 | 5 | |||
50552 | 205436 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 374 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999594.80251 | 2094992.93753 | 37.7324279099011 | -122.443767058604 | (37.7324279099011, -122.443767058604) | 9 | 7 | 4 | 63 | 40 | ||||
50934 | 189291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 31 | : Yard | Tree | Private 2 | 5 | 6014386.77773 | 2105894.38958 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | 14 | 3 | 8 | 28856 | 29 | ||||
51371 | 205474 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999468.48436 | 2093527.67559 | 37.7283974371761 | -122.444098519924 | (37.7283974371761, -122.444098519924) | 9 | 7 | 4 | 63 | 40 | ||||
51828 | 248187 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6007416.25597 | 2098719.21061 | 37.7431024507267 | -122.416990309471 | (37.7431024507267, -122.416990309471) | 2 | 7 | 7 | 28859 | 2 | ||||
52136 | 245772 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 395 Addison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002120.14451 | 2097689.53055 | 37.7399758488049 | -122.435229181078 | (37.7399758488049, -122.435229181078) | 2 | 7 | 5 | 63 | 7 | ||||
54169 | 247861 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 81 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 6009580.66804 | 2098127.95413 | 37.741600504664 | -122.409464602736 | (37.741600504664, -122.409464602736) | 10 | 7 | 7 | 28859 | 2 | ||||
54357 | 175943 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 86 Arago St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5999607.21926 | 2093005.0564 | 37.7269703596801 | -122.443581381 | (37.7269703596801, -122.443581381) | 9 | 7 | 6 | 28861 | 25 | ||||
54371 | 205433 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 231 Edna St | 4 | Side Yard : Yard | Tree | Private 2 | 2 | 5998775.87477 | 2095301.89625 | 37.733229493638 | -122.44662049415 | (37.733229493638, -122.44662049415) | 9 | 7 | 4 | 59 | 40 | ||||
54827 | 205439 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 378 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999592.52385 | 2094994.83149 | 37.7324329803013 | -122.44377507246 | (37.7324329803013, -122.44377507246) | 9 | 7 | 4 | 63 | 40 | ||||
56424 | 205445 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Melrose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 14 | 5998069.65907 | 2095547.09422 | 37.7338623834248 | -122.449079720856 | (37.7338623834248, -122.449079720856) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |
57083 | 187501 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6005123.3425 | 2086496.85663 | 37.7094133054443 | -122.424049601701 | (37.7094133054443, -122.424049601701) | 9 | 7 | 6 | 309 | 5 | ||||
57292 | 175890 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 623 London St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6001228.09445 | 2090159.83888 | 37.7192503462927 | -122.43777436682 | (37.7192503462927, -122.43777436682) | 9 | 7 | 6 | 28861 | 5 | ||||
58430 | 205422 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 60 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999723.9083 | 2095525.77356 | 37.7338983158454 | -122.443358969664 | (37.7338983158454, -122.443358969664) | 9 | 7 | 4 | 63 | 40 | ||||
59658 | 126122 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2833 Larkin St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.421829107228 | (37.804070054442, -122.421829107228) | 5 | 9 | 1 | 28858 | 32 | ||||
59793 | 126128 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 10 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6008577.74955 | 2119176.39981 | 37.7993383659246 | -122.414421369076 | (37.7993383659246, -122.414421369076) | 5 | 1 | 10 | 308 | 32 | ||||
59902 | 205290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999811.98894 | 2095790.05019 | 37.7346289799358 | -122.443073422301 | (37.7346289799358, -122.443073422301) | 9 | 7 | 4 | 63 | 40 | ||||
60901 | 84911 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 5546 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | Permit No. 49266 | 5981488 | 2111676 | 37.7771854666478 | -122.507602896513 | (37.7771854666478, -122.507602896513) | 11 | 6 | 2 | 55 | 26 | |||
61124 | 245787 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 26 Harry St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 61 | 6003360.59602 | 2097764.52803 | 37.7402521385234 | -122.430945566306 | (37.7402521385234, -122.430945566306) | 2 | 7 | 5 | 63 | 7 | ||||
61327 | 245790 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 6002818.16213 | 2098366.55064 | 37.7418744030785 | -122.432864081016 | (37.7418744030785, -122.432864081016) | 2 | 7 | 5 | 63 | 7 | ||||
62407 | 68811 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 56 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 10 | Permit Number 32754 | 5984318.17629 | 2112844.77947 | 37.7805609168358 | -122.49789889557 | (37.7805609168358, -122.49789889557) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
63379 | 248235 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 29 | 6006740.56255 | 2099063.99979 | 37.7440111320042 | -122.419351135062 | (37.7440111320042, -122.419351135062) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |
64400 | 48360 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 246 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45771 | 6003531.3283676 | 2101591.65736703 | 37.7507702195134 | -122.430628266841 | (37.7507702195134, -122.430628266841) | 2 | 4 | 5 | 28862 | 22 | |||
65032 | 250133 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2550x Lyon St | 1 | Median : Yard | Tree | DPW 1 | 16 | 5999242.46646 | 2117532.27961 | 37.7942952053215 | -122.446606235406 | (37.7942952053215, -122.446606235406) | 13 | 9 | 1 | 57 | 27 | ||||
66664 | 205420 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 714 Detroit St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 5999461.80443 | 2095388.23948 | 37.7335057294051 | -122.444255259197 | (37.7335057294051, -122.444255259197) | 9 | 7 | 4 | 63 | 40 | ||||
67804 | 189329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 22 | Median : Yard | Tree | DPW 1 | 22 | 6016170.50674 | 2096734.91499 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |
68673 | 175916 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010863.76059 | 2087996.01367 | 37.7138521198643 | -122.404315111648 | (37.7138521198643, -122.404315111648) | 9 | 7 | 8 | 309 | 39 | ||||
68809 | 205409 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 47 Chilton Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001682.76522 | 2095616.45632 | 37.7342588207884 | -122.436593107305 | (37.7342588207884, -122.436593107305) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||
72134 | 189324 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 13 | Median : Yard | Tree | DPW 1 | 4 | 6016254.7178 | 2096666.03631 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | 10 | 3 | 8 | 58 | 1 | ||||
73383 | 70425 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 33 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3 | Permit Number 53083 | 6005742.08039 | 2093385.20113 | 37.7283621315868 | -122.422400250478 | (37.7283621315868, -122.422400250478) | 9 | 7 | 7 | 309 | 5 | ||
75177 | 39819 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2101 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | 1 | 8 | 3 | 29491 | 35 | |||
75895 | 217790 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 151 Sloat Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5990892.29341 | 2095922.4867 | 37.7344800027407 | -122.473921168543 | (37.7344800027407, -122.473921168543) | 1 | 8 | 4 | 64 | 40 | ||||
76388 | 189289 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 20 | : Yard | Tree | Private 2 | 10 | 6014461.84726 | 2105889.9963 | 37.7631857104708 | -122.393129998769 | (37.7631857104708, -122.393129998769) | 14 | 3 | 8 | 28856 | 29 | ||||
76547 | 189285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 64 | Front Yard : Yard | Tree | Private 2 | 3 | 6015362.87396 | 2102344.01113 | 37.7534992062408 | -122.389765930873 | (37.7534992062408, -122.389765930873) | 10 | 3 | 8 | 28856 | 29 | ||||
76937 | 189321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 30 | Median : Yard | Tree | DPW 1 | 7 | 6016453.45941 | 2096140.51631 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | 10 | 3 | 8 | 58 | 1 | ||||
77139 | 205446 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Melrose Ave | 2 | Side Yard : Yard | Tree | Private 2 | 17 | 5998064.66474 | 2095546.64669 | 37.7338608689682 | -122.449096955455 | (37.7338608689682, -122.449096955455) | 9 | 7 | 4 | 59 | 40 | ||||
77967 | 205292 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999809.50087 | 2095795.27324 | 37.7346431793405 | -122.443082399355 | (37.7346431793405, -122.443082399355) | 9 | 7 | 4 | 63 | 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 | |
79813 | 189290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 23 | : Yard | Tree | Private 2 | 5 | 6014424.75736 | 2105899.25329 | 37.7632090676603 | -122.393258929155 | (37.7632090676603, -122.393258929155) | 14 | 3 | 8 | 28856 | 29 | ||||
80080 | 205478 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 442 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999784.33637 | 2093736.40435 | 37.7289885714569 | -122.44302159167 | (37.7289885714569, -122.44302159167) | 9 | 7 | 4 | 63 | 40 | ||||
80298 | 189316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1089 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6013485.95319 | 2089984.75612 | 37.7194589935203 | -122.395391011311 | (37.7194589935203, -122.395391011311) | 10 | 3 | 8 | 58 | 1 | ||||
80796 | 126093 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 235 Marina Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6002352.27621 | 2121852.1528 | 37.8063335877859 | -122.436155236376 | (37.8063335877859, -122.436155236376) | 13 | 9 | 1 | 57 | 17 | ||||
82070 | 175972 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 96 Stoneybrook Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 42 | 6005707.91985 | 2093742.94308 | 37.729342485259 | -122.422543755295 | (37.729342485259, -122.422543755295) | 9 | 7 | 6 | 28861 | 5 | ||||
83872 | 187503 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 9 | Front Yard : Yard | Tree | Private 2 | 2 | 6005106.37943 | 2086503.45631 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | 9 | 7 | 6 | 309 | 5 | ||||
84064 | 52914 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3017th ST Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.440349407902 | (37.7632031545323, -122.440349407902) | 15 | 5 | 5 | 28862 | 3 | |||
84091 | 245792 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6002825.04242 | 2098363.5292 | 37.7418664971384 | -122.432840075435 | (37.7418664971384, -122.432840075435) | 2 | 7 | 5 | 63 | 7 | ||||
84908 | 118496 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5981338.85751 | 2112308.63433 | 37.7789137063233 | -122.508165785879 | (37.7789137063233, -122.508165785879) | 11 | 6 | 2 | 55 | 26 | ||||
87273 | 201492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018741.78505 | 2094936.24141 | 37.7333457436025 | -122.377566764894 | (37.7333457436025, -122.377566764894) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
88804 | 189332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 25 | Median : Yard | Tree | DPW 1 | 5 | 6016155.51714 | 2096746.87389 | 37.7381745445247 | -122.386634507683 | (37.7381745445247, -122.386634507683) | 10 | 3 | 8 | 58 | 1 | ||||
89746 | 58598 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 4966 17th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 04/19/1979 12:00:00 AM | Permit Number 17804 | 5997580.2349427 | 2105651.04183436 | 37.7615773358373 | -122.45150033551 | (37.7615773358373, -122.45150033551) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
93987 | 249690 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2400 Baker St | 22 | Front Yard : Yard | Tree | Private 2 | 5 | 5999737.36235 | 2117301.9106 | 37.7936909292328 | -122.444877277083 | (37.7936909292328, -122.444877277083) | 13 | 9 | 1 | 57 | 27 | ||||
94508 | 189283 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 16 | : Yard | Tree | Private 2 | 4 | 6015000.28938 | 2102358.87265 | 37.7535198996319 | -122.391020875425 | (37.7535198996319, -122.391020875425) | 10 | 3 | 8 | 28856 | 29 | ||||
94701 | 126127 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 956 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 57 | 6008898.21639 | 2118715.71766 | 37.7980914442296 | -122.41327984251 | (37.7980914442296, -122.41327984251) | 3 | 1 | 10 | 308 | 21 | ||||
95266 | 189327 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 20 | Median : Yard | Tree | DPW 1 | 24 | 6016185.54998 | 2096725.46158 | 37.7381174132775 | -122.386529175505 | (37.7381174132775, -122.386529175505) | 10 | 3 | 8 | 58 | 1 | ||||
95670 | 245576 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2211 Castro St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | 6002722.83592 | 2099050.09706 | 37.7437458553887 | -122.433242518424 | (37.7437458553887, -122.433242518424) | 2 | 7 | 5 | 63 | 22 | ||||
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 | ||
101227 | 175960 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 167 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6004570.88863 | 2092419.5104 | 37.7256444208349 | -122.426380387255 | (37.7256444208349, -122.426380387255) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |
101894 | 205412 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 144 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6000480.30601 | 2095252.29232 | 37.7331905053241 | -122.440724269926 | (37.7331905053241, -122.440724269926) | 9 | 7 | 5 | 63 | 40 | ||||
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 | ||
105084 | 245506 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 455 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6003003.71485 | 2099185.37319 | 37.7441332221647 | -122.432280966017 | (37.7441332221647, -122.432280966017) | 2 | 7 | 5 | 63 | 22 | ||||
105358 | 247866 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 398 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.409613305631 | (37.7423644418716, -122.409613305631) | 10 | 7 | 7 | 28859 | 2 | ||||
105505 | 175952 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 275 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004189.37547 | 2091812.49337 | 37.7239561127781 | -122.427656018922 | (37.7239561127781, -122.427656018922) | 9 | 7 | 6 | 28861 | 5 | ||||
105972 | 201491 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018753.58694 | 2094959.04146 | 37.7334089983181 | -122.377527543687 | (37.7334089983181, -122.377527543687) | 10 | 3 | 8 | 58 | 1 | ||||
107267 | 187579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 19 | 6008885.34324 | 2088289.25998 | 37.7145465601547 | -122.411173984595 | (37.7145465601547, -122.411173984595) | 9 | 7 | 8 | 309 | 39 | ||||
107516 | 48773 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 7777 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2002 12:00:00 AM | 20 | Permit Number 46030 | 5982884.10852 | 2112361.52314 | 37.7791498591369 | -122.50282415167 | (37.7791498591369, -122.50282415167) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
108028 | 205319 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 116 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5998647.86756 | 2093227.75495 | 37.7275270769096 | -122.446913846721 | (37.7275270769096, -122.446913846721) | 9 | 7 | 4 | 28861 | 40 | ||||
108055 | 101029 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1010X Portola Dr | 3 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
108102 | 205477 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999454.95195 | 2093530.05196 | 37.7284031901334 | -122.444145472637 | (37.7284031901334, -122.444145472637) | 9 | 7 | 4 | 63 | 40 | ||||
108478 | 246744 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Ripley St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | 6008911.68213 | 2099076.13806 | 37.7441665024863 | -122.411844724161 | (37.7441665024863, -122.411844724161) | 2 | 7 | 7 | 28859 | 2 | ||||
108639 | 126114 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 20 Reed St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6008207.05335 | 2117051.51427 | 37.7934831255889 | -122.415553587621 | (37.7934831255889, -122.415553587621) | 5 | 1 | 10 | 28858 | 21 | ||||
108959 | 118498 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5981347.00286 | 2112298.64035 | 37.7788867457895 | -122.508136866402 | (37.7788867457895, -122.508136866402) | 11 | 6 | 2 | 55 | 26 | ||||
108965 | 53009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3560 JEFFERSON Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2006 12:00:00 AM | 38 | Permit Number 48994 | 5999214.77321 | 2121106.04415 | 37.8041062224979 | -122.446959349696 | (37.8041062224979, -122.446959349696) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
110121 | 64317 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 846 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | 7 | Permit Number 25135 | 5982027.09526 | 2109990.6128 | 37.7725896300025 | -122.505613061298 | (37.7725896300025, -122.505613061298) | 11 | 6 | 2 | 55 | 26 | ||
110470 | 35003 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3508 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2013 12:00:00 AM | 3 | Permit Number 768133 | 5984707.64332 | 2111114.13046 | 37.7758318788155 | -122.49642382506 | (37.7758318788155, -122.49642382506) | 11 | 6 | 2 | 55 | 26 | ||
110521 | 118492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981407.0833 | 2112311.43925 | 37.7789254278995 | -122.507929978094 | (37.7789254278995, -122.507929978094) | 11 | 6 | 2 | 55 | 26 | ||||
111209 | 205317 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 112 Marston Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998664.93768 | 2093225.42346 | 37.7275216503894 | -122.446854667736 | (37.7275216503894, -122.446854667736) | 9 | 7 | 4 | 28861 | 40 | ||||
112686 | 245793 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6002836.40816 | 2098357.0124 | 37.7418492481435 | -122.432800311009 | (37.7418492481435, -122.432800311009) | 2 | 7 | 5 | 63 | 7 | ||||
113071 | 254264 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4650 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981096.26906 | 2110986.58772 | 37.7752694592632 | -122.508906792671 | (37.7752694592632, -122.508906792671) | 11 | 6 | 2 | 55 | 26 | |||||
113594 | 187498 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.423980183056 | (37.7093929151184, -122.423980183056) | 9 | 7 | 6 | 309 | 5 | ||||
113905 | 205448 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 522 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5997965.62199 | 2095286.83516 | 37.7331418232242 | -122.449420661033 | (37.7331418232242, -122.449420661033) | 9 | 7 | 4 | 59 | 40 | ||||
116435 | 245575 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2211 Castro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 27 | 6002723.45066 | 2099047.1713 | 37.7437378568072 | -122.433240183789 | (37.7437378568072, -122.433240183789) | 2 | 7 | 5 | 63 | 22 |
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) );