Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75865 | 75865 | 202249 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013205.71087 | 2093269.90652 | 37.7284637621797 | -122.396589876845 | (37.7284637621797, -122.396589876845) | |||
| 75880 | 75880 | 202227 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013178.67077 | 2093060.8969999999 | 37.7278883597585 | -122.39666871048901 | (37.7278883597585, -122.396668710489) | |||
| 134932 | 134932 | 202258 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6013221.11687 | 2093370.23706 | 37.7287401067524 | -122.396543647186 | (37.7287401067524, -122.396543647186) | |||
| 136482 | 136482 | 202212 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013161.674930001 | 2092916.86339 | 37.7274919268866 | -122.39671737281999 | (37.7274919268866, -122.39671737282) | |||
| 148671 | 148671 | 202210 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013159.58864 | 2092897.28158 | 37.727438043107796 | -122.39672321300101 | (37.7274380431078, -122.396723213001) | |||
| 150759 | 150759 | 202240 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013194.80989 | 2093183.5011900002 | 37.728225904088895 | -122.396621507785 | (37.7282259040889, -122.396621507785) | |||
| 152959 | 152959 | 202225 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013176.52464 | 2093041.86631 | 37.727835985918205 | -122.396674796225 | (37.7278359859182, -122.396674796225) | |||
| 154852 | 154852 | 202245 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013200.83525 | 2093230.7571400001 | 37.728355994623996 | -122.396603988992 | (37.728355994624, -122.396603988992) | |||
| 156402 | 156402 | 202213 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013162.96536 | 2092924.96744 | 37.727514250778896 | -122.39671347965 | (37.7275142507789, -122.39671347965) | |||
| 159614 | 159614 | 202224 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013176.16423 | 2093034.4554599999 | 37.7278156171758 | -122.396675522878 | (37.7278156171758, -122.396675522878) | |||
| 161478 | 161478 | 202217 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013167.96472 | 2092963.2735400002 | 37.7276197097745 | -122.396698880956 | (37.7276197097745, -122.396698880956) | |||
| 161620 | 161620 | 202257 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6013220.214430001 | 2093360.4433 | 37.7287131648642 | -122.39654608076 | (37.7287131648642, -122.39654608076) | |||
| 162000 | 162000 | 202221 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013173.04643 | 2093005.64291 | 37.7277363302611 | -122.396684282259 | (37.7277363302611, -122.396684282259) | |||
| 164653 | 164653 | 202218 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013169.31452 | 2092974.31986 | 37.727650115843794 | -122.396694988704 | (37.7276501158438, -122.396694988704) | |||
| 168123 | 168123 | 202242 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013197.3579400005 | 2093205.03586 | 37.7282851757099 | -122.396614207973 | (37.7282851757099, -122.396614207973) | |||
| 170594 | 170594 | 202235 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013188.17067 | 2093133.73442 | 37.7280888851842 | -122.39664097272801 | (37.7280888851842, -122.396640972728) | |||
| 171447 | 171447 | 202211 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013160.61758 | 2092906.3718700001 | 37.7274630604606 | -122.396720292924 | (37.7274630604606, -122.396720292924) | |||
| 172298 | 172298 | 202246 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013202.20801 | 2093242.92412 | 37.728389479068 | -122.39660009581499 | (37.728389479068, -122.396600095815) | |||
| 174758 | 174758 | 202230 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013182.01879 | 2093087.1816200002 | 37.727960718302896 | -122.396658978052 | (37.7279607183029, -122.396658978052) | |||
| 176678 | 176678 | 202216 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013166.11984 | 2092955.6012799998 | 37.7275985406314 | -122.396704721146 | (37.7275985406314, -122.396704721146) | |||
| 178625 | 178625 | 202231 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013182.918409999 | 2093096.83525 | 37.727987275271396 | -122.396656544473 | (37.7279872752714, -122.396656544473) | |||
| 180423 | 180423 | 202229 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013180.4101 | 2093077.2619900003 | 37.7279333914885 | -122.39666384428001 | (37.7279333914885, -122.39666384428) | |||
| 185328 | 185328 | 202226 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013177.60207 | 2093049.8453 | 37.7278579545638 | -122.396671630611 | (37.7278579545638, -122.396671630611) | |||
| 185762 | 185762 | 202254 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013211.29686 | 2093316.3299599998 | 37.7285915423502 | -122.39657381854401 | (37.7285915423502, -122.396573818544) | |||
| 185974 | 185974 | 202222 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013173.80227 | 2093015.1592700002 | 37.7277625023133 | -122.396682336131 | (37.7277625023133, -122.396682336131) | |||
| 188576 | 188576 | 202247 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013203.9034 | 2093250.1788700002 | 37.728409493486296 | -122.39659474307501 | (37.7284094934863, -122.396594743075) | |||
| 35215 | 35215 | 196035 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6017042.43736 | 2096973.9330400003 | 37.7388470647366 | -122.38358375190501 | (37.7388470647366, -122.383583751905) | |||
| 38488 | 38488 | 196041 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6017065.52556 | 2097005.9762799998 | 37.738936325136706 | -122.383506153 | (37.7389363251367, -122.383506153) | |||
| 41246 | 41246 | 187776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6017085.142530001 | 2097027.7274599997 | 37.7389971337102 | -122.383439839679 | (37.7389971337102, -122.383439839679) | |||
| 53814 | 53814 | 196045 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6017076.588380001 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | |||
| 55642 | 55642 | 196036 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017046.41048 | 2096978.7292799999 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | |||
| 61094 | 61094 | 196049 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 10ft | 6017090.910619999 | 2097040.61449 | 37.7390328376916 | -122.38342079293501 | (37.7390328376916, -122.383420792935) | |||
| 65477 | 65477 | 196046 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017076.84536 | 2097020.9862799998 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | |||
| 69044 | 69044 | 196048 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6017086.8639400005 | 2097032.1625700002 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | |||
| 73353 | 73353 | 196047 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6017083.0987599995 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | |||
| 74651 | 74651 | 196034 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 6017038.2356199995 | 2096967.92235 | 37.738830328350794 | -122.38359786136002 | (37.7388303283508, -122.38359786136) | |||
| 148840 | 148840 | 196044 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.38347581797701 | (37.7389597551859, -122.383475817977) | |||
| 149400 | 149400 | 196040 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6017061.14337 | 2096999.0636099998 | 37.738917102131204 | -122.383520823632 | (37.7389171021312, -122.383520823632) | |||
| 150116 | 150116 | 196042 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6017068.02223 | 2097008.3641400002 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | |||
| 152191 | 152191 | 187774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6017047.63402 | 2096978.70465 | 37.738860453846996 | -122.383566116201 | (37.738860453847, -122.383566116201) | |||
| 152860 | 152860 | 196043 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.38349133844801 | (37.7389474821301, -122.383491338448) | |||
| 155523 | 155523 | 199338 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1 Lane St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6017017.1486 | 2096994.75956 | 37.738902852376704 | -122.38367263908998 | (37.7389028523767, -122.38367263909) | ||||
| 162017 | 162017 | 196037 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017049.14343 | 2096982.7375599998 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | |||
| 163207 | 163207 | 187775 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Lane St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6017053.32881 | 2096987.9359900001 | 37.7388861160087 | -122.383547068563 | (37.7388861160087, -122.383547068563) | |||
| 166201 | 166201 | 196038 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | |||
| 168448 | 168448 | 196039 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 Lane St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6017058.78761 | 2096996.2330599998 | 37.7389091998064 | -122.38352877183998 | (37.7389091998064, -122.38352877184) | |||
| 60936 | 60936 | 205299 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999812.60862 | 2095804.2587 | 37.7346680284999 | -122.443072299944 | (37.7346680284999, -122.443072299944) | |||
| 135051 | 135051 | 205296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999813.31551 | 2095822.6669599998 | 37.7347186135631 | -122.443071177587 | (37.7347186135631, -122.443071177587) | |||
| 151604 | 151604 | 205297 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.9038 | 2095818.47395 | 37.7347070770679 | -122.443072299973 | (37.7347070770679, -122.443072299973) | |||
| 154088 | 154088 | 205295 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.67748 | 2095838.8409 | 37.734762987024205 | -122.44307454465401 | (37.7347629870242, -122.443074544654) | |||
| 161218 | 161218 | 205761 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Malta Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999812.15419 | 2095813.64108 | 37.7346937644012 | -122.443074544653 | (37.7346937644012, -122.443074544653) | |||
| 162907 | 162907 | 217498 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Malta Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999813.4338 | 2095843.9965700002 | 37.7347771864063 | -122.443072299949 | (37.7347771864063, -122.443072299949) | |||
| 168336 | 168336 | 205298 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Malta Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999812.066980001 | 2095809.4413299998 | 37.7346822279016 | -122.443074544651 | (37.7346822279016, -122.443074544651) | |||
| 169081 | 169081 | 205760 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Malta Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999813.178859999 | 2095831.7198 | 37.7347434627438 | -122.443072299967 | (37.7347434627438, -122.443072299967) | |||
| 178209 | 178209 | 217497 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Malta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999813.58139 | 2095851.10387 | 37.7347967097977 | -122.44307229994 | (37.7347967097977, -122.44307229994) | |||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 154426 | 154426 | 210929 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1 Marne Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 4ft | 5995223.39717 | 2097839.86385 | 37.7399945663944 | -122.459086001528 | (37.7399945663944, -122.459086001528) | |||
| 171195 | 171195 | 203445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.972519999 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | |||
| 178983 | 178983 | 203444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995221.104719999 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | |||
| 187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) | |||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 51022 | 51022 | 179938 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 1 Moneta Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997974.23427 | 2088065.64877 | 37.7133146238397 | -122.448870915378 | (37.7133146238397, -122.448870915378) | |||
| 175588 | 175588 | 175590 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Moneta Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5997972.2511 | 2088063.0023700001 | 37.7133072440178 | -122.448877579363 | (37.7133072440178, -122.448877579363) | |||
| 180491 | 180491 | 178371 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1 Moneta Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5997975.94218 | 2088092.10775 | 37.713387371813 | -122.44886691697701 | (37.713387371813, -122.448866916977) | |||
| 19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 77508 | 77508 | 85510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 83308 | 83308 | 85506 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 87896 | 87896 | 85505 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 117346 | 117346 | 85502 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 55430 | 55430 | 203781 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 8ft | 5995760.050530001 | 2094044.5460299999 | 37.729604384015296 | -122.45695604179701 | (37.7296043840153, -122.456956041797) | |||
| 150308 | 150308 | 203780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5995711.8389800005 | 2094094.29693 | 37.72973821932529 | -122.457126310455 | (37.7297382193253, -122.457126310455) | |||
| 111919 | 111919 | 101477 | Permitted Site 1 | Tree(s) :: 17 | 1 Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | Permit Number 769453 | 5996419.1 | 2103319.0 | 37.7551075796122 | -122.455347659049 | (37.7551075796122, -122.455347659049) | |||
| 47095 | 47095 | 250014 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6005647.6336900005 | 2114206.58605 | 37.7855274664505 | -122.424206961487 | (37.7855274664505, -122.424206961487) | |||
| 137380 | 137380 | 250012 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 6005639.67048 | 2114203.54458 | 37.785518665693004 | -122.424234295496 | (37.785518665693, -122.424234295496) | |||
| 156257 | 156257 | 250021 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Peter Yorke Way | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6005906.53716 | 2114478.7126700003 | 37.7862892740647 | -122.423330582061 | (37.7862892740647, -122.423330582061) | ||||
| 156530 | 156530 | 250013 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Peter Yorke Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6005644.7352599995 | 2114200.81788 | 37.78551146482779 | -122.42421657883499 | (37.7855114648278, -122.424216578835) | |||
| 187218 | 187218 | 205386 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Rosewood Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5994512.47364 | 2095959.3750900002 | 37.734790314728706 | -122.461407773158 | (37.7347903147287, -122.461407773158) | |||
| 34946 | 34946 | 204388 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991323.5733900005 | 2094297.8939200002 | 37.730044251421 | -122.47231171573601 | (37.730044251421, -122.472311715736) | |||
| 134916 | 134916 | 204386 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991247.05781 | 2094303.3222700001 | 37.730054727639896 | -122.472576632627 | (37.7300547276399, -122.472576632627) | |||
| 186708 | 186708 | 204387 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991259.598999999 | 2094303.40475 | 37.7300556800255 | -122.472533282603 | (37.7300556800255, -122.472533282603) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 51044 | 51044 | 176285 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | |||
| 57617 | 57617 | 177094 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993369.32747 | 2086575.0773 | 37.708957449004394 | -122.464678768412 | (37.7089574490044, -122.464678768412) | |||
| 68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
| 131503 | 131503 | 177093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5993374.13741 | 2086578.2467 | 37.7089664287264 | -122.464662374692 | (37.7089664287264, -122.464662374692) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 58572 | 58572 | 131079 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5996978.93733 | 2116192.9947200003 | 37.7904883355148 | -122.454341475191 | (37.7904883355148, -122.454341475191) | |||
| 69605 | 69605 | 233599 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1 Unnamed 026 | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6002688.457 | 2095997.3975400003 | 37.7353618977364 | -122.43314332141001 | (37.7353618977364, -122.43314332141) | |||
| 25189 | 25189 | 206752 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 10 Beachmont Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5990858.798830001 | 2095874.41908 | 37.7343460811043 | -122.474033463291 | (37.7343460811043, -122.474033463291) | |||
| 64381 | 64381 | 125384 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 10 Fallon Pl | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008834.76125 | 2118568.89898 | 37.7976847536936 | -122.41348902751999 | (37.7976847536936, -122.41348902752) | ||||
| 68163 | 68163 | 125382 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 10 Fallon Pl | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008858.798359999 | 2118571.71552 | 37.7976938368446 | -122.413406051567 | (37.7976938368446, -122.413406051567) | ||||
| 77070 | 77070 | 125381 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 10 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008898.87665 | 2118577.20166 | 37.7977111506028 | -122.41326775740801 | (37.7977111506028, -122.413267757408) | ||||
| 90723 | 90723 | 125400 | Undocumented 2 | Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 305 | 10 Fallon Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008887.96232 | 2118576.49464 | 37.797708596537596 | -122.413305474088 | (37.7977085965376, -122.413305474088) | ||||
| 131892 | 131892 | 125401 | Undocumented 2 | Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 305 | 10 Fallon Pl | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6008876.70084 | 2118574.03718 | 37.7977012166941 | -122.41334426815 | (37.7977012166941, -122.41334426815) | ||||
| 152110 | 152110 | 125383 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 10 Fallon Pl | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008843.29101 | 2118569.75825 | 37.797687591969705 | -122.413459572924 | (37.7976875919697, -122.413459572924) | ||||
| 168120 | 168120 | 129006 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.41321064328301 | (37.7977154080083, -122.413210643283) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");