trees
8,298 rows where qLegalStatus_id = 4 sorted by XCoord 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38711 | 116976 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 7 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
173000 | 116975 | Undocumented 4 | Salix spp :: Willow 203 | 100x CARGO WAY | 6 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
8037 | 257932 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
36331 | 256763 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
124028 | 257931 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
152900 | 257934 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
170679 | 257933 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
34794 | 83038 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | 10 | 3 | 8 | 58 | 1 | |||
106034 | 255453 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 90 Kiska Rd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6018381 | 2093938 | 37.7305848832053 | -122.378744818809 | (37.7305848832053, -122.378744818809) | 10 | 3 | 8 | 58 | 1 | ||||
160662 | 117457 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 90 NAVY RD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018168 | 2093528 | 37.7294473579848 | -122.379452729346 | (37.7294473579848, -122.379452729346) | 10 | 3 | 8 | 58 | 1 | ||||
34742 | 254497 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1100x Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018024 | 2094000 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | 10 | 3 | 8 | 58 | 1 | ||||
65570 | 255182 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Ingalls St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018024 | 2094000 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | 10 | 3 | 8 | 58 | 1 | ||||
162723 | 114914 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6017974 | 2095171 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | 10 | 3 | 8 | 58 | 1 | |||
66685 | 198701 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 1200 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017953.40415 | 2093964.00554 | 37.7306327066323 | -122.380224903656 | (37.7306327066323, -122.380224903656) | 10 | 3 | 8 | 58 | 1 | |||
3645 | 254418 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1245x Ingalls St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017856 | 2093901 | 37.7304543311207 | -122.380557270451 | (37.7304543311207, -122.380557270451) | 10 | 3 | 8 | 58 | 1 | ||||
19491 | 260088 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 1100 Oakdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15x5 | 6017813 | 2093492 | 37.7293289240284 | -122.380677509991 | (37.7293289240284, -122.380677509991) | 10 | 3 | 8 | 58 | 1 | ||||
22311 | 254407 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
67748 | 254409 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
114708 | 254408 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
132903 | 255181 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1176x Ingalls St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | |||||
172594 | 254410 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1176x Ingalls St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | ||||
153003 | 254411 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1199x Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017612 | 2093930 | 37.7305204916798 | -122.381402837917 | (37.7305204916798, -122.381402837917) | 10 | 3 | 8 | 58 | 1 | ||||
129898 | 254394 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1237 Ingalls St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6017509 | 2093925 | 37.7305010756826 | -122.381758580005 | (37.7305010756826, -122.381758580005) | 10 | 3 | 8 | 58 | 1 | ||||
137649 | 108201 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 90 Reuel Ct | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774102 | 6017404.09127 | 2096025.61699 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | 10 | 3 | 8 | 58 | 1 | ||||
165630 | 108200 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 90 Reuel Ct | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774102 | 6017404.09127 | 2096025.61699 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | 10 | 3 | 8 | 58 | 1 | ||||
8158 | 254632 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||||
79983 | 254630 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1100x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||||
154190 | 121341 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 401X Cargo Way | 2 | Side Yard : Yard | Tree | Private 2 | 18 | 3x3 | 6017217 | 2098844 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | 10 | 3 | 8 | 58 | 1 | |||
10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
92463 | 111565 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
95331 | 111566 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
108884 | 111564 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017154 | 2092794 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | 10 | 3 | 8 | 58 | 1 | ||||
39661 | 103997 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
84748 | 103998 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
92814 | 103995 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
180005 | 103996 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
83572 | 119911 | Undocumented 4 | Tree(s) :: 17 | 67 Rebecca Ln | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6017125 | 2096711 | 37.7381296664541 | -122.383279988851 | (37.7381296664541, -122.383279988851) | 10 | 3 | 8 | 58 | 1 | ||||
179529 | 102730 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6017119 | 2092706 | 37.7271323979238 | -122.383022072855 | (37.7271323979238, -122.383022072855) | 10 | 3 | 8 | 58 | 1 | ||||
169477 | 255308 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | 6017061 | 2098665 | 37.7434914187463 | -122.383637271506 | (37.7434914187463, -122.383637271506) | 10 | 3 | 8 | 58 | 1 | ||
192395 | 102739 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | 10 | 3 | 8 | 58 | 1 | |||
180052 | 109251 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 53X DEDMAN CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 6016647 | 2096311 | 37.7370049195852 | -122.384904830601 | (37.7370049195852, -122.384904830601) | 10 | 3 | 8 | 58 | 1 | ||||
127359 | 195004 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016527.61209 | 2096304.47385 | 37.7369803959213 | -122.385317157364 | (37.7369803959213, -122.385317157364) | 10 | 3 | 8 | 58 | 1 | |||
49569 | 195005 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016499.64724 | 2096292.33943 | 37.7369455301091 | -122.385412999906 | (37.7369455301091, -122.385412999906) | 10 | 3 | 8 | 58 | 1 | |||
90740 | 112843 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1415 EVANS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016481 | 2097724 | 37.7408755487739 | -122.385577218432 | (37.7408755487739, -122.385577218432) | 10 | 3 | 8 | 58 | 1 | |||||
151245 | 255455 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 31x Garlington Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6016454 | 2094669 | 37.7324856396877 | -122.385457730704 | (37.7324856396877, -122.385457730704) | 10 | 3 | 8 | 58 | 1 | ||||
97745 | 104425 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101x WHITNEY YOUNG CIR | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6016394 | 2096049 | 37.7362715234519 | -122.385761317359 | (37.7362715234519, -122.385761317359) | 10 | 3 | 8 | 58 | 1 | |||
151230 | 188700 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1498 Evans Ave | 6 | : | Tree | Private 2 | 17 | Width 4ft | 6016385.13466 | 2098043.91296 | 37.7417486598831 | -122.385930982422 | (37.7417486598831, -122.385930982422) | 10 | 3 | 8 | 58 | 1 | |||
129496 | 255714 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 618x Mendell St | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016376 | 2097269 | 37.7396204009215 | -122.385908564927 | (37.7396204009215, -122.385908564927) | 10 | 3 | 8 | 58 | 1 | |||
147250 | 256029 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1323 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6016352 | 2093043 | 37.7280153225058 | -122.385697085802 | (37.7280153225058, -122.385697085802) | 10 | 3 | 8 | 58 | 1 | ||||
115506 | 99545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1345 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016251.7 | 2093118.1 | 37.7282159817318 | -122.386049062135 | (37.7282159817318, -122.386049062135) | 10 | 3 | 8 | 58 | 1 | ||||
23240 | 255713 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 618x Mendell St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
120683 | 255712 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 618x Mendell St | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016234 | 2097322 | 37.7397580688138 | -122.386403238688 | (37.7397580688138, -122.386403238688) | 10 | 3 | 8 | 58 | 1 | |||
172792 | 112970 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1409 MCKINNON AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016184 | 2095282 | 37.7341538729229 | -122.386433919032 | (37.7341538729229, -122.386433919032) | 10 | 3 | 8 | 58 | 1 | |||||
29525 | 74025 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
51279 | 116420 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||||
96304 | 72481 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
160187 | 72482 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
175844 | 116451 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 250X CASHMERE ST | 5 | Median : Yard | Tree | DPW 1 | 6016081 | 2096072 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | 10 | 3 | 8 | 58 | 1 | |||||
6455 | 117452 | Undocumented 4 | Tree(s) :: 17 | 1530 HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016055 | 2097226 | 37.7394845622146 | -122.387015456594 | (37.7394845622146, -122.387015456594) | 10 | 3 | 8 | 58 | 1 | ||||
119943 | 110264 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 220x CASHMERE ST | 1 | Median : Cutout | Tree | DPW 1 | 5x40 | 6015982.5 | 2095938 | 37.7359439605228 | -122.387176315997 | (37.7359439605228, -122.387176315997) | 10 | 3 | 8 | 58 | 1 | ||||
7225 | 260193 | Undocumented 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6015971 | 2096622 | 37.7378214492677 | -122.387263773804 | (37.7378214492677, -122.387263773804) | 10 | 3 | 8 | 58 | 1 | ||||
59108 | 109457 | Undocumented 4 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 951 GILMAN AVE | 43 | Front Yard : Yard | Tree | Rec/Park 5 | 23 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4185 | 262568 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
4200 | 262567 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
5772 | 262554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
7613 | 262571 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
8223 | 262569 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
9120 | 262556 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
10281 | 262560 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15440 | 262565 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15813 | 262563 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
15949 | 262561 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
16740 | 262573 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
17120 | 262555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18473 | 262562 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
18684 | 262572 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
30117 | 256072 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6015921 | 2093364 | 37.7288728663344 | -122.387209460387 | (37.7288728663344, -122.387209460387) | 10 | 3 | 8 | 58 | 1 | ||||
107442 | 256073 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6015921 | 2093364 | 37.7288728663344 | -122.387209460387 | (37.7288728663344, -122.387209460387) | 10 | 3 | 8 | 58 | 1 | ||||
150571 | 256071 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6015921 | 2093364 | 37.7288728663344 | -122.387209460387 | (37.7288728663344, -122.387209460387) | 10 | 3 | 8 | 58 | 1 | ||||
156054 | 256074 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6015921 | 2093364 | 37.7288728663344 | -122.387209460387 | (37.7288728663344, -122.387209460387) | 10 | 3 | 8 | 58 | 1 | ||||
11056 | 111333 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
16757 | 111332 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
34139 | 111331 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
47021 | 111329 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
63631 | 111325 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
69479 | 111326 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
87605 | 111327 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
106469 | 111328 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
169584 | 111330 | Undocumented 4 | Quercus suber :: Cork Oak 78 | 698x ILLINOIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015875 | 2105932 | 37.7633794456224 | -122.388245263499 | (37.7633794456224, -122.388245263499) | 14 | 3 | 8 | 28856 | 29 | ||||
172772 | 107071 | Undocumented 4 | Tree(s) :: 17 | 400X MARIPOSA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015842 | 2106286 | 37.7643496247585 | -122.38838411004 | (37.7643496247585, -122.38838411004) | 14 | 3 | 8 | 28856 | 29 | |
131315 | 254799 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 3795x 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015840 | 2098417 | 37.742742897035 | -122.387841920715 | (37.742742897035, -122.387841920715) | 10 | 3 | 8 | 58 | 1 | ||||
138225 | 101082 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1699X Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015823 | 2101385 | 37.7508914678049 | -122.388107781388 | (37.7508914678049, -122.388107781388) | 10 | 3 | 8 | 28856 | 1 |
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) );