trees

Custom SQL query returning 101 rows (show)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
767 100549 4 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
3669 103667 4 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 4 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree 2                              
4983 112267 4 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree 2                              
5100 101532 4 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
5748 115724 4 243 250x Octavia St 1 Side Yard : Yard Tree 7                              
6238 103666 4 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 4 243 250X Octavia St 2 Side Yard : Yard Tree 7                              
9335 112908 4 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree 2                              
9557 112910 4 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree 2                              
10205 173902 4 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2                              
10489 102839 4 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree 1                              
10516 102842 4 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree 1                              
10813 100543 4 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree 2     3 3x4                      
10916 108180 4 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2       3x3                      
10998 100001 4 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree 2         Address is 100 1st Street                    
11335 112269 4 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree 2                              
12733 102843 4 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree 1                              
14524 99746 4 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15154 102838 4 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree 1                              
15233 109923 4 14 214 state st 1 Sidewalk: Curb side : Cutout Tree 2       3x3                      
15258 103665 4 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 4 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 4 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 4 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree 2                              
18674 103662 4 17 350X Hickory St 1 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
38711 116976 4 203 100x CARGO WAY 7 Front Yard : Yard Tree 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
49681 116977 4 70 100x CARGO WAY 117 Front Yard : Yard Tree 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
173000 116975 4 203 100x CARGO WAY 6 Front Yard : Yard Tree 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
8037 257932 4 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
36331 256763 4 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
124028 257931 4 56 1039 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
152900 257934 4 56 1039 Hudson Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
170679 257933 4 56 1039 Hudson Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
34794 83038 4 5 100X Cargo Way 14 Sidewalk: Curb side : Cutout Tree 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 4 63 90 Kiska Rd 1 Front Yard : Yard Tree 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
160662 117457 4 52 90 NAVY RD 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6018168 2093528 37.7294473579848 -122.379452729346 (37.7294473579848, -122.379452729346) 10 3 8 58 1
34742 254497 4 11 1100x Ingalls St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6018024 2094000 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658) 10 3 8 58 1
65570 255182 4 42 1100x Ingalls St 13 Sidewalk: Curb side : Cutout Tree 2       3x3   6018024 2094000 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658) 10 3 8 58 1
66685 198701 4 98 1200 Ingalls St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6017953.40415 2093964.00554 37.7306327066323 -122.380224903656 (37.7306327066323, -122.380224903656) 10 3 8 58 1
162723 114914 4 52 200x MIDDLE POINT RD 1 Sidewalk: Curb side : Cutout Tree 15 Private     3x3   6017974 2095171 37.7339480130439 -122.380237547959 (37.7339480130439, -122.380237547959) 10 3 8 58 1
3645 254418 4 42 1245x Ingalls St 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6017856 2093901 37.7304543311207 -122.380557270451 (37.7304543311207, -122.380557270451) 10 3 8 58 1
19491 260088 4 384 1100 Oakdale Ave 1 Sidewalk: Property side : Yard Tree 2       15x5   6017813 2093492 37.7293289240284 -122.380677509991 (37.7293289240284, -122.380677509991) 10 3 8 58 1
22311 254407 4 42 1176x Ingalls St 22 Sidewalk: Curb side : Cutout Tree 2       3x3   6017715 2093956 37.7305975684905 -122.381048555108 (37.7305975684905, -122.381048555108) 10 3 8 58 1
67748 254409 4 42 1176x Ingalls St 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6017715 2093956 37.7305975684905 -122.381048555108 (37.7305975684905, -122.381048555108) 10 3 8 58 1
114708 254408 4 42 1176x Ingalls St 17 Sidewalk: Curb side : Cutout Tree 2       3x3   6017715 2093956 37.7305975684905 -122.381048555108 (37.7305975684905, -122.381048555108) 10 3 8 58 1
132903 255181 4 127 1176x Ingalls St   Sidewalk: Curb side : Cutout Tree 2       3x3   6017715 2093956 37.7305975684905 -122.381048555108 (37.7305975684905, -122.381048555108) 10 3 8 58 1
172594 254410 4 42 1176x Ingalls St 23 Sidewalk: Curb side : Cutout Tree 2       3x3   6017715 2093956 37.7305975684905 -122.381048555108 (37.7305975684905, -122.381048555108) 10 3 8 58 1
153003 254411 4 127 1199x Ingalls St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6017612 2093930 37.7305204916798 -122.381402837917 (37.7305204916798, -122.381402837917) 10 3 8 58 1
129898 254394 4 15 1237 Ingalls St 1 Sidewalk: Property side : Yard Tree 2       3x3   6017509 2093925 37.7305010756826 -122.381758580005 (37.7305010756826, -122.381758580005) 10 3 8 58 1
137649 108201 4 56 90 Reuel Ct 2 Front Yard : Yard Tree 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
165630 108200 4 56 90 Reuel Ct 1 Front Yard : Yard Tree 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
8158 254632 4 42 1100x Hudson Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6017356 2095183 37.733946845802 -122.382375019073 (37.733946845802, -122.382375019073) 10 3 8 58 1
79983 254630 4 42 1100x Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6017356 2095183 37.733946845802 -122.382375019073 (37.733946845802, -122.382375019073) 10 3 8 58 1
10420 105551 4 67 1398X HAWES ST 3 Sidewalk: Curb side : Cutout Tree 2     16 3x3   6017214 2092838 37.7275000929711 -122.382702837059 (37.7275000929711, -122.382702837059) 10 3 8 58 1
92463 111565 4 67 1400x HAWES ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6017154 2092794 37.7273759626121 -122.382907198656 (37.7273759626121, -122.382907198656) 10 3 8 58 1
95331 111566 4 67 1400x HAWES ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6017154 2092794 37.7273759626121 -122.382907198656 (37.7273759626121, -122.382907198656) 10 3 8 58 1
108884 111564 4 67 1400x HAWES ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6017154 2092794 37.7273759626121 -122.382907198656 (37.7273759626121, -122.382907198656) 10 3 8 58 1
39661 103997 4 67 1410X Hawes St 3 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
84748 103998 4 67 1410X Hawes St 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
92814 103995 4 67 1410X Hawes St 1 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
180005 103996 4 67 1410X Hawes St 2 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
179529 102730 4 11 1450 Hawes St 1 Sidewalk: Curb side : Cutout Tree 2       6x9   6017119 2092706 37.7271323979238 -122.383022072855 (37.7271323979238, -122.383022072855) 10 3 8 58 1
154190 121341 4 56 401X Cargo Way 2 Side Yard : Yard Tree 2     18 3x3   6017217 2098844 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195) 10 3 8 58 1
83572 119911 4 17 67 Rebecca Ln 1 Back Yard : Yard Tree 2       3x3   6017125 2096711 37.7381296664541 -122.383279988851 (37.7381296664541, -122.383279988851) 10 3 8 58 1
169477 255308 4 59 50 Mendell St 1 Front Yard : Yard Tree 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 4 67 1249 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6016779.4097 2092749.4074 37.7272328159816 -122.384199065737 (37.7272328159816, -122.384199065737) 10 3 8 58 1
180052 109251 4 41 53X DEDMAN CT 1 Sidewalk: Curb side : Cutout Tree 2     36     6016647 2096311 37.7370049195852 -122.384904830601 (37.7370049195852, -122.384904830601) 10 3 8 58 1
127359 195004 4 36 50 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6016527.61209 2096304.47385 37.7369803959213 -122.385317157364 (37.7369803959213, -122.385317157364) 10 3 8 58 1
49569 195005 4 36 50 Dedman Ct 2 Sidewalk: Curb side : Cutout Tree 2     17 Width 3ft   6016499.64724 2096292.33943 37.7369455301091 -122.385412999906 (37.7369455301091, -122.385412999906) 10 3 8 58 1
151245 255455 4 59 31x Garlington Ct 1 Side Yard : Yard Tree 2       3x3   6016454 2094669 37.7324856396877 -122.385457730704 (37.7324856396877, -122.385457730704) 10 3 8 58 1
90740 112843 4 83 1415 EVANS AVE 1 Front Yard : Yard Tree 2           6016481 2097724 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432) 10 3 8 58 1
147250 256029 4 19 1323 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2       4x4   6016352 2093043 37.7280153225058 -122.385697085802 (37.7280153225058, -122.385697085802) 10 3 8 58 1
97745 104425 4 70 101x WHITNEY YOUNG CIR 2 Sidewalk: Curb side : Cutout Tree 1     23 3x3   6016394 2096049 37.7362715234519 -122.385761317359 (37.7362715234519, -122.385761317359) 10 3 8 58 1
129496 255714 4 95 618x Mendell St 9 Front Yard : Yard Tree 2       3x3 Permit Number 781846 6016376 2097269 37.7396204009215 -122.385908564927 (37.7396204009215, -122.385908564927) 10 3 8 58 1
151230 188700 4 70 1498 Evans Ave 6 : Tree 2     17 Width 4ft   6016385.13466 2098043.91296 37.7417486598831 -122.385930982422 (37.7417486598831, -122.385930982422) 10 3 8 58 1
115506 99545 4 67 1345 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6016251.7 2093118.1 37.7282159817318 -122.386049062135 (37.7282159817318, -122.386049062135) 10 3 8 58 1
23240 255713 4 62 618x Mendell St 3 Front Yard : Yard Tree 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
120683 255712 4 35 618x Mendell St 6 Front Yard : Yard Tree 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
172792 112970 4 52 1409 MCKINNON AVE 1 Front Yard : Yard Tree 2           6016184 2095282 37.7341538729229 -122.386433919032 (37.7341538729229, -122.386433919032) 10 3 8 58 1
175844 116451 4 15 250X CASHMERE ST 5 Median : Yard Tree 1           6016081 2096072 37.7363173516773 -122.386845101275 (37.7363173516773, -122.386845101275) 10 3 8 58 1
59108 109457 4 142 951 GILMAN AVE 43 Front Yard : Yard Tree 5     23     6015934 2089205 37.7174537876507 -122.386874585955 (37.7174537876507, -122.386874585955) 10 3 8 58 1
6455 117452 4 17 1530 HUDSON AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6016055 2097226 37.7394845622146 -122.387015456594 (37.7394845622146, -122.387015456594) 10 3 8 58 1
119943 110264 4 41 220x CASHMERE ST 1 Median : Cutout Tree 1       5x40   6015982.5 2095938 37.7359439605228 -122.387176315997 (37.7359439605228, -122.387176315997) 10 3 8 58 1
30117 256072 4 14 1800 Jennings St 2 Sidewalk: Curb side : Cutout Tree 2       3x9   6015921 2093364 37.7288728663344 -122.387209460387 (37.7288728663344, -122.387209460387) 10 3 8 58 1
107442 256073 4 14 1800 Jennings St 4 Sidewalk: Curb side : Cutout Tree 2       3x9   6015921 2093364 37.7288728663344 -122.387209460387 (37.7288728663344, -122.387209460387) 10 3 8 58 1
150571 256071 4 14 1800 Jennings St 1 Sidewalk: Curb side : Cutout Tree 2       3x9   6015921 2093364 37.7288728663344 -122.387209460387 (37.7288728663344, -122.387209460387) 10 3 8 58 1
156054 256074 4 14 1800 Jennings St 3 Sidewalk: Curb side : Cutout Tree 2       3x9   6015921 2093364 37.7288728663344 -122.387209460387 (37.7288728663344, -122.387209460387) 10 3 8 58 1
7225 260193 4 230 845 Mendell St 1 Sidewalk: Curb side : Cutout Tree 2       4x4   6015971 2096622 37.7378214492677 -122.387263773804 (37.7378214492677, -122.387263773804) 10 3 8 58 1
29525 74025 4 36 409 Illinois St 1 Sidewalk: Curb side : Cutout Tree 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 4 36 409 Illinois St 8 Sidewalk: Curb side : Cutout Tree 2       5x5   6016159.9 2106964.2 37.766229426257 -122.387331885576 (37.766229426257, -122.387331885576) 14 3 9 310 20
96304 72481 4 36 409 Illinois St 3 Sidewalk: Curb side : Cutout Tree 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 4 36 409 Illinois St 2 Sidewalk: Curb side : Cutout Tree 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
157112 256075 4 32 1919 Jennings St   Sidewalk: Curb side : Cutout Tree 2       3x3   6015778 2093027 37.7279396111572 -122.387680322808 (37.7279396111572, -122.387680322808) 10 3 8 58 1
180723 256031 4 40 1431 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015779 2093470 37.7291560564579 -122.387707761404 (37.7291560564579, -122.387707761404) 10 3 8 58 1
115926 107644 4 15 1400x KIRKWOOD AVE 1 Median : Yard Tree 2           6015822.8 2096363.1 37.7371023539668 -122.38775811874 (37.7371023539668, -122.38775811874) 10 3 8 58 1
131315 254799 4 11 3795x 03rd St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015840 2098417 37.742742897035 -122.387841920715 (37.742742897035, -122.387841920715) 10 3 8 58 1
124827 256030 4 40 1439 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015739 2093499 37.7292334688727 -122.387848068648 (37.7292334688727, -122.387848068648) 10 3 8 58 1
121975 256175 4 75 1493 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015764 2095228 37.7339823414442 -122.387882237671 (37.7339823414442, -122.387882237671) 10 3 8 58 1
5495 260381 4 50 1924 Jennings St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6015697 2093053 37.7280065148754 -122.387962157958 (37.7280065148754, -122.387962157958) 10 3 8 58 1
138225 101082 4 11 1699X Tennessee St 8 Sidewalk: Curb side : Cutout Tree 2     9 3x3   6015823 2101385 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1